RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA911178" 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

  • PRJNA911178 · 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
27845614 27845614 PRJNA911178_P_NODE_190664_length_277_cov_1.235294_g188191_i0 PRJNA911178 190664 277 1.235294 3.42176438 Leptotrichia sp. OH362 104608 Bacteria Bacteria 147 7.179999999999999e-43   NR WP_158612544.1 2491048 g188191 i0 79.8 0.909747292418773 84 17 91 0 18 269 78 161 WP_158612544.1 hypothetical protein, partial [Leptotrichia sp. OH3620_COT-345] diamond 252 147 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. OH3620_COT-345
29203634 29203634 PRJNA911178_P_NODE_131089_length_322_cov_4.393574_g128617_i0 PRJNA911178 131089 322 4.393574 14.14730828 Fusobacterium mortiferum 850 Bacteria Bacteria 72.8 2.6e-12   NR MEF2601383.1 850 g128617 i0 40.8 0.959627329192547 103 48 95 4 16 321 354 444 MEF2601383.1 iron-containing alcohol dehydrogenase [Fusobacterium mortiferum] diamond 309 72.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium mortiferum
32459021 32459021 PRJNA911178_P_NODE_196239_length_274_cov_1.144279_g193766_i0 PRJNA911178 196239 274 1.144279 3.13532446 Cetobacterium sp. ZOR 2071632 Bacteria Bacteria 108 1.74e-25   NR WP_052193990.1 1339239 g193766 i0 62 2.94525547445255 92 32 97.4 1 7 273 307 398 WP_052193990.1 DUF4041 domain-containing protein [Cetobacterium sp. ZOR0034] diamond 807 108 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);;