contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA752278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 726679 | 726679 | PRJNA752278_P_NODE_102521_length_242_cov_0.911243_g102318_i0 | PRJNA752278 | 102521 | 242 | 0.911243 | 2.20520806 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 448 | 2.3799999999999995e-121 | NTclustered | gi|1708575239|dbj|AP019834.1| | 157687 | g102318 | i0 | 100 | 7.85123966942149 | 242 | 0 | 100 | 0 | 1 | 242 | 1753942 | 1754183 | Leptotrichia wadei JMUB3933 DNA, complete genome | blastn | 1900 | 448 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 727892 | 727892 | PRJNA752278_P_NODE_65521_length_262_cov_2.375661_g65318_i0 | PRJNA752278 | 65521 | 262 | 2.375661 | 6.22423182 | Leptotrichia buccalis | 40542 | Bacteria | Bacteria | 484 | 1.99e-132 | NTclustered | gi|257048753|gb|CP001685.1| | 523794 | g65318 | i0 | 100 | 10.8129770992366 | 262 | 0 | 100 | 0 | 1 | 262 | 1534873 | 1534612 | Leptotrichia buccalis DSM 1135, complete genome | blastn | 2833 | 484 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 2004523 | 2004523 | PRJNA752278_P_NODE_95702_length_244_cov_1.637427_g95499_i0 | PRJNA752278 | 95702 | 244 | 1.637427 | 3.99532188 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 429 | 8.699999999999998e-116 | NTclustered | gi|1276709865|gb|CP024700.1| | 2663009 | g95499 | i0 | 98.361 | 100.016393442623 | 244 | 4 | 100 | 0 | 1 | 244 | 762210 | 761967 | Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome | blastn | 24404 | 429 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 3278046 | 3278046 | PRJNA752278_P_NODE_102303_length_242_cov_0.911243_g102100_i0 | PRJNA752278 | 102303 | 242 | 0.911243 | 2.20520806 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 436 | 5.1499999999999985e-118 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g102100 | i0 | 99.174 | 4.46280991735537 | 242 | 2 | 100 | 0 | 1 | 242 | 239035 | 239276 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 1080 | 436 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 3278946 | 3278946 | PRJNA752278_P_NODE_48743_length_278_cov_2.004878_g48540_i0 | PRJNA752278 | 48743 | 278 | 2.004878 | 5.57356084 | Leptotrichia hofstadii | 157688 | Bacteria | Bacteria | 475 | 1.2799999999999997e-129 | NTclustered | gi|1708566027|dbj|AP019823.1| | 157688 | g48540 | i0 | 97.482 | 11.9820143884892 | 278 | 7 | 100 | 0 | 1 | 278 | 2534222 | 2534499 | Leptotrichia hofstadii JCM16775 DNA, complete genome | blastn | 3331 | 475 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia hofstadii | ||
| 5029488 | 5029488 | PRJNA752278_P_NODE_76104_length_252_cov_1.720670_g75901_i0 | PRJNA752278 | 76104 | 252 | 1.72067 | 4.3360884 | Fusobacterium | 848 | Bacteria | Bacteria | 464 | 2.4799999999999998e-126 | NTclustered | gi|958162200|gb|CP013331.1| | 1307442 | g75901 | i0 | 100 | 99.6388888888889 | 251 | 0 | 99 | 0 | 2 | 252 | 2162595 | 2162845 | Fusobacterium hwasookii ChDC F174, complete genome | blastn | 25109 | 464 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium hwasookii | ||
| 8381013 | 8381013 | PRJNA752278_P_NODE_54847_length_272_cov_2.698492_g54644_i0 | PRJNA752278 | 54847 | 272 | 2.698492 | 7.33989824 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 503 | 5.729999999999998e-138 | NTclustered | gi|2078816781|gb|CP071094.1| | 76857 | g54644 | i0 | 100 | 503.889705882353 | 272 | 0 | 100 | 0 | 1 | 272 | 260683 | 260412 | Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome | blastn | 137058 | 503 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 21130160 | 21130160 | PRJNA752278_P_NODE_46637_length_280_cov_1.956522_g46434_i0 | PRJNA752278 | 46637 | 280 | 1.956522 | 5.4782616 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 512 | 9.85e-141 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g46434 | i0 | 99.643 | 172.3 | 280 | 1 | 100 | 0 | 1 | 280 | 1228614 | 1228893 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 48244 | 512 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 22405481 | 22405481 | PRJNA752278_P_NODE_74218_length_254_cov_1.635359_g74015_i0 | PRJNA752278 | 74218 | 254 | 1.635359 | 4.15381186 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 431 | 2.539999999999999e-116 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g74015 | i0 | 97.244 | 2.99606299212598 | 254 | 7 | 100 | 0 | 1 | 254 | 2357937 | 2357684 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 761 | 431 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 22405713 | 22405713 | PRJNA752278_P_NODE_86618_length_248_cov_0.880000_g86415_i0 | PRJNA752278 | 86618 | 248 | 0.88 | 2.1824 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 459 | 1.13e-124 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g86415 | i0 | 100 | 4.9758064516129 | 248 | 0 | 100 | 0 | 1 | 248 | 1730207 | 1730454 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 1234 | 459 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei |
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);;