contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA624323" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2425372 | 2425372 | PRJNA624323_P_NODE_1222_length_652_cov_7.732297_g1068_i0 | PRJNA624323 | 1222 | 652 | 7.732297 | 50.41457644 | Cetobacterium | 180162 | Bacteria | Bacteria | 1166 | 0 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g1068 | i0 | 98.926 | 495.746932515337 | 652 | 7 | 100 | 0 | 1 | 652 | 279439 | 278788 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 323227 | 1166 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 2425388 | 2425388 | PRJNA624323_P_NODE_6602_length_278_cov_2.487805_g6440_i0 | PRJNA624323 | 6602 | 278 | 2.487805 | 6.9160979 | Cetobacterium | 180162 | Bacteria | Bacteria | 475 | 1.2799999999999997e-129 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g6440 | i0 | 97.482 | 472.172661870504 | 278 | 7 | 100 | 0 | 1 | 278 | 279678 | 279401 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 131264 | 475 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 3147224 | 3147224 | PRJNA624323_P_NODE_2663_length_452_cov_6.395778_g2502_i0 | PRJNA624323 | 2663 | 452 | 6.395778 | 28.90891656 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 789 | 0 | NTclustered | gi|2666488225|gb|CP143319.1| | 188913 | g2502 | i0 | 98.23 | 458.276548672566 | 452 | 7 | 100 | 1 | 1 | 452 | 1318971 | 1318521 | Cetobacterium somerae strain ceto chromosome, complete genome | blastn | 207141 | 789 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 11353564 | 11353564 | PRJNA624323_P_NODE_3849_length_374_cov_2.355482_g3687_i0 | PRJNA624323 | 3849 | 374 | 2.355482 | 8.80950268 | Fusobacterium | 848 | Bacteria | Bacteria | 686 | 0 | NTclustered | gi|2704983719|gb|CP077132.1| | 851 | g3687 | i0 | 99.733 | 498.542780748663 | 374 | 1 | 100 | 0 | 1 | 374 | 92774 | 93147 | Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome | blastn | 186455 | 686 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 12075734 | 12075734 | PRJNA624323_P_NODE_7730_length_255_cov_1.219780_g7568_i0 | PRJNA624323 | 7730 | 255 | 1.21978 | 3.110439 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 460 | 3.25e-125 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g7568 | i0 | 99.216 | 426.811764705882 | 255 | 2 | 100 | 0 | 1 | 255 | 54052 | 53798 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 108837 | 460 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 13350572 | 13350572 | PRJNA624323_P_NODE_8971_length_244_cov_3.514620_g8809_i0 | PRJNA624323 | 8971 | 244 | 3.51462 | 8.5756728 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 440 | 4.019999999999999e-119 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g8809 | i0 | 99.18 | 420.815573770492 | 244 | 2 | 100 | 0 | 1 | 244 | 52570 | 52813 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 102679 | 440 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 16452948 | 16452948 | PRJNA624323_P_NODE_5613_length_305_cov_1.594828_g5451_i0 | PRJNA624323 | 5613 | 305 | 1.594828 | 4.8642254 | Fusobacterium | 848 | Bacteria | Bacteria | 553 | 6.39e-153 | NTclustered | gi|2705020071|gb|CP084132.1| | 851 | g5451 | i0 | 99.669 | 477.744262295082 | 302 | 1 | 99 | 0 | 1 | 302 | 107620 | 107921 | Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome | blastn | 145712 | 558 | 0.991039426523297 | 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);;