contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1180292" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4144800 | 4144800 | PRJNA1180292_P_NODE_5184_length_306_cov_1.339056_g5052_i0 | PRJNA1180292 | 5184 | 306 | 1.339056 | 4.09751136 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 88.2 | 8.95e-18 | NR | WP_047380897.1 | 1340502 | g5052 | i0 | 91.5 | 0.901960784313726 | 47 | 4 | 46.1 | 0 | 1 | 141 | 978 | 1024 | WP_047380897.1 UvrD-helicase domain-containing protein [Cetobacterium sp. ZWU0022] | diamond | 276 | 88.2 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 5421016 | 5421016 | PRJNA1180292_P_NODE_8385_length_252_cov_0.871508_g8253_i0 | PRJNA1180292 | 8385 | 252 | 0.871508 | 2.19620016 | Cetobacterium | 180162 | Bacteria | Bacteria | 160 | 8.96e-47 | NR | MEG0424636.1 | 2071632 | g8253 | i0 | 90.4 | 1.97619047619048 | 83 | 8 | 98.8 | 0 | 250 | 2 | 188 | 270 | MEG0424636.1 glycosyltransferase [Cetobacterium sp.] | diamond | 498 | 160 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. | ||
| 9245746 | 9245746 | PRJNA1180292_P_NODE_3428_length_370_cov_1.575758_g3296_i0 | PRJNA1180292 | 3428 | 370 | 1.575758 | 5.8303046 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 109 | 3.97e-28 | NR | WP_047381601.1 | 2630983 | g3296 | i0 | 88 | 0.745945945945946 | 92 | 11 | 74.6 | 0 | 15 | 290 | 1 | 92 | WP_047381601.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] | diamond | 276 | 109 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 10521445 | 10521445 | PRJNA1180292_P_NODE_10729_length_247_cov_0.896552_g10597_i0 | PRJNA1180292 | 10729 | 247 | 0.896552 | 2.21448344 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 164 | 4.2099999999999996e-47 | NR | WP_052191619.1 | 1340502 | g10597 | i0 | 95.1 | 2.98785425101215 | 82 | 4 | 99.6 | 0 | 247 | 2 | 181 | 262 | WP_052191619.1 tRNA guanosine(34) transglycosylase Tgt [Cetobacterium sp. ZWU0022] | diamond | 738 | 164 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 27040627 | 27040627 | PRJNA1180292_P_NODE_12602_length_243_cov_0.917647_g12470_i0 | PRJNA1180292 | 12602 | 243 | 0.917647 | 2.22988221 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 115 | 2.13e-31 | NR | WP_047383547.1 | 2630983 | g12470 | i0 | 93.8 | 0.790123456790123 | 64 | 4 | 79 | 0 | 51 | 242 | 1 | 64 | WP_047383547.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] | diamond | 192 | 115 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 27230205 | 27230205 | PRJNA1180292_P_NODE_9063_length_251_cov_0.876404_g8931_i0 | PRJNA1180292 | 9063 | 251 | 0.876404 | 2.19977404 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 158 | 2.82e-47 | NR | WP_294094651.1 | 527638 | g8931 | i0 | 100 | 0.9800796812749 | 82 | 0 | 98 | 0 | 248 | 3 | 1 | 82 | WP_294094651.1 tetratricopeptide repeat protein [uncultured Cetobacterium sp.] | diamond | 246 | 158 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 27376132 | 27376132 | PRJNA1180292_P_NODE_10243_length_248_cov_0.891429_g10111_i0 | PRJNA1180292 | 10243 | 248 | 0.891429 | 2.21074392 | Cetobacterium | 180162 | Bacteria | Bacteria | 124 | 5.179999999999999e-31 | NR | WP_023051666.1 | 188913 | g10111 | i0 | 82.9 | 1.98387096774194 | 82 | 14 | 99.2 | 0 | 1 | 246 | 254 | 335 | WP_023051666.1 ABC-F family ATP-binding cassette domain-containing protein [Cetobacterium somerae] | diamond | 492 | 124 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 27577732 | 27577732 | PRJNA1180292_P_NODE_3704_length_356_cov_1.102473_g3572_i0 | PRJNA1180292 | 3704 | 356 | 1.102473 | 3.92480388 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 165 | 1.41e-50 | NR | WP_294094250.1 | 527638 | g3572 | i0 | 97.6 | 0.716292134831461 | 85 | 2 | 71.6 | 0 | 255 | 1 | 1 | 85 | WP_294094250.1 hypothetical protein [uncultured Cetobacterium sp.] | diamond | 255 | 165 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 28051320 | 28051320 | PRJNA1180292_P_NODE_4345_length_332_cov_1.204633_g4213_i0 | PRJNA1180292 | 4345 | 332 | 1.204633 | 3.99938156 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 198 | 1.34e-56 | NR | WP_294094044.1 | 527638 | g4213 | i0 | 88.1 | 0.984939759036145 | 109 | 13 | 98.5 | 0 | 329 | 3 | 38 | 146 | WP_294094044.1 EAL domain-containing protein [uncultured Cetobacterium sp.] | diamond | 327 | 198 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 28335484 | 28335484 | PRJNA1180292_P_NODE_3246_length_380_cov_3.006515_g3114_i0 | PRJNA1180292 | 3246 | 380 | 3.006515 | 11.424757 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 244 | 4.59e-78 | NR | WP_047393843.1 | 1339239 | g3114 | i0 | 96 | 0.994736842105263 | 126 | 5 | 99.5 | 0 | 1 | 378 | 156 | 281 | WP_047393843.1 SEC-C metal-binding domain-containing protein [Cetobacterium sp. ZOR0034] | diamond | 378 | 244 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 28588298 | 28588298 | PRJNA1180292_P_NODE_5727_length_291_cov_1.642202_g5595_i0 | PRJNA1180292 | 5727 | 291 | 1.642202 | 4.77880782 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 163 | 4.22e-49 | NR | WP_047384111.1 | 2630983 | g5595 | i0 | 94.8 | 1 | 97 | 5 | 100 | 0 | 291 | 1 | 38 | 134 | WP_047384111.1 MULTISPECIES: OmpH family outer membrane protein [unclassified Cetobacterium] | diamond | 291 | 163 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29598146 | 29598146 | PRJNA1180292_P_NODE_5590_length_295_cov_1.306306_g5458_i0 | PRJNA1180292 | 5590 | 295 | 1.306306 | 3.8536027 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 155 | 1.1e-44 | NR | WP_294095125.1 | 527638 | g5458 | i0 | 98.9 | 0.894915254237288 | 88 | 1 | 89.5 | 0 | 1 | 264 | 190 | 277 | WP_294095125.1 Rpn family recombination-promoting nuclease/putative transposase [uncultured Cetobacterium sp.] | diamond | 264 | 155 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 29945933 | 29945933 | PRJNA1180292_P_NODE_1451_length_571_cov_2.020080_g1319_i0 | PRJNA1180292 | 1451 | 571 | 2.02008 | 11.5346568 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 373 | 7.55e-129 | NR | WP_294095125.1 | 527638 | g1319 | i0 | 100 | 0.992994746059545 | 189 | 0 | 99.3 | 0 | 569 | 3 | 2 | 190 | WP_294095125.1 Rpn family recombination-promoting nuclease/putative transposase [uncultured Cetobacterium sp.] | diamond | 567 | 373 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 30009206 | 30009206 | PRJNA1180292_P_NODE_12791_length_242_cov_1.254438_g12659_i0 | PRJNA1180292 | 12791 | 242 | 1.254438 | 3.03573996 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 152 | 2.16e-41 | NR | WP_294095131.1 | 527638 | g12659 | i0 | 98.7 | 0.942148760330578 | 76 | 1 | 94.2 | 0 | 228 | 1 | 1 | 76 | WP_294095131.1 AAA family ATPase [uncultured Cetobacterium sp.] | diamond | 228 | 152 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 30546148 | 30546148 | PRJNA1180292_P_NODE_6613_length_274_cov_1.039801_g6481_i0 | PRJNA1180292 | 6613 | 274 | 1.039801 | 2.84905474 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 174 | 2.69e-54 | NR | WP_047384607.1 | 2630983 | g6481 | i0 | 95.6 | 0.996350364963504 | 91 | 4 | 99.6 | 0 | 273 | 1 | 9 | 99 | WP_047384607.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] | diamond | 273 | 174 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 32221950 | 32221950 | PRJNA1180292_P_NODE_1538_length_555_cov_3.230290_g1406_i0 | PRJNA1180292 | 1538 | 555 | 3.23029 | 17.9281095 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 298 | 7.309999999999999e-101 | NR | WP_294095876.1 | 527638 | g1406 | i0 | 90.5 | 0.913513513513514 | 169 | 15 | 91.4 | 1 | 31 | 537 | 1 | 168 | WP_294095876.1 hypothetical protein [uncultured Cetobacterium sp.] | diamond | 507 | 298 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 32285557 | 32285557 | PRJNA1180292_P_NODE_3419_length_371_cov_0.932886_g3287_i0 | PRJNA1180292 | 3419 | 371 | 0.932886 | 3.46100706 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 185 | 1.2e-57 | NR | WP_047380532.1 | 1340502 | g3287 | i0 | 93.1 | 0.824797843665768 | 102 | 7 | 82.5 | 0 | 61 | 366 | 1 | 102 | WP_047380532.1 23S rRNA (pseudouridine(1915)-N(3))-methyltransferase RlmH [Cetobacterium sp. ZWU0022] | diamond | 306 | 185 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 32506938 | 32506938 | PRJNA1180292_P_NODE_5419_length_300_cov_1.030837_g5287_i0 | PRJNA1180292 | 5419 | 300 | 1.030837 | 3.092511 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 196 | 1.71e-60 | NR | WP_294095638.1 | 527638 | g5287 | i0 | 100 | 0.99 | 99 | 0 | 99 | 0 | 298 | 2 | 114 | 212 | WP_294095638.1 PHP domain-containing protein [uncultured Cetobacterium sp.] | diamond | 297 | 196 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 32695817 | 32695817 | PRJNA1180292_P_NODE_4960_length_312_cov_1.305439_g4828_i0 | PRJNA1180292 | 4960 | 312 | 1.305439 | 4.07296968 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 206 | 7.31e-66 | NR | WP_294095935.1 | 527638 | g4828 | i0 | 100 | 0.961538461538462 | 100 | 0 | 96.2 | 0 | 301 | 2 | 1 | 100 | WP_294095935.1 TlpA family protein disulfide reductase [uncultured Cetobacterium sp.] | diamond | 300 | 206 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium 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);;