contig_metadata
7 rows where bioproject = "PRJNA1031674", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11645415 | 11645415 | PRJNA1031674_P_NODE_4250_length_398_cov_3.415385_g4040_i0 | PRJNA1031674 | 4250 | 398 | 3.415385 | 13.5932323 | Bacteria | 2 | Bacteria | Bacteria | 134 | 1.28e-33 | NR | OJU81857.1 | 1895742 | g4040 | i0 | 86.1 | 15.6859296482412 | 72 | 10 | 54.3 | 0 | 182 | 397 | 236 | 307 | OJU81857.1 MAG: cytochrome o ubiquinol oxidase subunit I [Chlamydia sp. 32-24] | diamond | 6243 | 134 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia sp. 32-24 | |
| 16743640 | 16743640 | PRJNA1031674_P_NODE_21394_length_253_cov_1.711111_g21183_i0 | PRJNA1031674 | 21394 | 253 | 1.711111 | 4.32911083 | uncultured Chlamydiales bacterium | 174324 | Bacteria | Bacteria | 392 | 1.1899999999999997e-104 | NTclustered | gi|260447275|gb|AF448723.3| | 174324 | g21183 | i0 | 94.862 | 104.596837944664 | 253 | 9 | 99 | 4 | 1 | 251 | 438 | 188 | Uncultured Chlamydiales bacterium clone cvE9 16S ribosomal RNA gene, partial sequence | blastn | 26463 | 392 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | uncultured Chlamydiales bacterium | |||
| 20567895 | 20567895 | PRJNA1031674_P_NODE_23897_length_248_cov_0.880000_g23686_i0 | PRJNA1031674 | 23897 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 157 | 2.5899999999999998e-42 | NR | MCC5832877.1 | 2047757 | g23686 | i0 | 93.9 | 33.7258064516129 | 82 | 5 | 99.2 | 0 | 248 | 3 | 434 | 515 | MCC5832877.1 ATP-dependent zinc metalloprotease FtsH [Chlamydiales bacterium] | diamond | 8364 | 157 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 27982721 | 27982721 | PRJNA1031674_P_NODE_25945_length_244_cov_2.000000_g25734_i0 | PRJNA1031674 | 25945 | 244 | 2 | 4.88 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 79.3 | 4.95e-15 | NR | MBX9924012.1 | 2047756 | g25734 | i0 | 93 | 0.528688524590164 | 43 | 3 | 52.9 | 0 | 244 | 116 | 666 | 708 | MBX9924012.1 HDIG domain-containing protein [Rhabdochlamydiaceae bacterium] | diamond | 129 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 29024992 | 29024992 | PRJNA1031674_P_NODE_17688_length_268_cov_1.205128_g17477_i0 | PRJNA1031674 | 17688 | 268 | 1.205128 | 3.22974304 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 171 | 2.77e-49 | NR | MBX9922974.1 | 2047756 | g17477 | i0 | 85.4 | 0.996268656716418 | 89 | 13 | 99.6 | 0 | 1 | 267 | 292 | 380 | MBX9922974.1 response regulator [Rhabdochlamydiaceae bacterium] | diamond | 267 | 171 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 31955226 | 31955226 | PRJNA1031674_P_NODE_11497_length_288_cov_1.776744_g11286_i0 | PRJNA1031674 | 11497 | 288 | 1.776744 | 5.11702272 | Chlamydiia | 204429 | Bacteria | Bacteria | 179 | 1.71e-50 | NR | WP_042243909.1 | 1353976 | g11286 | i0 | 88.2 | 2.90625 | 93 | 11 | 96.9 | 0 | 288 | 10 | 173 | 265 | WP_042243909.1 peptidoglycan D,D-transpeptidase FtsI family protein [Neochlamydia sp. S13] | diamond | 837 | 179 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Neochlamydia | Neochlamydia sp. S13 | |
| 32343265 | 32343265 | PRJNA1031674_P_NODE_21619_length_252_cov_1.743017_g21408_i0 | PRJNA1031674 | 21619 | 252 | 1.743017 | 4.39240284 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 147 | 1.15e-40 | NR | MES2122738.1 | 2081524 | g21408 | i0 | 88.1 | 1 | 84 | 10 | 100 | 0 | 1 | 252 | 270 | 353 | MES2122738.1 LysM peptidoglycan-binding domain-containing protein [Chlamydiota bacterium] | diamond | 252 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota 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);;