contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA983848" and tax_kingdom = "Fusobacteriati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 966977 | 966977 | PRJNA983848_P_NODE_125781_length_266_cov_2.088083_g119898_i0 | PRJNA983848 | 125781 | 266 | 2.088083 | 5.55430078 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 462 | 9.48e-126 | NTclustered | gi|2865366169|gb|CP122292.1| | 188913 | g119898 | i0 | 98.12 | 362.244360902256 | 266 | 4 | 100 | 1 | 1 | 266 | 420434 | 420170 | Cetobacterium somerae strain MSU41 chromosome, complete genome | blastn | 96357 | 462 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 6070430 | 6070430 | PRJNA983848_P_NODE_129585_length_262_cov_1.428571_g123702_i0 | PRJNA983848 | 129585 | 262 | 1.428571 | 3.74285602 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 484 | 1.99e-132 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g123702 | i0 | 100 | 165.603053435115 | 262 | 0 | 100 | 0 | 1 | 262 | 2299137 | 2298876 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 43388 | 484 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 7344624 | 7344624 | PRJNA983848_P_NODE_120486_length_273_cov_1.410000_g114603_i0 | PRJNA983848 | 120486 | 273 | 1.41 | 3.8493 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 505 | 1.6e-138 | NTclustered | gi|1208657894|gb|CP021934.1| | 76857 | g114603 | i0 | 100 | 476.736263736264 | 273 | 0 | 100 | 0 | 1 | 273 | 1602526 | 1602798 | Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome | blastn | 130149 | 505 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 7345599 | 7345599 | PRJNA983848_P_NODE_148906_length_247_cov_1.649425_g143023_i0 | PRJNA983848 | 148906 | 247 | 1.649425 | 4.07407975 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 440 | 4.079999999999999e-119 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g143023 | i0 | 98.785 | 412.963562753036 | 247 | 3 | 100 | 0 | 1 | 247 | 220538 | 220784 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 102002 | 440 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 17545112 | 17545112 | PRJNA983848_P_NODE_131374_length_260_cov_1.363636_g125491_i0 | PRJNA983848 | 131374 | 260 | 1.363636 | 3.5454536 | Leptotrichia sp. oral taxon 221 | 712362 | Bacteria | Bacteria | 475 | 1.1899999999999999e-129 | NTclustered | gi|2028889048|gb|CP072378.1| | 712362 | g125491 | i0 | 99.615 | 1 | 260 | 1 | 100 | 0 | 1 | 260 | 168661 | 168920 | Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome | blastn | 260 | 475 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 221 | ||
| 25498073 | 25498073 | PRJNA983848_P_NODE_90640_length_321_cov_1.254032_g84757_i0 | PRJNA983848 | 90640 | 321 | 1.254032 | 4.02544272 | Fusobacterium | 848 | Bacteria | Bacteria | 52.8 | 0.03 | NTclustered | gi|2705042081|gb|CP085192.1| | 856 | g84757 | i0 | 100 | 0.348909657320872 | 28 | 0 | 9 | 0 | 227 | 254 | 2865428 | 2865401 | Fusobacterium varium strain SB069 chromosome | blastn | 112 | 52.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium varium |
Advanced export
JSON shape: default, array, newline-delimited
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);;