contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA756891" and tax_phylum = "Candidatus Woesearchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28032177 | 28032177 | PRJNA756891_P_NODE_2405_length_537_cov_1.745690_g2337_i0 | PRJNA756891 | 2405 | 537 | 1.74569 | 9.3743553 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 144 | 1.81e-38 | NR | MBI2546193.1 | 2026803 | g2337 | i0 | 42 | 2 | 174 | 96 | 96.6 | 3 | 522 | 4 | 103 | 272 | MBI2546193.1 GDP-mannose 4,6-dehydratase [Candidatus Woesearchaeota archaeon] | diamond | 1074 | 144 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 31475150 | 31475150 | PRJNA756891_P_NODE_9496_length_283_cov_1.009524_g9427_i0 | PRJNA756891 | 9496 | 283 | 1.009524 | 2.85695292 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 58.9 | 2.02e-8 | NR | MFH1276387.1 | 2026803 | g9427 | i0 | 38.2 | 3.12720848056537 | 89 | 50 | 90.1 | 2 | 27 | 281 | 2 | 89 | MFH1276387.1 vitamin K epoxide reductase family protein [Candidatus Woesearchaeota archaeon] | diamond | 885 | 58.9 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32708141 | 32708141 | PRJNA756891_P_NODE_1920_length_598_cov_1.961905_g1853_i0 | PRJNA756891 | 1920 | 598 | 1.961905 | 11.7321919 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 199 | 5.779999999999999e-55 | NR | MBW2981830.1 | 2026803 | g1853 | i0 | 53 | 1.94147157190635 | 200 | 88 | 99.3 | 6 | 3 | 596 | 796 | 991 | MBW2981830.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Woesearchaeota archaeon] | diamond | 1161 | 199 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota 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);;