RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where bioproject = "PRJNA437204", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 26 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 26 ✖

bioproject 1

  • PRJNA437204 · 26 ✖

tax_kingdom 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
1707202 1707202 PRJNA437204_P_NODE_27322_length_368_cov_1.244068_g27023_i0 PRJNA437204 27322 368 1.244068 4.57817024 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 169 7.019999999999999e-46   NR KOO22127.1 1460289 g27023 i0 65.6 2.98369565217391 122 42 99.5 0 1 366 632 753 KOO22127.1 ubiquitin-activating enzyme e1 [Chrysochromulina tobinii] diamond 1098 169 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
6809500 6809500 PRJNA437204_P_NODE_116766_length_243_cov_0.905882_g116467_i0 PRJNA437204 116766 243 0.905882 2.20129326 root 1 Root_unresolved Root_unresolved 122 4.4699999999999995e-30   NR KAL1529848.1 97485 g116467 i0 68.8 6.91358024691358 80 24 98.8 1 3 242 289 367 KAL1529848.1 hypothetical protein AB1Y20_000779 [Prymnesium parvum] diamond 1680 123 0.991869918699187 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
9359698 9359698 PRJNA437204_P_NODE_106848_length_245_cov_0.895349_g106549_i0 PRJNA437204 106848 245 0.895349 2.19360505 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 68.2 4.08e-11   NR KAL1530571.1 97485 g106549 i0 48.7 9.34285714285714 78 40 95.5 0 5 238 133 210 KAL1530571.1 hypothetical protein AB1Y20_001472 [Prymnesium parvum] diamond 2289 68.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
11911628 11911628 PRJNA437204_P_NODE_5730_length_670_cov_1.144054_g5440_i0 PRJNA437204 5730 670 1.144054 7.6651618 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 62.1 1.11e-4   NTclustered gi|551625712|ref|XM_005792906.1| 280463 g5440 i0 100 0.477611940298507 33 0 5 0 392 424 333 301 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 320 62.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
13186093 13186093 PRJNA437204_P_NODE_33471_length_344_cov_1.114391_g33172_i0 PRJNA437204 33471 344 1.114391 3.83350504 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 134 1.13e-26   NTclustered gi|551550727|ref|XM_005762801.1| 280463 g33172 i0 80.925 0.502906976744186 173 29 50 4 120 290 10874 10704 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 173 134 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
14461680 14461680 PRJNA437204_P_NODE_58512_length_283_cov_2.761905_g58213_i0 PRJNA437204 58512 283 2.761905 7.81619115 Prymnesium parvum 97485 Haptophyta other_Eukaryota 126 4.4499999999999995e-35   NR KAL1515397.1 97485 g58213 i0 74.1 4.32508833922261 81 21 85.9 0 244 2 1 81 KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] diamond 1224 126 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
18284759 18284759 PRJNA437204_P_NODE_70675_length_264_cov_1.209424_g70376_i0 PRJNA437204 70675 264 1.209424 3.19287936 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 130 1.66e-35   NR XP_005783763.1 280463 g70376 i0 83.1 5.53409090909091 77 11 85.2 1 32 256 17 93 XP_005783763.1 peptidyl-prolyl isomerase [Emiliania huxleyi CCMP1516] diamond 1461 131 0.99236641221374 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
23384299 23384299 PRJNA437204_P_NODE_16299_length_444_cov_3.121294_g16000_i0 PRJNA437204 16299 444 3.121294 13.85854536 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 90.1 3.06e-20   NR KAG8469654.1 2081491 g16000 i0 51.5 1.41891891891892 103 45 66.2 2 2 295 2 104 KAG8469654.1 hypothetical protein KFE25_006109 [Diacronema lutheri] diamond 630 90.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
24041588 24041588 PRJNA437204_P_NODE_37119_length_332_cov_2.073359_g36820_i0 PRJNA437204 37119 332 2.073359 6.88355188 Viridiplantae 33090 Haptophyta other_Eukaryota 307 6.050000000000001e-79   NTclustered gi|551613833|ref|XM_005787831.1| 280463 g36820 i0 84.112 58.9969879518072 321 47 96 4 12 330 48 366 Emiliania huxleyi CCMP1516 putative EF-1 alpha/Tu like protein (EFG1), mRNA blastn 19587 307 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27423793 27423793 PRJNA437204_P_NODE_39023_length_327_cov_1.212598_g38724_i0 PRJNA437204 39023 327 1.212598 3.96519546 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 70.1 2.33e-11   NR BBJ00879.1 2792838 g38724 i0 52.9 0.642201834862385 70 32 64.2 1 302 93 393 461 BBJ00879.1 vacuolar protein-sorting-associated protein variant 1, partial [Raphidocystis contractilis] diamond 210 70.1 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
27644767 27644767 PRJNA437204_P_NODE_113384_length_244_cov_0.900585_g113085_i0 PRJNA437204 113384 244 0.900585 2.1974274 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 84.3 8.56e-17   NR KOO29092.1 1460289 g113085 i0 62.1 0.811475409836066 66 23 81.1 2 43 240 83 146 KOO29092.1 phosphoenolpyruvate carboxykinase [Chrysochromulina tobinii] diamond 198 84.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28008421 28008421 PRJNA437204_P_NODE_14985_length_459_cov_1.994819_g14686_i0 PRJNA437204 14985 459 1.994819 9.15621921 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99 1.8e-23   NR KOO23953.1 1460289 g14686 i0 52.1 4.29411764705882 117 54 75.8 2 404 57 4 119 KOO23953.1 ribosomal protein l31 [Chrysochromulina tobinii] diamond 1971 99.8 0.991983967935872 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28623522 28623522 PRJNA437204_P_NODE_62967_length_276_cov_1.325123_g62668_i0 PRJNA437204 62967 276 1.325123 3.65733948 Prymnesium parvum 97485 Haptophyta other_Eukaryota 59.7 6.11e-8   NR KAL1503142.1 97485 g62668 i0 53.2 2.32608695652174 62 27 65.2 1 5 184 49 110 KAL1503142.1 hypothetical protein AB1Y20_011204 [Prymnesium parvum] diamond 642 59.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28749657 28749657 PRJNA437204_P_NODE_45087_length_311_cov_7.172269_g44788_i0 PRJNA437204 45087 311 7.172269 22.30575659 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 88.6 2.66e-20   NR KAG8469654.1 2081491 g44788 i0 50.5 2.92282958199357 97 44 89.7 1 308 30 8 104 KAG8469654.1 hypothetical protein KFE25_006109 [Diacronema lutheri] diamond 909 88.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
29191821 29191821 PRJNA437204_P_NODE_89449_length_249_cov_0.875000_g89150_i0 PRJNA437204 89449 249 0.875 2.17875 Prymnesium parvum 97485 Haptophyta other_Eukaryota 60.8 1.63e-8   NR KAL1518543.1 97485 g89150 i0 45.1 6.8433734939759 71 38 84.3 1 36 245 182 252 KAL1518543.1 hypothetical protein AB1Y20_002832 [Prymnesium parvum] diamond 1704 60.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29349649 29349649 PRJNA437204_P_NODE_83229_length_251_cov_0.865169_g82930_i0 PRJNA437204 83229 251 0.865169 2.17157419 Prymnesium parvum 97485 Haptophyta other_Eukaryota 64.3 1.07e-9   NR KAL1515792.1 97485 g82930 i0 49.2 1.49402390438247 63 32 75.3 0 238 50 3265 3327 KAL1515792.1 hypothetical protein AB1Y20_002408 [Prymnesium parvum] diamond 375 64.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30012835 30012835 PRJNA437204_P_NODE_41491_length_320_cov_1.870445_g41192_i0 PRJNA437204 41491 320 1.870445 5.985424 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 65.9 3.83e-10   NR KAG8461242.1 2081491 g41192 i0 34.7 1.78125 95 54 89.1 2 308 24 4 90 KAG8461242.1 hypothetical protein KFE25_002431 [Diacronema lutheri] diamond 570 65.9 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30107360 30107360 PRJNA437204_P_NODE_107972_length_245_cov_0.895349_g107673_i0 PRJNA437204 107972 245 0.895349 2.19360505 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 62.8 7.09e-11   NR KAG8467329.1 2081491 g107673 i0 41.9 0.759183673469388 62 35 75.9 1 15 200 7 67 KAG8467329.1 hypothetical protein KFE25_000645 [Diacronema lutheri] diamond 186 62.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30265719 30265719 PRJNA437204_P_NODE_10332_length_530_cov_3.531729_g10034_i0 PRJNA437204 10332 530 3.531729 18.7181637 Prymnesium parvum 97485 Haptophyta other_Eukaryota 216 1.87e-64   NR KAL1523449.1 97485 g10034 i0 63.7 0.888679245283019 157 54 87.7 2 66 530 22 177 KAL1523449.1 hypothetical protein AB1Y20_018389 [Prymnesium parvum] diamond 471 216 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30423836 30423836 PRJNA437204_P_NODE_85233_length_250_cov_0.870056_g84934_i0 PRJNA437204 85233 250 0.870056 2.17514 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 43.1 0.0289   NR KAG8462114.1 2081491 g84934 i0 58.5 0.636 53 16 60 3 2 151 339 388 KAG8462114.1 hypothetical protein KFE25_011564 [Diacronema lutheri] diamond 159 43.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30581169 30581169 PRJNA437204_P_NODE_26593_length_371_cov_5.114094_g26294_i0 PRJNA437204 26593 371 5.114094 18.97328874 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 77.8 1.09e-15   NR KAL3928833.1 2812485 g26294 i0 43.3 3.33153638814016 67 38 54.2 0 337 137 7 73 KAL3928833.1 MAG: hypothetical protein SGPRY_002222 [Prymnesium sp.] diamond 1236 77.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30865693 30865693 PRJNA437204_P_NODE_34154_length_342_cov_0.858736_g33855_i0 PRJNA437204 34154 342 0.858736 2.93687712 Prymnesium parvum 97485 Haptophyta other_Eukaryota 45.8 0.00844   NR KAL1530149.1 97485 g33855 i0 41.7 0.842105263157895 96 25 84.2 4 3 290 129 193 KAL1530149.1 hypothetical protein AB1Y20_001065 [Prymnesium parvum] diamond 288 45.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31845787 31845787 PRJNA437204_P_NODE_117897_length_243_cov_0.905882_g117598_i0 PRJNA437204 117897 243 0.905882 2.20129326 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 97.8 1.54e-21   NR KOO33974.1 1460289 g117598 i0 56.3 0.987654320987654 80 35 98.8 0 241 2 708 787 KOO33974.1 ubiquitin-activating enzyme e1, partial [Chrysochromulina tobinii] diamond 240 97.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32020575 32020575 PRJNA437204_P_NODE_98478_length_247_cov_0.885057_g98179_i0 PRJNA437204 98478 247 0.885057 2.18609079 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 49.3 1.33e-4   NR KAL1527810.1 97485 g98179 i0 40.3 2.18623481781377 72 31 83.8 3 215 9 20 82 KAL1527810.1 hypothetical protein AB1Y20_009193 [Prymnesium parvum] diamond 540 49.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32415566 32415566 PRJNA437204_P_NODE_14399_length_466_cov_3.302799_g14100_i0 PRJNA437204 14399 466 3.302799 15.39104334 Prymnesium parvum 97485 Haptophyta other_Eukaryota 104 1.89e-25   NR KAL1514807.1 97485 g14100 i0 42.9 0.766094420600858 119 65 76.6 1 380 24 25 140 KAL1514807.1 hypothetical protein AB1Y20_003893 [Prymnesium parvum] diamond 357 104 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32636339 32636339 PRJNA437204_P_NODE_38780_length_328_cov_0.901961_g38481_i0 PRJNA437204 38780 328 0.901961 2.95843208 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 78.2 2.22e-14   NR KAJ1620944.1 483367 g38481 i0 52 0.685975609756098 75 36 68.6 0 326 102 274 348 KAJ1620944.1 hypothetical protein T492DRAFT_1074198 [Pavlovales sp. CCMP2436] diamond 225 78.2 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;