RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA796753" and tax_phylum = "Candidatus Zixiibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Zixiibacteriota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA796753 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
29705970 29705970 PRJNA796753_P_NODE_21170_length_322_cov_1.236948_g20858_i0 PRJNA796753 21170 322 1.236948 3.98297256 Candidatus Zixiibacteriota bacterium 2053527 Bacteria Bacteria 47.8 0.00159   NR MFQ5606477.1 2053527 g20858 i0 58.8 0.316770186335404 34 14 31.7 0 319 218 443 476 MFQ5606477.1 hypothetical protein [Candidatus Zixiibacteriota bacterium] diamond 102 47.8 1 Bacteria FCB group Pseudomonadati Candidatus Zixiibacteriota         Candidatus Zixiibacteriota bacterium
31096431 31096431 PRJNA796753_P_NODE_48455_length_245_cov_0.895349_g48143_i0 PRJNA796753 48455 245 0.895349 2.19360505 Candidatus Zixiibacteriota bacterium 2053527 Bacteria Bacteria 44.3 0.00976   NR MBU0983993.1 2053527 g48143 i0 48.7 0.477551020408163 39 20 47.8 0 129 245 77 115 MBU0983993.1 serine protease [Candidatus Zixiibacteriota bacterium] diamond 117 44.3 1 Bacteria FCB group Pseudomonadati Candidatus Zixiibacteriota         Candidatus Zixiibacteriota bacterium
32140320 32140320 PRJNA796753_P_NODE_27658_length_288_cov_1.051163_g27346_i0 PRJNA796753 27658 288 1.051163 3.02734944 Candidatus Zixiibacteriota bacterium 2053527 Bacteria Bacteria 62.4 7.79e-9   NR MEW5701813.1 2053527 g27346 i0 42.9 0.875 84 44 87.5 1 254 3 497 576 MEW5701813.1 SBBP repeat-containing protein [Candidatus Zixiibacteriota bacterium] diamond 252 62.4 1 Bacteria FCB group Pseudomonadati Candidatus Zixiibacteriota         Candidatus Zixiibacteriota bacterium
32267024 32267024 PRJNA796753_P_NODE_24398_length_304_cov_0.826840_g24086_i0 PRJNA796753 24398 304 0.82684 2.5135936 Candidatus Zixiibacteriota bacterium 2053527 Bacteria Bacteria 120 4.83e-30   NR NIW41742.1 2053527 g24086 i0 60.9 0.858552631578947 87 34 85.9 0 282 22 255 341 NIW41742.1 hypothetical protein [Candidatus Zixiibacteriota bacterium] diamond 261 120 1 Bacteria FCB group Pseudomonadati Candidatus Zixiibacteriota         Candidatus Zixiibacteriota 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);;