contig_metadata
7 rows where bioproject = "PRJNA431371" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2979062 | 2979062 | PRJNA431371_P_NODE_32823_length_244_cov_0.900585_g32750_i0 | PRJNA431371 | 32823 | 244 | 0.900585 | 2.1974274 | Leptotrichia shahii | 157691 | Bacteria | Bacteria | 412 | 8.759999999999998e-111 | NTclustered | gi|1708568515|dbj|AP019827.1| | 157691 | g32750 | i0 | 97.131 | 5.55327868852459 | 244 | 7 | 100 | 0 | 1 | 244 | 1283234 | 1282991 | Leptotrichia shahii JCM16776 DNA, complete genome | blastn | 1355 | 412 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia shahii | ||
| 4254862 | 4254862 | PRJNA431371_P_NODE_11944_length_364_cov_2.109966_g11871_i0 | PRJNA431371 | 11944 | 364 | 2.109966 | 7.68027624 | Haliovirga abyssi | 2996794 | Bacteria | Bacteria | 52.8 | 0.035 | NTclustered | gi|2502752323|dbj|AP027059.1| | 2996794 | g11871 | i0 | 100 | 0.0769230769230769 | 28 | 0 | 8 | 0 | 98 | 125 | 2226661 | 2226634 | Fusobacteria bacterium IC12 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Haliovirgaceae | Haliovirga | Haliovirga abyssi | ||
| 8740811 | 8740811 | PRJNA431371_P_NODE_18387_length_299_cov_1.022124_g18314_i0 | PRJNA431371 | 18387 | 299 | 1.022124 | 3.05615076 | FCB group | 1783270 | Bacteria | Bacteria | 113 | 2.75e-28 | NR | WP_298067053.1 | 527638 | g18314 | i0 | 63.3 | 15.7224080267559 | 90 | 33 | 90.3 | 0 | 272 | 3 | 25 | 114 | WP_298067053.1 arsenic resistance protein, partial [uncultured Cetobacterium sp.] | diamond | 4701 | 114 | 0.991228070175439 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 11907282 | 11907282 | PRJNA431371_P_NODE_6230_length_486_cov_2.288136_g6157_i0 | PRJNA431371 | 6230 | 486 | 2.288136 | 11.12034096 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 56.5 | 0.004 | NTclustered | gi|2706067283|gb|CP077110.1| | 76857 | g6157 | i0 | 100 | 0.0617283950617284 | 30 | 0 | 6 | 0 | 335 | 364 | 2236498 | 2236527 | Fusobacterium polymorphum strain KCOM1278 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 17665650 | 17665650 | PRJNA431371_P_NODE_34414_length_243_cov_0.905882_g34341_i0 | PRJNA431371 | 34414 | 243 | 0.905882 | 2.20129326 | Leptotrichia | 32067 | Bacteria | Bacteria | 372 | 1.48e-98 | NTclustered | gi|2557559843|gb|CP130323.1| | 3058373 | g34341 | i0 | 94.286 | 5.02880658436214 | 245 | 11 | 100 | 3 | 1 | 243 | 543906 | 544149 | Leptotrichia sp. HMT-225 chromosome, complete genome | blastn | 1222 | 372 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. HMT-225 | ||
| 28528696 | 28528696 | PRJNA431371_P_NODE_27747_length_249_cov_0.875000_g27674_i0 | PRJNA431371 | 27747 | 249 | 0.875 | 2.17875 | Caviibacter abscessus | 1766719 | Bacteria | Bacteria | 134 | 1.92e-35 | NR | WP_068268604.1 | 1766719 | g27674 | i0 | 84.1 | 0.987951807228916 | 82 | 13 | 98.8 | 0 | 2 | 247 | 297 | 378 | WP_068268604.1 TrkH family potassium uptake protein [Caviibacter abscessus] | diamond | 246 | 134 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Caviibacter | Caviibacter abscessus | ||
| 32257494 | 32257494 | PRJNA431371_P_NODE_4798_length_541_cov_1.946581_g4725_i0 | PRJNA431371 | 4798 | 541 | 1.946581 | 10.53100321 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 57.8 | 3.91e-6 | NR | WP_021746721.1 | 157687 | g4725 | i0 | 31.2 | 1.48059149722736 | 138 | 87 | 73.8 | 4 | 462 | 64 | 70 | 204 | WP_021746721.1 tetratricopeptide repeat protein [Leptotrichia wadei] | diamond | 801 | 57.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei |
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);;