contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA846110" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26651417 | 26651417 | PRJNA846110_P_NODE_23361_length_250_cov_0.870056_g23116_i0 | PRJNA846110 | 23361 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 63.5 | 1.91e-9 | NR | HTW81267.1 | 1964191 | g23116 | i0 | 46.6 | 1.776 | 73 | 36 | 86.4 | 2 | 16 | 231 | 198 | 268 | HTW81267.1 acyltransferase family protein [Terracidiphilus sp.] | diamond | 444 | 63.9 | 0.993740219092332 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 26801483 | 26801483 | PRJNA846110_P_NODE_16721_length_279_cov_1.388350_g16476_i0 | PRJNA846110 | 16721 | 279 | 1.38835 | 3.8734965 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 90.9 | 6.9e-19 | NR | MBX7223318.1 | 2052146 | g16476 | i0 | 58.7 | 0.989247311827957 | 92 | 38 | 98.9 | 0 | 278 | 3 | 823 | 914 | MBX7223318.1 carboxypeptidase regulatory-like domain-containing protein [Blastocatellia bacterium] | diamond | 276 | 90.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27718573 | 27718573 | PRJNA846110_P_NODE_14964_length_287_cov_2.453271_g14719_i0 | PRJNA846110 | 14964 | 287 | 2.453271 | 7.04088777 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 194 | 6.520000000000001e-59 | NR | MSV31675.1 | 2026791 | g14719 | i0 | 93.7 | 4.96515679442509 | 95 | 6 | 99.3 | 0 | 285 | 1 | 66 | 160 | MSV31675.1 DUF1501 domain-containing protein [Bryobacterales bacterium] | diamond | 1425 | 194 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 28191533 | 28191533 | PRJNA846110_P_NODE_27766_length_244_cov_0.900585_g27521_i0 | PRJNA846110 | 27766 | 244 | 0.900585 | 2.1974274 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 80.5 | 1.47e-15 | NR | HWE00483.1 | 2212468 | g27521 | i0 | 60.3 | 1.72131147540984 | 58 | 23 | 71.3 | 0 | 242 | 69 | 154 | 211 | HWE00483.1 glycosyltransferase [Bryobacteraceae bacterium] | diamond | 420 | 80.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28326317 | 28326317 | PRJNA846110_P_NODE_17486_length_275_cov_1.940594_g17241_i0 | PRJNA846110 | 17486 | 275 | 1.940594 | 5.3366335 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 105 | 3.7799999999999996e-24 | NR | HST24295.1 | 2052146 | g17241 | i0 | 93.9 | 11.2036363636364 | 49 | 3 | 53.5 | 0 | 127 | 273 | 1 | 49 | HST24295.1 hypothetical protein [Blastocatellia bacterium] | diamond | 3081 | 106 | 0.990566037735849 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28854649 | 28854649 | PRJNA846110_P_NODE_30808_length_231_cov_2.405063_g30563_i0 | PRJNA846110 | 30808 | 231 | 2.405063 | 5.55569553 | Edaphobacter sp. | 1934404 | Bacteria | Bacteria | 143 | 2.45e-40 | NR | WP_299371629.1 | 1934404 | g30563 | i0 | 91.3 | 0.896103896103896 | 69 | 6 | 89.6 | 0 | 212 | 6 | 2 | 70 | WP_299371629.1 DUF692 domain-containing protein [Edaphobacter sp.] | diamond | 207 | 143 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. | ||
| 29810337 | 29810337 | PRJNA846110_P_NODE_17371_length_276_cov_1.354680_g17126_i0 | PRJNA846110 | 17371 | 276 | 1.35468 | 3.7389168 | Bacteria | 2 | Bacteria | Bacteria | 119 | 4.6899999999999994e-30 | NR | MBZ5646461.1 | 2081523 | g17126 | i0 | 80.6 | 3.90217391304348 | 72 | 14 | 78.3 | 0 | 3 | 218 | 304 | 375 | MBZ5646461.1 SAM-dependent methyltransferase [Terriglobia bacterium] | diamond | 1077 | 120 | 0.991666666666667 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia 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);;