RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA670521" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 19 ✖

bioproject 1

  • PRJNA670521 · 19 ✖

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
3189009 3189009 PRJNA670521_P_NODE_36143_length_336_cov_1.977186_g35398_i0 PRJNA670521 36143 336 1.977186 6.64334496 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 63.9 3.82e-9   NR KAL3919184.1 2812485 g35398 i0 66.7 1.79464285714286 42 14 37.5 0 332 207 353 394 KAL3919184.1 MAG: hypothetical protein SGPRY_005721 [Prymnesium sp.] diamond 603 63.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
13918861 13918861 PRJNA670521_P_NODE_46311_length_305_cov_1.625000_g45566_i0 PRJNA670521 46311 305 1.625 4.95625 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 59.7 8.59e-8   NR KAG8469219.1 2081491 g45566 i0 51.9 2.11475409836066 54 26 53.1 0 253 92 719 772 KAG8469219.1 hypothetical protein KFE25_007737 [Diacronema lutheri] diamond 645 59.7 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
14667052 14667052 PRJNA670521_P_NODE_2052_length_1211_cov_2.469244_g1613_i0 PRJNA670521 2052 1211 2.469244 29.90254484 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 378 2.8099999999999994e-126   NR XP_005790675.1 280463 g1613 i0 63.6 2.83897605284889 286 99 70.1 4 114 962 45 328 XP_005790675.1 putative alternative oxidase [Emiliania huxleyi CCMP1516] diamond 3438 378 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
19764956 19764956 PRJNA670521_P_NODE_13676_length_494_cov_1.071259_g12938_i0 PRJNA670521 13676 494 1.071259 5.29201946 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 331 5.53e-86   NTclustered gi|551605616|ref|XM_005784143.1| 280463 g12938 i0 80.18 69.2935222672065 444 86 90 2 50 492 1246 804 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 34231 331 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26860548 26860548 PRJNA670521_P_NODE_86541_length_244_cov_0.900585_g85796_i0 PRJNA670521 86541 244 0.900585 2.1974274 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 118 5.01e-29   NR XP_005764875.1 280463 g85796 i0 67.9 0.995901639344262 81 26 99.6 0 2 244 19 99 XP_005764875.1 mitochondrial malic enzyme [Emiliania huxleyi CCMP1516] diamond 243 118 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27366428 27366428 PRJNA670521_P_NODE_20123_length_420_cov_1.775216_g19380_i0 PRJNA670521 20123 420 1.775216 7.4559072 Prymnesium parvum 97485 Haptophyta other_Eukaryota 153 4.28e-40   NR KAL1508083.1 97485 g19380 i0 51.4 1 140 68 100 0 1 420 690 829 KAL1508083.1 hypothetical protein AB1Y20_007676 [Prymnesium parvum] diamond 420 153 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27745360 27745360 PRJNA670521_P_NODE_85104_length_244_cov_1.350877_g84359_i0 PRJNA670521 85104 244 1.350877 3.29613988 Prymnesium parvum 97485 Haptophyta other_Eukaryota 101 2.26e-23   NR KAL1498745.1 97485 g84359 i0 60 0.983606557377049 80 31 98.4 1 3 242 61 139 KAL1498745.1 hypothetical protein AB1Y20_014055 [Prymnesium parvum] diamond 240 101 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28502886 28502886 PRJNA670521_P_NODE_33407_length_346_cov_1.128205_g32662_i0 PRJNA670521 33407 346 1.128205 3.9035893 Prymnesium parvum 97485 Haptophyta other_Eukaryota 72.4 4.5e-12   NR KAL1495312.1 97485 g32662 i0 38.6 0.988439306358382 114 61 95.4 3 2 331 129 237 KAL1495312.1 hypothetical protein AB1Y20_017170 [Prymnesium parvum] diamond 342 72.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28881644 28881644 PRJNA670521_P_NODE_17908_length_441_cov_2.298913_g17166_i0 PRJNA670521 17908 441 2.298913 10.13820633 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 76.6 1.79e-15   NR KAJ1628734.1 483367 g17166 i0 70 0.863945578231292 60 17 40.1 1 360 184 1 60 KAJ1628734.1 ribosomal protein S30 [Pavlovales sp. CCMP2436] diamond 381 76.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
28945148 28945148 PRJNA670521_P_NODE_17488_length_446_cov_1.080429_g16746_i0 PRJNA670521 17488 446 1.080429 4.81871334 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 65.5 2.5e-9   NR KOO53888.1 1460289 g16746 i0 38.1 1.24439461883408 97 59 65.2 1 28 318 212 307 KOO53888.1 voltage-dependent anion-selective channel [Chrysochromulina tobinii] diamond 555 65.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29323674 29323674 PRJNA670521_P_NODE_26609_length_377_cov_1.256579_g25865_i0 PRJNA670521 26609 377 1.256579 4.73730283 Prymnesium parvum 97485 Haptophyta other_Eukaryota 54.7 1.05e-5   NR KAL1508506.1 97485 g25865 i0 53.5 0.342175066312997 43 20 34.2 0 377 249 342 384 KAL1508506.1 hypothetical protein AB1Y20_004607 [Prymnesium parvum] diamond 129 54.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29702311 29702311 PRJNA670521_P_NODE_86550_length_244_cov_0.900585_g85805_i0 PRJNA670521 86550 244 0.900585 2.1974274 Prymnesium parvum 97485 Haptophyta other_Eukaryota 60.1 1.45e-8   NR KAL1527939.1 97485 g85805 i0 44.8 0.823770491803279 67 36 82.4 1 206 6 84 149 KAL1527939.1 hypothetical protein AB1Y20_009310 [Prymnesium parvum] diamond 201 60.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30018683 30018683 PRJNA670521_P_NODE_6931_length_672_cov_1.771285_g6220_i0 PRJNA670521 6931 672 1.771285 11.9030352 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 164 2.1200000000000001e-44   NR KAG8463698.1 2081491 g6220 i0 35.8 1.93303571428571 218 135 96.9 2 672 22 215 428 KAG8463698.1 hypothetical protein KFE25_003971 [Diacronema lutheri] diamond 1299 164 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30776916 30776916 PRJNA670521_P_NODE_77554_length_248_cov_0.880000_g76809_i0 PRJNA670521 77554 248 0.88 2.1824 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 76.3 2.67e-14   NR KOO28243.1 1460289 g76809 i0 45.1 0.991935483870968 82 43 99.2 1 247 2 177 256 KOO28243.1 mitochondrial carrier protein [Chrysochromulina tobinii] diamond 246 76.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30839987 30839987 PRJNA670521_P_NODE_70714_length_251_cov_0.865169_g69969_i0 PRJNA670521 70714 251 0.865169 2.17157419 Prymnesium parvum 97485 Haptophyta other_Eukaryota 62.8 1.56e-10   NR KAL1521921.1 97485 g69969 i0 42.9 0.836653386454183 70 40 83.7 0 250 41 31 100 KAL1521921.1 hypothetical protein AB1Y20_021570 [Prymnesium parvum] diamond 210 62.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31124003 31124003 PRJNA670521_P_NODE_43635_length_313_cov_0.954167_g42890_i0 PRJNA670521 43635 313 0.954167 2.98654271 Prymnesium parvum 97485 Haptophyta other_Eukaryota 103 2.23e-24   NR KAL1522205.1 97485 g42890 i0 61.5 0.747603833865815 78 29 73.8 1 233 3 3 80 KAL1522205.1 hypothetical protein AB1Y20_021843 [Prymnesium parvum] diamond 234 103 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31282304 31282304 PRJNA670521_P_NODE_52875_length_289_cov_1.129630_g52130_i0 PRJNA670521 52875 289 1.12963 3.2646307 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 77.8 3.18e-14   NR KOO29508.1 1460289 g52130 i0 42.7 0.996539792387543 96 52 99.7 2 288 1 9 101 KOO29508.1 uv damaged DNA binding protein 1 [Chrysochromulina tobinii] diamond 288 77.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31725106 31725106 PRJNA670521_P_NODE_23677_length_394_cov_1.352025_g22933_i0 PRJNA670521 23677 394 1.352025 5.3269785 Prymnesium parvum 97485 Haptophyta other_Eukaryota 146 6.56e-38   NR KAL1525396.1 97485 g22933 i0 64.7 1.86548223350254 116 40 87.6 1 350 6 305 420 KAL1525396.1 hypothetical protein AB1Y20_020255 [Prymnesium parvum] diamond 735 146 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32548100 32548100 PRJNA670521_P_NODE_64939_length_262_cov_1.222222_g64194_i0 PRJNA670521 64939 262 1.222222 3.20222164 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 64.7 1.92e-10   NR KAJ1628197.1 483367 g64194 i0 50 0.66412213740458 58 29 66.4 0 2 175 127 184 KAJ1628197.1 hypothetical protein T492DRAFT_1145812 [Pavlovales sp. CCMP2436] diamond 174 64.7 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);;