RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA893346" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 3 ✖

bioproject 1

  • PRJNA893346 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
10171828 10171828 PRJNA893346_P_NODE_27508_length_287_cov_1.373832_g27018_i0 PRJNA893346 27508 287 1.373832 3.94289784 uncultured Cetobacterium sp. 527638 Bacteria Bacteria 170 1.08e-46   NR WP_294094044.1 527638 g27018 i0 98.8 0.888501742160279 85 1 88.9 0 1 255 843 927 WP_294094044.1 EAL domain-containing protein [uncultured Cetobacterium sp.] diamond 255 170 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium uncultured Cetobacterium sp.
29045233 29045233 PRJNA893346_P_NODE_31548_length_261_cov_1.638298_g31058_i0 PRJNA893346 31548 261 1.638298 4.27595778 unclassified Cetobacterium 2630983 Bacteria Bacteria 115 2.55e-30   NR WP_047383605.1 2630983 g31058 i0 89.8 2.03448275862069 59 6 67.8 0 1 177 134 192 WP_047383605.1 MULTISPECIES: uracil-DNA glycosylase family protein [unclassified Cetobacterium] diamond 531 115 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
32363727 32363727 PRJNA893346_P_NODE_22439_length_324_cov_1.131474_g21950_i0 PRJNA893346 22439 324 1.131474 3.66597576 Cetobacterium sp. ZOR 2071632 Bacteria Bacteria 193 2.45e-58   NR WP_047393843.1 1339239 g21950 i0 87.7 0.981481481481482 106 13 98.1 0 320 3 49 154 WP_047393843.1 SEC-C metal-binding domain-containing protein [Cetobacterium sp. ZOR0034] diamond 318 193 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZOR0034

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