contig_metadata
13 rows where bioproject = "PRJNA1174207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1590269 | 1590269 | PRJNA1174207_P_NODE_26662_length_279_cov_0.805825_g26133_i0 | PRJNA1174207 | 26662 | 279 | 0.805825 | 2.24825175 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 433 | 7.85e-117 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g26133 | i0 | 94.624 | 317.870967741935 | 279 | 15 | 100 | 0 | 1 | 279 | 52152 | 51874 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 88686 | 433 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 1590287 | 1590287 | PRJNA1174207_P_NODE_27642_length_274_cov_2.029851_g27113_i0 | PRJNA1174207 | 27642 | 274 | 2.029851 | 5.56179174 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 507 | 4.47e-139 | NTclustered | gi|1708575239|dbj|AP019834.1| | 157687 | g27113 | i0 | 100 | 35.0401459854015 | 274 | 0 | 100 | 0 | 1 | 274 | 131593 | 131320 | Leptotrichia wadei JMUB3933 DNA, complete genome | blastn | 9601 | 507 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 2315731 | 2315731 | PRJNA1174207_P_NODE_16262_length_356_cov_2.141343_g15733_i0 | PRJNA1174207 | 16262 | 356 | 2.141343 | 7.62318108 | Fusobacterium | 848 | Bacteria | Bacteria | 656 | 0 | NTclustered | gi|2446175567|gb|CP117964.1| | 851 | g15733 | i0 | 100 | 426.393258426966 | 355 | 0 | 99 | 0 | 2 | 356 | 996828 | 997182 | Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome | blastn | 151796 | 656 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 5419080 | 5419080 | PRJNA1174207_P_NODE_9445_length_501_cov_3.420561_g8919_i0 | PRJNA1174207 | 9445 | 501 | 3.420561 | 17.13701061 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 876 | 0 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g8919 | i0 | 98.204 | 203.748502994012 | 501 | 9 | 100 | 0 | 1 | 501 | 1757972 | 1757472 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 102078 | 876 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 8693646 | 8693646 | PRJNA1174207_P_NODE_33567_length_251_cov_0.865169_g33038_i0 | PRJNA1174207 | 33567 | 251 | 0.865169 | 2.17157419 | Fusobacterium | 848 | Bacteria | Bacteria | 464 | 2.47e-126 | NTclustered | gi|1208657894|gb|CP021934.1| | 76857 | g33038 | i0 | 100 | 99.199203187251 | 251 | 0 | 100 | 0 | 1 | 251 | 870134 | 869884 | Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome | blastn | 24899 | 464 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 14344774 | 14344774 | PRJNA1174207_P_NODE_35852_length_248_cov_0.880000_g35323_i0 | PRJNA1174207 | 35852 | 248 | 0.88 | 2.1824 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 459 | 1.13e-124 | NTclustered | gi|2706074160|gb|CP077112.1| | 76857 | g35323 | i0 | 100 | 99.6975806451613 | 248 | 0 | 100 | 0 | 1 | 248 | 2182965 | 2183212 | Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome | blastn | 24725 | 459 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 15068218 | 15068218 | PRJNA1174207_P_NODE_22672_length_298_cov_2.982222_g22143_i0 | PRJNA1174207 | 22672 | 298 | 2.982222 | 8.88702156 | Fusobacterium | 848 | Bacteria | Bacteria | 278 | 4.2e-70 | NTclustered | gi|1208657894|gb|CP021934.1| | 76857 | g22143 | i0 | 100 | 97.2684563758389 | 150 | 0 | 99 | 0 | 1 | 150 | 344428 | 344577 | Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome | blastn | 28986 | 278 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 15618357 | 15618357 | PRJNA1174207_P_NODE_2553_length_1164_cov_4.919340_g2190_i0 | PRJNA1174207 | 2553 | 1164 | 4.91934 | 57.2611176 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 2104 | 0 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g2190 | i0 | 99.313 | 559.775773195876 | 1164 | 7 | 100 | 1 | 1 | 1164 | 1756154 | 1757316 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 651579 | 2104 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 17618169 | 17618169 | PRJNA1174207_P_NODE_12254_length_423_cov_2.285714_g11727_i0 | PRJNA1174207 | 12254 | 423 | 2.285714 | 9.66857022 | Leptotrichia | 32067 | Bacteria | Bacteria | 782 | 0 | NTclustered | gi|470484715|ref|NR_076664.1| | 40542 | g11727 | i0 | 100 | 481.430260047281 | 423 | 0 | 100 | 0 | 1 | 423 | 2379 | 1957 | Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence | blastn | 203645 | 782 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 18891968 | 18891968 | PRJNA1174207_P_NODE_1375_length_1634_cov_11.729020_g1124_i0 | PRJNA1174207 | 1375 | 1634 | 11.72902 | 191.6521868 | Fusobacterium | 848 | Bacteria | Bacteria | 2953 | 0 | NTclustered | gi|1370537877|gb|CP028108.1| | 860 | g1124 | i0 | 99.326 | 477.077723378213 | 1632 | 11 | 99 | 0 | 3 | 1634 | 463214 | 461583 | Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome | blastn | 779545 | 2953 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium periodonticum | ||
| 20716901 | 20716901 | PRJNA1174207_P_NODE_23277_length_294_cov_1.918552_g22748_i0 | PRJNA1174207 | 23277 | 294 | 1.918552 | 5.64054288 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 455 | 1.7800000000000002e-123 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g22748 | i0 | 94.558 | 111.095238095238 | 294 | 16 | 100 | 0 | 1 | 294 | 51892 | 51599 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 32662 | 455 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 20717303 | 20717303 | PRJNA1174207_P_NODE_43837_length_199_cov_4.031746_g43308_i0 | PRJNA1174207 | 43837 | 199 | 4.031746 | 8.02317454 | Leptotrichia sp. HMT-225 | 3058373 | Bacteria | Bacteria | 368 | 1.51e-97 | NTclustered | gi|2557559843|gb|CP130323.1| | 3058373 | g43308 | i0 | 100 | 82.7889447236181 | 199 | 0 | 100 | 0 | 1 | 199 | 196899 | 197097 | Leptotrichia sp. HMT-225 chromosome, complete genome | blastn | 16475 | 368 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. HMT-225 | ||
| 23267563 | 23267563 | PRJNA1174207_P_NODE_14099_length_388_cov_1.126984_g13570_i0 | PRJNA1174207 | 14099 | 388 | 1.126984 | 4.37269792 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 623 | 6.259999999999999e-174 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g13570 | i0 | 95.619 | 421.29381443299 | 388 | 17 | 100 | 0 | 1 | 388 | 52159 | 51772 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 163462 | 623 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 |
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);;