contig_metadata
5 rows where bioproject = "PRJNA690592", tax_phylum = "Candidatus Bathyarchaeota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27082450 | 27082450 | PRJNA690592_S_NODE_14782_length_765_cov_3.310694_g13897_i0 | PRJNA690592 | 14782 | 765 | 3.310694 | 25.3268091 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 47 | 0.04 | NR | MCD6089350.1 | 2026714 | g13897 | i0 | 28.1 | 0.698039215686274 | 178 | 112 | 64.7 | 5 | 258 | 752 | 110 | 284 | MCD6089350.1 CdvA-like protein [Candidatus Bathyarchaeota archaeon] | diamond | 534 | 47 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29829703 | 29829703 | PRJNA690592_S_NODE_23711_length_616_cov_3.088398_g22724_i0 | PRJNA690592 | 23711 | 616 | 3.088398 | 19.02453168 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 52.8 | 3.61e-4 | NR | RLI09622.1 | 2026714 | g22724 | i0 | 45.5 | 0.267857142857143 | 55 | 30 | 26.8 | 0 | 2 | 166 | 645 | 699 | RLI09622.1 MAG: AAA family ATPase [Candidatus Bathyarchaeota archaeon] | diamond | 165 | 52.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 30904140 | 30904140 | PRJNA690592_S_NODE_80834_length_357_cov_2.197183_g79820_i0 | PRJNA690592 | 80834 | 357 | 2.197183 | 7.84394331 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 106 | 3.4999999999999997e-25 | NR | MCJ7635527.1 | 2026714 | g79820 | i0 | 45.5 | 0.941176470588235 | 112 | 59 | 94.1 | 2 | 337 | 2 | 147 | 256 | MCJ7635527.1 FRG domain-containing protein [Candidatus Bathyarchaeota archaeon] | diamond | 336 | 106 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 30935679 | 30935679 | PRJNA690592_S_NODE_20894_length_654_cov_2.259897_g19927_i0 | PRJNA690592 | 20894 | 654 | 2.259897 | 14.77972638 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 132 | 4.99e-33 | NR | MCD6470594.1 | 2026714 | g19927 | i0 | 38.8 | 8.84403669724771 | 214 | 127 | 98.2 | 2 | 7 | 648 | 71 | 280 | MCD6470594.1 polyprenyl synthetase family protein [Candidatus Bathyarchaeota archaeon] | diamond | 5784 | 132 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32053719 | 32053719 | PRJNA690592_S_NODE_145738_length_280_cov_2.009662_g144724_i0 | PRJNA690592 | 145738 | 280 | 2.009662 | 5.6270536 | Thermoproteati | 1783275 | Archaea | Archaea | 68.2 | 6.31e-11 | NR | MBS7638539.1 | 2026714 | g144724 | i0 | 41.6 | 7.10357142857143 | 77 | 45 | 82.5 | 0 | 32 | 262 | 185 | 261 | MBS7638539.1 translation elongation factor EF-1 subunit alpha [Candidatus Bathyarchaeota archaeon] | diamond | 1989 | 68.2 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon |
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);;