RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA841653" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 4 ✖

bioproject 1

  • PRJNA841653 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27434168 27434168 PRJNA841653_P_NODE_39483_length_262_cov_2.888889_g38809_i0 PRJNA841653 39483 262 2.888889 7.56888918 Fusobacteriaceae bacterium 2053555 Bacteria Bacteria 150 3.199999999999999e-41   NR MBP6409359.1 2053555 g38809 i0 86 1.93511450381679 86 12 98.5 0 4 261 183 268 MBP6409359.1 SusD/RagB family nutrient-binding outer membrane lipoprotein [Fusobacteriaceae bacterium] diamond 507 150 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae   Fusobacteriaceae bacterium
28791476 28791476 PRJNA841653_P_NODE_50947_length_247_cov_0.885057_g50273_i0 PRJNA841653 50947 247 0.885057 2.18609079 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 144 8.39e-39   NR WP_047383217.1 1340502 g50273 i0 89.5 0.923076923076923 76 8 92.3 0 228 1 1 76 WP_047383217.1 carbon starvation protein A [Cetobacterium sp. ZWU0022] diamond 228 144 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZWU0022
30528575 30528575 PRJNA841653_P_NODE_55413_length_244_cov_1.719298_g54739_i0 PRJNA841653 55413 244 1.719298 4.19508712 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 131 4.83e-37   NR WP_047382959.1 1340502 g54739 i0 96.9 0.799180327868853 65 2 79.9 0 50 244 1 65 WP_047382959.1 Dps family protein [Cetobacterium sp. ZWU0022] diamond 195 131 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZWU0022
31729748 31729748 PRJNA841653_P_NODE_63957_length_227_cov_2.389610_g63283_i0 PRJNA841653 63957 227 2.38961 5.4244147 Cetobacterium sp. ZOR 2071632 Bacteria Bacteria 158 1.3299999999999999e-46   NR WP_052193983.1 1339239 g63283 i0 97.3 0.964757709251101 73 2 96.5 0 219 1 151 223 WP_052193983.1 outer membrane beta-barrel protein [Cetobacterium sp. ZOR0034] diamond 219 158 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);;