RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA382357", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Rokuibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Rokuibacteriota · 4 ✖

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJNA382357 · 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
28923534 28923534 PRJNA382357_P_NODE_63668_length_295_cov_1.589744_g62929_i0 PRJNA382357 63668 295 1.589744 4.6897448 Bacteria 2 Bacteria Bacteria 72.4 2.46e-12   NR MBI3029537.1 2053607 g62929 i0 38.9 3.54915254237288 90 55 91.5 0 24 293 134 223 MBI3029537.1 GMC family oxidoreductase [Candidatus Rokuibacteriota bacterium] diamond 1047 72.8 0.994505494505495 Bacteria Bacteria candidate phyla   Candidatus Rokuibacteriota         Candidatus Rokuibacteriota bacterium
29934262 29934262 PRJNA382357_P_NODE_145411_length_206_cov_1.710345_g144672_i0 PRJNA382357 145411 206 1.710345 3.5233107 Pseudomonadati 3379134 Bacteria Bacteria 46.6 9.73e-4   NR OGL10217.1 1802107 g144672 i0 81.5 0.815533980582524 27 5 39.3 0 4 84 7 33 OGL10217.1 MAG: hypothetical protein A3I14_02345, partial [Candidatus Rokubacteria bacterium RIFCSPLOWO2_02_FULL_73_56] diamond 168 46.6 1 Bacteria Bacteria candidate phyla   Candidatus Rokuibacteriota         Candidatus Rokubacteria bacterium RIFCSPLOWO2_02_FULL_73_56
30755599 30755599 PRJNA382357_P_NODE_166094_length_182_cov_7.991736_g165355_i0 PRJNA382357 166094 182 7.991736 14.54495952 Bacillati 1783272 Bacteria Bacteria 84.3 3.42e-19   NR MDP2701594.1 2053607 g165355 i0 90.9 5.07692307692308 44 4 72.5 0 145 14 17 60 MDP2701594.1 branched-chain amino acid ABC transporter permease [Candidatus Rokuibacteriota bacterium] diamond 924 84.3 1 Bacteria Bacteria candidate phyla   Candidatus Rokuibacteriota         Candidatus Rokuibacteriota bacterium
31623597 31623597 PRJNA382357_P_NODE_109496_length_232_cov_19.070175_g108757_i0 PRJNA382357 109496 232 19.070175 44.242806 Candidatus Rokuibacteriota bacterium 2053607 Bacteria Bacteria 45.8 0.0027   NR PYO17978.1 2053607 g108757 i0 57.1 1.75862068965517 35 15 45.3 0 223 119 747 781 PYO17978.1 MAG: xanthine dehydrogenase [Candidatus Rokuibacteriota bacterium] diamond 408 45.8 1 Bacteria Bacteria candidate phyla   Candidatus Rokuibacteriota         Candidatus Rokuibacteriota 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);;