contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1164198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2862800 | 2862800 | PRJNA1164198_P_NODE_20763_length_272_cov_1.959799_g20494_i0 | PRJNA1164198 | 20763 | 272 | 1.959799 | 5.33065328 | Cetobacterium | 180162 | Bacteria | Bacteria | 144 | 4.8899999999999997e-39 | NR | WP_266187309.1 | 188913 | g20494 | i0 | 96.2 | 2.61397058823529 | 78 | 3 | 86 | 0 | 234 | 1 | 106 | 183 | WP_266187309.1 RNA polymerase sigma factor RpoD [Cetobacterium somerae] | diamond | 711 | 145 | 0.993103448275862 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 15614839 | 15614839 | PRJNA1164198_P_NODE_8213_length_435_cov_7.104972_g7951_i0 | PRJNA1164198 | 8213 | 435 | 7.104972 | 30.9066282 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 208 | 8.89e-67 | NR | WP_047395296.1 | 1339239 | g7951 | i0 | 100 | 0.820689655172414 | 119 | 0 | 82.1 | 0 | 407 | 51 | 1 | 119 | WP_047395296.1 hypothetical protein [Cetobacterium sp. ZOR0034] | diamond | 357 | 208 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 27324974 | 27324974 | PRJNA1164198_P_NODE_16543_length_304_cov_1.350649_g16274_i0 | PRJNA1164198 | 16543 | 304 | 1.350649 | 4.10597296 | Cetobacterium sp. | 2071632 | Bacteria | Bacteria | 115 | 2.06e-27 | NR | WP_291941771.1 | 2071632 | g16274 | i0 | 85 | 1.97368421052632 | 100 | 15 | 98.7 | 0 | 302 | 3 | 67 | 166 | WP_291941771.1 translation initiation factor IF-2 [Cetobacterium sp.] | diamond | 600 | 115 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. | ||
| 27451513 | 27451513 | PRJNA1164198_P_NODE_13943_length_331_cov_2.248062_g13674_i0 | PRJNA1164198 | 13943 | 331 | 2.248062 | 7.44108522 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 106 | 3.65e-26 | NR | WP_294093487.1 | 527638 | g13674 | i0 | 98.1 | 0.48036253776435 | 53 | 1 | 48 | 0 | 171 | 329 | 1 | 53 | WP_294093487.1 HD domain-containing protein [uncultured Cetobacterium sp.] | diamond | 159 | 106 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 28840438 | 28840438 | PRJNA1164198_P_NODE_22828_length_260_cov_1.251337_g22559_i0 | PRJNA1164198 | 22828 | 260 | 1.251337 | 3.2534762 | Fusobacterium | 848 | Bacteria | Bacteria | 43.5 | 0.0227 | NR | WP_005884745.1 | 848 | g22559 | i0 | 42.5 | 0.461538461538462 | 40 | 23 | 46.2 | 0 | 113 | 232 | 59 | 98 | WP_005884745.1 MULTISPECIES: DNA-binding protein WhiA [Fusobacterium] | diamond | 120 | 43.5 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | |||
| 29219564 | 29219564 | PRJNA1164198_P_NODE_16069_length_309_cov_1.275424_g15800_i0 | PRJNA1164198 | 16069 | 309 | 1.275424 | 3.94106016 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 189 | 1.1000000000000004e-59 | NR | WP_047383405.1 | 2630983 | g15800 | i0 | 100 | 0.951456310679612 | 98 | 0 | 95.1 | 0 | 14 | 307 | 1 | 98 | WP_047383405.1 MULTISPECIES: nucleoside-diphosphate kinase [unclassified Cetobacterium] | diamond | 294 | 189 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29314151 | 29314151 | PRJNA1164198_P_NODE_15329_length_316_cov_1.283951_g15060_i0 | PRJNA1164198 | 15329 | 316 | 1.283951 | 4.05728516 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 174 | 1.04e-49 | NR | WP_156110627.1 | 1339239 | g15060 | i0 | 98.1 | 0.977848101265823 | 103 | 2 | 97.8 | 0 | 6 | 314 | 1 | 103 | WP_156110627.1 putative glycoside hydrolase [Cetobacterium sp. ZOR0034] | diamond | 309 | 174 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 31019994 | 31019994 | PRJNA1164198_P_NODE_24915_length_252_cov_0.871508_g24646_i0 | PRJNA1164198 | 24915 | 252 | 0.871508 | 2.19620016 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 175 | 3e-50 | NR | WP_047393897.1 | 1339239 | g24646 | i0 | 100 | 0.988095238095238 | 83 | 0 | 98.8 | 0 | 3 | 251 | 380 | 462 | WP_047393897.1 S1 RNA-binding domain-containing protein [Cetobacterium sp. ZOR0034] | diamond | 249 | 175 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 31936862 | 31936862 | PRJNA1164198_P_NODE_24317_length_253_cov_0.866667_g24048_i0 | PRJNA1164198 | 24317 | 253 | 0.866667 | 2.19266751 | Cetobacterium sp. NK | 2071632 | Bacteria | Bacteria | 159 | 2.3599999999999996e-47 | NR | WP_256691072.1 | 2993530 | g24048 | i0 | 95.2 | 0.99604743083004 | 84 | 4 | 99.6 | 0 | 252 | 1 | 67 | 150 | WP_256691072.1 MotA/TolQ/ExbB proton channel family protein [Cetobacterium sp. NK01] | diamond | 252 | 159 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. NK01 |
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);;