RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1047551" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 4 ✖

bioproject 1

  • PRJNA1047551 · 4 ✖

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
27699047 27699047 PRJNA1047551_S_NODE_2984_length_267_cov_1.771552_g2857_i0 PRJNA1047551 2984 267 1.771552 4.7300438400000004 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 45.4 9.57e-4   NR KAG8466619.1 2081491 g2857 i0 84 1.13483146067416 25 4 28.1 0 262 188 71 95 KAG8466619.1 hypothetical protein KFE25_007998 [Diacronema lutheri] diamond 303 45.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28993538 28993538 PRJNA1047551_S_NODE_11648_length_159_cov_1.419355_g11521_i0 PRJNA1047551 11648 159 1.419355 2.25677445 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 65.5 1.83e-11   NR XP_005788446.1 280463 g11521 i0 57.1 1.86792452830189 49 21 92.5 0 13 159 103 151 XP_005788446.1 hypothetical protein EMIHUDRAFT_440728, partial [Emiliania huxleyi CCMP1516] diamond 297 65.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29434981 29434981 PRJNA1047551_S_NODE_7450_length_186_cov_2.516556_g7323_i0 PRJNA1047551 7450 186 2.516556 4.68079416 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 49.3 8.05e-5   NR KOO31611.1 1460289 g7323 i0 87 0.370967741935484 23 3 37.1 0 184 116 292 314 KOO31611.1 hydroxyacyl-coenzyme a mitochondrial precursor [Chrysochromulina tobinii] diamond 69 49.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30058621 30058621 PRJNA1047551_S_NODE_5731_length_205_cov_4.011765_g5604_i0 PRJNA1047551 5731 205 4.011765 8.22411825 Prymnesium 35143 Haptophyta other_Eukaryota 51.2 1.01e-5   NR KAL1529621.1 97485 g5604 i0 75 0.819512195121951 28 7 41 0 2 85 146 173 KAL1529621.1 hypothetical protein AB1Y20_000563 [Prymnesium parvum] diamond 168 51.6 0.992248062015504 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);;