RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA793147", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA793147 · 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
29201312 29201312 PRJNA793147_P_NODE_57349_length_230_cov_0.894410_g57083_i0 PRJNA793147 57349 230 0.89441 2.057143 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 137 9.329999999999998e-37   NR MCA2964187.1 2052142 g57083 i0 89.5 0.991304347826087 76 8 99.1 0 3 230 25 100 MCA2964187.1 DUF1552 domain-containing protein [Acidobacteriaceae bacterium] diamond 228 137 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
30022351 30022351 PRJNA793147_P_NODE_15631_length_428_cov_3.211699_g15365_i0 PRJNA793147 15631 428 3.211699 13.74607172 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 59.3 4.4e-7   NR MEZ5356914.1 2212468 g15365 i0 44.3 0.679906542056075 97 46 64.5 3 49 324 249 342 MEZ5356914.1 cellulose binding domain-containing protein [Bryobacteraceae bacterium] diamond 291 59.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31136918 31136918 PRJNA793147_P_NODE_30775_length_301_cov_3.724138_g30509_i0 PRJNA793147 30775 301 3.724138 11.20965538 Pseudomonadati 3379134 Bacteria Bacteria 102 1.74e-25   NR MDD8031718.1 1978231 g30509 i0 58 13.0863787375415 88 37 87.7 0 270 7 2 89 MDD8031718.1 RidA family protein [Acidobacteriota bacterium] diamond 3939 103 0.990291262135922 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31728817 31728817 PRJNA793147_P_NODE_62137_length_226_cov_0.917197_g61871_i0 PRJNA793147 62137 226 0.917197 2.07286522 Bryobacteraceae bacterium CoA2 C42 2967959 Bacteria Bacteria 112 7.3e-28   NR MBZ2176506.1 2967959 g61871 i0 69.3 0.995575221238938 75 23 99.6 0 2 226 121 195 MBZ2176506.1 hypothetical protein [Bryobacteraceae bacterium CoA2 C42] diamond 225 112 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium CoA2 C42

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