contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Candidatus Cloacimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26859952 | 26859952 | PRJNA641707_P_NODE_205541_length_196_cov_8.421769_g202878_i0 | PRJNA641707 | 205541 | 196 | 8.421769 | 16.50666724 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 127 | 3.26e-32 | NR | NLO11442.1 | 2030808 | g202878 | i0 | 77.1 | 1.27040816326531 | 83 | 0 | 98 | 1 | 5 | 196 | 2131 | 2213 | NLO11442.1 choice-of-anchor D domain-containing protein [Candidatus Cloacimonadota bacterium] | diamond | 249 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 28502324 | 28502324 | PRJNA641707_P_NODE_210307_length_195_cov_8.945205_g207644_i0 | PRJNA641707 | 210307 | 195 | 8.945205 | 17.44314975 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 108 | 6.45e-26 | NR | NLO11727.1 | 2030808 | g207644 | i0 | 69 | 1.33846153846154 | 87 | 1 | 93.8 | 1 | 12 | 194 | 1 | 87 | NLO11727.1 acyl-CoA carboxylase subunit beta [Candidatus Cloacimonadota bacterium] | diamond | 261 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 29133892 | 29133892 | PRJNA641707_P_NODE_137769_length_242_cov_7.720207_g135106_i0 | PRJNA641707 | 137769 | 242 | 7.720207 | 18.68290094 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 51.6 | 2.76e-5 | NR | MCK9329919.1 | 2030808 | g135106 | i0 | 76.7 | 0.743801652892562 | 30 | 7 | 37.2 | 0 | 151 | 240 | 590 | 619 | MCK9329919.1 heavy metal translocating P-type ATPase [Candidatus Cloacimonadota bacterium] | diamond | 180 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 29291604 | 29291604 | PRJNA641707_P_NODE_259649_length_178_cov_5.736434_g256986_i0 | PRJNA641707 | 259649 | 178 | 5.736434 | 10.21085252 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 60.5 | 7.14e-9 | NR | MDA3813860.1 | 2030808 | g256986 | i0 | 55.3 | 2.39325842696629 | 47 | 21 | 79.2 | 0 | 9 | 149 | 192 | 238 | MDA3813860.1 aminotransferase class V-fold PLP-dependent enzyme [Candidatus Cloacimonadota bacterium] | diamond | 426 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium |
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);;