contig_metadata
4 rows where bioproject = "PRJNA533114", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28877691 | 28877691 | PRJNA533114_P_NODE_97648_length_250_cov_0.870056_g97396_i0 | PRJNA533114 | 97648 | 250 | 0.870056 | 2.17514 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 42.7 | 0.0406 | NR | MEM2129180.1 | 3045160 | g97396 | i0 | 28.4 | 0.888 | 74 | 48 | 82.8 | 1 | 225 | 19 | 376 | 449 | MEM2129180.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] | diamond | 222 | 42.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29587043 | 29587043 | PRJNA533114_P_NODE_108310_length_246_cov_0.861272_g108058_i0 | PRJNA533114 | 108310 | 246 | 0.861272 | 2.11872912 | Candidatus Bathycorpusculum | 3139623 | Archaea | Archaea | 42.7 | 0.0279 | NR | MCL2642081.1 | 2994959 | g108058 | i0 | 31.7 | 1.46341463414634 | 60 | 35 | 68.3 | 2 | 55 | 222 | 118 | 175 | MCL2642081.1 transposase [Candidatus Bathycorpusculum sp.] | diamond | 360 | 42.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeales | Candidatus Bathycorpusculaceae | Candidatus Bathycorpusculum | Candidatus Bathycorpusculum sp. | ||
| 29998043 | 29998043 | PRJNA533114_P_NODE_101071_length_248_cov_1.308571_g100819_i0 | PRJNA533114 | 101071 | 248 | 1.308571 | 3.24525608 | Archaea | 2157 | Archaea | Archaea | 80.1 | 2.53e-15 | NR | MCW4044179.1 | 2026714 | g100819 | i0 | 47.5 | 1.93548387096774 | 80 | 42 | 96.8 | 0 | 3 | 242 | 166 | 245 | MCW4044179.1 SLC13 family permease [Candidatus Bathyarchaeota archaeon] | diamond | 480 | 80.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32100874 | 32100874 | PRJNA533114_P_NODE_84018_length_265_cov_1.364583_g83766_i0 | PRJNA533114 | 84018 | 265 | 1.364583 | 3.61614495 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 53.9 | 5.42e-6 | NR | MEJ2241842.1 | 2026714 | g83766 | i0 | 34.1 | 2.98867924528302 | 88 | 29 | 99.6 | 2 | 1 | 264 | 151 | 209 | MEJ2241842.1 multicopper oxidase domain-containing protein [Candidatus Bathyarchaeota archaeon] | diamond | 792 | 53.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);;