RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA520845 · 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
27013876 27013876 PRJNA520845_P_NODE_117902_length_343_cov_1.707407_g116403_i0 PRJNA520845 117902 343 1.707407 5.85640601 Candidatus Cetobacterium colombiensis 3073100 Bacteria Bacteria 140 4.19e-40   NR WP_320312335.1 3073100 g116403 i0 60 1.26822157434402 145 22 98.8 2 341 3 5 145 WP_320312335.1 Rpn family recombination-promoting nuclease/putative transposase [Candidatus Cetobacterium colombiensis] diamond 435 140 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Candidatus Cetobacterium colombiensis
29666318 29666318 PRJNA520845_P_NODE_226590_length_249_cov_0.875000_g225091_i0 PRJNA520845 226590 249 0.875 2.17875 Fusobacteriaceae bacterium 2053555 Bacteria Bacteria 43.9 0.0156   NR BFO51757.1 2053555 g225091 i0 35.4 0.951807228915663 79 44 90.4 4 239 15 633 708 BFO51757.1 hypothetical protein F9N8_09700 [Fusobacteriaceae bacterium] diamond 237 43.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae   Fusobacteriaceae bacterium
29792820 29792820 PRJNA520845_P_NODE_23731_length_792_cov_1.222531_g22377_i0 PRJNA520845 23731 792 1.222531 9.68244552 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 505 6.5499999999999975e-180   NR WP_047384851.1 1340502 g22377 i0 100 0.996212121212121 263 0 99.6 0 791 3 14 276 WP_047384851.1 Rpn family recombination-promoting nuclease/putative transposase [Cetobacterium sp. ZWU0022] diamond 789 505 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZWU0022
32100419 32100419 PRJNA520845_P_NODE_246678_length_245_cov_0.895349_g245179_i0 PRJNA520845 246678 245 0.895349 2.19360505 unclassified Cetobacterium 2630983 Bacteria Bacteria 152 2.09e-45   NR WP_052191835.1 2630983 g245179 i0 100 0.906122448979592 74 0 90.6 0 1 222 63 136 WP_052191835.1 MULTISPECIES: DUF1499 domain-containing protein [unclassified Cetobacterium] diamond 222 152 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  

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