RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJEB14175", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Collieribacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Collieribacteriota · 2 ✖

tax_clade 1

  • Bacteria candidate phyla · 2 ✖

bioproject 1

  • PRJEB14175 · 2 ✖

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
33113252 33113252 PRJEB14175_P_NODE_128359_length_306_cov_5.342857_g126092_i0 PRJEB14175 128359 306 5.342857 16.34914242 Candidatus Collierbacteria bacterium RIFOXYD1_FULL_4 2053540 Bacteria Bacteria 116 9.87e-30   NR OGD84103.1 1817731 g126092 i0 53.8 0.911764705882353 93 43 91.2 0 281 3 91 183 OGD84103.1 MAG: hypothetical protein A2572_03175 [Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9] diamond 279 116 1 Bacteria Bacteria candidate phyla   Candidatus Collieribacteriota         Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9
33113468 33113468 PRJEB14175_P_NODE_150399_length_276_cov_4.604651_g148132_i0 PRJEB14175 150399 276 4.604651 12.70883676 Candidatus Collierbacteria bacterium RIFOXYD1_FULL_4 2053540 Bacteria Bacteria 123 1.38e-30   NR OGD84104.1 1817731 g148132 i0 75.8 0.717391304347826 66 16 71.7 0 199 2 1 66 OGD84104.1 MAG: hypothetical protein A2572_03180, partial [Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9] diamond 198 123 1 Bacteria Bacteria candidate phyla   Candidatus Collieribacteriota         Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9

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