contig_metadata
8 rows where bioproject = "PRJNA489308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14478948 | 14478948 | PRJNA489308_P_NODE_8832_length_372_cov_2.311037_g8756_i0 | PRJNA489308 | 8832 | 372 | 2.311037 | 8.59705764 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 151 | 4.32e-42 | NR | MDP1880507.1 | 2052176 | g8756 | i0 | 62.9 | 5 | 124 | 40 | 100 | 2 | 372 | 1 | 95 | 212 | MDP1880507.1 transaldolase [Parachlamydiaceae bacterium] | diamond | 1860 | 151 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27107777 | 27107777 | PRJNA489308_P_NODE_37122_length_243_cov_0.905882_g37046_i0 | PRJNA489308 | 37122 | 243 | 0.905882 | 2.20129326 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 99.4 | 1.95e-24 | NR | HEV8051452.1 | 2052176 | g37046 | i0 | 59.2 | 2.87654320987654 | 76 | 31 | 93.8 | 0 | 230 | 3 | 15 | 90 | HEV8051452.1 alpha/beta fold hydrolase [Parachlamydiaceae bacterium] | diamond | 699 | 99.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27329352 | 27329352 | PRJNA489308_P_NODE_23843_length_272_cov_1.447236_g23767_i0 | PRJNA489308 | 23843 | 272 | 1.447236 | 3.93648192 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 89.4 | 2.01e-20 | NR | MCX6990841.1 | 2081524 | g23767 | i0 | 51.6 | 2.00735294117647 | 91 | 42 | 99.3 | 2 | 271 | 2 | 2 | 91 | MCX6990841.1 NUDIX domain-containing protein [Chlamydiota bacterium] | diamond | 546 | 89.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 29318381 | 29318381 | PRJNA489308_P_NODE_39069_length_241_cov_0.916667_g38993_i0 | PRJNA489308 | 39069 | 241 | 0.916667 | 2.20916747 | Simkaniaceae bacterium | 2698248 | Bacteria | Bacteria | 68.6 | 2.92e-11 | NR | QVL54756.1 | 2698248 | g38993 | i0 | 50.8 | 1.51867219917012 | 61 | 28 | 73.4 | 2 | 65 | 241 | 447 | 507 | QVL54756.1 MAG: hypothetical protein KFB95_05390 [Simkaniaceae bacterium] | diamond | 366 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkaniaceae bacterium | ||
| 30708214 | 30708214 | PRJNA489308_P_NODE_37934_length_242_cov_0.911243_g37858_i0 | PRJNA489308 | 37934 | 242 | 0.911243 | 2.20520806 | Neochlamydia sp. TUME1 | 1478174 | Bacteria | Bacteria | 50.1 | 6.74e-6 | NR | WP_080502455.1 | 1478174 | g37858 | i0 | 55.3 | 1.16528925619835 | 47 | 21 | 58.3 | 0 | 241 | 101 | 12 | 58 | WP_080502455.1 DUF4116 domain-containing protein [Neochlamydia sp. TUME1] | diamond | 282 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Neochlamydia | Neochlamydia sp. TUME1 | |
| 31862241 | 31862241 | PRJNA489308_P_NODE_20777_length_284_cov_1.317536_g20701_i0 | PRJNA489308 | 20777 | 284 | 1.317536 | 3.74180224 | Bacteria | 2 | Bacteria | Bacteria | 115 | 1.29e-28 | NR | WP_098039151.1 | 483423 | g20701 | i0 | 61.3 | 7.88028169014085 | 93 | 35 | 98.2 | 1 | 284 | 6 | 239 | 330 | WP_098039151.1 redox-regulated ATPase YchF [Estrella lausannensis] | diamond | 2238 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Criblamydiaceae | Estrella | Estrella lausannensis | |
| 32052275 | 32052275 | PRJNA489308_P_NODE_30658_length_251_cov_1.297753_g30582_i0 | PRJNA489308 | 30658 | 251 | 1.297753 | 3.25736003 | Estrella | 483422 | Bacteria | Bacteria | 50.8 | 5.39e-5 | NR | WP_098038465.1 | 483423 | g30582 | i0 | 35.4 | 1.67330677290837 | 65 | 40 | 77.7 | 1 | 248 | 54 | 65 | 127 | WP_098038465.1 hypothetical protein [Estrella lausannensis] | diamond | 420 | 51.2 | 0.9921875 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Criblamydiaceae | Estrella | Estrella lausannensis | |
| 32668471 | 32668471 | PRJNA489308_P_NODE_4240_length_499_cov_5.957746_g4164_i0 | PRJNA489308 | 4240 | 499 | 5.957746 | 29.72915254 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 147 | 1.03e-41 | NR | MCP5470421.1 | 2047757 | g4164 | i0 | 51.9 | 3.60120240480962 | 156 | 69 | 92.6 | 2 | 497 | 36 | 6 | 157 | MCP5470421.1 hypothetical protein [Chlamydiales bacterium] | diamond | 1797 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales 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);;