contig_metadata
4 rows where bioproject = "PRJNA924320", tax_kingdom = "Fusobacteriati" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6356285 | 6356285 | PRJNA924320_S_NODE_8845_length_327_cov_3.428058_g8703_i0 | PRJNA924320 | 8845 | 327 | 3.428058 | 11.20974966 | Cetobacterium | 180162 | Bacteria | Bacteria | 603 | 6.769999999999999e-168 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g8703 | i0 | 100 | 409.296636085627 | 326 | 0 | 99 | 0 | 2 | 327 | 278210 | 277885 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 133840 | 603 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 30411434 | 30411434 | PRJNA924320_S_NODE_24493_length_215_cov_0.921687_g24351_i0 | PRJNA924320 | 24493 | 215 | 0.921687 | 1.98162705 | Fusobacterium | 848 | Bacteria | Bacteria | 58.2 | 9.38e-8 | NR | WP_005958302.1 | 859 | g24351 | i0 | 40.6 | 2.88837209302326 | 69 | 40 | 96.3 | 1 | 215 | 9 | 100 | 167 | WP_005958302.1 DNA helicase RecQ [Fusobacterium necrophorum] | diamond | 621 | 58.2 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium necrophorum | ||
| 32174569 | 32174569 | PRJNA924320_S_NODE_3138_length_525_cov_1.714286_g2998_i0 | PRJNA924320 | 3138 | 525 | 1.714286 | 9.0000015 | Streptobacillus canis | 2678686 | Bacteria | Bacteria | 47.8 | 0.0102 | NR | WP_156299150.1 | 2678686 | g2998 | i0 | 31.7 | 0.594285714285714 | 104 | 65 | 58.9 | 3 | 508 | 200 | 862 | 960 | WP_156299150.1 autotransporter domain-containing protein [Streptobacillus canis] | diamond | 312 | 47.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Streptobacillus | Streptobacillus canis | ||
| 32900338 | 32900338 | PRJNA924320_S_NODE_44440_length_169_cov_1.700000_g44298_i0 | PRJNA924320 | 44440 | 169 | 1.7 | 2.873 | Ilyobacter sp. | 3100343 | Bacteria | Bacteria | 44.3 | 0.00232 | NR | WP_372712900.1 | 3100343 | g44298 | i0 | 39.6 | 0.85207100591716 | 48 | 29 | 85.2 | 0 | 24 | 167 | 32 | 79 | WP_372712900.1 Crp/Fnr family transcriptional regulator [Ilyobacter sp.] | diamond | 144 | 44.3 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Ilyobacter | Ilyobacter sp. |
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);;