RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA896758", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 11 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 11 ✖

bioproject 1

  • PRJNA896758 · 11 ✖

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
2148185 2148185 PRJNA896758_P_NODE_22622_length_249_cov_0.863636_g22232_i0 PRJNA896758 22622 249 0.863636 2.15045364 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 154 6.01e-33   NTclustered gi|551570707|ref|XM_005771218.1| 280463 g22232 i0 81.443 28.144578313253 194 30 77 5 1 191 714 524 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 7008 154 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8525641 8525641 PRJNA896758_P_NODE_22827_length_248_cov_0.880000_g22437_i0 PRJNA896758 22827 248 0.88 2.1824 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 145 1.4e-39   NR KAJ1637160.1 483367 g22437 i0 86.6 0.991935483870968 82 11 99.2 0 247 2 275 356 KAJ1637160.1 hypothetical protein T492DRAFT_954282 [Pavlovales sp. CCMP2436] diamond 246 145 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
11076294 11076294 PRJNA896758_P_NODE_11789_length_335_cov_1.175573_g11399_i0 PRJNA896758 11789 335 1.175573 3.93816955 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 235 2.92e-57   NTclustered gi|551619282|ref|XM_005790173.1| 280463 g11399 i0 84.746 16.1283582089552 236 34 70 2 100 334 1135 901 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 5403 235 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
19999381 19999381 PRJNA896758_P_NODE_16336_length_285_cov_1.264151_g15946_i0 PRJNA896758 16336 285 1.264151 3.60283035 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 107 4.88e-25   NR KAG8457368.1 2081491 g15946 i0 55.3 1.97894736842105 94 41 98.9 1 3 284 16 108 KAG8457368.1 hypothetical protein KFE25_005049 [Diacronema lutheri] diamond 564 107 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
23824960 23824960 PRJNA896758_P_NODE_17199_length_279_cov_1.427184_g16809_i0 PRJNA896758 17199 279 1.427184 3.98184336 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 110 1.5e-19   NTclustered gi|551583056|ref|XM_005776908.1| 280463 g16809 i0 85.577 0.745519713261649 104 15 37 0 160 263 382 279 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 208 110 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
25098771 25098771 PRJNA896758_P_NODE_11220_length_343_cov_1.140741_g10830_i0 PRJNA896758 11220 343 1.140741 3.91274163 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 162 9.64e-49   NR KAL1515397.1 97485 g10830 i0 75.7 3.83090379008746 107 24 93.6 1 323 3 1 105 KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] diamond 1314 162 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26968414 26968414 PRJNA896758_P_NODE_16662_length_283_cov_1.238095_g16272_i0 PRJNA896758 16662 283 1.238095 3.50380885 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 53.9 2.05e-6   NR KAJ1641131.1 483367 g16272 i0 54 1.06007067137809 50 23 53 0 2 151 76 125 KAJ1641131.1 PPP4R2-domain-containing protein [Pavlovales sp. CCMP2436] diamond 300 53.9 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
27252963 27252963 PRJNA896758_P_NODE_23203_length_247_cov_1.770115_g22813_i0 PRJNA896758 23203 247 1.770115 4.37218405 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 120 1.04e-29   NR KAL1495187.1 97485 g22813 i0 69.5 11.9028340080972 82 25 99.6 0 2 247 450 531 KAL1495187.1 hypothetical protein AB1Y20_017052 [Prymnesium parvum] diamond 2940 121 0.991735537190083 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31161174 31161174 PRJNA896758_P_NODE_15815_length_288_cov_1.739535_g15425_i0 PRJNA896758 15815 288 1.739535 5.0098608 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 76.6 3.24e-16   NR KAJ1628734.1 483367 g15425 i0 70 1.96875 60 17 61.5 1 28 204 1 60 KAJ1628734.1 ribosomal protein S30 [Pavlovales sp. CCMP2436] diamond 567 76.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
31793858 31793858 PRJNA896758_P_NODE_21157_length_251_cov_0.865169_g20767_i0 PRJNA896758 21157 251 0.865169 2.17157419 Prymnesium parvum 97485 Haptophyta other_Eukaryota 65.5 3.22e-11   NR KAL1515331.1 97485 g20767 i0 58.1 0.741035856573705 62 26 74.1 0 35 220 71 132 KAL1515331.1 hypothetical protein AB1Y20_001962 [Prymnesium parvum] diamond 186 65.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32773803 32773803 PRJNA896758_P_NODE_15840_length_288_cov_1.432558_g15450_i0 PRJNA896758 15840 288 1.432558 4.12576704 Prymnesium parvum 97485 Haptophyta other_Eukaryota 160 2.6599999999999997e-48   NR KAL1523551.1 97485 g15450 i0 84.2 2.98958333333333 95 15 99 0 3 287 5 99 KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum] diamond 861 160 1 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);;