contig_metadata
6 rows where bioproject = "PRJNA1264536", tax_phylum = "Acidobacteriota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2329327 | 2329327 | PRJNA1264536_P_NODE_5322_length_244_cov_0.912281_g5248_i0 | PRJNA1264536 | 5322 | 244 | 0.912281 | 2.22596564 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 134 | 2.38e-34 | NR | HKQ88412.1 | 2952895 | g5248 | i0 | 77.8 | 10.9549180327869 | 81 | 18 | 99.6 | 0 | 2 | 244 | 475 | 555 | HKQ88412.1 efflux RND transporter permease subunit [Candidatus Acidiferrales bacterium] | diamond | 2673 | 134 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 26630762 | 26630762 | PRJNA1264536_P_NODE_5081_length_246_cov_0.901734_g5007_i0 | PRJNA1264536 | 5081 | 246 | 0.901734 | 2.21826564 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 70.1 | 1.96e-12 | NR | HUE52513.1 | 2282142 | g5007 | i0 | 73.8 | 0.51219512195122 | 42 | 11 | 51.2 | 0 | 245 | 120 | 172 | 213 | HUE52513.1 hypothetical protein [Terriglobales bacterium] | diamond | 126 | 70.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 28495216 | 28495216 | PRJNA1264536_P_NODE_4607_length_251_cov_0.876404_g4533_i0 | PRJNA1264536 | 4607 | 251 | 0.876404 | 2.19977404 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 123 | 8.169999999999998e-31 | NR | HUK87135.1 | 2282142 | g4533 | i0 | 78.6 | 1.00398406374502 | 84 | 16 | 99.2 | 2 | 3 | 251 | 129 | 211 | HUK87135.1 AsmA family protein [Terriglobales bacterium] | diamond | 252 | 123 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 29820940 | 29820940 | PRJNA1264536_P_NODE_5431_length_243_cov_0.917647_g5357_i0 | PRJNA1264536 | 5431 | 243 | 0.917647 | 2.22988221 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 106 | 1.66e-25 | NR | HZT74101.1 | 2282142 | g5357 | i0 | 75.7 | 0.91358024691358 | 74 | 18 | 91.4 | 0 | 223 | 2 | 178 | 251 | HZT74101.1 ABC transporter permease [Terriglobales bacterium] | diamond | 222 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31559457 | 31559457 | PRJNA1264536_P_NODE_4436_length_252_cov_0.871508_g4362_i0 | PRJNA1264536 | 4436 | 252 | 0.871508 | 2.19620016 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 46.2 | 0.00208 | NR | HVM46498.1 | 3069120 | g4362 | i0 | 63.6 | 0.392857142857143 | 33 | 11 | 39.3 | 1 | 153 | 251 | 1 | 32 | HVM46498.1 hypothetical protein [Candidatus Acidiferrum sp.] | diamond | 99 | 46.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 32318852 | 32318852 | PRJNA1264536_P_NODE_4899_length_248_cov_0.891429_g4825_i0 | PRJNA1264536 | 4899 | 248 | 0.891429 | 2.21074392 | Candidatus Sulfopaludibacter sp. | 2963552 | Bacteria | Bacteria | 96.3 | 5.77e-21 | NR | HWC97358.1 | 2963552 | g4825 | i0 | 68.5 | 0.883064516129032 | 73 | 20 | 87.1 | 2 | 219 | 4 | 1 | 71 | HWC97358.1 alpha/beta hydrolase-fold protein [Candidatus Sulfopaludibacter sp.] | diamond | 219 | 96.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Sulfopaludibacter | Candidatus Sulfopaludibacter sp. |
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);;