contig_metadata
7 rows where bioproject = "PRJNA454503", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18294431 | 18294431 | PRJNA454503_P_NODE_72295_length_206_cov_0.896552_g71966_i0 | PRJNA454503 | 72295 | 206 | 0.896552 | 1.84689712 | Parachlamydia sp. AcF125 | 2795736 | Bacteria | Bacteria | 59.3 | 3.23e-8 | NR | WP_213156828.1 | 2795736 | g71966 | i0 | 49.4 | 2.22815533980583 | 77 | 30 | 99 | 3 | 205 | 2 | 36 | 112 | WP_213156828.1 RNA polymerase factor sigma-54 [Parachlamydia sp. AcF125] | diamond | 459 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. AcF125 | |
| 28970972 | 28970972 | PRJNA454503_P_NODE_6908_length_429_cov_2.331522_g6579_i0 | PRJNA454503 | 6908 | 429 | 2.331522 | 10.00222938 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 56.6 | 7.46e-8 | NR | EPJ33784.1 | 1112244 | g6579 | i0 | 90.2 | 0.286713286713287 | 41 | 4 | 28.7 | 0 | 325 | 203 | 1 | 41 | EPJ33784.1 hypothetical protein CP061683_1943, partial [Chlamydia psittaci 06-1683] | diamond | 123 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 29050393 | 29050393 | PRJNA454503_P_NODE_76748_length_204_cov_1.818182_g76419_i0 | PRJNA454503 | 76748 | 204 | 1.818182 | 3.70909128 | Chlamydia | 810 | Bacteria | Bacteria | 60.5 | 2.53e-10 | NR | EPJ32822.1 | 1112244 | g76419 | i0 | 77.8 | 1.41176470588235 | 36 | 8 | 52.9 | 0 | 202 | 95 | 9 | 44 | EPJ32822.1 hypothetical protein CP061683_2581, partial [Chlamydia psittaci 06-1683] | diamond | 288 | 60.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 29507603 | 29507603 | PRJNA454503_P_NODE_66070_length_208_cov_0.884354_g65741_i0 | PRJNA454503 | 66070 | 208 | 0.884354 | 1.83945632 | Chlamydia psittaci 1 | 83554 | Bacteria | Bacteria | 115 | 4.4899999999999997e-32 | NR | EPP35796.1 | 1238236 | g65741 | i0 | 92.3 | 0.9375 | 65 | 5 | 93.8 | 0 | 1 | 195 | 12 | 76 | EPP35796.1 putative membrane protein, partial [Chlamydia psittaci 10_743_SC13] | diamond | 195 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31118537 | 31118537 | PRJNA454503_P_NODE_22615_length_258_cov_2.700508_g22286_i0 | PRJNA454503 | 22615 | 258 | 2.700508 | 6.96731064 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 86.7 | 1.47e-20 | NR | EPJ33125.1 | 1112244 | g22286 | i0 | 97.5 | 0.465116279069767 | 40 | 1 | 46.5 | 0 | 21 | 140 | 1 | 40 | EPJ33125.1 hypothetical protein CP061683_1974, partial [Chlamydia psittaci 06-1683] | diamond | 120 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31340070 | 31340070 | PRJNA454503_P_NODE_73996_length_205_cov_1.326389_g73667_i0 | PRJNA454503 | 73996 | 205 | 1.326389 | 2.71909745 | Chlamydia psittaci 84-8471/1 | 1112230 | Bacteria | Bacteria | 48.1 | 1.78e-5 | NR | EPP30210.1 | 1112230 | g73667 | i0 | 95.5 | 0.321951219512195 | 22 | 1 | 32.2 | 0 | 139 | 204 | 1 | 22 | EPP30210.1 putative membrane protein, partial [Chlamydia psittaci 84-8471/1] | diamond | 66 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31593338 | 31593338 | PRJNA454503_P_NODE_19996_length_268_cov_3.024155_g19667_i0 | PRJNA454503 | 19996 | 268 | 3.024155 | 8.1047354 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 75.9 | 2.87e-16 | NR | EPP29147.1 | 1112246 | g19667 | i0 | 100 | 0.391791044776119 | 35 | 0 | 39.2 | 0 | 266 | 162 | 6 | 40 | EPP29147.1 hypothetical protein CP082626L3_1338, partial [Chlamydia psittaci 08-2626_L3] | diamond | 105 | 75.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci |
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);;