contig_metadata
10 rows where bioproject = "PRJNA599208" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 572202 | 572202 | PRJNA599208_P_NODE_16201_length_153_cov_2.258621_g16005_i0 | PRJNA599208 | 16201 | 153 | 2.258621 | 3.45569013 | Ilyobacter tartaricus | 167644 | Bacteria | Bacteria | 185 | 1.18e-42 | NTclustered | gi|15029010|emb|AJ307977.1| | 167644 | g16005 | i0 | 91.176 | 143.098039215686 | 136 | 12 | 89 | 0 | 1 | 136 | 1042 | 907 | Ilyobacter tartaricus 23S rRNA gene, DSM 2382 T | blastn | 21894 | 185 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Ilyobacter | Ilyobacter tartaricus | ||
| 4969610 | 4969610 | PRJNA599208_P_NODE_6444_length_298_cov_3.869732_g6248_i0 | PRJNA599208 | 6444 | 298 | 3.869732 | 11.53180136 | Leptotrichia | 32067 | Bacteria | Bacteria | 551 | 2.239999999999999e-152 | NTclustered | gi|631253196|ref|NR_114394.1| | 40542 | g6248 | i0 | 100 | 111.989932885906 | 298 | 0 | 100 | 0 | 1 | 298 | 786 | 489 | Leptotrichia buccalis strain C-1013-b 16S ribosomal RNA, partial sequence | blastn | 33373 | 551 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 6245095 | 6245095 | PRJNA599208_P_NODE_14985_length_161_cov_4.798387_g14789_i0 | PRJNA599208 | 14985 | 161 | 4.798387 | 7.72540307 | Fusobacterium | 848 | Bacteria | Bacteria | 298 | 1.56e-76 | NTclustered | gi|2446175567|gb|CP117964.1| | 851 | g14789 | i0 | 100 | 491 | 161 | 0 | 100 | 0 | 1 | 161 | 2087554 | 2087394 | Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome | blastn | 79051 | 298 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 6950470 | 6950470 | PRJNA599208_P_NODE_16146_length_154_cov_1.017094_g15950_i0 | PRJNA599208 | 16146 | 154 | 1.017094 | 1.56632476 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 283 | 4.12e-72 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g15950 | i0 | 100 | 193.603896103896 | 153 | 0 | 99 | 0 | 1 | 153 | 1756660 | 1756508 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 29815 | 283 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 14601046 | 14601046 | PRJNA599208_P_NODE_11272_length_197_cov_3.600000_g11076_i0 | PRJNA599208 | 11272 | 197 | 3.6 | 7.092 | uncultured Leptotrichia sp. | 159271 | Bacteria | Bacteria | 359 | 8.98e-95 | NTclustered | gi|253683908|gb|FJ976286.1| | 159271 | g11076 | i0 | 99.492 | 104.005076142132 | 197 | 1 | 100 | 0 | 1 | 197 | 311 | 115 | Uncultured Leptotrichia sp. clone 7BBB40 16S ribosomal RNA gene, partial sequence | blastn | 20489 | 359 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | uncultured Leptotrichia sp. | ||
| 14601104 | 14601104 | PRJNA599208_P_NODE_16452_length_152_cov_1.321739_g16256_i0 | PRJNA599208 | 16452 | 152 | 1.321739 | 2.00904328 | Leptotrichia hofstadii | 157688 | Bacteria | Bacteria | 265 | 1.47e-66 | NTclustered | gi|1708566027|dbj|AP019823.1| | 157688 | g16256 | i0 | 98.026 | 85.4934210526316 | 152 | 3 | 100 | 0 | 1 | 152 | 2256969 | 2257120 | Leptotrichia hofstadii JCM16775 DNA, complete genome | blastn | 12995 | 265 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia hofstadii | ||
| 19698659 | 19698659 | PRJNA599208_P_NODE_10536_length_208_cov_1.725146_g10340_i0 | PRJNA599208 | 10536 | 208 | 1.725146 | 3.58830368 | Leptotrichia sp. HMT-225 | 3058373 | Bacteria | Bacteria | 357 | 3.4499999999999996e-94 | NTclustered | gi|2557559843|gb|CP130323.1| | 3058373 | g10340 | i0 | 97.596 | 211.211538461538 | 208 | 5 | 100 | 0 | 1 | 208 | 196700 | 196907 | Leptotrichia sp. HMT-225 chromosome, complete genome | blastn | 43932 | 357 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. HMT-225 | ||
| 21543385 | 21543385 | PRJNA599208_P_NODE_3097_length_494_cov_47.413567_g2906_i0 | PRJNA599208 | 3097 | 494 | 47.413567 | 234.22302098 | Fusobacterium | 848 | Bacteria | Bacteria | 813 | 0 | NTclustered | gi|15028908|emb|AJ307974.1| | 851 | g2906 | i0 | 96.371 | 458.763157894737 | 496 | 15 | 100 | 2 | 1 | 494 | 507 | 13 | Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482 | blastn | 226629 | 813 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 22818622 | 22818622 | PRJNA599208_P_NODE_15158_length_160_cov_2.081301_g14962_i0 | PRJNA599208 | 15158 | 160 | 2.081301 | 3.3300816 | Fusobacterium | 848 | Bacteria | Bacteria | 291 | 2.5799999999999998e-74 | NTclustered | gi|2706074160|gb|CP077112.1| | 76857 | g14962 | i0 | 99.375 | 482.90625 | 160 | 1 | 100 | 0 | 1 | 160 | 1980023 | 1979864 | Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome | blastn | 77265 | 291 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 24093401 | 24093401 | PRJNA599208_P_NODE_15539_length_157_cov_5.658333_g15343_i0 | PRJNA599208 | 15539 | 157 | 5.658333 | 8.88358281 | Leptotrichia | 32067 | Bacteria | Bacteria | 283 | 4.22e-72 | NTclustered | gi|470484715|ref|NR_076664.1| | 40542 | g15343 | i0 | 99.363 | 502.955414012739 | 157 | 0 | 100 | 1 | 1 | 157 | 1042 | 1197 | Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence | blastn | 78964 | 283 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis |
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);;