RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB20058" and tax_phylum = "Candidatus Shapironibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Shapironibacteriota · 3 ✖

tax_clade 1

bioproject 1

  • PRJEB20058 · 3 ✖

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
33048035 33048035 PRJEB20058_P_NODE_63197_length_526_cov_10.339785_g60435_i0 PRJEB20058 63197 526 10.339785 54.3872691 Candidatus Shapirobacteria bacterium 2053613 Bacteria Bacteria 177 2.0599999999999994e-48   NR MDD4106608.1 2053613 g60435 i0 73.9 1.87072243346008 111 29 63.3 0 503 171 598 708 MDD4106608.1 PBP1A family penicillin-binding protein [Candidatus Shapirobacteria bacterium] diamond 984 177 1 Bacteria Bacteria candidate phyla   Candidatus Shapironibacteriota         Candidatus Shapirobacteria bacterium
33082030 33082030 PRJEB20058_P_NODE_33878_length_721_cov_6.584848_g31314_i0 PRJEB20058 33878 721 6.584848 47.47675408 Candidatus Shapirobacteria bacterium 2053613 Bacteria Bacteria 385 3.3499999999999996e-121   NR MCW1949664.1 2053613 g31314 i0 88.6 0.952843273231623 229 26 95.3 0 24 710 978 1206 MCW1949664.1 hypothetical protein [Candidatus Shapirobacteria bacterium] diamond 687 385 1 Bacteria Bacteria candidate phyla   Candidatus Shapironibacteriota         Candidatus Shapirobacteria bacterium
33150534 33150534 PRJEB20058_P_NODE_77136_length_472_cov_13.656934_g74356_i0 PRJEB20058 77136 472 13.656934 64.46072848 Candidatus Shapirobacteria bacterium 2053613 Bacteria Bacteria 225 3.5999999999999993e-68   NR MCW1949394.1 2053613 g74356 i0 97.5 0.775423728813559 122 3 77.5 0 54 419 416 537 MCW1949394.1 Rnase Y domain-containing protein [Candidatus Shapirobacteria bacterium] diamond 366 225 1 Bacteria Bacteria candidate phyla   Candidatus Shapironibacteriota         Candidatus Shapirobacteria 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);;