RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA407368 · 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
23367118 23367118 PRJNA407368_S_NODE_1799_length_465_cov_4.518349_g1702_i0 PRJNA407368 1799 465 4.518349 21.01032285 uncultured Cetobacterium sp. 527638 Bacteria Bacteria 292 5.5499999999999996e-95   NR WP_297487257.1 527638 g1702 i0 89.6 1.98709677419355 154 16 99.4 0 2 463 165 318 WP_297487257.1 YgiQ family radical SAM protein, partial [uncultured Cetobacterium sp.] diamond 924 292 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium uncultured Cetobacterium sp.
27043844 27043844 PRJNA407368_S_NODE_7762_length_185_cov_2.121795_g7660_i0 PRJNA407368 7762 185 2.121795 3.92532075 Leptotrichia hofstadii F 157688 Bacteria Bacteria 41.2 0.0217   NR EEX74124.1 634994 g7660 i0 50 0.713513513513514 44 22 71.4 0 48 179 47 90 EEX74124.1 hypothetical protein GCWU000323_01827 [Leptotrichia hofstadii F0254] diamond 132 41.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hofstadii
30707293 30707293 PRJNA407368_S_NODE_7374_length_192_cov_2.061350_g7272_i0 PRJNA407368 7374 192 2.06135 3.957792 Fusobacteriaceae bacterium 2053555 Bacteria Bacteria 76.3 2.94e-14   NR MBP6468532.1 2053555 g7272 i0 71.4 1.984375 63 17 98.4 1 192 4 32 93 MBP6468532.1 IS21 family transposase [Fusobacteriaceae bacterium] diamond 381 76.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae   Fusobacteriaceae 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);;