contig_metadata
7 rows where bioproject = "PRJNA737474", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32919430 | 32919430 | PRJNA737474f_S_NODE_143753_length_269_cov_1.551020_g143075_i0 | PRJNA737474 | 143753 | 269 | 1.55102 | 4.1722438 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 70.9 | 3.28e-12 | NR | HNV87256.1 | 2035772 | g143075 | i0 | 43.5 | 0.947955390334573 | 85 | 42 | 93.7 | 2 | 3 | 254 | 199 | 278 | HNV87256.1 class I SAM-dependent methyltransferase [Candidatus Omnitrophota bacterium] | diamond | 255 | 70.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32936139 | 32936139 | PRJNA737474d_S_NODE_33553_length_263_cov_2.126316_g32959_i0 | PRJNA737474 | 33553 | 263 | 2.126316 | 5.59221108 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 69.7 | 1.51e-11 | NR | MDD5500475.1 | 2035772 | g32959 | i0 | 50.8 | 4.47148288973384 | 65 | 32 | 74.1 | 0 | 260 | 66 | 524 | 588 | MDD5500475.1 ABC transporter ATP-binding protein [Candidatus Omnitrophota bacterium] | diamond | 1176 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32975845 | 32975845 | PRJNA737474d_S_NODE_27394_length_291_cov_2.458716_g26800_i0 | PRJNA737474 | 27394 | 291 | 2.458716 | 7.15486356 | Bacteria | 2 | Bacteria | Bacteria | 44.7 | 0.0144 | NR | MBP9853305.1 | 2035772 | g26800 | i0 | 53.5 | 2.58762886597938 | 43 | 20 | 44.3 | 0 | 45 | 173 | 3340 | 3382 | MBP9853305.1 AAA family ATPase [Candidatus Omnitrophota bacterium] | diamond | 753 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33039406 | 33039406 | PRJNA737474f_S_NODE_38612_length_366_cov_1.361775_g37934_i0 | PRJNA737474 | 38612 | 366 | 1.361775 | 4.9840965 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 72.8 | 4.89e-13 | NR | NQU73862.1 | 2035772 | g37934 | i0 | 33.1 | 3.07377049180328 | 127 | 70 | 100 | 3 | 366 | 1 | 64 | 180 | NQU73862.1 RNA 2',3'-cyclic phosphodiesterase [Candidatus Omnitrophota bacterium] | diamond | 1125 | 72.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33039571 | 33039571 | PRJNA737474f_S_NODE_81460_length_304_cov_1.341991_g80782_i0 | PRJNA737474 | 81460 | 304 | 1.341991 | 4.07965264 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 59.7 | 8.08e-8 | NR | MDA9101352.1 | 2035772 | g80782 | i0 | 36.4 | 1.79605263157895 | 88 | 56 | 86.8 | 0 | 18 | 281 | 39 | 126 | MDA9101352.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 546 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33108035 | 33108035 | PRJNA737474g_S_NODE_157302_length_293_cov_1.290909_g156008_i0 | PRJNA737474 | 157302 | 293 | 1.290909 | 3.78236337 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 50.1 | 1.55e-4 | NR | HNV87256.1 | 2035772 | g156008 | i0 | 44.3 | 0.62457337883959 | 61 | 28 | 61.4 | 2 | 34 | 213 | 221 | 276 | HNV87256.1 class I SAM-dependent methyltransferase [Candidatus Omnitrophota bacterium] | diamond | 183 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33129347 | 33129347 | PRJNA737474d_S_NODE_7783_length_557_cov_11.981405_g7214_i0 | PRJNA737474 | 7783 | 557 | 11.981405 | 66.73642585 | PVC group | 1783257 | Bacteria | Bacteria | 53.9 | 1.11e-4 | NR | OGX39691.1 | 1801861 | g7214 | i0 | 31.3 | 1.40035906642729 | 131 | 77 | 67.9 | 3 | 511 | 134 | 1363 | 1485 | OGX39691.1 MAG: hypothetical protein A3C53_05575 [Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_68_15] | diamond | 780 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_68_15 |
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);;