contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6387181 | 6387181 | PRJDB3785_S_NODE_506_length_1103_cov_3.298861_g457_i0 | PRJDB3785 | 506 | 1103 | 3.298861 | 36.38643683 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 665 | 1.5199999999999997e-240 | NR | WP_047382551.1 | 2630983 | g457 | i0 | 99.7 | 0.922030825022665 | 339 | 1 | 92.2 | 0 | 1094 | 78 | 1 | 339 | WP_047382551.1 MULTISPECIES: 3-deoxy-7-phosphoheptulonate synthase [unclassified Cetobacterium] | diamond | 1017 | 665 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 20409545 | 20409545 | PRJDB3785_S_NODE_4797_length_346_cov_2.296296_g4644_i0 | PRJDB3785 | 4797 | 346 | 2.296296 | 7.94518416 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 232 | 3.93e-75 | NR | WP_047382549.1 | 2630983 | g4644 | i0 | 100 | 0.997109826589595 | 115 | 0 | 99.7 | 0 | 346 | 2 | 34 | 148 | WP_047382549.1 MULTISPECIES: peptidoglycan editing factor PgeF [unclassified Cetobacterium] | diamond | 345 | 232 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 27348709 | 27348709 | PRJDB3785_S_NODE_11903_length_221_cov_2.366279_g11750_i0 | PRJDB3785 | 11903 | 221 | 2.366279 | 5.22947659 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 139 | 1.2e-36 | NR | WP_294095131.1 | 527638 | g11750 | i0 | 97.3 | 0.990950226244344 | 73 | 2 | 99.1 | 0 | 220 | 2 | 383 | 455 | WP_294095131.1 AAA family ATPase [uncultured Cetobacterium sp.] | diamond | 219 | 139 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 27538083 | 27538083 | PRJDB3785_S_NODE_19644_length_179_cov_1.176923_g19491_i0 | PRJDB3785 | 19644 | 179 | 1.176923 | 2.10669217 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 67.4 | 3.14e-11 | NR | WP_294095131.1 | 527638 | g19491 | i0 | 100 | 0.553072625698324 | 33 | 0 | 55.3 | 0 | 13 | 111 | 517 | 549 | WP_294095131.1 AAA family ATPase [uncultured Cetobacterium sp.] | diamond | 99 | 67.4 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 27601382 | 27601382 | PRJDB3785_S_NODE_22624_length_168_cov_1.714286_g22471_i0 | PRJDB3785 | 22624 | 168 | 1.714286 | 2.88000048 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 114 | 6e-28 | NR | WP_294095131.1 | 527638 | g22471 | i0 | 100 | 1 | 56 | 0 | 100 | 0 | 168 | 1 | 316 | 371 | WP_294095131.1 AAA family ATPase [uncultured Cetobacterium sp.] | diamond | 168 | 114 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 27759364 | 27759364 | PRJDB3785_S_NODE_9724_length_243_cov_1.036082_g9571_i0 | PRJDB3785 | 9724 | 243 | 1.036082 | 2.51767926 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 160 | 4.44e-46 | NR | WP_047393843.1 | 1339239 | g9571 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 3 | 242 | 48 | 127 | WP_047393843.1 SEC-C metal-binding domain-containing protein [Cetobacterium sp. ZOR0034] | diamond | 240 | 160 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 28043218 | 28043218 | PRJDB3785_S_NODE_9165_length_249_cov_2.035000_g9012_i0 | PRJDB3785 | 9165 | 249 | 2.035 | 5.06715 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 162 | 6.89e-49 | NR | WP_047380386.1 | 2630983 | g9012 | i0 | 100 | 0.963855421686747 | 80 | 0 | 96.4 | 0 | 247 | 8 | 65 | 144 | WP_047380386.1 MULTISPECIES: NUDIX hydrolase [unclassified Cetobacterium] | diamond | 240 | 162 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 28106204 | 28106204 | PRJDB3785_S_NODE_14545_length_203_cov_1.636364_g14392_i0 | PRJDB3785 | 14545 | 203 | 1.636364 | 3.32181892 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 133 | 6.35e-37 | NR | WP_081982706.1 | 2630983 | g14392 | i0 | 100 | 0.990147783251232 | 67 | 0 | 99 | 0 | 1 | 201 | 99 | 165 | WP_081982706.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] | diamond | 201 | 133 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 28138129 | 28138129 | PRJDB3785_S_NODE_14325_length_204_cov_3.174194_g14172_i0 | PRJDB3785 | 14325 | 204 | 3.174194 | 6.47535576 | Cetobacterium | 180162 | Bacteria | Bacteria | 96.7 | 9.62e-25 | NR | WP_023049725.1 | 180162 | g14172 | i0 | 92.2 | 0.75 | 51 | 4 | 75 | 0 | 188 | 36 | 3 | 53 | WP_023049725.1 MULTISPECIES: DUF6693 family protein [Cetobacterium] | diamond | 153 | 96.7 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 28200816 | 28200816 | PRJDB3785_S_NODE_10666_length_232_cov_1.114754_g10513_i0 | PRJDB3785 | 10666 | 232 | 1.114754 | 2.58622928 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 148 | 3.2599999999999993e-43 | NR | WP_047380307.1 | 2630983 | g10513 | i0 | 100 | 0.982758620689655 | 76 | 0 | 98.3 | 0 | 230 | 3 | 24 | 99 | WP_047380307.1 MULTISPECIES: ribonuclease H family protein [unclassified Cetobacterium] | diamond | 228 | 148 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 28232377 | 28232377 | PRJDB3785_S_NODE_4366_length_365_cov_1.436709_g4213_i0 | PRJDB3785 | 4366 | 365 | 1.436709 | 5.24398785 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 218 | 2.35e-71 | NR | WP_047382085.1 | 2630983 | g4213 | i0 | 99 | 0.854794520547945 | 104 | 1 | 85.5 | 0 | 322 | 11 | 1 | 104 | WP_047382085.1 MULTISPECIES: winged helix-turn-helix transcriptional regulator [unclassified Cetobacterium] | diamond | 312 | 218 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29747910 | 29747910 | PRJDB3785_S_NODE_891_length_856_cov_8.845105_g800_i0 | PRJDB3785 | 891 | 856 | 8.845105 | 75.7140988 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 539 | 8.739999999999998e-193 | NR | WP_047384851.1 | 1340502 | g800 | i0 | 99.6 | 0.981308411214953 | 280 | 1 | 98.1 | 0 | 855 | 16 | 1 | 280 | WP_047384851.1 Rpn family recombination-promoting nuclease/putative transposase [Cetobacterium sp. ZWU0022] | diamond | 840 | 539 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 29779740 | 29779740 | PRJDB3785_S_NODE_21531_length_172_cov_1.243902_g21378_i0 | PRJDB3785 | 21531 | 172 | 1.243902 | 2.13951144 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 74.3 | 1.01e-13 | NR | WP_047382221.1 | 2630983 | g21378 | i0 | 67.9 | 0.976744186046512 | 56 | 18 | 97.7 | 0 | 170 | 3 | 448 | 503 | WP_047382221.1 MULTISPECIES: EAL domain-containing protein [unclassified Cetobacterium] | diamond | 168 | 74.3 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29874586 | 29874586 | PRJDB3785_S_NODE_9851_length_241_cov_1.822917_g9698_i0 | PRJDB3785 | 9851 | 241 | 1.822917 | 4.39322997 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 94.4 | 2.44e-20 | NR | WP_294094044.1 | 527638 | g9698 | i0 | 63.3 | 0.983402489626556 | 79 | 29 | 98.3 | 0 | 239 | 3 | 191 | 269 | WP_294094044.1 EAL domain-containing protein [uncultured Cetobacterium sp.] | diamond | 237 | 94.4 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 30001013 | 30001013 | PRJDB3785_S_NODE_21151_length_173_cov_3.620968_g20998_i0 | PRJDB3785 | 21151 | 173 | 3.620968 | 6.26427464 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 104 | 4.34e-28 | NR | WP_081982852.1 | 2630983 | g20998 | i0 | 100 | 0.867052023121387 | 50 | 0 | 86.7 | 0 | 23 | 172 | 1 | 50 | WP_081982852.1 MULTISPECIES: (2Fe-2S)-binding protein [unclassified Cetobacterium] | diamond | 150 | 104 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 31454603 | 31454603 | PRJDB3785_S_NODE_6116_length_305_cov_0.992188_g5963_i0 | PRJDB3785 | 6116 | 305 | 0.992188 | 3.0261734 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 104 | 6.91e-25 | NR | WP_294095125.1 | 527638 | g5963 | i0 | 98.3 | 0.580327868852459 | 59 | 1 | 58 | 0 | 304 | 128 | 219 | 277 | WP_294095125.1 Rpn family recombination-promoting nuclease/putative transposase [uncultured Cetobacterium sp.] | diamond | 177 | 104 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 31644113 | 31644113 | PRJDB3785_S_NODE_16037_length_195_cov_1.397260_g15884_i0 | PRJDB3785 | 16037 | 195 | 1.39726 | 2.724657 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 132 | 3.47e-38 | NR | WP_047382390.1 | 2630983 | g15884 | i0 | 100 | 0.923076923076923 | 60 | 0 | 92.3 | 0 | 14 | 193 | 1 | 60 | WP_047382390.1 MULTISPECIES: arsenate reductase family protein [unclassified Cetobacterium] | diamond | 180 | 132 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 31675804 | 31675804 | PRJDB3785_S_NODE_9997_length_239_cov_3.826316_g9844_i0 | PRJDB3785 | 9997 | 239 | 3.826316 | 9.14489524 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 134 | 4.75e-39 | NR | WP_047394936.1 | 1339239 | g9844 | i0 | 98.6 | 0.866108786610879 | 69 | 1 | 86.6 | 0 | 32 | 238 | 1 | 69 | WP_047394936.1 hypothetical protein [Cetobacterium sp. ZOR0034] | diamond | 207 | 134 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 32087222 | 32087222 | PRJDB3785_S_NODE_7598_length_272_cov_2.044843_g7445_i0 | PRJDB3785 | 7598 | 272 | 2.044843 | 5.56197296 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 181 | 3.89e-54 | NR | WP_047393843.1 | 1339239 | g7445 | i0 | 100 | 0.992647058823529 | 90 | 0 | 99.3 | 0 | 1 | 270 | 266 | 355 | WP_047393843.1 SEC-C metal-binding domain-containing protein [Cetobacterium sp. ZOR0034] | diamond | 270 | 181 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 32144596 | 32144596 | PRJDB3785_S_NODE_5718_length_315_cov_2.233083_g5565_i0 | PRJDB3785 | 5718 | 315 | 2.233083 | 7.03421145 | Cetobacterium | 180162 | Bacteria | Bacteria | 210 | 3.43e-63 | NR | WP_294095131.1 | 527638 | g5565 | i0 | 98.1 | 1.98095238095238 | 104 | 2 | 99 | 0 | 3 | 314 | 89 | 192 | WP_294095131.1 AAA family ATPase [uncultured Cetobacterium sp.] | diamond | 624 | 212 | 0.990566037735849 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 32182211 | 32182211 | PRJDB3785_S_NODE_20378_length_176_cov_1.606299_g20225_i0 | PRJDB3785 | 20378 | 176 | 1.606299 | 2.82708624 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 110 | 2.53e-26 | NR | WP_047381739.1 | 1340502 | g20225 | i0 | 100 | 0.988636363636364 | 58 | 0 | 98.9 | 0 | 174 | 1 | 515 | 572 | WP_047381739.1 GTPase HflX [Cetobacterium sp. ZWU0022] | diamond | 174 | 110 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 32467153 | 32467153 | PRJDB3785_S_NODE_28039_length_154_cov_2.590476_g27886_i0 | PRJDB3785 | 28039 | 154 | 2.590476 | 3.98933304 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 101 | 1.2e-25 | NR | WP_047380386.1 | 2630983 | g27886 | i0 | 100 | 0.974025974025974 | 50 | 0 | 97.4 | 0 | 152 | 3 | 14 | 63 | WP_047380386.1 MULTISPECIES: NUDIX hydrolase [unclassified Cetobacterium] | diamond | 150 | 101 | 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);;