RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA857857", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 14 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 14 ✖

bioproject 1

  • PRJNA857857 · 14 ✖

analysis 1

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
2120936 2120936 PRJNA857857_P_NODE_9642_length_504_cov_1.141531_g9205_i0 PRJNA857857 9642 504 1.141531 5.75331624 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 255 2.95e-82   NR XP_005777541.1 280463 g9205 i0 88 3.16666666666667 133 16 79.2 0 1 399 175 307 XP_005777541.1 hypothetical protein EMIHUDRAFT_415666 [Emiliania huxleyi CCMP1516] diamond 1596 256 0.99609375 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
5948727 5948727 PRJNA857857_P_NODE_49525_length_242_cov_0.970414_g49076_i0 PRJNA857857 49525 242 0.970414 2.34840188 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 126 1.09e-34   NR KAG8468424.1 2081491 g49076 i0 82.9 1.89669421487603 76 11 93 2 240 16 116 190 KAG8468424.1 hypothetical protein KFE25_013507 [Diacronema lutheri] diamond 459 126 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
7223357 7223357 PRJNA857857_P_NODE_39086_length_250_cov_0.870056_g38637_i0 PRJNA857857 39086 250 0.870056 2.17514 Prymnesium parvum 97485 Haptophyta other_Eukaryota 152 1.26e-40   NR KAL1530354.1 97485 g38637 i0 84.3 4.98 83 13 99.6 0 250 2 398 480 KAL1530354.1 hypothetical protein AB1Y20_001262 [Prymnesium parvum] diamond 1245 152 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
25070943 25070943 PRJNA857857_P_NODE_21420_length_338_cov_1.162264_g20971_i0 PRJNA857857 21420 338 1.162264 3.92845232 Prymnesium parvum 97485 Haptophyta other_Eukaryota 56.2 2.09e-6   NR KAL1527782.1 97485 g20971 i0 32.4 0.958579881656805 108 56 84.3 3 338 54 591 694 KAL1527782.1 hypothetical protein AB1Y20_009167 [Prymnesium parvum] diamond 324 56.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26801829 26801829 PRJNA857857_P_NODE_39621_length_249_cov_0.875000_g39172_i0 PRJNA857857 39621 249 0.875 2.17875 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 103 7.19e-24   NR KAL3933475.1 2812485 g39172 i0 57.5 0.963855421686747 80 33 95.2 1 2 238 111 190 KAL3933475.1 MAG: hypothetical protein SGPRY_000266 [Prymnesium sp.] diamond 240 103 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
26959997 26959997 PRJNA857857_P_NODE_15322_length_402_cov_0.936170_g14875_i0 PRJNA857857 15322 402 0.93617 3.7634034 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 135 1.06e-33   NR XP_005766397.1 280463 g14875 i0 54.4 3.48507462686567 114 52 85.1 0 58 399 628 741 XP_005766397.1 hypothetical protein EMIHUDRAFT_419647 [Emiliania huxleyi CCMP1516] diamond 1401 135 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27411173 27411173 PRJNA857857_P_NODE_43063_length_247_cov_0.885057_g42614_i0 PRJNA857857 43063 247 0.885057 2.18609079 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 61.6 7.54e-9   NR XP_005756354.1 280463 g42614 i0 66.7 1.42105263157895 39 13 47.4 0 21 137 204 242 XP_005756354.1 hypothetical protein EMIHUDRAFT_221729 [Emiliania huxleyi CCMP1516] diamond 351 61.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28413178 28413178 PRJNA857857_P_NODE_11606_length_462_cov_1.933162_g11166_i0 PRJNA857857 11606 462 1.933162 8.93120844 Prymnesium parvum 97485 Haptophyta other_Eukaryota 60.5 2.44e-7   NR KAL1529569.1 97485 g11166 i0 39 0.649350649350649 100 53 61.7 3 287 3 4 100 KAL1529569.1 hypothetical protein AB1Y20_000513 [Prymnesium parvum] diamond 300 60.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29802289 29802289 PRJNA857857_P_NODE_44991_length_245_cov_1.343023_g44542_i0 PRJNA857857 44991 245 1.343023 3.29040635 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 127 2.8199999999999996e-32   NR KAL3916196.1 2812485 g44542 i0 79.3 2.00816326530612 82 16 99.2 1 1 243 43 124 KAL3916196.1 MAG: hypothetical protein SGPRY_006925 [Prymnesium sp.] diamond 492 127 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
29991957 29991957 PRJNA857857_P_NODE_43571_length_246_cov_1.335260_g43122_i0 PRJNA857857 43571 246 1.33526 3.2847396 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 59.3 5.4e-8   NR XP_005777080.1 280463 g43122 i0 54 1.78048780487805 50 23 61 0 152 3 47 96 XP_005777080.1 hypothetical protein EMIHUDRAFT_450562 [Emiliania huxleyi CCMP1516] diamond 438 59.3 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30623618 30623618 PRJNA857857_P_NODE_32733_length_268_cov_2.297436_g32284_i0 PRJNA857857 32733 268 2.297436 6.15712848 Prymnesium parvum 97485 Haptophyta other_Eukaryota 86.7 1.26e-17   NR KAL1519519.1 97485 g32284 i0 52.8 1.94776119402985 89 37 94 2 266 15 127 215 KAL1519519.1 hypothetical protein AB1Y20_023034 [Prymnesium parvum] diamond 522 86.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30750267 30750267 PRJNA857857_P_NODE_8934_length_521_cov_1.332589_g8503_i0 PRJNA857857 8934 521 1.332589 6.94278869 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 134 4.34e-33   NR KOO29442.1 1460289 g8503 i0 77.9 1.19769673704415 104 23 59.9 0 3 314 14 117 KOO29442.1 cytosolic endo-beta-n-acetylglucosaminidase-like protein [Chrysochromulina tobinii] diamond 624 134 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32308178 32308178 PRJNA857857_P_NODE_37899_length_250_cov_1.282486_g37450_i0 PRJNA857857 37899 250 1.282486 3.206215 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 114 1.39e-27   NR KAL1495595.1 97485 g37450 i0 80.2 9.66 81 16 97.2 0 245 3 401 481 KAL1495595.1 hypothetical protein AB1Y20_016955 [Prymnesium parvum] diamond 2415 114 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32741997 32741997 PRJNA857857_P_NODE_9880_length_498_cov_1.378824_g9440_i0 PRJNA857857 9880 498 1.378824 6.86654352 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 133 4.78e-36   NR KAG8468267.1 2081491 g9440 i0 61.5 0.656626506024096 109 42 65.7 0 497 171 26 134 KAG8468267.1 hypothetical protein KFE25_013350 [Diacronema lutheri] diamond 327 133 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri

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);;