RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA478247", tax_phylum = "Bacillota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Bacillota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA478247 · 4 ✖

analysis 1

tax_clade 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
26633092 26633092 PRJNA478247_P_NODE_3301_length_163_cov_1.365672_g3195_i0 PRJNA478247 3301 163 1.365672 2.22604536 Clostridiales bacterium 1898207 Bacteria Bacteria 45.4 0.00141   NR MCI7029261.1 1898207 g3195 i0 45.5 0.809815950920245 44 24 81 0 31 162 29 72 MCI7029261.1 Gfo/Idh/MocA family oxidoreductase [Clostridiales bacterium] diamond 132 45.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27107683 27107683 PRJNA478247_P_NODE_1122_length_377_cov_2.126437_g1016_i0 PRJNA478247 1122 377 2.126437 8.01666749 Bacillota bacterium 1879010 Bacteria Bacteria 53.5 2.61e-5   NR MFO7263334.1 1879010 g1016 i0 52.2 0.36604774535809 46 22 36.6 0 138 1 4 49 MFO7263334.1 F0F1 ATP synthase subunit beta [Bacillota bacterium] diamond 138 53.5 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
27265986 27265986 PRJNA478247_P_NODE_3523_length_154_cov_1.944000_g3417_i0 PRJNA478247 3523 154 1.944 2.99376 Ruminococcus sp. 41978 Bacteria Bacteria 45.8 7.05e-4   NR MBQ3855877.1 41978 g3417 i0 40.4 0.915584415584416 47 28 91.6 0 146 6 6 52 MBQ3855877.1 ribonuclease P subunit p25 family protein [Ruminococcus sp.] diamond 141 45.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
31498541 31498541 PRJNA478247_P_NODE_1856_length_259_cov_1.186957_g1750_i0 PRJNA478247 1856 259 1.186957 3.07421863 Clostridia bacterium 2044939 Bacteria Bacteria 48.9 3.1e-4   NR MBR3696712.1 2044939 g1750 i0 47.3 1.21621621621622 55 28 62.5 1 26 187 263 317 MBR3696712.1 hypothetical protein [Clostridia bacterium] diamond 315 48.9 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia 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);;