RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA206070", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 4 ✖

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 4 ✖

bioproject 1

  • PRJNA206070 · 4 ✖

analysis 1

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
14395157 14395157 PRJNA206070_S_NODE_11092_length_348_cov_2.691318_g9216_i0 PRJNA206070 11092 348 2.691318 9.36578664 Candidatus Gastranaerophilaceae bacterium 3022870 Bacteria Bacteria 160 1.84e-46   NR MEE3350688.1 3022870 g9216 i0 72.6 2.01724137931034 117 25 98.3 2 7 348 127 239 MEE3350688.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium] diamond 702 160 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales Candidatus Gastranaerophilaceae   Candidatus Gastranaerophilaceae bacterium
28684763 28684763 PRJNA206070_S_NODE_12367_length_315_cov_2.705036_g10491_i0 PRJNA206070 12367 315 2.705036 8.5208634 Candidatus Gastranaerophilaceae bacterium 3022870 Bacteria Bacteria 60.1 1.34e-8   NR MEE3350528.1 3022870 g10491 i0 39.2 0.704761904761905 74 39 64.8 1 281 78 89 162 MEE3350528.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium] diamond 222 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales Candidatus Gastranaerophilaceae   Candidatus Gastranaerophilaceae bacterium
31210904 31210904 PRJNA206070_S_NODE_13215_length_298_cov_1.551724_g11339_i0 PRJNA206070 13215 298 1.551724 4.62413752 Candidatus Gastranaerophilaceae bacterium 3022870 Bacteria Bacteria 137 3.36e-39   NR MEE3350689.1 3022870 g11339 i0 71 0.936241610738255 93 27 93.6 0 18 296 50 142 MEE3350689.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium] diamond 279 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales Candidatus Gastranaerophilaceae   Candidatus Gastranaerophilaceae bacterium
32002205 32002205 PRJNA206070_S_NODE_20118_length_205_cov_1.160714_g18242_i0 PRJNA206070 20118 205 1.160714 2.3794637 Candidatus Gastranaerophilaceae bacterium 3022870 Bacteria Bacteria 48.9 6.75e-5   NR MEE3350528.1 3022870 g18242 i0 46.9 0.717073170731707 49 26 71.7 0 205 59 39 87 MEE3350528.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium] diamond 147 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales Candidatus Gastranaerophilaceae   Candidatus Gastranaerophilaceae bacterium

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