contig_metadata
9 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Wildermuthiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27895875 | 27895875 | PRJNA340009_P_NODE_61365_length_167_cov_2.550847_g61058_i0 | PRJNA340009 | 61365 | 167 | 2.550847 | 4.25991449 | Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_ | 2053642 | Bacteria | Bacteria | 70.1 | 2.85e-12 | NR | OHA67078.1 | 1802451 | g61058 | i0 | 67.3 | 4.94011976047904 | 55 | 18 | 98.8 | 0 | 3 | 167 | 214 | 268 | OHA67078.1 MAG: hypothetical protein A3C82_02375 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_02_FULL_47_12] | diamond | 825 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_02_FULL_47_12 | ||||||
| 30043079 | 30043079 | PRJNA340009_P_NODE_74131_length_162_cov_0.902655_g73824_i0 | PRJNA340009 | 74131 | 162 | 0.902655 | 1.4623011 | Candidatus Wildermuthbacteria bacterium | 2053642 | Bacteria | Bacteria | 42 | 0.0231 | NR | MBI2003188.1 | 2053642 | g73824 | i0 | 38.6 | 0.814814814814815 | 44 | 26 | 81.5 | 1 | 31 | 162 | 9 | 51 | MBI2003188.1 trypsin-like peptidase domain-containing protein [Candidatus Wildermuthbacteria bacterium] | diamond | 132 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium | ||||||
| 30232656 | 30232656 | PRJNA340009_P_NODE_26432_length_240_cov_1.068063_g26125_i0 | PRJNA340009 | 26432 | 240 | 1.068063 | 2.5633512 | Candidatus Wildermuthbacteria bacterium | 2053642 | Bacteria | Bacteria | 106 | 7.78e-28 | NR | MBI1971424.1 | 2053642 | g26125 | i0 | 75.4 | 0.8125 | 65 | 16 | 81.3 | 0 | 45 | 239 | 1 | 65 | MBI1971424.1 acylphosphatase [Candidatus Wildermuthbacteria bacterium] | diamond | 195 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium | ||||||
| 30232691 | 30232691 | PRJNA340009_P_NODE_65612_length_165_cov_5.379310_g65305_i0 | PRJNA340009 | 65612 | 165 | 5.37931 | 8.8758615 | Candidatus Wildermuthbacteria bacterium | 2053642 | Bacteria | Bacteria | 57.4 | 1.8e-8 | NR | MDO8663621.1 | 2053642 | g65305 | i0 | 58.5 | 0.745454545454545 | 41 | 17 | 74.5 | 0 | 41 | 163 | 25 | 65 | MDO8663621.1 DUF192 domain-containing protein [Candidatus Wildermuthbacteria bacterium] | diamond | 123 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium | ||||||
| 30454118 | 30454118 | PRJNA340009_P_NODE_68413_length_164_cov_1.773913_g68106_i0 | PRJNA340009 | 68413 | 164 | 1.773913 | 2.90921732 | Candidatus Wildermuthbacteria bacterium | 2053642 | Bacteria | Bacteria | 85.1 | 4.17e-19 | NR | MBI2123642.1 | 2053642 | g68106 | i0 | 95.6 | 0.823170731707317 | 45 | 2 | 82.3 | 0 | 162 | 28 | 67 | 111 | MBI2123642.1 translation initiation factor IF-3 [Candidatus Wildermuthbacteria bacterium] | diamond | 135 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium | ||||||
| 30674901 | 30674901 | PRJNA340009_P_NODE_30453_length_225_cov_14.454545_g30146_i0 | PRJNA340009 | 30453 | 225 | 14.454545 | 32.52272625 | Candidatus Wildermuthbacteria bacterium | 2053642 | Bacteria | Bacteria | 58.2 | 1.07e-7 | NR | MBI2644300.1 | 2053642 | g30146 | i0 | 50 | 0.853333333333333 | 64 | 29 | 81.3 | 2 | 8 | 190 | 15 | 78 | MBI2644300.1 DUF4082 domain-containing protein [Candidatus Wildermuthbacteria bacterium] | diamond | 192 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium | ||||||
| 30801266 | 30801266 | PRJNA340009_P_NODE_13814_length_316_cov_5.741573_g13507_i0 | PRJNA340009 | 13814 | 316 | 5.741573 | 18.14337068 | Candidatus Wildermuthbacteria bacterium | 2053642 | Bacteria | Bacteria | 171 | 2.4e-51 | NR | MBI2098617.1 | 2053642 | g13507 | i0 | 78.1 | 2.98101265822785 | 105 | 23 | 99.7 | 0 | 2 | 316 | 94 | 198 | MBI2098617.1 MBL fold metallo-hydrolase [Candidatus Wildermuthbacteria bacterium] | diamond | 942 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium | ||||||
| 30864506 | 30864506 | PRJNA340009_P_NODE_59374_length_170_cov_1.685950_g59067_i0 | PRJNA340009 | 59374 | 170 | 1.68595 | 2.866115 | Candidatus Wildermuthbacteria bacterium | 2053642 | Bacteria | Bacteria | 92.4 | 4.84e-22 | NR | MBI2123708.1 | 2053642 | g59067 | i0 | 80 | 0.970588235294118 | 55 | 11 | 97.1 | 0 | 1 | 165 | 6 | 60 | MBI2123708.1 hypothetical protein [Candidatus Wildermuthbacteria bacterium] | diamond | 165 | 92.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium | ||||||
| 32509491 | 32509491 | PRJNA340009_P_NODE_69559_length_164_cov_0.886957_g69252_i0 | PRJNA340009 | 69559 | 164 | 0.886957 | 1.45460948 | Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_ | 2053642 | Bacteria | Bacteria | 85.1 | 1.02e-18 | NR | OHA67323.1 | 1802452 | g69252 | i0 | 75 | 0.951219512195122 | 52 | 13 | 95.1 | 0 | 157 | 2 | 1 | 52 | OHA67323.1 MAG: hypothetical protein A3D59_02595 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_02_FULL_47_17] | diamond | 156 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_02_FULL_47_17 |
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);;