contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA630877" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26859716 | 26859716 | PRJNA630877_S_NODE_142981_length_164_cov_1.609756_g123844_i0 | PRJNA630877 | 142981 | 164 | 1.609756 | 2.63999984 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0131 | NR | MEO8379456.1 | 1978231 | g123844 | i0 | 38.1 | 0.768292682926829 | 42 | 24 | 76.8 | 1 | 145 | 20 | 3405 | 3444 | MEO8379456.1 Ig-like domain-containing protein [Acidobacteriota bacterium] | diamond | 126 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26859722 | 26859722 | PRJNA630877_S_NODE_91001_length_252_cov_1.810427_g71864_i0 | PRJNA630877 | 91001 | 252 | 1.810427 | 4.56227604 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 42.7 | 0.0423 | NR | HLO07340.1 | 2282142 | g71864 | i0 | 40.7 | 0.702380952380952 | 59 | 34 | 70.2 | 1 | 73 | 249 | 1 | 58 | HLO07340.1 DUF885 domain-containing protein [Terriglobales bacterium] | diamond | 177 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27143656 | 27143656 | PRJNA630877_S_NODE_109162_length_208_cov_1.041916_g90025_i0 | PRJNA630877 | 109162 | 208 | 1.041916 | 2.16718528 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 80.5 | 2.94e-16 | NR | MCY3928488.1 | 1978231 | g90025 | i0 | 52.2 | 0.966346153846154 | 67 | 32 | 96.6 | 0 | 6 | 206 | 30 | 96 | MCY3928488.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 201 | 80.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27302234 | 27302234 | PRJNA630877_S_NODE_123543_length_185_cov_2.229167_g104406_i0 | PRJNA630877 | 123543 | 185 | 2.229167 | 4.12395895 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 42.7 | 0.017 | NR | HVB29812.1 | 2081523 | g104406 | i0 | 40 | 1.62162162162162 | 50 | 29 | 79.5 | 1 | 174 | 28 | 43 | 92 | HVB29812.1 GTP 3',8-cyclase MoaA [Terriglobia bacterium] | diamond | 300 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 28660019 | 28660019 | PRJNA630877_S_NODE_107267_length_211_cov_2.705882_g88130_i0 | PRJNA630877 | 107267 | 211 | 2.705882 | 5.70941102 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 40.8 | 0.0406 | NR | HEX6731931.1 | 2283092 | g88130 | i0 | 46.2 | 0.554502369668246 | 39 | 21 | 55.5 | 0 | 126 | 10 | 59 | 97 | HEX6731931.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 117 | 40.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28912216 | 28912216 | PRJNA630877_S_NODE_83208_length_280_cov_2.384937_g64071_i0 | PRJNA630877 | 83208 | 280 | 2.384937 | 6.6778236 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 42.4 | 0.032 | NR | HTC42095.1 | 2952895 | g64071 | i0 | 34 | 0.535714285714286 | 50 | 33 | 53.6 | 0 | 45 | 194 | 86 | 135 | HTC42095.1 bleomycin resistance family protein [Candidatus Acidiferrales bacterium] | diamond | 150 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 29543825 | 29543825 | PRJNA630877_S_NODE_80150_length_294_cov_1.332016_g61013_i0 | PRJNA630877 | 80150 | 294 | 1.332016 | 3.91612704 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 53.9 | 8.32e-6 | NR | MBV8073763.1 | 2052142 | g61013 | i0 | 45.2 | 1.18367346938776 | 62 | 19 | 48 | 1 | 189 | 49 | 655 | 716 | MBV8073763.1 RNA-directed DNA polymerase [Acidobacteriaceae bacterium] | diamond | 348 | 53.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 30649317 | 30649317 | PRJNA630877_S_NODE_121553_length_188_cov_1.496599_g102416_i0 | PRJNA630877 | 121553 | 188 | 1.496599 | 2.81360612 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.1 | 0.00251 | NR | HSQ53421.1 | 1978231 | g102416 | i0 | 36.7 | 0.957446808510638 | 60 | 37 | 95.7 | 1 | 4 | 183 | 26 | 84 | HSQ53421.1 30S ribosomal protein S4e [Acidobacteriota bacterium] | diamond | 180 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30680948 | 30680948 | PRJNA630877_S_NODE_118093_length_193_cov_1.157895_g98956_i0 | PRJNA630877 | 118093 | 193 | 1.157895 | 2.23473735 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 43.5 | 0.01 | NR | HEY1903716.1 | 1964191 | g98956 | i0 | 48.8 | 0.637305699481865 | 41 | 21 | 63.7 | 0 | 125 | 3 | 138 | 178 | HEY1903716.1 class I adenylate-forming enzyme family protein [Terracidiphilus sp.] | diamond | 123 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 31344917 | 31344917 | PRJNA630877_S_NODE_72196_length_337_cov_2.469595_g53059_i0 | PRJNA630877 | 72196 | 337 | 2.469595 | 8.32253515 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 44.7 | 0.00638 | NR | HJX00211.1 | 2282142 | g53059 | i0 | 37.5 | 0.640949554896142 | 72 | 44 | 63.2 | 1 | 60 | 272 | 15 | 86 | HJX00211.1 hypothetical protein [Terriglobales bacterium] | diamond | 216 | 44.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31471507 | 31471507 | PRJNA630877_S_NODE_121596_length_188_cov_1.442177_g102459_i0 | PRJNA630877 | 121596 | 188 | 1.442177 | 2.71129276 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 42.4 | 0.0223 | NR | HVN06238.1 | 2212468 | g102459 | i0 | 38.7 | 0.98936170212766 | 62 | 36 | 95.7 | 2 | 1 | 180 | 44 | 105 | HVN06238.1 phage baseplate assembly protein V [Bryobacteraceae bacterium] | diamond | 186 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31503147 | 31503147 | PRJNA630877_S_NODE_89436_length_257_cov_1.921296_g70299_i0 | PRJNA630877 | 89436 | 257 | 1.921296 | 4.93773072 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 43.9 | 0.0162 | NR | HEX8764948.1 | 3069120 | g70299 | i0 | 32.8 | 1.55252918287938 | 64 | 41 | 72.4 | 1 | 25 | 210 | 106 | 169 | HEX8764948.1 phosphate ABC transporter substrate-binding protein PstS [Candidatus Acidiferrum sp.] | diamond | 399 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 32103981 | 32103981 | PRJNA630877_S_NODE_132558_length_175_cov_0.932836_g113421_i0 | PRJNA630877 | 132558 | 175 | 0.932836 | 1.632463 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.5 | 0.00814 | NR | HYL76495.1 | 2212468 | g113421 | i0 | 43.8 | 0.822857142857143 | 48 | 26 | 82.3 | 1 | 7 | 150 | 247 | 293 | HYL76495.1 alginate lyase family protein [Bryobacteraceae bacterium] | diamond | 144 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae 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);;