RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA540466", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 18 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 18 ✖

bioproject 1

  • PRJNA540466 · 18 ✖

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
508271 508271 PRJNA540466_S_NODE_57661_length_250_cov_0.870056_g57112_i0 PRJNA540466 57661 250 0.870056 2.17514 Prymnesium parvum 97485 Haptophyta other_Eukaryota 149 4.7e-44   NR KAL1495829.1 97485 g57112 i0 86.3 5.844 80 11 96 0 9 248 9 88 KAL1495829.1 hypothetical protein AB1Y20_016689 [Prymnesium parvum] diamond 1461 149 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
1783349 1783349 PRJNA540466_S_NODE_26782_length_345_cov_4.687500_g26233_i0 PRJNA540466 26782 345 4.6875 16.171875 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 76.8 1.94e-9   NTclustered gi|551583056|ref|XM_005776908.1| 280463 g26233 i0 85.915 0.411594202898551 71 10 21 0 73 143 318 388 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 142 76.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
3059068 3059068 PRJNA540466_S_NODE_52263_length_259_cov_3.284946_g51714_i0 PRJNA540466 52263 259 3.284946 8.50801014 Prymnesium parvum 97485 Haptophyta other_Eukaryota 102 6.13e-25   NR KAL1511153.1 97485 g51714 i0 80.7 1.30888030888031 57 11 66 0 239 69 136 192 KAL1511153.1 hypothetical protein AB1Y20_005971 [Prymnesium parvum] diamond 339 102 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
4334817 4334817 PRJNA540466_S_NODE_19464_length_400_cov_10.418960_g18915_i0 PRJNA540466 19464 400 10.41896 41.67584 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 119 3.73e-22   NTclustered gi|551607238|ref|XM_005784882.1| 280463 g18915 i0 97.143 16.665 70 2 18 0 1 70 1096 1165 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 6666 119 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8161041 8161041 PRJNA540466_S_NODE_60247_length_246_cov_1.780347_g59698_i0 PRJNA540466 60247 246 1.780347 4.37965362 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 77 3.26e-14   NR KAG8457469.1 2081491 g59698 i0 71.2 0.634146341463415 52 15 63.4 0 227 72 982 1033 KAG8457469.1 hypothetical protein KFE25_003773 [Diacronema lutheri] diamond 156 77 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
11986789 11986789 PRJNA540466_S_NODE_36670_length_301_cov_2.026316_g36121_i0 PRJNA540466 36670 301 2.026316 6.09921116 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 198 3.4e-46   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g36121 i0 80.15 5.39202657807309 267 51 88 2 12 277 133 398 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 1623 198 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
17085689 17085689 PRJNA540466_S_NODE_57454_length_250_cov_1.322034_g56905_i0 PRJNA540466 57454 250 1.322034 3.305085 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 104 8.28e-27   NR KAL1522762.1 97485 g56905 i0 70 2.52 70 21 84 0 2 211 55 124 KAL1522762.1 hypothetical protein AB1Y20_017734 [Prymnesium parvum] diamond 630 104 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26951104 26951104 PRJNA540466_S_NODE_45982_length_273_cov_3.110000_g45433_i0 PRJNA540466 45982 273 3.11 8.4903 Prymnesium parvum 97485 Haptophyta other_Eukaryota 85.5 4.2e-19   NR KAL1522762.1 97485 g45433 i0 76 1.65934065934066 50 12 54.9 0 5 154 75 124 KAL1522762.1 hypothetical protein AB1Y20_017734 [Prymnesium parvum] diamond 453 85.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28277832 28277832 PRJNA540466_S_NODE_68226_length_228_cov_3.316129_g67677_i0 PRJNA540466 68226 228 3.316129 7.56077412 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 53.1 1.49e-6   NR XP_005768791.1 280463 g67677 i0 58.8 0.671052631578947 51 19 64.5 1 4 150 86 136 XP_005768791.1 hypothetical protein EMIHUDRAFT_427548 [Emiliania huxleyi CCMP1516] diamond 153 53.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28892625 28892625 PRJNA540466_S_NODE_53608_length_257_cov_1.255435_g53059_i0 PRJNA540466 53608 257 1.255435 3.22646795 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 138 5.95e-40   NR KAL1515397.1 97485 g53059 i0 77.4 12.7937743190661 84 19 98.1 0 257 6 24 107 KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] diamond 3288 138 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29004619 29004619 PRJNA540466_S_NODE_36788_length_301_cov_1.013158_g36239_i0 PRJNA540466 36788 301 1.013158 3.04960558 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 66.2 2.2e-11   NR KAJ1620281.1 483367 g36239 i0 48.1 1.1063122923588 54 28 53.8 0 12 173 40 93 KAJ1620281.1 microsomal signal peptidase 12 kDa subunit-domain-containing protein [Pavlovales sp. CCMP2436] diamond 333 66.2 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
30709648 30709648 PRJNA540466_S_NODE_25654_length_352_cov_6.068100_g25105_i0 PRJNA540466 25654 352 6.0681 21.359712 Prymnesium parvum 97485 Haptophyta other_Eukaryota 56.6 1.77e-6   NR KAL1508075.1 97485 g25105 i0 47.5 0.502840909090909 59 28 47.7 1 1 168 368 426 KAL1508075.1 hypothetical protein AB1Y20_007669 [Prymnesium parvum] diamond 177 56.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30773092 30773092 PRJNA540466_S_NODE_5594_length_652_cov_161.029361_g5165_i0 PRJNA540466 5594 652 161.029361 1049.91143372 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 109 1.88e-26   NR XP_005778651.1 280463 g5165 i0 39.9 0.657975460122699 143 74 65.8 2 87 515 2 132 XP_005778651.1 hypothetical protein EMIHUDRAFT_73627, partial [Emiliania huxleyi CCMP1516] diamond 429 109 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31151668 31151668 PRJNA540466_S_NODE_15035_length_450_cov_6.297082_g14488_i0 PRJNA540466 15035 450 6.297082 28.336869 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 81.6 4.27e-17   NR KAG8465571.1 2081491 g14488 i0 57.1 0.853333333333333 84 33 54 1 354 112 5 88 KAG8465571.1 hypothetical protein KFE25_002878 [Diacronema lutheri] diamond 384 81.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31214851 31214851 PRJNA540466_S_NODE_55135_length_254_cov_1.414365_g54586_i0 PRJNA540466 55135 254 1.414365 3.5924871 Prymnesium parvum 97485 Haptophyta other_Eukaryota 67.4 6.01e-11   NR KAL1514892.1 97485 g54586 i0 50 1.64173228346457 68 31 76.8 1 10 204 172 239 KAL1514892.1 hypothetical protein AB1Y20_003974 [Prymnesium parvum] diamond 417 67.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31974408 31974408 PRJNA540466_S_NODE_37198_length_299_cov_2.199115_g36649_i0 PRJNA540466 37198 299 2.199115 6.57535385 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 63.2 3.78e-9   NR KOO53704.1 1460289 g36649 i0 45.5 0.983277591973244 55 30 55.2 0 285 121 243 297 KOO53704.1 transmembrane and coiled-coil domain-containing protein 1 [Chrysochromulina tobinii] diamond 294 63.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32100981 32100981 PRJNA540466_S_NODE_64178_length_240_cov_2.790419_g63629_i0 PRJNA540466 64178 240 2.790419 6.6970056 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 87.4 3.91e-20   NR KAJ1630079.1 483367 g63629 i0 50.7 1.825 73 36 91.3 0 22 240 34 106 KAJ1630079.1 hypothetical protein T492DRAFT_1006031 [Pavlovales sp. CCMP2436] diamond 438 87.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32147613 32147613 PRJNA540466_S_NODE_40258_length_289_cov_2.138889_g39709_i0 PRJNA540466 40258 289 2.138889 6.18138921 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 56.6 6.93e-7   NR KAL1521100.1 97485 g39709 i0 42.2 5.7923875432526 64 36 65.4 1 284 96 229 292 KAL1521100.1 hypothetical protein AB1Y20_022654 [Prymnesium parvum] diamond 1674 57 0.992982456140351 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum

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