contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA770826" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6310763 | 6310763 | PRJNA770826_P_NODE_5845_length_348_cov_1.217391_g5674_i0 | PRJNA770826 | 5845 | 348 | 1.217391 | 4.23652068 | Bacteria | 2 | Bacteria | Bacteria | 135 | 2.73e-34 | NR | MBN1493660.1 | 2035772 | g5674 | i0 | 58.9 | 3.82758620689655 | 112 | 45 | 96.6 | 1 | 338 | 3 | 652 | 762 | MBN1493660.1 pyruvate, phosphate dikinase [Candidatus Omnitrophota bacterium] | diamond | 1332 | 135 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 24973555 | 24973555 | PRJNA770826_P_NODE_37740_length_164_cov_0.904348_g37569_i0 | PRJNA770826 | 37740 | 164 | 0.904348 | 1.48313072 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 104 | 2.32e-24 | NR | MCX5712880.1 | 2035772 | g37569 | i0 | 87 | 5.92682926829268 | 54 | 7 | 98.8 | 0 | 1 | 162 | 282 | 335 | MCX5712880.1 glucose-6-phosphate isomerase [Candidatus Omnitrophota bacterium] | diamond | 972 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 26831815 | 26831815 | PRJNA770826_P_NODE_19221_length_185_cov_1.147059_g19050_i0 | PRJNA770826 | 19221 | 185 | 1.147059 | 2.12205915 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 61.2 | 1.26e-10 | NR | MEA3305771.1 | 2035772 | g19050 | i0 | 67.4 | 2.27027027027027 | 46 | 15 | 74.6 | 0 | 183 | 46 | 16 | 61 | MEA3305771.1 RNA-binding protein [Candidatus Omnitrophota bacterium] | diamond | 420 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28095575 | 28095575 | PRJNA770826_P_NODE_33505_length_165_cov_1.387931_g33334_i0 | PRJNA770826 | 33505 | 165 | 1.387931 | 2.29008615 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 73.9 | 1.27e-13 | NR | MBU1913507.1 | 2035772 | g33334 | i0 | 63 | 0.981818181818182 | 54 | 20 | 98.2 | 0 | 3 | 164 | 1664 | 1717 | MBU1913507.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 162 | 73.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29137756 | 29137756 | PRJNA770826_P_NODE_12229_length_230_cov_1.149171_g12058_i0 | PRJNA770826 | 12229 | 230 | 1.149171 | 2.6430933 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 62.4 | 3.82e-9 | NR | NQU74025.1 | 2035772 | g12058 | i0 | 44.4 | 1.59130434782609 | 63 | 35 | 82.2 | 0 | 4 | 192 | 972 | 1034 | NQU74025.1 methyltransferase domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 366 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30653407 | 30653407 | PRJNA770826_P_NODE_18353_length_189_cov_1.114286_g18182_i0 | PRJNA770826 | 18353 | 189 | 1.114286 | 2.10600054 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 51.2 | 1.86e-5 | NR | MCB9719623.1 | 2035772 | g18182 | i0 | 43.1 | 2.06349206349206 | 65 | 29 | 90.5 | 2 | 188 | 18 | 3435 | 3499 | MCB9719623.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 390 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota 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);;