contig_metadata
4 rows where bioproject = "PRJNA756891", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28063576 | 28063576 | PRJNA756891_P_NODE_5185_length_372_cov_1.030100_g5116_i0 | PRJNA756891 | 5185 | 372 | 1.0301 | 3.831972 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 102 | 1.36e-23 | NR | MCO4780973.1 | 2030808 | g5116 | i0 | 43.1 | 0.991935483870968 | 123 | 69 | 99.2 | 1 | 369 | 1 | 70 | 191 | MCO4780973.1 succinylglutamate desuccinylase/aspartoacylase family protein [Candidatus Cloacimonadota bacterium] | diamond | 369 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 28442671 | 28442671 | PRJNA756891_P_NODE_1566_length_655_cov_1.805842_g1501_i0 | PRJNA756891 | 1566 | 655 | 1.805842 | 11.8282651 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 142 | 1.5299999999999998e-37 | NR | PCJ19601.1 | 2030808 | g1501 | i0 | 40.4 | 1.74503816793893 | 188 | 105 | 86.1 | 2 | 631 | 68 | 92 | 272 | PCJ19601.1 MAG: hypothetical protein COB02_07595 [Candidatus Cloacimonadota bacterium] | diamond | 1143 | 142 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 32107683 | 32107683 | PRJNA756891_P_NODE_4778_length_386_cov_0.984026_g4709_i0 | PRJNA756891 | 4778 | 386 | 0.984026 | 3.79834036 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 176 | 1.54e-49 | NR | MCF7792764.1 | 2030808 | g4709 | i0 | 68.5 | 6.93264248704663 | 127 | 40 | 98.7 | 0 | 5 | 385 | 408 | 534 | MCF7792764.1 AMP-binding protein [Candidatus Cloacimonadota bacterium] | diamond | 2676 | 176 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 32613726 | 32613726 | PRJNA756891_P_NODE_4780_length_386_cov_0.923323_g4711_i0 | PRJNA756891 | 4780 | 386 | 0.923323 | 3.56402678 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 157 | 9.709999999999997e-43 | NR | PID28562.1 | 2030808 | g4711 | i0 | 58.1 | 0.963730569948187 | 124 | 51 | 96.4 | 1 | 2 | 373 | 328 | 450 | PID28562.1 MAG: 1-pyrroline-5-carboxylate dehydrogenase [Candidatus Cloacimonadota bacterium] | diamond | 372 | 157 | 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);;