contig_metadata
13 rows where bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 860884 | 860884 | PRJNA884104_S_NODE_46161_length_307_cov_1.316239_g45418_i0 | PRJNA884104 | 46161 | 307 | 1.316239 | 4.04085373 | Bacteria | 2 | Bacteria | Bacteria | 120 | 1.3199999999999999e-31 | NR | MCB1114783.1 | 2052156 | g45418 | i0 | 54.9 | 6.8599348534202 | 102 | 42 | 99.7 | 2 | 2 | 307 | 92 | 189 | MCB1114783.1 superoxide dismutase [Chlamydiia bacterium] | diamond | 2106 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 7239404 | 7239404 | PRJNA884104_S_NODE_666_length_2189_cov_7.748110_g527_i1 | PRJNA884104 | 666 | 2189 | 7.74811 | 169.6061279 | root | 1 | Root_unresolved | Root_unresolved | 793 | 8.870000000000001e-281 | NR | WP_059059927.1 | 389348 | g527 | i1 | 63 | 8.31749657377798 | 598 | 211 | 82 | 5 | 296 | 2089 | 3 | 590 | WP_059059927.1 phosphoenolpyruvate carboxykinase (GTP) [Candidatus Protochlamydia naegleriophila] | diamond | 18207 | 793 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 9788375 | 9788375 | PRJNA884104_S_NODE_25208_length_404_cov_1.169184_g24465_i0 | PRJNA884104 | 25208 | 404 | 1.169184 | 4.72350336 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 60.5 | 1.85e-8 | NR | MCB1109477.1 | 2052156 | g24465 | i0 | 49.3 | 1.2029702970297 | 69 | 31 | 48.3 | 2 | 347 | 153 | 69 | 137 | MCB1109477.1 DoxX family membrane protein [Chlamydiia bacterium] | diamond | 486 | 60.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 17439375 | 17439375 | PRJNA884104_S_NODE_634_length_2226_cov_8.100790_g527_i0 | PRJNA884104 | 634 | 2226 | 8.10079 | 180.3235854 | root | 1 | Root_unresolved | Root_unresolved | 784 | 8.680000000000001e-277 | NR | WP_013182645.1 | 71667 | g527 | i0 | 62.8 | 13.0700808625337 | 600 | 213 | 80.7 | 6 | 1931 | 135 | 13 | 603 | WP_013182645.1 phosphoenolpyruvate carboxykinase (GTP) [Waddlia chondrophila] | diamond | 29094 | 788 | 0.99492385786802 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Waddliaceae | Waddlia | Waddlia chondrophila | |
| 26897387 | 26897387 | PRJNA884104_S_NODE_81221_length_244_cov_0.900585_g80478_i0 | PRJNA884104 | 81221 | 244 | 0.900585 | 2.1974274 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 54.7 | 2.11e-6 | NR | MBX7066126.1 | 2052178 | g80478 | i0 | 38 | 0.971311475409836 | 79 | 42 | 97.1 | 2 | 239 | 3 | 134 | 205 | MBX7066126.1 NAD(P)-binding domain-containing protein [Parachlamydiales bacterium] | diamond | 237 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 27308487 | 27308487 | PRJNA884104_S_NODE_42943_length_317_cov_1.262295_g42200_i0 | PRJNA884104 | 42943 | 317 | 1.262295 | 4.00147515 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 94 | 6.33e-20 | NR | MCB1113299.1 | 2052156 | g42200 | i0 | 56.3 | 1.35331230283912 | 71 | 28 | 67.2 | 1 | 312 | 100 | 373 | 440 | MCB1113299.1 deoxyribodipyrimidine photo-lyase [Chlamydiia bacterium] | diamond | 429 | 94 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 28200120 | 28200120 | PRJNA884104_S_NODE_20126_length_449_cov_2.590426_g19383_i0 | PRJNA884104 | 20126 | 449 | 2.590426 | 11.63101274 | Bacteria | 2 | Bacteria | Bacteria | 117 | 6.02e-29 | NR | OGN61875.1 | 1797601 | g19383 | i0 | 41.9 | 1.92427616926503 | 136 | 75 | 90.9 | 2 | 412 | 5 | 121 | 252 | OGN61875.1 MAG: hypothetical protein A3F40_03365 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8] | diamond | 864 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8 | |||||
| 29455016 | 29455016 | PRJNA884104_S_NODE_55150_length_282_cov_1.023923_g54407_i0 | PRJNA884104 | 55150 | 282 | 1.023923 | 2.88746286 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 103 | 1.92e-26 | NR | HSX13502.1 | 2047757 | g54407 | i0 | 63 | 0.776595744680851 | 73 | 25 | 77.7 | 1 | 282 | 64 | 16 | 86 | HSX13502.1 2OG-Fe(II) oxygenase [Chlamydiales bacterium] | diamond | 219 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29612913 | 29612913 | PRJNA884104_S_NODE_39130_length_330_cov_1.603113_g38387_i0 | PRJNA884104 | 39130 | 330 | 1.603113 | 5.2902729 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 100 | 1.85e-24 | NR | MCP5470420.1 | 2047757 | g38387 | i0 | 46.8 | 1.98181818181818 | 109 | 58 | 99.1 | 0 | 328 | 2 | 4 | 112 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 654 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29802669 | 29802669 | PRJNA884104_S_NODE_78991_length_245_cov_0.895349_g78248_i0 | PRJNA884104 | 78991 | 245 | 0.895349 | 2.19360505 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 56.6 | 1.93e-7 | NR | MEI8365440.1 | 2052176 | g78248 | i0 | 57.1 | 1.07755102040816 | 42 | 18 | 51.4 | 0 | 243 | 118 | 150 | 191 | MEI8365440.1 HD domain-containing protein [Parachlamydiaceae bacterium] | diamond | 264 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 30876888 | 30876888 | PRJNA884104_S_NODE_44854_length_311_cov_1.268908_g44111_i0 | PRJNA884104 | 44854 | 311 | 1.268908 | 3.94630388 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 44.3 | 0.0226 | NR | MCB1108406.1 | 2052156 | g44111 | i0 | 35.5 | 2.86495176848875 | 76 | 48 | 72.3 | 1 | 235 | 11 | 42 | 117 | MCB1108406.1 hypothetical protein [Chlamydiia bacterium] | diamond | 891 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 31160902 | 31160902 | PRJNA884104_S_NODE_45555_length_309_cov_0.978814_g44812_i0 | PRJNA884104 | 45555 | 309 | 0.978814 | 3.02453526 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 43.5 | 0.0426 | NR | HEY2811008.1 | 2047756 | g44812 | i0 | 51.2 | 0.398058252427184 | 41 | 20 | 39.8 | 0 | 174 | 296 | 6 | 46 | HEY2811008.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 123 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 31287577 | 31287577 | PRJNA884104_S_NODE_16535_length_494_cov_4.923990_g15797_i0 | PRJNA884104 | 16535 | 494 | 4.92399 | 24.3245106 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 147 | 4.959999999999998e-42 | NR | MCP5470421.1 | 2047757 | g15797 | i0 | 51.9 | 3.63765182186235 | 156 | 69 | 93.5 | 2 | 483 | 22 | 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);;