contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2780878 | 2780878 | PRJNA1118794_P_NODE_10843_length_431_cov_0.860335_g10095_i0 | PRJNA1118794 | 10843 | 431 | 0.860335 | 3.70804385 | Chlamydiia | 204429 | Bacteria | Bacteria | 267 | 5.69e-84 | NR | KAF3362278.1 | 1910938 | g10095 | i0 | 86.6 | 17.7911832946636 | 142 | 19 | 98.8 | 0 | 6 | 431 | 207 | 348 | KAF3362278.1 Phosphoenolpyruvate carboxykinase [GTP] [Chlamydiales bacterium STE3] | diamond | 7668 | 267 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium STE3 | |||
| 26964014 | 26964014 | PRJNA1118794_P_NODE_72982_length_241_cov_0.916667_g72232_i0 | PRJNA1118794 | 72982 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 129 | 7.29e-33 | NR | MCB1111706.1 | 2052156 | g72232 | i0 | 73.8 | 1.99170124481328 | 80 | 21 | 99.6 | 0 | 241 | 2 | 103 | 182 | MCB1111706.1 NAD+ synthase [Chlamydiia bacterium] | diamond | 480 | 130 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 29026313 | 29026313 | PRJNA1118794_P_NODE_57248_length_248_cov_0.880000_g56498_i0 | PRJNA1118794 | 57248 | 248 | 0.88 | 2.1824 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 86.7 | 1.36e-17 | NR | HNA61571.1 | 2047756 | g56498 | i0 | 47.1 | 1.02822580645161 | 85 | 41 | 98 | 1 | 2 | 244 | 12 | 96 | HNA61571.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 255 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 29269381 | 29269381 | PRJNA1118794_P_NODE_71869_length_242_cov_0.911243_g71119_i0 | PRJNA1118794 | 71869 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 146 | 5.88e-39 | NR | WP_053331979.1 | 340071 | g71119 | i0 | 85 | 61.4628099173554 | 80 | 12 | 99.2 | 0 | 242 | 3 | 201 | 280 | WP_053331979.1 phosphoenolpyruvate carboxykinase (GTP) [Criblamydia sequanensis] | diamond | 14874 | 147 | 0.993197278911565 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Criblamydiaceae | Candidatus Criblamydia | Candidatus Criblamydia sequanensis | |
| 29436174 | 29436174 | PRJNA1118794_P_NODE_74290_length_241_cov_0.916667_g73540_i0 | PRJNA1118794 | 74290 | 241 | 0.916667 | 2.20916747 | Simkania sp. | 34094 | Bacteria | Bacteria | 75.1 | 3.84e-14 | NR | MCB1084310.1 | 34094 | g73540 | i0 | 57.4 | 0.759336099585062 | 61 | 26 | 75.9 | 0 | 241 | 59 | 131 | 191 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 183 | 75.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 30636647 | 30636647 | PRJNA1118794_P_NODE_67133_length_243_cov_1.700000_g66383_i0 | PRJNA1118794 | 67133 | 243 | 1.7 | 4.131 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 80.1 | 2.4e-15 | NR | HEV8051001.1 | 2052176 | g66383 | i0 | 46.3 | 2.96296296296296 | 80 | 43 | 98.8 | 0 | 3 | 242 | 162 | 241 | HEV8051001.1 deoxyribodipyrimidine photo-lyase [Parachlamydiaceae bacterium] | diamond | 720 | 80.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31300413 | 31300413 | PRJNA1118794_P_NODE_75535_length_229_cov_2.474359_g74785_i0 | PRJNA1118794 | 75535 | 229 | 2.474359 | 5.66628211 | Simkania sp. | 34094 | Bacteria | Bacteria | 102 | 1.03e-24 | NR | MCB1084310.1 | 34094 | g74785 | i0 | 60.8 | 0.96943231441048 | 74 | 29 | 96.9 | 0 | 6 | 227 | 108 | 181 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 222 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 31932936 | 31932936 | PRJNA1118794_P_NODE_68997_length_243_cov_0.905882_g68247_i0 | PRJNA1118794 | 68997 | 243 | 0.905882 | 2.20129326 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 48.1 | 4.85e-4 | NR | MBI1870221.1 | 2081524 | g68247 | i0 | 44.3 | 1.49382716049383 | 61 | 26 | 69.1 | 3 | 177 | 10 | 881 | 938 | MBI1870221.1 fibronectin type III domain-containing protein [Chlamydiota bacterium] | diamond | 363 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 32525537 | 32525537 | PRJNA1118794_P_NODE_66759_length_244_cov_0.900585_g66009_i0 | PRJNA1118794 | 66759 | 244 | 0.900585 | 2.1974274 | Chlamydiia | 204429 | Bacteria | Bacteria | 154 | 6.749999999999998e-43 | NR | WP_044881192.1 | 1478175 | g66009 | i0 | 87.5 | 6.88524590163934 | 80 | 10 | 98.4 | 0 | 242 | 3 | 280 | 359 | WP_044881192.1 PhoH family protein [Neochlamydia sp. EPS4] | diamond | 1680 | 154 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Neochlamydia | Neochlamydia sp. EPS4 |
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);;