contig_metadata
17 rows where bioproject = "PRJNA939415" and tax_phylum = "Candidatus Dormiibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3465763 | 3465763 | PRJNA939415_P_NODE_14043_length_413_cov_3.200000_g13624_i0 | PRJNA939415 | 14043 | 413 | 3.2 | 13.216 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 88.6 | 2.19e-17 | NR | HZU18069.1 | 2052315 | g13624 | i0 | 63.6 | 0.479418886198547 | 66 | 24 | 47.9 | 0 | 3 | 200 | 492 | 557 | HZU18069.1 AMP-binding protein [Candidatus Dormiibacterota bacterium] | diamond | 198 | 88.6 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 4743581 | 4743581 | PRJNA939415_P_NODE_28844_length_310_cov_3.493671_g28422_i0 | PRJNA939415 | 28844 | 310 | 3.493671 | 10.8303801 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|2874253982|emb|OY970307.1| | 2052315 | g28422 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 6 | 33 | 2740110 | 2740137 | MAG: Candidatus Dormibacteraeota bacterium isolate MFD04463.bin.c.11 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 26937004 | 26937004 | PRJNA939415_P_NODE_82242_length_251_cov_6.269663_g81820_i0 | PRJNA939415 | 82242 | 251 | 6.269663 | 15.73685413 | Bacteria | 2 | Bacteria | Bacteria | 114 | 3.96e-28 | NR | HWW14586.1 | 2052315 | g81820 | i0 | 67.5 | 3.9681274900398402 | 83 | 27 | 99.2 | 0 | 250 | 2 | 120 | 202 | HWW14586.1 efflux RND transporter periplasmic adaptor subunit [Candidatus Dormiibacterota bacterium] | diamond | 996 | 114 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 28098879 | 28098879 | PRJNA939415_P_NODE_35845_length_303_cov_1.500000_g35423_i0 | PRJNA939415 | 35845 | 303 | 1.5 | 4.545 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 103 | 4.179999999999999e-23 | NR | MBV8300755.1 | 2052315 | g35423 | i0 | 56 | 0.99009900990099 | 100 | 43 | 99 | 1 | 301 | 2 | 383 | 481 | MBV8300755.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 300 | 103 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 28225109 | 28225109 | PRJNA939415_P_NODE_94146_length_242_cov_1.881657_g93724_i0 | PRJNA939415 | 94146 | 242 | 1.881657 | 4.55360994 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 84.3 | 4.03e-17 | NR | HEV3095847.1 | 2052315 | g93724 | i0 | 46.3 | 0.991735537190083 | 80 | 42 | 99.2 | 1 | 2 | 241 | 237 | 315 | HEV3095847.1 AAA family ATPase [Candidatus Dormiibacterota bacterium] | diamond | 240 | 84.3 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 28699038 | 28699038 | PRJNA939415_P_NODE_22207_length_330_cov_3.112840_g21786_i0 | PRJNA939415 | 22207 | 330 | 3.11284 | 10.272372 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 80.1 | 6.29e-15 | NR | HUY40664.1 | 2052315 | g21786 | i0 | 72 | 0.454545454545455 | 50 | 14 | 45.5 | 0 | 180 | 329 | 309 | 358 | HUY40664.1 glycoside hydrolase family 125 protein [Candidatus Dormiibacterota bacterium] | diamond | 150 | 80.1 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29589579 | 29589579 | PRJNA939415_P_NODE_92870_length_243_cov_2.152941_g92448_i0 | PRJNA939415 | 92870 | 243 | 2.152941 | 5.23164663 | Bacillati | 1783272 | Bacteria | Bacteria | 45.8 | 0.0015 | NR | HEV3124571.1 | 2052315 | g92448 | i0 | 64.5 | 3.01234567901235 | 31 | 11 | 38.3 | 0 | 150 | 242 | 31 | 61 | HEV3124571.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 732 | 45.8 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29645740 | 29645740 | PRJNA939415_P_NODE_87390_length_247_cov_4.689655_g86968_i0 | PRJNA939415 | 87390 | 247 | 4.689655 | 11.58344785 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 97.8 | 1.57e-22 | NR | HWZ99489.1 | 2052315 | g86968 | i0 | 61.4 | 2.95141700404858 | 83 | 29 | 97.2 | 1 | 6 | 245 | 106 | 188 | HWZ99489.1 isocitrate lyase/phosphoenolpyruvate mutase family protein [Candidatus Dormiibacterota bacterium] | diamond | 729 | 97.8 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29835484 | 29835484 | PRJNA939415_P_NODE_41191_length_292_cov_5.853881_g40769_i0 | PRJNA939415 | 41191 | 292 | 5.853881 | 17.09333252 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 107 | 8.84e-25 | NR | MDQ6884231.1 | 2052315 | g40769 | i0 | 55.2 | 0.986301369863014 | 96 | 43 | 98.6 | 0 | 290 | 3 | 327 | 422 | MDQ6884231.1 GMC family oxidoreductase N-terminal domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 288 | 107 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29835531 | 29835531 | PRJNA939415_P_NODE_80111_length_254_cov_1.386740_g79689_i0 | PRJNA939415 | 80111 | 254 | 1.38674 | 3.5223196 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 65.1 | 1.57e-10 | NR | HXM97256.1 | 2052315 | g79689 | i0 | 65.9 | 0.519685039370079 | 44 | 15 | 52 | 0 | 122 | 253 | 36 | 79 | HXM97256.1 cupin domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 132 | 65.1 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30214529 | 30214529 | PRJNA939415_P_NODE_73812_length_260_cov_2.363636_g73390_i0 | PRJNA939415 | 73812 | 260 | 2.363636 | 6.1454536 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 42.7 | 0.0442 | NR | MBV8195513.1 | 2052315 | g73390 | i0 | 39.6 | 0.611538461538462 | 53 | 31 | 60 | 1 | 165 | 10 | 32 | 84 | MBV8195513.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 159 | 42.7 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30348534 | 30348534 | PRJNA939415_P_NODE_99972_length_235_cov_2.098765_g99550_i0 | PRJNA939415 | 99972 | 235 | 2.098765 | 4.93209775 | FCB group | 1783270 | Bacteria | Bacteria | 101 | 9.38e-26 | NR | HEX6488685.1 | 2052315 | g99550 | i0 | 55.8 | 4.92765957446808 | 77 | 34 | 98.3 | 0 | 232 | 2 | 35 | 111 | HEX6488685.1 DUF1801 domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 1158 | 101 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 31162302 | 31162302 | PRJNA939415_P_NODE_82375_length_251_cov_4.320225_g81953_i0 | PRJNA939415 | 82375 | 251 | 4.320225 | 10.84376475 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 92.4 | 1.25e-19 | NR | HVH62389.1 | 2052315 | g81953 | i0 | 66.2 | 1.80478087649402 | 77 | 21 | 87.3 | 2 | 249 | 31 | 457 | 532 | HVH62389.1 IS21 family transposase [Candidatus Dormiibacterota bacterium] | diamond | 453 | 92.4 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 31320583 | 31320583 | PRJNA939415_P_NODE_63155_length_270_cov_4.730964_g62733_i0 | PRJNA939415 | 63155 | 270 | 4.730964 | 12.7736028 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 144 | 1.72e-40 | NR | HEY4868545.1 | 2052315 | g62733 | i0 | 80.9 | 0.988888888888889 | 89 | 17 | 98.9 | 0 | 2 | 268 | 158 | 246 | HEY4868545.1 APC family permease [Candidatus Dormiibacterota bacterium] | diamond | 267 | 144 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 31384026 | 31384026 | PRJNA939415_P_NODE_51256_length_282_cov_3.277512_g50834_i0 | PRJNA939415 | 51256 | 282 | 3.277512 | 9.24258384 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 96.7 | 9.7e-24 | NR | HZC65148.1 | 2052315 | g50834 | i0 | 71 | 0.659574468085106 | 62 | 18 | 66 | 0 | 188 | 3 | 1 | 62 | HZC65148.1 antibiotic biosynthesis monooxygenase [Candidatus Dormiibacterota bacterium] | diamond | 186 | 96.7 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 31478932 | 31478932 | PRJNA939415_P_NODE_21416_length_337_cov_0.875000_g20996_i0 | PRJNA939415 | 21416 | 337 | 0.875 | 2.94875 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 105 | 9.69e-24 | NR | HXM96374.1 | 2052315 | g20996 | i0 | 49.5 | 0.98813056379822 | 111 | 56 | 98.8 | 0 | 336 | 4 | 152 | 262 | HXM96374.1 MaoC/PaaZ C-terminal domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 333 | 105 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 32750319 | 32750319 | PRJNA939415_P_NODE_14380_length_408_cov_3.808955_g13961_i0 | PRJNA939415 | 14380 | 408 | 3.808955 | 15.5405364 | Bacteria | 2 | Bacteria | Bacteria | 79 | 4.94e-14 | NR | HYS03588.1 | 2052315 | g13961 | i0 | 37 | 2.93382352941176 | 135 | 78 | 97.8 | 3 | 10 | 408 | 127 | 256 | HYS03588.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 1197 | 79.7 | 0.991217063989962 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium |
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);;