contig_metadata
4 rows where bioproject = "PRJNA849172" and tax_phylum = "Candidatus Dormiibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3386994 | 3386994 | PRJNA849172_P_NODE_41603_length_321_cov_3.016129_g41243_i0 | PRJNA849172 | 41603 | 321 | 3.016129 | 9.68177409 | Bacillati | 1783272 | Bacteria | Bacteria | 147 | 5.88e-41 | NR | HEV3232006.1 | 2052315 | g41243 | i0 | 76.3 | 3.60747663551402 | 97 | 23 | 90.7 | 0 | 31 | 321 | 27 | 123 | HEV3232006.1 ABC transporter ATP-binding protein [Candidatus Dormiibacterota bacterium] | diamond | 1158 | 147 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29296976 | 29296976 | PRJNA849172_P_NODE_53969_length_289_cov_2.115741_g53609_i0 | PRJNA849172 | 53969 | 289 | 2.115741 | 6.11449149 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 143 | 6.61e-42 | NR | HEY0493228.1 | 2052315 | g53609 | i0 | 87.3 | 0.820069204152249 | 79 | 10 | 82 | 0 | 3 | 239 | 39 | 117 | HEY0493228.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 237 | 143 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30971254 | 30971254 | PRJNA849172_P_NODE_60294_length_280_cov_11.840580_g59934_i0 | PRJNA849172 | 60294 | 280 | 11.84058 | 33.153624 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 155 | 1.37e-44 | NR | HEY0493227.1 | 2052315 | g59934 | i0 | 77.5 | 0.953571428571429 | 89 | 20 | 95.4 | 0 | 3 | 269 | 200 | 288 | HEY0493227.1 PHB depolymerase family esterase [Candidatus Dormiibacterota bacterium] | diamond | 267 | 155 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 32867477 | 32867477 | PRJNA849172_P_NODE_92260_length_250_cov_3.197740_g91900_i0 | PRJNA849172 | 92260 | 250 | 3.19774 | 7.99435 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 144 | 2.57e-41 | NR | HLQ97773.1 | 2052315 | g91900 | i0 | 100 | 0.864 | 72 | 0 | 86.4 | 0 | 2 | 217 | 131 | 202 | HLQ97773.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 216 | 144 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota 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);;