contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1001940" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1421459 | 1421459 | PRJNA1001940_S_NODE_180702_length_161_cov_2.033898_g179648_i0 | PRJNA1001940 | 180702 | 161 | 2.033898 | 3.27457578 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 265 | 1.5799999999999998e-66 | NTclustered | gi|2706071841|gb|CP077111.1| | 76857 | g179648 | i0 | 96.273 | 99.7763975155279 | 161 | 6 | 100 | 0 | 1 | 161 | 1293393 | 1293233 | Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome | blastn | 16064 | 265 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 3973788 | 3973788 | PRJNA1001940_S_NODE_35424_length_354_cov_4.938907_g34370_i0 | PRJNA1001940 | 35424 | 354 | 4.938907 | 17.48373078 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 507 | 5.95e-139 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g34370 | i0 | 92.614 | 0.994350282485876 | 352 | 26 | 99 | 0 | 3 | 354 | 684627 | 684276 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 352 | 507 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 9074288 | 9074288 | PRJNA1001940_S_NODE_186488_length_159_cov_1.241379_g185434_i0 | PRJNA1001940 | 186488 | 159 | 1.241379 | 1.97379261 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 255 | 9.35e-64 | NTclustered | gi|2673502234|gb|CP144257.1| | 76857 | g185434 | i0 | 95.597 | 82.3962264150943 | 159 | 7 | 100 | 0 | 1 | 159 | 388503 | 388661 | Fusobacterium polymorphum strain IOOS_98 chromosome | blastn | 13101 | 255 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 12901478 | 12901478 | PRJNA1001940_S_NODE_63491_length_272_cov_3.563319_g62437_i0 | PRJNA1001940 | 63491 | 272 | 3.563319 | 9.69222768 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 492 | 1.24e-134 | NTclustered | gi|1276709865|gb|CP024700.1| | 2663009 | g62437 | i0 | 99.265 | 41.6691176470588 | 272 | 2 | 100 | 0 | 1 | 272 | 1582078 | 1582349 | Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome | blastn | 11334 | 492 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 13753027 | 13753027 | PRJNA1001940_S_NODE_32891_length_365_cov_3.304348_g31839_i0 | PRJNA1001940 | 32891 | 365 | 3.304348 | 12.0608702 | Leptotrichia | 32067 | Bacteria | Bacteria | 652 | 0 | NTclustered | gi|470484715|ref|NR_076664.1| | 40542 | g31839 | i0 | 98.904 | 197.545205479452 | 365 | 4 | 100 | 0 | 1 | 365 | 393 | 29 | Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence | blastn | 72104 | 652 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 20126085 | 20126085 | PRJNA1001940_S_NODE_44816_length_320_cov_7.111913_g43762_i0 | PRJNA1001940 | 44816 | 320 | 7.111913 | 22.7581216 | Fusobacterium | 848 | Bacteria | Bacteria | 547 | 3.139999999999999e-151 | NTclustered | gi|1370537877|gb|CP028108.1| | 860 | g43762 | i0 | 100 | 322.675 | 296 | 0 | 93 | 0 | 1 | 296 | 460148 | 459853 | Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome | blastn | 103256 | 547 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium periodonticum | ||
| 23099583 | 23099583 | PRJNA1001940_S_NODE_30399_length_376_cov_4.498498_g29348_i0 | PRJNA1001940 | 30399 | 376 | 4.498498 | 16.91435248 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 656 | 0 | NTclustered | gi|1276705688|gb|CP024698.1| | 2663009 | g29348 | i0 | 98.138 | 81.5797872340426 | 376 | 7 | 100 | 0 | 1 | 376 | 895852 | 895477 | Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome | blastn | 30674 | 656 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 23951965 | 23951965 | PRJNA1001940_S_NODE_34039_length_360_cov_4.542587_g32985_i0 | PRJNA1001940 | 34039 | 360 | 4.542587 | 16.3533132 | Fusobacterium | 848 | Bacteria | Bacteria | 577 | 4.549999999999999e-160 | NTclustered | gi|2704996929|gb|CP077149.1| | 851 | g32985 | i0 | 96.552 | 16.5083333333333 | 348 | 12 | 97 | 0 | 10 | 357 | 1427858 | 1428205 | Fusobacterium nucleatum strain KCOM2013 chromosome, complete genome | blastn | 5943 | 582 | 0.991408934707904 | 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);;