contig_metadata
6 rows where bioproject = "PRJNA556992", tax_clade = "Caldisericota/Cryosericota group" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12607048 | 12607048 | PRJNA556992_P_NODE_958170_length_235_cov_2.253086_g955980_i0 | PRJNA556992 | 958170 | 235 | 2.253086 | 5.2947521 | Caldisericum | 693074 | Bacteria | Bacteria | 206 | 1.53e-48 | NTclustered | gi|381363297|dbj|AP012051.1| | 511051 | g955980 | i0 | 90 | 169.774468085106 | 160 | 15 | 68 | 1 | 26 | 185 | 544430 | 544588 | Caldisericum exile AZM16c01 DNA, complete genome | blastn | 39897 | 206 | 1 | Bacteria | Caldisericota/Cryosericota group | Pseudomonadati | Caldisericota | Caldisericia | Caldisericales | Caldisericaceae | Caldisericum | Caldisericum exile | |
| 26903198 | 26903198 | PRJNA556992_P_NODE_38481_length_568_cov_4.525253_g36341_i0 | PRJNA556992 | 38481 | 568 | 4.525253 | 25.70343704 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 116 | 1.3500000000000002e-26 | NR | MDO9099684.1 | 2052147 | g36341 | i0 | 39.2 | 2.9419014084507 | 166 | 85 | 81.3 | 3 | 464 | 3 | 149 | 310 | MDO9099684.1 ATP-binding protein [Caldisericota bacterium] | diamond | 1671 | 117 | 0.991452991452991 | Bacteria | Caldisericota/Cryosericota group | Pseudomonadati | Caldisericota | Caldisericota bacterium | |||||
| 29573005 | 29573005 | PRJNA556992_P_NODE_365650_length_280_cov_2.285024_g363461_i0 | PRJNA556992 | 365650 | 280 | 2.285024 | 6.3980672 | Caldisericota bacterium | 2052147 | Bacteria | Bacteria | 46.2 | 0.00353 | NR | MDO9100078.1 | 2052147 | g363461 | i0 | 32.2 | 0.964285714285714 | 90 | 61 | 96.4 | 0 | 279 | 10 | 102 | 191 | MDO9100078.1 VWA domain-containing protein [Caldisericota bacterium] | diamond | 270 | 46.2 | 1 | Bacteria | Caldisericota/Cryosericota group | Pseudomonadati | Caldisericota | Caldisericota bacterium | |||||
| 30647118 | 30647118 | PRJNA556992_P_NODE_716373_length_250_cov_2.327684_g714184_i0 | PRJNA556992 | 716373 | 250 | 2.327684 | 5.81921 | Caldisericota bacterium | 2052147 | Bacteria | Bacteria | 57 | 3.69e-7 | NR | MDO9099684.1 | 2052147 | g714184 | i0 | 34.1 | 0.984 | 82 | 52 | 96 | 1 | 248 | 9 | 162 | 243 | MDO9099684.1 ATP-binding protein [Caldisericota bacterium] | diamond | 246 | 57 | 1 | Bacteria | Caldisericota/Cryosericota group | Pseudomonadati | Caldisericota | Caldisericota bacterium | |||||
| 32607578 | 32607578 | PRJNA556992_P_NODE_18560_length_784_cov_4.905767_g16680_i0 | PRJNA556992 | 18560 | 784 | 4.905767 | 38.46121328 | Candidatus Cryosericum sp. | 2815585 | Bacteria | Bacteria | 201 | 3.68e-56 | NR | HOV50847.1 | 2815585 | g16680 | i0 | 43.7 | 5.98469387755102 | 261 | 142 | 99.9 | 1 | 784 | 2 | 22 | 277 | HOV50847.1 NAD-dependent DNA ligase LigA [Candidatus Cryosericum sp.] | diamond | 4692 | 201 | 1 | Bacteria | Caldisericota/Cryosericota group | Pseudomonadati | Candidatus Cryosericota | Candidatus Cryosericia | Candidatus Cryosericales | Candidatus Cryosericaceae | Candidatus Cryosericum | Candidatus Cryosericum sp. | |
| 32670704 | 32670704 | PRJNA556992_P_NODE_680820_length_252_cov_3.279330_g678631_i0 | PRJNA556992 | 680820 | 252 | 3.27933 | 8.2639116 | Caldisericota bacterium | 2052147 | Bacteria | Bacteria | 109 | 4.08e-28 | NR | MDO9100505.1 | 2052147 | g678631 | i0 | 72.6 | 1 | 84 | 23 | 100 | 0 | 1 | 252 | 88 | 171 | MDO9100505.1 hypothetical protein [Caldisericota bacterium] | diamond | 252 | 109 | 1 | Bacteria | Caldisericota/Cryosericota group | Pseudomonadati | Caldisericota | Caldisericota 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);;