contig_metadata
10 rows where bioproject = "PRJNA929924" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2184252 | 2184252 | PRJNA929924_P_NODE_17782_length_163_cov_0.912281_g17619_i0 | PRJNA929924 | 17782 | 163 | 0.912281 | 1.48701803 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 252 | 1.25e-62 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g17619 | i0 | 94.479 | 84.0122699386503 | 163 | 9 | 100 | 0 | 1 | 163 | 4652312 | 4652150 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 13694 | 252 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 3459805 | 3459805 | PRJNA929924_P_NODE_17683_length_163_cov_0.912281_g17520_i0 | PRJNA929924 | 17683 | 163 | 0.912281 | 1.48701803 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 296 | 5.68e-76 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g17520 | i0 | 99.387 | 181.59509202454 | 163 | 1 | 100 | 0 | 1 | 163 | 4787232 | 4787394 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 29600 | 296 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 3459938 | 3459938 | PRJNA929924_P_NODE_9683_length_254_cov_5.336585_g9520_i0 | PRJNA929924 | 9683 | 254 | 5.336585 | 13.5549259 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 364 | 2.6099999999999993e-96 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g9520 | i0 | 92.549 | 179.700787401575 | 255 | 17 | 100 | 2 | 1 | 254 | 636140 | 635887 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 45644 | 364 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 4737236 | 4737236 | PRJNA929924_P_NODE_13844_length_181_cov_1.181818_g13681_i0 | PRJNA929924 | 13844 | 181 | 1.181818 | 2.13909058 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 215 | 1.85e-51 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g13681 | i0 | 94.286 | 0.773480662983425 | 140 | 8 | 77 | 0 | 38 | 177 | 638512 | 638651 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 140 | 215 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 12388057 | 12388057 | PRJNA929924_P_NODE_17050_length_164_cov_1.765217_g16887_i0 | PRJNA929924 | 17050 | 164 | 1.765217 | 2.89495588 | Acidobacteria bacterium Mor1 | 1660251 | Bacteria | Bacteria | 204 | 3.5699999999999997e-48 | NTclustered | gi|1037405666|gb|CP011806.1| | 1660251 | g16887 | i0 | 89.091 | 56.4817073170732 | 165 | 16 | 100 | 2 | 1 | 164 | 1850470 | 1850307 | Acidobacteria bacterium Mor1 chromosome | blastn | 9263 | 204 | 1 | Bacteria | Acidobacteriota subdivision 22 | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium Mor1 | |||||
| 14936855 | 14936855 | PRJNA929924_P_NODE_17952_length_162_cov_1.831858_g17789_i0 | PRJNA929924 | 17952 | 162 | 1.831858 | 2.96760996 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 169 | 1.28e-37 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g17789 | i0 | 86.538 | 1.5679012345679 | 156 | 17 | 95 | 4 | 1 | 154 | 6082288 | 6082135 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 254 | 169 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 27404344 | 27404344 | PRJNA929924_P_NODE_16923_length_165_cov_0.896552_g16760_i0 | PRJNA929924 | 16923 | 165 | 0.896552 | 1.4793108 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 100 | 7.879999999999999e-23 | NR | HZS52835.1 | 2212468 | g16760 | i0 | 87 | 1.96363636363636 | 54 | 7 | 98.2 | 0 | 3 | 164 | 461 | 514 | HZS52835.1 error-prone DNA polymerase [Bryobacteraceae bacterium] | diamond | 324 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28509324 | 28509324 | PRJNA929924_P_NODE_15387_length_168_cov_0.873950_g15224_i0 | PRJNA929924 | 15387 | 168 | 0.87395 | 1.468236 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 88.2 | 8.18e-21 | NR | MBS1835797.1 | 1978231 | g15224 | i0 | 89.1 | 0.982142857142857 | 55 | 6 | 98.2 | 0 | 2 | 166 | 39 | 93 | MBS1835797.1 roadblock/LC7 domain-containing protein [Acidobacteriota bacterium] | diamond | 165 | 88.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32403217 | 32403217 | PRJNA929924_P_NODE_13999_length_179_cov_1.446154_g13836_i0 | PRJNA929924 | 13999 | 179 | 1.446154 | 2.58861566 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 96.3 | 2.0200000000000003e-21 | NR | HTM47052.1 | 2212468 | g13836 | i0 | 70.7 | 2.91620111731844 | 58 | 17 | 97.2 | 0 | 4 | 177 | 425 | 482 | HTM47052.1 PQQ-dependent dehydrogenase, methanol/ethanol family [Bryobacteraceae bacterium] | diamond | 522 | 96.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32617330 | 32617330 | PRJNA929924_P_NODE_17260_length_164_cov_0.904348_g17097_i0 | PRJNA929924 | 17260 | 164 | 0.904348 | 1.48313072 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 100 | 1.69e-23 | NR | MBS1833718.1 | 1978231 | g17097 | i0 | 83.3 | 0.98780487804878 | 54 | 9 | 98.8 | 0 | 2 | 163 | 57 | 110 | MBS1833718.1 TerC/Alx family metal homeostasis membrane protein [Acidobacteriota bacterium] | diamond | 162 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;