contig_metadata
4 rows where bioproject = "PRJNA382357" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26822023 | 26822023 | PRJNA382357_P_NODE_131161_length_213_cov_3.276316_g130422_i0 | PRJNA382357 | 131161 | 213 | 3.276316 | 6.97855308 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 81.6 | 2.18e-16 | NR | HSU56765.1 | 2052315 | g130422 | i0 | 77.8 | 0.633802816901408 | 45 | 10 | 63.4 | 0 | 201 | 67 | 237 | 281 | HSU56765.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 135 | 81.6 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 26870885 | 26870885 | PRJNA382357_P_NODE_117001_length_226_cov_0.927273_g116262_i0 | PRJNA382357 | 117001 | 226 | 0.927273 | 2.09563698 | PVC group | 1783257 | Bacteria | Bacteria | 73.2 | 5.64e-13 | NR | HYW66395.1 | 2052315 | g116262 | i0 | 82.1 | 2.58849557522124 | 39 | 7 | 51.8 | 0 | 118 | 2 | 362 | 400 | HYW66395.1 AMP-binding protein [Candidatus Dormiibacterota bacterium] | diamond | 585 | 73.6 | 0.994565217391304 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29239473 | 29239473 | PRJNA382357_P_NODE_49269_length_330_cov_6.676580_g48530_i0 | PRJNA382357 | 49269 | 330 | 6.67658 | 22.032714 | Bacteria | 2 | Bacteria | Bacteria | 127 | 1.0599999999999998e-31 | NR | HYW65073.1 | 2052315 | g48530 | i0 | 74.1 | 8.48181818181818 | 81 | 21 | 73.6 | 0 | 285 | 43 | 76 | 156 | HYW65073.1 alpha-amylase family glycosyl hydrolase [Candidatus Dormiibacterota bacterium] | diamond | 2799 | 127 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 31845011 | 31845011 | PRJNA382357_P_NODE_24177_length_454_cov_1.338422_g23440_i0 | PRJNA382357 | 24177 | 454 | 1.338422 | 6.07643588 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 45.4 | 0.0268 | NR | HVB87814.1 | 2052315 | g23440 | i0 | 27.9 | 0.92511013215859 | 140 | 76 | 91.9 | 5 | 419 | 3 | 81 | 196 | HVB87814.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 420 | 45.4 | 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);;