contig_metadata
8 rows where bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1272228 | 1272228 | PRJNA986481_P_NODE_62361_length_228_cov_2.648045_g61836_i0 | PRJNA986481 | 62361 | 228 | 2.648045 | 6.0375426 | Fusobacterium | 848 | Bacteria | Bacteria | 388 | 1.3599999999999998e-103 | NTclustered | gi|2704995109|gb|CP077144.1| | 851 | g61836 | i0 | 97.368 | 99.9824561403509 | 228 | 6 | 100 | 0 | 1 | 228 | 1044452 | 1044225 | Fusobacterium nucleatum strain KCOM2847 chromosome, complete genome | blastn | 22796 | 388 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 11176823 | 11176823 | PRJNA986481_P_NODE_28069_length_309_cov_4.403846_g27544_i0 | PRJNA986481 | 28069 | 309 | 4.403846 | 13.60788414 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 503 | 6.629999999999998e-138 | NTclustered | gi|1276718681|gb|CP024704.1| | 2663009 | g27544 | i0 | 98.932 | 90.9385113268608 | 281 | 3 | 91 | 0 | 20 | 300 | 848561 | 848281 | Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome | blastn | 28100 | 503 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 14025933 | 14025933 | PRJNA986481_P_NODE_2371_length_951_cov_3.586475_g2054_i0 | PRJNA986481 | 2371 | 951 | 3.586475 | 34.10737725 | Leptotrichia | 32067 | Bacteria | Bacteria | 1698 | 0 | NTclustered | gi|470484715|ref|NR_076664.1| | 40542 | g2054 | i0 | 99.57 | 481.937960042061 | 931 | 4 | 98 | 0 | 21 | 951 | 3 | 933 | Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence | blastn | 458323 | 1698 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 16276890 | 16276890 | PRJNA986481_P_NODE_7493_length_593_cov_1.814338_g6995_i0 | PRJNA986481 | 7493 | 593 | 1.814338 | 10.75902434 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 1072 | 0 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g6995 | i0 | 99.325 | 1.90387858347386 | 593 | 3 | 100 | 1 | 1 | 593 | 1984275 | 1983684 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 1129 | 1072 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 21674556 | 21674556 | PRJNA986481_P_NODE_60897_length_238_cov_3.777778_g60372_i0 | PRJNA986481 | 60897 | 238 | 3.777778 | 8.99111164 | Fusobacterium | 848 | Bacteria | Bacteria | 398 | 2.3799999999999995e-106 | NTclustered | gi|1370537877|gb|CP028108.1| | 860 | g60372 | i0 | 99.541 | 287.373949579832 | 218 | 1 | 92 | 0 | 21 | 238 | 1815285 | 1815068 | Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome | blastn | 68395 | 398 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium periodonticum | ||
| 22650377 | 22650377 | PRJNA986481_P_NODE_19578_length_370_cov_2.084112_g19053_i0 | PRJNA986481 | 19578 | 370 | 2.084112 | 7.7112144 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 684 | 0 | NTclustered | gi|2706056059|gb|CP077188.1| | 76857 | g19053 | i0 | 100 | 99.3162162162162 | 370 | 0 | 100 | 0 | 1 | 370 | 919734 | 920103 | Fusobacterium polymorphum strain SB028 chromosome, complete genome | blastn | 36747 | 684 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 24223831 | 24223831 | PRJNA986481_P_NODE_5679_length_670_cov_2.903382_g5228_i0 | PRJNA986481 | 5679 | 670 | 2.903382 | 19.4526594 | Leptotrichia | 32067 | Bacteria | Bacteria | 1194 | 0 | NTclustered | gi|470484715|ref|NR_076664.1| | 40542 | g5228 | i0 | 99.392 | 507.729850746269 | 658 | 4 | 98 | 0 | 13 | 670 | 1645 | 988 | Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence | blastn | 340179 | 1199 | 0.995829858215179 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 29589871 | 29589871 | PRJNA986481_P_NODE_23450_length_339_cov_1.227586_g22925_i0 | PRJNA986481 | 23450 | 339 | 1.227586 | 4.16151654 | Cetobacterium | 180162 | Bacteria | Bacteria | 47.4 | 0.00271 | NR | WP_297595860.1 | 527638 | g22925 | i0 | 78.6 | 6.93805309734513 | 28 | 6 | 24.8 | 0 | 141 | 58 | 572 | 599 | WP_297595860.1 ATP-dependent zinc metalloprotease FtsH [uncultured Cetobacterium sp.] | diamond | 2352 | 47.4 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. |
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);;