contig_metadata
4 rows where bioproject = "PRJNA1022139" and tax_phylum = "Candidatus Bathyarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27477346 | 27477346 | PRJNA1022139_P_NODE_32183_length_258_cov_1.664865_g32078_i0 | PRJNA1022139 | 32183 | 258 | 1.664865 | 4.2953517 | Candidatus Bathyarchaeum tardum | 3042151 | Archaea | Archaea | 67 | 1.11e-10 | NR | MDG6222931.1 | 3042151 | g32078 | i0 | 38.6 | 0.965116279069767 | 83 | 40 | 83.7 | 1 | 221 | 6 | 77 | 159 | MDG6222931.1 kelch repeat-containing protein [Candidatus Bathyarchaeum tardum] | diamond | 249 | 67 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeales | Candidatus Bathyarchaeaceae | Candidatus Bathyarchaeum | Candidatus Bathyarchaeum tardum | ||
| 30153238 | 30153238 | PRJNA1022139_P_NODE_11952_length_389_cov_0.968354_g11847_i0 | PRJNA1022139 | 11952 | 389 | 0.968354 | 3.76689706 | Archaea | 2157 | Archaea | Archaea | 62.4 | 2.53e-8 | NR | MBD3188925.1 | 2026714 | g11847 | i0 | 52.8 | 0.802056555269923 | 53 | 25 | 40.9 | 0 | 159 | 1 | 197 | 249 | MBD3188925.1 CDC48 family AAA ATPase [Candidatus Bathyarchaeota archaeon] | diamond | 312 | 62.8 | 0.993630573248408 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31322584 | 31322584 | PRJNA1022139_P_NODE_40615_length_244_cov_0.900585_g40510_i0 | PRJNA1022139 | 40615 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0267 | NR | HID18365.1 | 2026714 | g40510 | i0 | 37.1 | 2.88934426229508 | 62 | 37 | 76.2 | 1 | 55 | 240 | 153 | 212 | HID18365.1 AAA family ATPase [Candidatus Bathyarchaeota archaeon] | diamond | 705 | 43.5 | 0.990804597701149 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32406183 | 32406183 | PRJNA1022139_P_NODE_26239_length_280_cov_1.830918_g26134_i0 | PRJNA1022139 | 26239 | 280 | 1.830918 | 5.1265704 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 48.9 | 3.85e-4 | NR | MDH5691071.1 | 2026714 | g26134 | i0 | 35.8 | 0.867857142857143 | 81 | 51 | 85.7 | 1 | 33 | 272 | 542 | 622 | MDH5691071.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Bathyarchaeota archaeon] | diamond | 243 | 48.9 | 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);;