contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA811725" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2085659 | 2085659 | PRJNA811725_P_NODE_27362_length_295_cov_3.801802_g27116_i0 | PRJNA811725 | 27362 | 295 | 3.801802 | 11.2153159 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 527 | 3.7299999999999984e-145 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g27116 | i0 | 98.98 | 3.76949152542373 | 294 | 3 | 99 | 0 | 1 | 294 | 1191654 | 1191361 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 1112 | 527 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 9738156 | 9738156 | PRJNA811725_P_NODE_39688_length_245_cov_0.895349_g39442_i0 | PRJNA811725 | 39688 | 245 | 0.895349 | 2.19360505 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 442 | 1.1199999999999994e-119 | NTclustered | gi|1276705688|gb|CP024698.1| | 2663009 | g39442 | i0 | 99.184 | 100.134693877551 | 245 | 2 | 100 | 0 | 1 | 245 | 144927 | 145171 | Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome | blastn | 24533 | 442 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 13563576 | 13563576 | PRJNA811725_P_NODE_26151_length_299_cov_5.473451_g25905_i0 | PRJNA811725 | 26151 | 299 | 5.473451 | 16.36561849 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 446 | 1.09e-120 | NTclustered | gi|1708575239|dbj|AP019834.1| | 157687 | g25905 | i0 | 92.857 | 8.52842809364548 | 322 | 0 | 100 | 1 | 1 | 299 | 1893825 | 1893504 | Leptotrichia wadei JMUB3933 DNA, complete genome | blastn | 2550 | 446 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 13563669 | 13563669 | PRJNA811725_P_NODE_36711_length_250_cov_0.870056_g36465_i0 | PRJNA811725 | 36711 | 250 | 0.870056 | 2.17514 | Fusobacterium animalis | 76859 | Bacteria | Bacteria | 462 | 8.83e-126 | NTclustered | gi|2078825571|gb|CP071099.1| | 76859 | g36465 | i0 | 100 | 99.552 | 250 | 0 | 100 | 0 | 1 | 250 | 2047473 | 2047722 | Fusobacterium animalis strain THCT5A4 chromosome, complete genome | blastn | 24888 | 462 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium animalis | ||
| 18661448 | 18661448 | PRJNA811725_P_NODE_32375_length_273_cov_1.805000_g32129_i0 | PRJNA811725 | 32375 | 273 | 1.805 | 4.92765 | Fusobacterium vincentii | 155615 | Bacteria | Bacteria | 505 | 1.6e-138 | NTclustered | gi|2593368740|dbj|AP028933.1| | 155615 | g32129 | i0 | 100 | 89.8534798534799 | 273 | 0 | 100 | 0 | 1 | 273 | 67395 | 67667 | Fusobacterium vincentii TDC100 DNA, complete genome | blastn | 24530 | 505 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium vincentii | ||
| 24175625 | 24175625 | PRJNA811725_P_NODE_28959_length_288_cov_2.265116_g28713_i0 | PRJNA811725 | 28959 | 288 | 2.265116 | 6.52353408 | Fusobacterium | 848 | Bacteria | Bacteria | 532 | 7.8e-147 | NTclustered | gi|1208657894|gb|CP021934.1| | 76857 | g28713 | i0 | 100 | 119.552083333333 | 288 | 0 | 100 | 0 | 1 | 288 | 1749183 | 1749470 | Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome | blastn | 34431 | 532 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 25036351 | 25036351 | PRJNA811725_P_NODE_23820_length_310_cov_4.949367_g23574_i0 | PRJNA811725 | 23820 | 310 | 4.949367 | 15.3430377 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 527 | 3.9499999999999986e-145 | NTclustered | gi|2706407748|gb|CP077116.1| | 76857 | g23574 | i0 | 96.774 | 97.5387096774193 | 310 | 7 | 100 | 1 | 1 | 310 | 2414070 | 2414376 | Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome | blastn | 30237 | 527 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum |
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);;