contig_metadata
8 rows where bioproject = "PRJEB49404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11194437 | 11194437 | PRJEB49404_P_NODE_525649_length_175_cov_1.852941_g511848_i0 | PRJEB49404 | 525649 | 175 | 1.852941 | 3.24264675 | Cetobacterium | 180162 | Bacteria | Bacteria | 318 | 1.32e-82 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g511848 | i0 | 99.429 | 521.742857142857 | 175 | 1 | 100 | 0 | 1 | 175 | 279336 | 279162 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 91305 | 318 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 11194469 | 11194469 | PRJEB49404_P_NODE_569649_length_165_cov_2.277778_g555848_i0 | PRJEB49404 | 569649 | 165 | 2.277778 | 3.7583337 | Fusobacterium | 848 | Bacteria | Bacteria | 305 | 9.59e-79 | NTclustered | gi|2704983719|gb|CP077132.1| | 851 | g555848 | i0 | 100 | 456.927272727273 | 165 | 0 | 100 | 0 | 1 | 165 | 91649 | 91813 | Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome | blastn | 75393 | 305 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 17568718 | 17568718 | PRJEB49404_P_NODE_187174_length_369_cov_1.642424_g173375_i0 | PRJEB49404 | 187174 | 369 | 1.642424 | 6.06054456 | Fusobacterium | 848 | Bacteria | Bacteria | 660 | 0 | NTclustered | gi|2704979632|gb|CP077143.1| | 851 | g173375 | i0 | 98.916 | 486.084010840108 | 369 | 4 | 100 | 0 | 1 | 369 | 74734 | 75102 | Fusobacterium nucleatum strain KCOM2878 chromosome, complete genome | blastn | 179365 | 660 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 17568844 | 17568844 | PRJEB49404_P_NODE_396594_length_215_cov_1.914773_g382793_i0 | PRJEB49404 | 396594 | 215 | 1.914773 | 4.11676195 | Fusobacterium | 848 | Bacteria | Bacteria | 387 | 4.57e-103 | NTclustered | gi|2704983719|gb|CP077132.1| | 851 | g382793 | i0 | 99.07 | 491.488372093023 | 215 | 2 | 100 | 0 | 1 | 215 | 92640 | 92854 | Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome | blastn | 105670 | 387 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 17967688 | 17967688 | PRJEB49404_P_NODE_613035_length_157_cov_1.347458_g599234_i0 | PRJEB49404 | 613035 | 157 | 1.347458 | 2.11550906 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 267 | 4.25e-67 | NTclustered | gi|2865366169|gb|CP122292.1| | 188913 | g599234 | i0 | 97.452 | 57.0063694267516 | 157 | 3 | 100 | 1 | 1 | 157 | 420306 | 420151 | Cetobacterium somerae strain MSU41 chromosome, complete genome | blastn | 8950 | 267 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 22667837 | 22667837 | PRJEB49404_P_NODE_287218_length_272_cov_2.051502_g273417_i0 | PRJEB49404 | 287218 | 272 | 2.051502 | 5.58008544 | Fusobacterium | 848 | Bacteria | Bacteria | 473 | 4.4899999999999996e-129 | NTclustered | gi|2704968189|gb|CP077126.1| | 851 | g273417 | i0 | 98.155 | 491.198529411765 | 271 | 5 | 99 | 0 | 2 | 272 | 1546147 | 1545877 | Fusobacterium nucleatum strain KCOM3685 chromosome, complete genome | blastn | 133606 | 473 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 23044895 | 23044895 | PRJEB49404_P_NODE_120259_length_505_cov_1.965665_g106553_i0 | PRJEB49404 | 120259 | 505 | 1.965665 | 9.92660825 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 909 | 0 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g106553 | i0 | 99.206 | 436.988118811881 | 504 | 4 | 99 | 0 | 2 | 505 | 53149 | 52646 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 220679 | 909 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 24339013 | 24339013 | PRJEB49404_P_NODE_550560_length_169_cov_2.661538_g536759_i0 | PRJEB49404 | 550560 | 169 | 2.661538 | 4.49799922 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 313 | 5.859999999999999e-81 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g536759 | i0 | 100 | 503.87573964497 | 169 | 0 | 100 | 0 | 1 | 169 | 52333 | 52501 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 85155 | 313 | 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);;