contig_metadata
7 rows where bioproject = "PRJNA674048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3193958 | 3193958 | PRJNA674048_P_NODE_19703_length_199_cov_1.206667_g19500_i0 | PRJNA674048 | 19703 | 199 | 1.206667 | 2.40126733 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 315 | 1.99e-81 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g19500 | i0 | 95.431 | 350.462311557789 | 197 | 9 | 99 | 0 | 1 | 197 | 53415 | 53219 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 69742 | 315 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 7021710 | 7021710 | PRJNA674048_P_NODE_22106_length_187_cov_1.507246_g21903_i0 | PRJNA674048 | 22106 | 187 | 1.507246 | 2.81855002 | Fusobacteria bacterium ZRK30 | 2970471 | Bacteria | Bacteria | 252 | 1.47e-62 | NTclustered | gi|2284594148|gb|CP102404.1| | 2970471 | g21903 | i0 | 90.909 | 1 | 187 | 17 | 100 | 0 | 1 | 187 | 550060 | 550246 | Fusobacteria bacterium ZRK30 chromosome 1, complete sequence | blastn | 187 | 252 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteria bacterium ZRK30 | ||||||
| 14672089 | 14672089 | PRJNA674048_P_NODE_17552_length_212_cov_0.877301_g17349_i0 | PRJNA674048 | 17552 | 212 | 0.877301 | 1.85987812 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 353 | 4.56e-93 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g17349 | i0 | 96.698 | 350.188679245283 | 212 | 7 | 100 | 0 | 1 | 212 | 52815 | 53026 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 74240 | 353 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 15945865 | 15945865 | PRJNA674048_P_NODE_33033_length_161_cov_3.008929_g32830_i0 | PRJNA674048 | 33033 | 161 | 3.008929 | 4.84437569 | Leptotrichia hofstadii | 157688 | Bacteria | Bacteria | 298 | 1.56e-76 | NTclustered | gi|1708566027|dbj|AP019823.1| | 157688 | g32830 | i0 | 100 | 333.416149068323 | 161 | 0 | 100 | 0 | 1 | 161 | 498367 | 498527 | Leptotrichia hofstadii JCM16775 DNA, complete genome | blastn | 53680 | 298 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia hofstadii | ||
| 18495420 | 18495420 | PRJNA674048_P_NODE_16055_length_222_cov_2.323699_g15852_i0 | PRJNA674048 | 16055 | 222 | 2.323699 | 5.15861178 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 409 | 1.0100000000000001e-109 | NTclustered | gi|2704959642|gb|CP077196.1| | 2663009 | g15852 | i0 | 100 | 486.810810810811 | 221 | 0 | 99 | 0 | 2 | 222 | 1672361 | 1672581 | Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome | blastn | 108072 | 409 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 23596030 | 23596030 | PRJNA674048_P_NODE_33319_length_159_cov_2.363636_g33116_i0 | PRJNA674048 | 33319 | 159 | 2.363636 | 3.75818124 | Fusobacteria bacterium ZRK30 | 2970471 | Bacteria | Bacteria | 272 | 9.28e-69 | NTclustered | gi|2284594148|gb|CP102404.1| | 2970471 | g33116 | i0 | 97.484 | 466.081761006289 | 159 | 4 | 100 | 0 | 1 | 159 | 203743 | 203585 | Fusobacteria bacterium ZRK30 chromosome 1, complete sequence | blastn | 74107 | 272 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteria bacterium ZRK30 | ||||||
| 24118046 | 24118046 | PRJNA674048_P_NODE_34079_length_152_cov_3.611650_g33876_i0 | PRJNA674048 | 34079 | 152 | 3.61165 | 5.489708 | Fusobacterium | 848 | Bacteria | Bacteria | 281 | 1.46e-71 | NTclustered | gi|2704983719|gb|CP077132.1| | 851 | g33876 | i0 | 100 | 485.993421052632 | 152 | 0 | 100 | 0 | 1 | 152 | 92555 | 92404 | Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome | blastn | 73871 | 281 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum |
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);;