contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Tayloriibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29070330 | 29070330 | PRJNA630162_P_NODE_129008_length_170_cov_1.371901_g127485_i0 | PRJNA630162 | 129008 | 170 | 1.371901 | 2.3322317 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 49.7 | 2.07e-6 | NR | MDB5204740.1 | 2052153 | g127485 | i0 | 84.6 | 0.458823529411765 | 26 | 4 | 45.9 | 0 | 11 | 88 | 1 | 26 | MDB5204740.1 hypothetical protein [Candidatus Taylorbacteria bacterium] | diamond | 78 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 30378126 | 30378126 | PRJNA630162_P_NODE_112732_length_178_cov_1.813953_g111209_i0 | PRJNA630162 | 112732 | 178 | 1.813953 | 3.22883634 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 3.04e-8 | NR | OHA16301.1 | 1802299 | g111209 | i0 | 96.4 | 1.41573033707865 | 28 | 1 | 47.2 | 0 | 85 | 2 | 1 | 28 | OHA16301.1 MAG: hypothetical protein A2830_00145 [Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_01_FULL_44_110] | diamond | 252 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_01_FULL_44_110 | ||||||
| 30693733 | 30693733 | PRJNA630162_P_NODE_89353_length_192_cov_1.888112_g87830_i0 | PRJNA630162 | 89353 | 192 | 1.888112 | 3.62517504 | Bacteria | 2 | Bacteria | Bacteria | 110 | 3.3500000000000006e-27 | NR | MEI6396746.1 | 2052153 | g87830 | i0 | 80.6 | 4.8125 | 62 | 12 | 96.9 | 0 | 6 | 191 | 243 | 304 | MEI6396746.1 PCRF domain-containing protein [Candidatus Taylorbacteria bacterium] | diamond | 924 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 31895075 | 31895075 | PRJNA630162_P_NODE_69117_length_213_cov_2.530488_g67594_i0 | PRJNA630162 | 69117 | 213 | 2.530488 | 5.38993944 | Bacteria | 2 | Bacteria | Bacteria | 48.1 | 2.69e-5 | NR | MDB5259410.1 | 2052153 | g67594 | i0 | 66.7 | 5.16901408450704 | 33 | 11 | 46.5 | 0 | 101 | 3 | 26 | 58 | MDB5259410.1 ribosomal protein [Candidatus Taylorbacteria bacterium] | diamond | 1101 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota 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);;