contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax_phylum = "Fusobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27656239 | 27656239 | PRJNA900999_S_NODE_4624_length_202_cov_1.965318_g4568_i0 | PRJNA900999 | 4624 | 202 | 1.965318 | 3.96994236 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 135 | 2.62e-38 | NR | WP_294094651.1 | 527638 | g4568 | i0 | 92.5 | 1.99009900990099 | 67 | 5 | 99.5 | 0 | 2 | 202 | 47 | 113 | WP_294094651.1 tetratricopeptide repeat protein [uncultured Cetobacterium sp.] | diamond | 402 | 135 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 28350655 | 28350655 | PRJNA900999_S_NODE_9526_length_152_cov_2.382114_g9470_i0 | PRJNA900999 | 9526 | 152 | 2.382114 | 3.62081328 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 103 | 1.6500000000000002e-26 | NR | WP_047382507.1 | 1340502 | g9470 | i0 | 100 | 0.986842105263158 | 50 | 0 | 98.7 | 0 | 1 | 150 | 52 | 101 | WP_047382507.1 DUF134 domain-containing protein [Cetobacterium sp. ZWU0022] | diamond | 150 | 103 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 28982395 | 28982395 | PRJNA900999_S_NODE_9548_length_152_cov_1.626016_g9492_i0 | PRJNA900999 | 9548 | 152 | 1.626016 | 2.47154432 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 103 | 1.95e-24 | NR | WP_047384167.1 | 2630983 | g9492 | i0 | 100 | 0.967105263157895 | 49 | 0 | 96.7 | 0 | 151 | 5 | 349 | 397 | WP_047384167.1 MULTISPECIES: bifunctional 3,4-dihydroxy-2-butanone-4-phosphate synthase/GTP cyclohydrolase II [unclassified Cetobacterium] | diamond | 147 | 103 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29297958 | 29297958 | PRJNA900999_S_NODE_3629_length_222_cov_2.492228_g3573_i0 | PRJNA900999 | 3629 | 222 | 2.492228 | 5.53274616 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 132 | 1.93e-36 | NR | WP_047382483.1 | 2630983 | g3573 | i0 | 100 | 0.905405405405405 | 67 | 0 | 90.5 | 0 | 21 | 221 | 1 | 67 | WP_047382483.1 MULTISPECIES: 2,3,4,5-tetrahydropyridine-2,6-dicarboxylate N-acetyltransferase [unclassified Cetobacterium] | diamond | 201 | 132 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29739692 | 29739692 | PRJNA900999_S_NODE_3370_length_228_cov_2.336683_g3314_i0 | PRJNA900999 | 3370 | 228 | 2.336683 | 5.32763724 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 148 | 1.17e-41 | NR | WP_047380601.1 | 2630983 | g3314 | i0 | 100 | 0.986842105263158 | 75 | 0 | 98.7 | 0 | 3 | 227 | 50 | 124 | WP_047380601.1 MULTISPECIES: UDP-3-O-(3-hydroxymyristoyl)glucosamine N-acyltransferase [unclassified Cetobacterium] | diamond | 225 | 148 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29803035 | 29803035 | PRJNA900999_S_NODE_8851_length_156_cov_3.370079_g8795_i0 | PRJNA900999 | 8851 | 156 | 3.370079 | 5.25732324 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 68.2 | 1.01e-12 | NR | WP_047382507.1 | 1340502 | g8795 | i0 | 100 | 0.596153846153846 | 31 | 0 | 59.6 | 0 | 64 | 156 | 115 | 145 | WP_047382507.1 DUF134 domain-containing protein [Cetobacterium sp. ZWU0022] | diamond | 93 | 68.2 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 30087340 | 30087340 | PRJNA900999_S_NODE_7612_length_166_cov_2.802920_g7556_i0 | PRJNA900999 | 7612 | 166 | 2.80292 | 4.6528472 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 107 | 5.05e-26 | NR | WP_047383992.1 | 2630983 | g7556 | i0 | 100 | 0.975903614457831 | 54 | 0 | 97.6 | 0 | 3 | 164 | 329 | 382 | WP_047383992.1 MULTISPECIES: beta-ketoacyl-ACP synthase II [unclassified Cetobacterium] | diamond | 162 | 107 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 30814078 | 30814078 | PRJNA900999_S_NODE_7074_length_171_cov_2.676056_g7018_i0 | PRJNA900999 | 7074 | 171 | 2.676056 | 4.57605576 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 80.5 | 3.86e-18 | NR | WP_047395676.1 | 1339239 | g7018 | i0 | 97.7 | 0.771929824561403 | 44 | 1 | 77.2 | 0 | 170 | 39 | 45 | 88 | WP_047395676.1 hypothetical protein [Cetobacterium sp. ZOR0034] | diamond | 132 | 80.5 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 30845755 | 30845755 | PRJNA900999_S_NODE_3174_length_233_cov_2.843137_g3118_i0 | PRJNA900999 | 3174 | 233 | 2.843137 | 6.62450921 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 132 | 7.729999999999998e-35 | NR | WP_053391838.1 | 712357 | g3118 | i0 | 92.2 | 0.991416309012876 | 77 | 6 | 99.1 | 0 | 2 | 232 | 333 | 409 | WP_053391838.1 branched-chain amino acid transport system II carrier protein [Leptotrichia sp. oral taxon 212] | diamond | 231 | 132 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 31383149 | 31383149 | PRJNA900999_S_NODE_3176_length_232_cov_419.551724_g3120_i0 | PRJNA900999 | 3176 | 232 | 419.551724 | 973.35999968 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 105 | 3.3e-25 | NR | WP_047381403.1 | 2630983 | g3120 | i0 | 91.8 | 0.788793103448276 | 61 | 5 | 78.9 | 0 | 191 | 9 | 192 | 252 | WP_047381403.1 MULTISPECIES: heat-inducible transcriptional repressor HrcA [unclassified Cetobacterium] | diamond | 183 | 105 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 32490495 | 32490495 | PRJNA900999_S_NODE_9739_length_151_cov_1.639344_g9683_i0 | PRJNA900999 | 9739 | 151 | 1.639344 | 2.47540944 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 93.2 | 1.08e-20 | NR | WP_047383992.1 | 2630983 | g9683 | i0 | 91.7 | 0.95364238410596 | 48 | 4 | 95.4 | 0 | 8 | 151 | 279 | 326 | WP_047383992.1 MULTISPECIES: beta-ketoacyl-ACP synthase II [unclassified Cetobacterium] | diamond | 144 | 93.2 | 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);;