RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA799842" and tax_phylum = "Candidatus Kerfeldiibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Kerfeldiibacteriota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA799842 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27496509 27496509 PRJNA799842_P_NODE_179083_length_243_cov_0.905882_g177510_i0 PRJNA799842 179083 243 0.905882 2.20129326 Candidatus Kerfeldbacteria bacterium 2053565 Bacteria Bacteria 126 1.66e-32   NR MBI2984541.1 2053565 g177510 i0 74.4 0.962962962962963 78 20 96.3 0 235 2 175 252 MBI2984541.1 serine--tRNA ligase [Candidatus Kerfeldbacteria bacterium] diamond 234 126 1 Bacteria Bacteria candidate phyla   Candidatus Kerfeldiibacteriota         Candidatus Kerfeldbacteria bacterium
28348884 28348884 PRJNA799842_P_NODE_171646_length_244_cov_0.900585_g170073_i0 PRJNA799842 171646 244 0.900585 2.1974274 Candidatus Kerfeldbacteria bacterium 2053565 Bacteria Bacteria 79 6.76e-15   NR MBI2984788.1 2053565 g170073 i0 53.8 0.959016393442623 78 36 95.9 0 240 7 447 524 MBI2984788.1 hypothetical protein [Candidatus Kerfeldbacteria bacterium] diamond 234 79 1 Bacteria Bacteria candidate phyla   Candidatus Kerfeldiibacteriota         Candidatus Kerfeldbacteria bacterium
31887247 31887247 PRJNA799842_P_NODE_161777_length_246_cov_0.890173_g160204_i0 PRJNA799842 161777 246 0.890173 2.18982558 Candidatus Kerfeldbacteria bacterium 2053565 Bacteria Bacteria 119 1.43e-31   NR MBI5466768.1 2053565 g160204 i0 86.2 0.792682926829268 65 9 79.3 0 52 246 1 65 MBI5466768.1 uracil-DNA glycosylase [Candidatus Kerfeldbacteria bacterium] diamond 195 119 1 Bacteria Bacteria candidate phyla   Candidatus Kerfeldiibacteriota         Candidatus Kerfeldbacteria 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);;