RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA951810" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 7 ✖

bioproject 1

  • PRJNA951810 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26708810 26708810 PRJNA951810_P_NODE_180661_length_231_cov_4.436709_g180316_i0 PRJNA951810 180661 231 4.436709 10.24879779 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 138 6.4299999999999995e-37   NR WP_021767467.1 712359 g180316 i0 98.7 1 77 1 100 0 1 231 278 354 WP_021767467.1 TIGR00341 family protein [Leptotrichia sp. oral taxon 215] diamond 231 138 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
26804011 26804011 PRJNA951810_P_NODE_128961_length_274_cov_1.333333_g128616_i0 PRJNA951810 128961 274 1.333333 3.65333242 Leptotrichia sp. 104608 Bacteria Bacteria 118 9.999999999999999e-29   NR MBF1332793.1 104608 g128616 i0 96.6 0.645985401459854 59 2 64.6 0 98 274 1 59 MBF1332793.1 AAA family ATPase [Leptotrichia sp.] diamond 177 118 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
27120210 27120210 PRJNA951810_P_NODE_180682_length_231_cov_4.335443_g180337_i0 PRJNA951810 180682 231 4.335443 10.01487333 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 94.7 1.6299999999999994e-23   NR WP_021767772.1 712359 g180337 i0 95.7 0.597402597402597 46 2 59.7 0 93 230 1 46 WP_021767772.1 hypothetical protein [Leptotrichia sp. oral taxon 215] diamond 138 94.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
29431856 29431856 PRJNA951810_P_NODE_119709_length_280_cov_3.893720_g119364_i0 PRJNA951810 119709 280 3.89372 10.902416 Bacteria 2 Bacteria Bacteria 48.5 4.5e-5   NR MFC2737781.1 157687 g119364 i0 56.8 1.24285714285714 37 14 39.6 1 225 115 41 75 MFC2737781.1 hypothetical protein [Leptotrichia wadei] diamond 348 48.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
31327668 31327668 PRJNA951810_P_NODE_91295_length_297_cov_2.352679_g90951_i0 PRJNA951810 91295 297 2.352679 6.98745663 Bacteria 2 Bacteria Bacteria 101 3.5599999999999995e-24   NR WP_367101745.1 1755100 g90951 i0 54.1 6.74747474747475 111 37 98 1 295 5 28 138 WP_367101745.1 hypothetical protein [Fusobacterium gastrosuis] diamond 2004 101 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium gastrosuis
31454379 31454379 PRJNA951810_P_NODE_187916_length_220_cov_6.503401_g187571_i0 PRJNA951810 187916 220 6.503401 14.3074822 Leptotrichia 32067 Bacteria Bacteria 62.8 2.34e-9   NR WP_304181942.1 109328 g187571 i0 75.8 1.8 33 8 45 0 99 1 299 331 WP_304181942.1 hypothetical protein, partial [Leptotrichia trevisanii] diamond 396 62.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia trevisanii
31549377 31549377 PRJNA951810_P_NODE_191556_length_212_cov_7.640288_g191211_i0 PRJNA951810 191556 212 7.640288 16.19741056 Leptotrichia 32067 Bacteria Bacteria 42 0.0109   NR MBF1333263.1 104608 g191211 i0 52.3 1.24528301886792 44 21 62.3 0 133 2 1 44 MBF1333263.1 hypothetical protein [Leptotrichia sp.] diamond 264 42 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.

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