contig_metadata
8 rows where bioproject = "PRJNA505329", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27013749 | 27013749 | PRJNA505329_P_NODE_39882_length_172_cov_1.674797_g39411_i0 | PRJNA505329 | 39882 | 172 | 1.674797 | 2.88065084 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 62.4 | 1.44e-9 | NR | MDP3791097.1 | 2035772 | g39411 | i0 | 68.2 | 0.767441860465116 | 44 | 14 | 76.7 | 0 | 4 | 135 | 102 | 145 | MDP3791097.1 transposase [Candidatus Omnitrophota bacterium] | diamond | 132 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27456507 | 27456507 | PRJNA505329_P_NODE_28283_length_190_cov_1.290780_g27812_i0 | PRJNA505329 | 28283 | 190 | 1.29078 | 2.452482 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 52.8 | 5.4e-6 | NR | HQP10524.1 | 2035772 | g27812 | i0 | 55 | 1.27894736842105 | 40 | 18 | 63.2 | 0 | 190 | 71 | 528 | 567 | HQP10524.1 insulinase family protein [Candidatus Omnitrophota bacterium] | diamond | 243 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28308892 | 28308892 | PRJNA505329_P_NODE_48166_length_163_cov_2.692982_g47695_i0 | PRJNA505329 | 48166 | 163 | 2.692982 | 4.38956066 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 43.1 | 0.00956 | NR | MCA9403135.1 | 2035772 | g47695 | i0 | 41.2 | 1.87730061349693 | 51 | 29 | 93.9 | 1 | 160 | 8 | 2546 | 2595 | MCA9403135.1 peptidoglycan DD-metalloendopeptidase family protein [Candidatus Omnitrophota bacterium] | diamond | 306 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30330323 | 30330323 | PRJNA505329_P_NODE_16732_length_231_cov_3.675824_g16261_i0 | PRJNA505329 | 16732 | 231 | 3.675824 | 8.49115344 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 65.5 | 2.12e-11 | NR | MDP2654438.1 | 2035772 | g16261 | i0 | 49.3 | 1.94805194805195 | 75 | 33 | 97.4 | 1 | 229 | 5 | 20 | 89 | MDP2654438.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 450 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31435875 | 31435875 | PRJNA505329_P_NODE_46876_length_165_cov_0.896552_g46405_i0 | PRJNA505329 | 46876 | 165 | 0.896552 | 1.4793108 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 53.5 | 1.99e-6 | NR | HBG60449.1 | 2035772 | g46405 | i0 | 50 | 2.72727272727273 | 50 | 24 | 90.9 | 1 | 152 | 3 | 712 | 760 | HBG60449.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 450 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31688891 | 31688891 | PRJNA505329_P_NODE_28737_length_189_cov_1.828571_g28266_i0 | PRJNA505329 | 28737 | 189 | 1.828571 | 3.45599919 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 98.2 | 1.09e-22 | NR | HNV85595.1 | 2035772 | g28266 | i0 | 83.1 | 0.936507936507937 | 59 | 10 | 93.7 | 0 | 12 | 188 | 103 | 161 | HNV85595.1 TRAM domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 177 | 98.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32448553 | 32448553 | PRJNA505329_P_NODE_39019_length_173_cov_2.483871_g38548_i0 | PRJNA505329 | 39019 | 173 | 2.483871 | 4.29709683 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 119 | 5.829999999999999e-31 | NR | MBI4972032.1 | 2035772 | g38548 | i0 | 96.4 | 0.971098265895954 | 56 | 2 | 97.1 | 0 | 5 | 172 | 118 | 173 | MBI4972032.1 sugar ABC transporter permease [Candidatus Omnitrophota bacterium] | diamond | 168 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32763687 | 32763687 | PRJNA505329_P_NODE_34640_length_180_cov_2.167939_g34169_i0 | PRJNA505329 | 34640 | 180 | 2.167939 | 3.9022902 | Omnitrophica bacterium RIFCSPHIGHO2_ | 2035772 | Bacteria | Bacteria | 76.3 | 2.89e-16 | NR | OGW80638.1 | 1801823 | g34169 | i0 | 63.8 | 1.93333333333333 | 58 | 21 | 96.7 | 0 | 4 | 177 | 39 | 96 | OGW80638.1 MAG: hypothetical protein A3C47_00185 [Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18] | diamond | 348 | 76.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18 |
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);;