RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA874604", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 21 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 21 ✖

bioproject 1

  • PRJNA874604 · 21 ✖

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
5066010 5066010 PRJNA874604_P_NODE_44964_length_295_cov_1.387387_g44612_i0 PRJNA874604 44964 295 1.387387 4.09279165 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 77.8 9.11e-17   NR KAJ1630732.1 483367 g44612 i0 81.8 23.3389830508475 44 8 44.7 0 295 164 8 51 KAJ1630732.1 ribosomal protein L39e [Pavlovales sp. CCMP2436] diamond 6885 77.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
13992082 13992082 PRJNA874604_P_NODE_72811_length_250_cov_0.870056_g72459_i0 PRJNA874604 72811 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 118 4.39e-29   NR KAJ1624316.1 483367 g72459 i0 69.9 11.748 83 23 99.6 1 250 2 279 359 KAJ1624316.1 putative adenylosuccinate synthetase [Pavlovales sp. CCMP2436] diamond 2937 118 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
17430588 17430588 PRJNA874604_P_NODE_70994_length_250_cov_2.305085_g70642_i0 PRJNA874604 70994 250 2.305085 5.7627125 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 92.4 1.36e-19   NR KAG8470740.1 2081491 g70642 i0 50.6 1.992 83 41 99.6 0 2 250 86 168 KAG8470740.1 hypothetical protein KFE25_009161 [Diacronema lutheri] diamond 498 92.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
19979701 19979701 PRJNA874604_P_NODE_99736_length_241_cov_0.916667_g99384_i0 PRJNA874604 99736 241 0.916667 2.20916747 Prymnesium parvum 97485 Haptophyta other_Eukaryota 114 4.54e-28   NR KAL1495842.1 97485 g99384 i0 70.9 1.96680497925311 79 23 98.3 0 3 239 48 126 KAL1495842.1 hypothetical protein AB1Y20_016701 [Prymnesium parvum] diamond 474 114 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
23803532 23803532 PRJNA874604_P_NODE_11939_length_500_cov_1.081967_g11588_i0 PRJNA874604 11939 500 1.081967 5.409835 Prymnesium parvum 97485 Haptophyta other_Eukaryota 218 5.72e-69   NR KAL1525517.1 97485 g11588 i0 67.1 6.822 167 52 99 2 500 6 37 202 KAL1525517.1 hypothetical protein AB1Y20_020373 [Prymnesium parvum] diamond 3411 218 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
25078417 25078417 PRJNA874604_P_NODE_66880_length_254_cov_0.895028_g66528_i0 PRJNA874604 66880 254 0.895028 2.27337112 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 107 3.5100000000000004e-27   NR KAG8466399.1 2081491 g66528 i0 67.5 3.59055118110236 83 26 98 1 249 1 25 106 KAG8466399.1 hypothetical protein KFE25_002155 [Diacronema lutheri] diamond 912 107 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
26611878 26611878 PRJNA874604_P_NODE_90301_length_244_cov_0.900585_g89949_i0 PRJNA874604 90301 244 0.900585 2.1974274 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 81.6 6.38e-16   NR KAL3911515.1 2812485 g89949 i0 68.8 0.786885245901639 64 20 78.7 0 228 37 201 264 KAL3911515.1 MAG: hypothetical protein SGPRY_008664 [Prymnesium sp.] diamond 192 81.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
27719048 27719048 PRJNA874604_P_NODE_29584_length_346_cov_1.783883_g29232_i0 PRJNA874604 29584 346 1.783883 6.17223518 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 122 6.5e-33   NR KAJ1638552.1 483367 g29232 i0 63.8 1.65606936416185 94 34 81.5 0 284 3 4 97 KAJ1638552.1 transcription factor [Pavlovales sp. CCMP2436] diamond 573 122 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
27781892 27781892 PRJNA874604_P_NODE_68784_length_251_cov_0.865169_g68432_i0 PRJNA874604 68784 251 0.865169 2.17157419 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 65.9 2.91e-10   NR KAL3900026.1 2812485 g68432 i0 44.3 0.729083665338645 61 34 72.9 0 196 14 429 489 KAL3900026.1 MAG: hypothetical protein SGPRY_012536, partial [Prymnesium sp.] diamond 183 65.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
28129184 28129184 PRJNA874604_P_NODE_30545_length_342_cov_1.405204_g30193_i0 PRJNA874604 30545 342 1.405204 4.80579768 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 81.6 2.67e-15   NR KOO30669.1 1460289 g30193 i0 48.5 0.850877192982456 97 44 80.7 2 281 6 794 889 KOO30669.1 lysosomal alpha-mannosidase-like protein [Chrysochromulina tobinii] diamond 291 81.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28223652 28223652 PRJNA874604_P_NODE_89126_length_244_cov_1.719298_g88774_i0 PRJNA874604 89126 244 1.719298 4.19508712 Prymnesium parvum 97485 Haptophyta other_Eukaryota 99.4 9.67e-25   NR KAL1495466.1 97485 g88774 i0 73 5.0655737704918 63 17 77.5 0 190 2 15 77 KAL1495466.1 hypothetical protein AB1Y20_016832 [Prymnesium parvum] diamond 1236 99.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28444996 28444996 PRJNA874604_P_NODE_82466_length_247_cov_0.885057_g82114_i0 PRJNA874604 82466 247 0.885057 2.18609079 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 56.2 7.12e-7   NR KAG8460151.1 2081491 g82114 i0 39.5 1.84615384615385 76 45 91.1 1 247 23 60 135 KAG8460151.1 hypothetical protein KFE25_014296 [Diacronema lutheri] diamond 456 56.2 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28697596 28697596 PRJNA874604_P_NODE_51207_length_282_cov_1.220096_g50855_i0 PRJNA874604 51207 282 1.220096 3.44067072 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 48.9 8.19e-5   NR KOO52985.1 1460289 g50855 i0 50 0.446808510638298 42 21 44.7 0 281 156 63 104 KOO52985.1 hypothetical protein Ctob_013854 [Chrysochromulina tobinii] diamond 126 48.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29518261 29518261 PRJNA874604_P_NODE_84290_length_246_cov_0.890173_g83938_i0 PRJNA874604 84290 246 0.890173 2.18982558 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 53.9 4.37e-6   NR XP_005783837.1 280463 g83938 i0 34.6 0.951219512195122 78 51 95.1 0 8 241 273 350 XP_005783837.1 hypothetical protein EMIHUDRAFT_442264 [Emiliania huxleyi CCMP1516] diamond 234 53.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29747123 29747123 PRJNA874604_P_NODE_87370_length_245_cov_0.895349_g87018_i0 PRJNA874604 87370 245 0.895349 2.19360505 Viridiplantae 33090 Haptophyta other_Eukaryota 62.8 3.34e-9   NR KAL1528079.1 97485 g87018 i0 38.3 1.98367346938776 81 47 98 2 4 243 573 651 KAL1528079.1 hypothetical protein AB1Y20_009445 [Prymnesium parvum] diamond 486 62.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30023811 30023811 PRJNA874604_P_NODE_70291_length_251_cov_0.865169_g69939_i0 PRJNA874604 70291 251 0.865169 2.17157419 Prymnesium parvum 97485 Haptophyta other_Eukaryota 71.6 2.84e-12   NR KAL1520209.1 97485 g69939 i0 46.4 4.43426294820717 84 41 95.6 2 250 11 2790 2873 KAL1520209.1 hypothetical protein AB1Y20_023679 [Prymnesium parvum] diamond 1113 71.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30371625 30371625 PRJNA874604_P_NODE_92652_length_243_cov_0.905882_g92300_i0 PRJNA874604 92652 243 0.905882 2.20129326 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 45.4 0.00412   NR KOO34161.1 1460289 g92300 i0 35 2.33333333333333 60 37 74.1 1 224 45 135 192 KOO34161.1 polycystic kidney disease 2-like 1 [Chrysochromulina tobinii] diamond 567 45.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30916543 30916543 PRJNA874604_P_NODE_82054_length_247_cov_0.885057_g81702_i0 PRJNA874604 82054 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 102 1.1799999999999999e-23   NR KAG8465291.1 2081491 g81702 i0 65.3 2.81781376518219 75 25 91.1 1 235 11 201 274 KAG8465291.1 hypothetical protein KFE25_002598 [Diacronema lutheri] diamond 696 102 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31896507 31896507 PRJNA874604_P_NODE_50977_length_282_cov_1.473684_g50625_i0 PRJNA874604 50977 282 1.473684 4.15578888 Prymnesiales 73028 Haptophyta other_Eukaryota 74.7 5.2e-14   NR KAL1523442.1 97485 g50625 i0 52.4 1.64893617021277 82 37 85.1 2 241 2 129 210 KAL1523442.1 hypothetical protein AB1Y20_018382 [Prymnesium parvum] diamond 465 75.1 0.994673768308922 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31991416 31991416 PRJNA874604_P_NODE_88498_length_245_cov_0.895349_g88146_i0 PRJNA874604 88498 245 0.895349 2.19360505 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 46.6 0.00156   NR KAL1520698.1 97485 g88146 i0 43.1 1.39591836734694 51 29 62.4 0 66 218 217 267 KAL1520698.1 hypothetical protein AB1Y20_022267 [Prymnesium parvum] diamond 342 46.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32394860 32394860 PRJNA874604_P_NODE_47359_length_289_cov_1.425926_g47007_i0 PRJNA874604 47359 289 1.425926 4.12092614 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 61.2 2e-8   NR XP_005767792.1 280463 g47007 i0 36.2 0.975778546712803 94 48 97.6 2 6 287 823 904 XP_005767792.1 hypothetical protein EMIHUDRAFT_211533 [Emiliania huxleyi CCMP1516] diamond 282 61.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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