RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA408129", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 3 ✖

tax_kingdom 1

  • Bacillati · 3 ✖

bioproject 1

  • PRJNA408129 · 3 ✖

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
26680568 26680568 PRJNA408129_S_NODE_17281_length_187_cov_2.460000_g17263_i0 PRJNA408129 17281 187 2.46 4.6002 Bacteria 2 Bacteria Bacteria 58.2 4.86e-8   NR TAK64608.1 2026734 g17263 i0 58.5 7.17112299465241 41 17 65.8 0 3 125 237 277 TAK64608.1 MAG: polyphosphate kinase 2 [Dehalococcoidia bacterium] diamond 1341 58.5 0.994871794871795 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
28086128 28086128 PRJNA408129_S_NODE_22165_length_173_cov_3.117647_g22147_i0 PRJNA408129 22165 173 3.117647 5.39352931 Chloroflexota bacterium 2026724 Bacteria Bacteria 42.7 0.0146   NR HVA23263.1 2026724 g22147 i0 36.4 0.953757225433526 55 35 95.4 0 165 1 134 188 HVA23263.1 YifB family Mg chelatase-like AAA ATPase [Chloroflexota bacterium] diamond 165 42.7 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28654603 28654603 PRJNA408129_S_NODE_19227_length_181_cov_2.208333_g19209_i0 PRJNA408129 19227 181 2.208333 3.99708273 Chloroflexota bacterium 2026724 Bacteria Bacteria 103 4.36e-24   NR MBN9392426.1 2026724 g19209 i0 80.4 0.92817679558011 56 11 92.8 0 3 170 396 451 MBN9392426.1 glycosyltransferase family 39 protein [Chloroflexota bacterium] diamond 168 103 1 Bacteria   Bacillati Chloroflexota         Chloroflexota 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);;