contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA782551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22890131 | 22890131 | PRJNA782551_P_NODE_17558_length_249_cov_0.875000_g17436_i0 | PRJNA782551 | 17558 | 249 | 0.875 | 2.17875 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 99 | 3.799999999999999e-24 | NR | WP_047394524.1 | 1339239 | g17436 | i0 | 96.1 | 0.614457831325301 | 51 | 2 | 61.4 | 0 | 96 | 248 | 1 | 51 | WP_047394524.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex ATPase subunit type 1 TsaE [Cetobacterium sp. ZOR0034] | diamond | 153 | 99 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 26990105 | 26990105 | PRJNA782551_P_NODE_25042_length_241_cov_0.916667_g24920_i0 | PRJNA782551 | 25042 | 241 | 0.916667 | 2.20916747 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 160 | 7.41e-45 | NR | WP_047384462.1 | 2630983 | g24920 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 1 | 240 | 255 | 334 | WP_047384462.1 MULTISPECIES: Ppx/GppA family phosphatase [unclassified Cetobacterium] | diamond | 240 | 160 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 27085274 | 27085274 | PRJNA782551_P_NODE_2262_length_647_cov_2.714286_g2144_i0 | PRJNA782551 | 2262 | 647 | 2.714286 | 17.56143042 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 422 | 2.2899999999999998e-148 | NR | WP_047384900.1 | 1340502 | g2144 | i0 | 100 | 0.996908809891808 | 215 | 0 | 99.7 | 0 | 3 | 647 | 31 | 245 | WP_047384900.1 hypothetical protein [Cetobacterium sp. ZWU0022] | diamond | 645 | 422 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 27401380 | 27401380 | PRJNA782551_P_NODE_6723_length_359_cov_9.713287_g6601_i0 | PRJNA782551 | 6723 | 359 | 9.713287 | 34.87070033 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 109 | 3.55e-28 | NR | WP_047381601.1 | 2630983 | g6601 | i0 | 89.1 | 0.768802228412256 | 92 | 10 | 76.9 | 0 | 10 | 285 | 1 | 92 | WP_047381601.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] | diamond | 276 | 109 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 28316983 | 28316983 | PRJNA782551_P_NODE_23886_length_242_cov_0.911243_g23764_i0 | PRJNA782551 | 23886 | 242 | 0.911243 | 2.20520806 | Leptotrichia sp. oral taxon 215 | 712359 | Bacteria | Bacteria | 155 | 4.84e-44 | NR | WP_021766977.1 | 712359 | g23764 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 3 | 242 | 161 | 240 | WP_021766977.1 FAD:protein FMN transferase [Leptotrichia sp. oral taxon 215] | diamond | 240 | 155 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 215 | ||
| 28980158 | 28980158 | PRJNA782551_P_NODE_25008_length_241_cov_0.916667_g24886_i0 | PRJNA782551 | 25008 | 241 | 0.916667 | 2.20916747 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 141 | 8.579999999999999e-37 | NR | WP_053393397.1 | 712357 | g24886 | i0 | 90 | 0.995850622406639 | 80 | 8 | 99.6 | 0 | 240 | 1 | 494 | 573 | WP_053393397.1 translocation/assembly module TamB domain-containing protein [Leptotrichia sp. oral taxon 212] | diamond | 240 | 141 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 29327190 | 29327190 | PRJNA782551_P_NODE_16169_length_251_cov_0.865169_g16047_i0 | PRJNA782551 | 16169 | 251 | 0.865169 | 2.17157419 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 148 | 1.0599999999999999e-42 | NR | WP_023049726.1 | 188913 | g16047 | i0 | 94.4 | 0.860557768924303 | 72 | 4 | 86.1 | 0 | 249 | 34 | 138 | 209 | WP_023049726.1 flavin reductase family protein [Cetobacterium somerae] | diamond | 216 | 148 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 29769220 | 29769220 | PRJNA782551_P_NODE_18051_length_249_cov_0.875000_g17929_i0 | PRJNA782551 | 18051 | 249 | 0.875 | 2.17875 | uncultured Leptotrichia sp. | 159271 | Bacteria | Bacteria | 148 | 4.72e-42 | NR | WP_299264898.1 | 159271 | g17929 | i0 | 96.3 | 0.987951807228916 | 82 | 3 | 98.8 | 0 | 247 | 2 | 178 | 259 | WP_299264898.1 hypothetical protein [uncultured Leptotrichia sp.] | diamond | 246 | 148 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | uncultured Leptotrichia sp. | ||
| 32393179 | 32393179 | PRJNA782551_P_NODE_25259_length_232_cov_2.716981_g25137_i0 | PRJNA782551 | 25259 | 232 | 2.716981 | 6.30339592 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 147 | 7.88e-44 | NR | WP_047383851.1 | 2630983 | g25137 | i0 | 96.1 | 0.982758620689655 | 76 | 3 | 98.3 | 0 | 230 | 3 | 48 | 123 | WP_047383851.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] | diamond | 228 | 147 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium |
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);;