contig_metadata
4 rows where bioproject = "PRJNA675638" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9577158 | 9577158 | PRJNA675638_S_NODE_5108_length_199_cov_2.040000_g5046_i0 | PRJNA675638 | 5108 | 199 | 2.04 | 4.0596 | Luteitalea sp. TBR-22 | 2802971 | Bacteria | Bacteria | 340 | 3.2899999999999996e-89 | NTclustered | gi|2131947417|dbj|AP024452.2| | 2802971 | g5046 | i0 | 97.487 | 434.040201005025 | 199 | 5 | 100 | 0 | 1 | 199 | 642204 | 642006 | Vicinamibacteria bacterium TBR-22 DNA, complete genome | blastn | 86374 | 340 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea sp. TBR-22 | ||
| 27208134 | 27208134 | PRJNA675638_S_NODE_2262_length_288_cov_0.824268_g2200_i0 | PRJNA675638 | 2262 | 288 | 0.824268 | 2.37389184 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.1 | 0.0433 | NR | MDA1313252.1 | 1978231 | g2200 | i0 | 33.8 | 0.708333333333333 | 68 | 35 | 68.8 | 3 | 87 | 284 | 299 | 358 | MDA1313252.1 glycosyltransferase [Acidobacteriota bacterium] | diamond | 204 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28661051 | 28661051 | PRJNA675638_S_NODE_6907_length_174_cov_0.824000_g6845_i0 | PRJNA675638 | 6907 | 174 | 0.824 | 1.43376 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 41.6 | 0.00808 | NR | HEY2544549.1 | 3069120 | g6845 | i0 | 41.5 | 0.706896551724138 | 41 | 24 | 70.7 | 0 | 29 | 151 | 40 | 80 | HEY2544549.1 hypothetical protein [Candidatus Acidiferrum sp.] | diamond | 123 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 31662015 | 31662015 | PRJNA675638_S_NODE_8617_length_163_cov_2.263158_g8555_i0 | PRJNA675638 | 8617 | 163 | 2.263158 | 3.68894754 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 42.7 | 0.0123 | NR | HYO14880.1 | 2651171 | g8555 | i0 | 47.8 | 0.846625766871166 | 46 | 20 | 77.3 | 2 | 36 | 161 | 361 | 406 | HYO14880.1 MMPL family transporter [Thermoanaerobaculia bacterium] | diamond | 138 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia 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);;