contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA724039" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27305209 | 27305209 | PRJNA724039_S_NODE_17063_length_154_cov_3.273504_g16856_i0 | PRJNA724039 | 17063 | 154 | 3.273504 | 5.04119616 | Candidatus Sulfotelmatobacter sp. | 2771375 | Bacteria | Bacteria | 41.2 | 0.0253 | NR | HET9305486.1 | 2771375 | g16856 | i0 | 51.6 | 1.20779220779221 | 31 | 15 | 60.4 | 0 | 8 | 100 | 81 | 111 | HET9305486.1 DUF2127 domain-containing protein [Candidatus Sulfotelmatobacter sp.] | diamond | 186 | 41.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Sulfotelmatobacter | Candidatus Sulfotelmatobacter sp. | ||
| 28788971 | 28788971 | PRJNA724039_S_NODE_17167_length_154_cov_1.367521_g16960_i0 | PRJNA724039 | 17167 | 154 | 1.367521 | 2.10598234 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 48.9 | 7.41e-5 | NR | HZF14297.1 | 2651171 | g16960 | i0 | 45.8 | 0.935064935064935 | 48 | 26 | 93.5 | 0 | 145 | 2 | 126 | 173 | HZF14297.1 IPTL-CTERM sorting domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 144 | 48.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29010563 | 29010563 | PRJNA724039_S_NODE_14008_length_171_cov_1.164179_g13801_i0 | PRJNA724039 | 14008 | 171 | 1.164179 | 1.99074609 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 42.7 | 0.0145 | NR | HLE20026.1 | 2793154 | g13801 | i0 | 43.6 | 0.964912280701754 | 55 | 30 | 94.7 | 1 | 1 | 162 | 202 | 256 | HLE20026.1 ABC transporter permease [Vicinamibacteria bacterium] | diamond | 165 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 29672909 | 29672909 | PRJNA724039_S_NODE_15890_length_160_cov_1.577236_g15683_i0 | PRJNA724039 | 15890 | 160 | 1.577236 | 2.5235776 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 43.5 | 0.00601 | NR | HEY8021067.1 | 2651171 | g15683 | i0 | 45.1 | 0.95625 | 51 | 25 | 95.6 | 1 | 155 | 3 | 65 | 112 | HEY8021067.1 ParB/RepB/Spo0J family partition protein [Thermoanaerobaculia bacterium] | diamond | 153 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 31105089 | 31105089 | PRJNA724039_S_NODE_18215_length_150_cov_1.008850_g18008_i0 | PRJNA724039 | 18215 | 150 | 1.00885 | 1.513275 | Bacteria | 2 | Bacteria | Bacteria | 45.4 | 0.00114 | NR | MBW8894768.1 | 1978231 | g18008 | i0 | 51.1 | 2.62 | 45 | 22 | 90 | 0 | 14 | 148 | 327 | 371 | MBW8894768.1 ABC transporter permease [Acidobacteriota bacterium] | diamond | 393 | 45.8 | 0.991266375545852 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31221011 | 31221011 | PRJNA724039_S_NODE_9235_length_215_cov_1.573034_g9028_i0 | PRJNA724039 | 9235 | 215 | 1.573034 | 3.3820231 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 60.8 | 9.64e-9 | NR | MEM9553623.1 | 1978231 | g9028 | i0 | 46.4 | 0.781395348837209 | 56 | 26 | 72.6 | 1 | 3 | 158 | 287 | 342 | MEM9553623.1 thaumatin family protein [Acidobacteriota bacterium] | diamond | 168 | 60.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31347919 | 31347919 | PRJNA724039_S_NODE_17196_length_154_cov_1.290598_g16989_i0 | PRJNA724039 | 17196 | 154 | 1.290598 | 1.98752092 | Candidatus Sulfopaludibacter sp. SbA3 | 2043164 | Bacteria | Bacteria | 41.2 | 0.0395 | NR | SPE42860.1 | 2043164 | g16989 | i0 | 40.4 | 0.915584415584416 | 47 | 24 | 87.7 | 2 | 145 | 11 | 343 | 387 | SPE42860.1 hypothetical protein SBA3_690046 [Candidatus Sulfopaludibacter sp. SbA3] | diamond | 141 | 41.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Sulfopaludibacter | Candidatus Sulfopaludibacter sp. SbA3 |
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);;