RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA928559", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 25 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 25 ✖

bioproject 1

  • PRJNA928559 · 25 ✖

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
9832521 9832521 PRJNA928559_P_NODE_97768_length_360_cov_4.738676_g96199_i0 PRJNA928559 97768 360 4.738676 17.0592336 Dicrateria rotunda 2703868 Haptophyta other_Eukaryota 228 5.279999999999998e-55   NTclustered gi|259419544|emb|FN392559.1| 2703868 g96199 i0 81.169 81.0555555555556 308 37 86 11 4 311 121 407 Imantonia rotunda partial mRNA for ADP-ribosylation factor 3, contig 10068 blastn 29180 228 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Dicrateria Dicrateria rotunda
11106376 11106376 PRJNA928559_P_NODE_166169_length_271_cov_3.444444_g164600_i0 PRJNA928559 166169 271 3.444444 9.33444324 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 158 5.12e-34   NTclustered gi|551583414|ref|XM_005777087.1| 280463 g164600 i0 79.31 13.5608856088561 232 42 85 5 2 230 3816 4044 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 3675 158 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
20029204 20029204 PRJNA928559_P_NODE_15176_length_801_cov_49.837912_g13817_i0 PRJNA928559 15176 801 49.837912 399.20167512 Pterocystis tropica 299886 Root_unresolved Root_unresolved 625 3.7799999999999996e-174   NTclustered gi|61187375|gb|AY752993.1| 299886 g13817 i0 91.023 53.9388264669164 479 20 59 13 266 739 2501 2041 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 43205 625 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
21305213 21305213 PRJNA928559_P_NODE_188357_length_253_cov_0.866667_g186788_i0 PRJNA928559 188357 253 0.866667 2.19266751 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 167 3.14e-46   NR KAJ1625898.1 483367 g186788 i0 95.2 1.99209486166008 84 4 99.6 0 252 1 158 241 KAJ1625898.1 cell division control protein 48-like protein E-like protein [Pavlovales sp. CCMP2436] diamond 504 167 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
22579572 22579572 PRJNA928559_P_NODE_136738_length_303_cov_1.400000_g135169_i0 PRJNA928559 136738 303 1.4 4.242 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 156 2.09e-33   NTclustered gi|551555706|ref|XM_005764956.1| 280463 g135169 i0 78.926 3.03300330033003 242 41 78 9 42 278 737 501 Emiliania huxleyi CCMP1516 mitochondrial carrier protein mRNA blastn 919 156 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26613116 26613116 PRJNA928559_P_NODE_195681_length_250_cov_0.881356_g194112_i0 PRJNA928559 195681 250 0.881356 2.20339 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 93.6 5.32e-20   NR KOO31503.1 1460289 g194112 i0 57.3 0.984 82 35 98.4 0 247 2 286 367 KOO31503.1 family 3 glycoside hydrolase [Chrysochromulina tobinii] diamond 246 93.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27056507 27056507 PRJNA928559_P_NODE_191182_length_252_cov_0.871508_g189613_i0 PRJNA928559 191182 252 0.871508 2.19620016 Prymnesium parvum 97485 Haptophyta other_Eukaryota 45.4 0.00454   NR KAL1499491.1 97485 g189613 i0 53.8 0.464285714285714 39 18 46.4 0 134 250 265 303 KAL1499491.1 hypothetical protein AB1Y20_011694 [Prymnesium parvum] diamond 117 45.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27150761 27150761 PRJNA928559_P_NODE_144382_length_294_cov_1.393665_g142813_i0 PRJNA928559 144382 294 1.393665 4.0973751 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 124 2.6999999999999997e-31   NR KAJ1619581.1 483367 g142813 i0 69.1 3.30612244897959 81 25 82.7 0 286 44 388 468 KAJ1619581.1 methionyl aminopeptidase 2 [Pavlovales sp. CCMP2436] diamond 972 124 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
27158084 27158084 PRJNA928559_P_NODE_37862_length_541_cov_3.745726_g36308_i0 PRJNA928559 37862 541 3.745726 20.26437766 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 155 5.48e-45   NR KAL1514451.1 97485 g36308 i0 54.1 10.9075785582255 135 62 74.9 0 509 105 9 143 KAL1514451.1 hypothetical protein AB1Y20_003550 [Prymnesium parvum] diamond 5901 155 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27189868 27189868 PRJNA928559_P_NODE_147462_length_290_cov_2.806452_g145893_i0 PRJNA928559 147462 290 2.806452 8.1387108 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 84 1.02e-16   NR KAL1519278.1 97485 g145893 i0 62.3 4.84137931034483 69 26 71.4 0 282 76 274 342 KAL1519278.1 hypothetical protein AB1Y20_022807 [Prymnesium parvum] diamond 1404 84 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27695687 27695687 PRJNA928559_P_NODE_171284_length_267_cov_1.309278_g169715_i0 PRJNA928559 171284 267 1.309278 3.49577226 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 70.9 3.52e-13   NR KAL1527875.1 97485 g169715 i0 43.8 1.98876404494382 89 49 98.9 1 265 2 46 134 KAL1527875.1 hypothetical protein AB1Y20_009251 [Prymnesium parvum] diamond 531 70.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27877720 27877720 PRJNA928559_P_NODE_227445_length_200_cov_5.338583_g225876_i0 PRJNA928559 227445 200 5.338583 10.677166 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 67.4 4.12e-11   NR KAG8466175.1 2081491 g225876 i0 49.2 0.885 59 30 88.5 0 197 21 293 351 KAG8466175.1 hypothetical protein KFE25_001931 [Diacronema lutheri] diamond 177 67.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28705906 28705906 PRJNA928559_P_NODE_212707_length_243_cov_0.917647_g211138_i0 PRJNA928559 212707 243 0.917647 2.22988221 root 1 Root_unresolved Root_unresolved 107 6.43e-25   NR KOO24103.1 1460289 g211138 i0 60 1.97530864197531 80 32 98.8 0 3 242 603 682 KOO24103.1 thymidylate kinase [Chrysochromulina tobinii] diamond 480 108 0.990740740740741 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28856320 28856320 PRJNA928559_P_NODE_194328_length_250_cov_1.480226_g192759_i0 PRJNA928559 194328 250 1.480226 3.700565 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 68.6 3.28e-11   NR XP_005783561.1 280463 g192759 i0 39.7 0.936 78 47 93.6 0 241 8 42 119 XP_005783561.1 hypothetical protein EMIHUDRAFT_434409 [Emiliania huxleyi CCMP1516] diamond 234 68.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29235465 29235465 PRJNA928559_P_NODE_188129_length_253_cov_0.866667_g186560_i0 PRJNA928559 188129 253 0.866667 2.19266751 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 58.9 8.35e-8   NR XP_005766303.1 280463 g186560 i0 41.9 2.01581027667984 86 45 98.4 2 250 2 375 458 XP_005766303.1 hypothetical protein EMIHUDRAFT_451930 [Emiliania huxleyi CCMP1516] diamond 510 58.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29393402 29393402 PRJNA928559_P_NODE_64329_length_436_cov_2.413223_g62760_i0 PRJNA928559 64329 436 2.413223 10.52165228 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 63.5 1.61e-8   NR KOO23707.1 1460289 g62760 i0 31.4 1.09403669724771 159 95 99.8 3 1 435 227 385 KOO23707.1 u5 small nuclear ribonucleoprotein 200 kda helicase [Chrysochromulina tobinii] diamond 477 63.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29677029 29677029 PRJNA928559_P_NODE_159970_length_277_cov_3.083333_g158401_i0 PRJNA928559 159970 277 3.083333 8.54083241 Prymnesium parvum 97485 Haptophyta other_Eukaryota 62.4 7.26e-9   NR KAL1521978.1 97485 g158401 i0 36.3 0.985559566787004 91 56 98.6 1 2 274 1213 1301 KAL1521978.1 hypothetical protein AB1Y20_021623 [Prymnesium parvum] diamond 273 62.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29740351 29740351 PRJNA928559_P_NODE_90290_length_374_cov_5.890365_g88721_i0 PRJNA928559 90290 374 5.890365 22.0299651 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 93.2 1.05e-21   NR XP_005782836.1 280463 g88721 i0 51 4.09893048128342 102 46 81 2 361 59 16 114 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 1533 93.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30119483 30119483 PRJNA928559_P_NODE_214452_length_242_cov_0.923077_g212883_i0 PRJNA928559 214452 242 0.923077 2.23384634 Prymnesium parvum 97485 Haptophyta other_Eukaryota 105 2.1e-24   NR KAL1527885.1 97485 g212883 i0 62.5 2.02066115702479 80 30 99.2 0 240 1 72 151 KAL1527885.1 hypothetical protein AB1Y20_009261 [Prymnesium parvum] diamond 489 105 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31004381 31004381 PRJNA928559_P_NODE_91854_length_371_cov_31.097315_g90285_i0 PRJNA928559 91854 371 31.097315 115.37103865 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87.4 1.88e-19   NR XP_005782836.1 280463 g90285 i0 50 1.68194070080863 102 47 81.7 2 339 37 16 114 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 624 87.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31011382 31011382 PRJNA928559_P_NODE_103534_length_350_cov_7.953069_g101965_i0 PRJNA928559 103534 350 7.953069 27.8357415 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 162 1.47e-45   NR KAJ1625763.1 483367 g101965 i0 72.2 3.75428571428571 108 30 92.6 0 349 26 209 316 KAJ1625763.1 pseudouridine synthase [Pavlovales sp. CCMP2436] diamond 1314 162 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
31288576 31288576 PRJNA928559_P_NODE_138495_length_301_cov_1.122807_g136926_i0 PRJNA928559 138495 301 1.1228070000000001 3.37964907 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 132 2.37e-33   NR KAG8460107.1 2081491 g136926 i0 63.3 3.90697674418605 98 36 97.7 0 296 3 716 813 KAG8460107.1 hypothetical protein KFE25_014252 [Diacronema lutheri] diamond 1176 132 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31320299 31320299 PRJNA928559_P_NODE_204215_length_246_cov_1.248555_g202646_i0 PRJNA928559 204215 246 1.248555 3.0714453 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 88.6 2.96e-18   NR KOO23673.1 1460289 g202646 i0 58.3 0.878048780487805 72 28 87.8 1 219 4 202 271 KOO23673.1 calcium-transporting ATPase endoplasmic reticulum-type-like protein [Chrysochromulina tobinii] diamond 216 88.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32016218 32016218 PRJNA928559_P_NODE_179438_length_259_cov_3.354839_g177869_i0 PRJNA928559 179438 259 3.354839 8.68903301 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 79 9.77e-17   NR KAL3928833.1 2812485 g177869 i0 43.3 1.54054054054054 67 38 77.6 0 257 57 7 73 KAL3928833.1 MAG: hypothetical protein SGPRY_002222 [Prymnesium sp.] diamond 399 79 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
32174687 32174687 PRJNA928559_P_NODE_194418_length_250_cov_1.344633_g192849_i0 PRJNA928559 194418 250 1.344633 3.3615825 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 47.4 8.93e-4   NR KOO34824.1 1460289 g192849 i0 30.4 0.948 79 54 93.6 1 242 9 27 105 KOO34824.1 calcyphosin-like protein [Chrysochromulina tobinii] diamond 237 47.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii

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