contig_metadata
3 rows where bioproject = "PRJNA1204310" and tax_phylum = "Candidatus Micrarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4155703 | 4155703 | PRJNA1204310_P_NODE_15744_length_449_cov_1.659574_g15447_i0 | PRJNA1204310 | 15744 | 449 | 1.659574 | 7.45148726 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 188 | 1.47e-53 | NR | MBD3210254.1 | 2250274 | g15447 | i0 | 59.7 | 2.03118040089087 | 149 | 60 | 99.6 | 0 | 2 | 448 | 216 | 364 | MBD3210254.1 ATP citrate synthase [Candidatus Micrarchaeota archaeon] | diamond | 912 | 188 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 18180300 | 18180300 | PRJNA1204310_P_NODE_15095_length_457_cov_1.625000_g14798_i0 | PRJNA1204310 | 15095 | 457 | 1.625 | 7.42625 | Candidatus Bilamarchaeaceae archaeon | 2886391 | Archaea | Archaea | 196 | 5.7900000000000006e-58 | NR | HLC68239.1 | 2886391 | g14798 | i0 | 64.5 | 4.89715536105033 | 152 | 50 | 99.8 | 2 | 1 | 456 | 188 | 335 | HLC68239.1 ATP citrate lyase citrate-binding domain-containing protein [Candidatus Bilamarchaeaceae archaeon] | diamond | 2238 | 196 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Bilamarchaeaceae | Candidatus Bilamarchaeaceae archaeon | |||
| 26597453 | 26597453 | PRJNA1204310_P_NODE_24481_length_371_cov_1.308725_g24184_i0 | PRJNA1204310 | 24481 | 371 | 1.308725 | 4.85536975 | Candidatus Micrarchaeota archaeon CG | 2250274 | Archaea | Archaea | 165 | 2.54e-47 | NR | PIO02069.1 | 1974416 | g24184 | i0 | 63 | 0.962264150943396 | 119 | 44 | 96.2 | 0 | 362 | 6 | 20 | 138 | PIO02069.1 MAG: polyprenyl synthetase [Candidatus Micrarchaeota archaeon CG09_land_8_20_14_0_10_60_16] | diamond | 357 | 165 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon CG09_land_8_20_14_0_10_60_16 |
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);;