RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA680334" and tax_phylum = "Candidatus Magasanikiibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Magasanikiibacteriota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA680334 · 5 ✖

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
28041376 28041376 PRJNA680334_S_NODE_17285_length_266_cov_2.751073_g16799_i0 PRJNA680334 17285 266 2.751073 7.31785418 Bacteria 2 Bacteria Bacteria 133 3.12e-37   NR KKQ39008.1 1619036 g16799 i0 78.4 10.9172932330827 88 19 99.2 0 266 3 61 148 KKQ39008.1 MAG: Phosphoenolpyruvate synthase [Candidatus Magasanikbacteria bacterium GW2011_GWA2_37_8] diamond 2904 134 0.992537313432836 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikbacteria bacterium GW2011_GWA2_37_8
28376736 28376736 PRJNA680334_S_NODE_82706_length_163_cov_3.392308_g82220_i0 PRJNA680334 82706 163 3.392308 5.52946204 Candidatus Magasanikiibacteriota bacterium 2026717 Bacteria Bacteria 110 2.03e-27   NR MBP7992785.1 2026717 g82220 i0 92.2 0.938650306748466 51 4 93.9 0 4 156 23 73 MBP7992785.1 tyrosine-type recombinase/integrase [Candidatus Magasanikiibacteriota bacterium] diamond 153 110 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikiibacteriota bacterium
31346012 31346012 PRJNA680334_S_NODE_50636_length_191_cov_3.025316_g50150_i0 PRJNA680334 50636 191 3.025316 5.77835356 Candidatus Magasanikiibacteriota bacterium 2026717 Bacteria Bacteria 110 1.31e-28   NR MBP7992620.1 2026717 g50150 i0 98.2 0.863874345549738 55 1 86.4 0 26 190 1 55 MBP7992620.1 transcription termination/antitermination protein NusG [Candidatus Magasanikiibacteriota bacterium] diamond 165 110 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikiibacteriota bacterium
31883543 31883543 PRJNA680334_S_NODE_61277_length_180_cov_1.959184_g60791_i0 PRJNA680334 61277 180 1.959184 3.5265312 Candidatus Magasanikiibacteriota bacterium 2026717 Bacteria Bacteria 93.2 1.9699999999999998e-23   NR MBP7992619.1 2026717 g60791 i0 75.9 0.966666666666667 58 14 96.7 0 7 180 1 58 MBP7992619.1 preprotein translocase subunit SecE [Candidatus Magasanikiibacteriota bacterium] diamond 174 93.2 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikiibacteriota bacterium
32327005 32327005 PRJNA680334_S_NODE_88119_length_160_cov_2.204724_g87633_i0 PRJNA680334 88119 160 2.204724 3.5275584 Candidatus Magasanikiibacteriota bacterium 2026717 Bacteria Bacteria 71.2 7.13e-13   NR MBP7992443.1 2026717 g87633 i0 70.8 0.9 48 14 90 0 16 159 267 314 MBP7992443.1 class I tRNA ligase family protein [Candidatus Magasanikiibacteriota bacterium] diamond 144 71.2 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikiibacteriota 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);;