RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA773778 · 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
27685493 27685493 PRJNA773778_S_NODE_3604_length_612_cov_6.870130_g3459_i0 PRJNA773778 3604 612 6.87013 42.0451956 Leptotrichia sp. OH362 104608 Bacteria Bacteria 72.8 3.55e-11   NR WP_125235653.1 2491048 g3459 i0 57.4 0.651960784313726 68 26 31.9 1 277 83 4 71 WP_125235653.1 S1C family serine protease [Leptotrichia sp. OH3620_COT-345] diamond 399 72.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. OH3620_COT-345
28578862 28578862 PRJNA773778_S_NODE_7647_length_475_cov_7.022388_g7497_i0 PRJNA773778 7647 475 7.022388 33.356343 Fusobacterium 848 Bacteria Bacteria 188 7.34e-52   NR WP_249525282.1 851 g7497 i0 60.5 3.94105263157895 157 62 99.2 0 474 4 341 497 WP_249525282.1 filamentous hemagglutinin N-terminal domain-containing protein [Fusobacterium nucleatum] diamond 1872 189 0.994708994708995 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
29958531 29958531 PRJNA773778_S_NODE_37851_length_257_cov_5.711957_g37701_i0 PRJNA773778 37851 257 5.711957 14.67972949 Leptotrichiaceae bacterium 2782225 Bacteria Bacteria 103 7.599999999999998e-24   NR MDO5089797.1 2782225 g37701 i0 73.2 0.828793774319066 71 19 82.9 0 257 45 149 219 MDO5089797.1 hypothetical protein [Leptotrichiaceae bacterium] diamond 213 103 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae   Leptotrichiaceae bacterium
31728381 31728381 PRJNA773778_S_NODE_7017_length_489_cov_9.266827_g6867_i0 PRJNA773778 7017 489 9.266827 45.31478403 Leptotrichia sp. oral taxon 847 1785996 Bacteria Bacteria 147 2.48e-39   NR WP_068157593.1 1785996 g6867 i0 65.5 0.674846625766871 110 38 67.5 0 398 69 1 110 WP_068157593.1 HlyD family secretion protein [Leptotrichia sp. oral taxon 847] diamond 330 147 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 847

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