contig_metadata
26 rows where bioproject = "PRJNA1028258", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7816154 | 7816154 | PRJNA1028258_P_NODE_137347_length_234_cov_0.860606_g136784_i0 | PRJNA1028258 | 137347 | 234 | 0.860606 | 2.01381804 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 116 | 2.27e-30 | NR | MDR3624404.1 | 2047757 | g136784 | i0 | 71.4 | 5.93589743589744 | 77 | 22 | 98.7 | 0 | 1 | 231 | 20 | 96 | MDR3624404.1 superoxide dismutase [Chlamydiales bacterium] | diamond | 1389 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 16741956 | 16741956 | PRJNA1028258_P_NODE_51654_length_353_cov_2.000000_g51091_i0 | PRJNA1028258 | 51654 | 353 | 2 | 7.06 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 206 | 6.189999999999999e-66 | NR | MCP5470421.1 | 2047757 | g51091 | i0 | 83.8 | 0.994334277620397 | 117 | 19 | 99.4 | 0 | 352 | 2 | 4 | 120 | MCP5470421.1 hypothetical protein [Chlamydiales bacterium] | diamond | 351 | 206 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 27035057 | 27035057 | PRJNA1028258_P_NODE_42162_length_389_cov_2.662500_g41599_i0 | PRJNA1028258 | 42162 | 389 | 2.6625 | 10.357125 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 221 | 1.64e-71 | NR | MCP5470421.1 | 2047757 | g41599 | i0 | 82.9 | 1.98971722365039 | 129 | 22 | 99.5 | 0 | 2 | 388 | 4 | 132 | MCP5470421.1 hypothetical protein [Chlamydiales bacterium] | diamond | 774 | 221 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 27824909 | 27824909 | PRJNA1028258_P_NODE_132844_length_235_cov_0.855422_g132281_i0 | PRJNA1028258 | 132844 | 235 | 0.855422 | 2.0102417 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 81.3 | 6.98e-16 | NR | MBX7066361.1 | 2052178 | g132281 | i0 | 54.8 | 0.931914893617021 | 73 | 33 | 93.2 | 0 | 9 | 227 | 103 | 175 | MBX7066361.1 MFS transporter [Parachlamydiales bacterium] | diamond | 219 | 81.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 28266624 | 28266624 | PRJNA1028258_P_NODE_6446_length_960_cov_3.043771_g6097_i0 | PRJNA1028258 | 6446 | 960 | 3.043771 | 29.2202016 | Simkania sp. | 34094 | Bacteria | Bacteria | 256 | 3.9e-81 | NR | MCB1084310.1 | 34094 | g6097 | i0 | 75.9 | 0.53125 | 170 | 41 | 53.1 | 0 | 710 | 201 | 1 | 170 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 510 | 256 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 28329858 | 28329858 | PRJNA1028258_P_NODE_155866_length_230_cov_0.881988_g155303_i0 | PRJNA1028258 | 155866 | 230 | 0.881988 | 2.0285724 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 42.4 | 0.0434 | NR | MCB1107454.1 | 2052156 | g155303 | i0 | 48.4 | 0.808695652173913 | 62 | 30 | 79.6 | 2 | 215 | 33 | 28 | 88 | MCB1107454.1 hypothetical protein [Chlamydiia bacterium] | diamond | 186 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 28645852 | 28645852 | PRJNA1028258_P_NODE_180607_length_217_cov_2.567568_g180044_i0 | PRJNA1028258 | 180607 | 217 | 2.567568 | 5.57162256 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 90.9 | 2.91e-22 | NR | EPP28937.1 | 1112246 | g180044 | i0 | 96.9 | 0.884792626728111 | 64 | 2 | 88.5 | 0 | 21 | 212 | 1 | 64 | EPP28937.1 hypothetical protein CP082626L3_1649 [Chlamydia psittaci 08-2626_L3] | diamond | 192 | 90.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 28929909 | 28929909 | PRJNA1028258_P_NODE_30168_length_462_cov_2.346056_g29607_i0 | PRJNA1028258 | 30168 | 462 | 2.346056 | 10.83877872 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 143 | 2.12e-40 | NR | MCP5470420.1 | 2047757 | g29607 | i0 | 60.4 | 0.902597402597403 | 139 | 53 | 90.3 | 1 | 2 | 418 | 9 | 145 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 417 | 143 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29087900 | 29087900 | PRJNA1028258_P_NODE_34988_length_428_cov_2.373259_g34425_i0 | PRJNA1028258 | 34988 | 428 | 2.373259 | 10.15754852 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 223 | 2.3799999999999996e-72 | NR | MCP5470421.1 | 2047757 | g34425 | i0 | 83.1 | 1.82242990654206 | 130 | 22 | 91.1 | 0 | 426 | 37 | 3 | 132 | MCP5470421.1 hypothetical protein [Chlamydiales bacterium] | diamond | 780 | 223 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29371984 | 29371984 | PRJNA1028258_P_NODE_26789_length_491_cov_2.018957_g26229_i0 | PRJNA1028258 | 26789 | 491 | 2.018957 | 9.91307887 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 162 | 1.13e-47 | NR | MCP5470420.1 | 2047757 | g26229 | i0 | 60.1 | 0.873727087576375 | 143 | 57 | 87.4 | 0 | 491 | 63 | 5 | 147 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 429 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29592499 | 29592499 | PRJNA1028258_P_NODE_124830_length_240_cov_1.660819_g124267_i0 | PRJNA1028258 | 124830 | 240 | 1.660819 | 3.9859656 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 125 | 6.5e-34 | NR | MFN0065451.1 | 2047757 | g124267 | i0 | 72.6 | 0.9125 | 73 | 20 | 91.3 | 0 | 220 | 2 | 3 | 75 | MFN0065451.1 superoxide dismutase [Chlamydiales bacterium] | diamond | 219 | 125 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29687350 | 29687350 | PRJNA1028258_P_NODE_49930_length_359_cov_1.406897_g49367_i0 | PRJNA1028258 | 49930 | 359 | 1.406897 | 5.05076023 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 87.8 | 3.54e-19 | NR | MCP5470420.1 | 2047757 | g49367 | i0 | 81.8 | 0.459610027855153 | 55 | 10 | 46 | 0 | 357 | 193 | 27 | 81 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 165 | 87.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29782377 | 29782377 | PRJNA1028258_P_NODE_75851_length_296_cov_0.938326_g75288_i0 | PRJNA1028258 | 75851 | 296 | 0.938326 | 2.77744496 | Simkania sp. | 34094 | Bacteria | Bacteria | 166 | 3.93e-49 | NR | MCB1084310.1 | 34094 | g75288 | i0 | 85.7 | 0.993243243243243 | 98 | 14 | 99.3 | 0 | 1 | 294 | 9 | 106 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 294 | 166 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 30003617 | 30003617 | PRJNA1028258_P_NODE_82071_length_284_cov_2.613953_g81508_i0 | PRJNA1028258 | 82071 | 284 | 2.613953 | 7.42362652 | Simkania sp. | 34094 | Bacteria | Bacteria | 103 | 7.85e-25 | NR | MCB1084310.1 | 34094 | g81508 | i0 | 65.8 | 0.77112676056338 | 73 | 25 | 77.1 | 0 | 284 | 66 | 98 | 170 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 219 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 30153287 | 30153287 | PRJNA1028258_P_NODE_50772_length_356_cov_1.731707_g50209_i0 | PRJNA1028258 | 50772 | 356 | 1.731707 | 6.16487692 | root | 1 | Root_unresolved | Root_unresolved | 150 | 9.749999999999999e-43 | NR | MCB1084310.1 | 34094 | g50209 | i0 | 64.1 | 1.98033707865169 | 117 | 42 | 98.6 | 0 | 354 | 4 | 29 | 145 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 705 | 150 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 30161201 | 30161201 | PRJNA1028258_P_NODE_162972_length_228_cov_0.893082_g162409_i0 | PRJNA1028258 | 162972 | 228 | 0.893082 | 2.03622696 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 48.5 | 2.77e-4 | NR | MCE2982390.1 | 2052048 | g162409 | i0 | 38.2 | 1 | 76 | 35 | 88.2 | 2 | 219 | 19 | 74 | 146 | MCE2982390.1 hypothetical protein [Parachlamydia sp.] | diamond | 228 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 30477545 | 30477545 | PRJNA1028258_P_NODE_43713_length_383_cov_1.280255_g43150_i0 | PRJNA1028258 | 43713 | 383 | 1.280255 | 4.90337665 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 186 | 1.06e-57 | NR | MCP5470420.1 | 2047757 | g43150 | i0 | 78.6 | 0.986945169712794 | 126 | 25 | 98.7 | 1 | 381 | 4 | 7 | 130 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 378 | 186 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 30793249 | 30793249 | PRJNA1028258_P_NODE_137114_length_234_cov_0.860606_g136551_i0 | PRJNA1028258 | 137114 | 234 | 0.860606 | 2.01381804 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 93.6 | 4.25e-23 | NR | EPP28276.1 | 1112246 | g136551 | i0 | 90.4 | 0.935897435897436 | 73 | 7 | 93.6 | 0 | 2 | 220 | 3 | 75 | EPP28276.1 putative membrane protein [Chlamydia psittaci 08-2626_L3] | diamond | 219 | 93.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31203642 | 31203642 | PRJNA1028258_P_NODE_35215_length_427_cov_1.351955_g34652_i0 | PRJNA1028258 | 35215 | 427 | 1.351955 | 5.77284785 | Chlamydia psittaci 1 | 83554 | Bacteria | Bacteria | 53.5 | 2.24e-6 | NR | EPP36379.1 | 1238236 | g34652 | i0 | 100 | 0.154566744730679 | 22 | 0 | 15.5 | 0 | 346 | 281 | 1 | 22 | EPP36379.1 hypothetical protein CP10743SC13_1075, partial [Chlamydia psittaci 10_743_SC13] | diamond | 66 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31322610 | 31322610 | PRJNA1028258_P_NODE_165395_length_227_cov_1.797468_g164832_i0 | PRJNA1028258 | 165395 | 227 | 1.797468 | 4.08025236 | root | 1 | Root_unresolved | Root_unresolved | 122 | 1.32e-33 | NR | MCB1084350.1 | 34094 | g164832 | i0 | 71.6 | 1.95594713656388 | 74 | 21 | 97.8 | 0 | 2 | 223 | 1 | 74 | MCB1084350.1 MC/SLC25 family protein [Simkania sp.] | diamond | 444 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 31552232 | 31552232 | PRJNA1028258_P_NODE_127056_length_238_cov_2.100592_g126493_i0 | PRJNA1028258 | 127056 | 238 | 2.100592 | 4.99940896 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 132 | 1.4799999999999998e-37 | NR | MCP5470420.1 | 2047757 | g126493 | i0 | 86.5 | 0.932773109243697 | 74 | 10 | 93.3 | 0 | 1 | 222 | 8 | 81 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 222 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 31646760 | 31646760 | PRJNA1028258_P_NODE_67897_length_311_cov_1.595041_g67334_i0 | PRJNA1028258 | 67897 | 311 | 1.595041 | 4.96057751 | Waddliaceae bacterium | 2026802 | Bacteria | Bacteria | 72 | 3.22e-12 | NR | HEY4831209.1 | 2026802 | g67334 | i0 | 46 | 1.44694533762058 | 87 | 45 | 82 | 1 | 303 | 49 | 266 | 352 | HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium] | diamond | 450 | 72 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Waddliaceae | Waddliaceae bacterium | ||
| 32050232 | 32050232 | PRJNA1028258_P_NODE_57378_length_336_cov_1.329588_g56815_i0 | PRJNA1028258 | 57378 | 336 | 1.329588 | 4.46741568 | root | 1 | Root_unresolved | Root_unresolved | 137 | 5.53e-39 | NR | MCB1084326.1 | 34094 | g56815 | i0 | 77.4 | 3 | 84 | 19 | 75 | 0 | 84 | 335 | 7 | 90 | MCB1084326.1 serine/threonine-protein kinase [Simkania sp.] | diamond | 1008 | 138 | 0.992753623188406 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 32089843 | 32089843 | PRJNA1028258_P_NODE_89198_length_273_cov_1.181373_g88635_i0 | PRJNA1028258 | 89198 | 273 | 1.181373 | 3.22514829 | Chlamydia psittaci 84-8471/1 | 1112230 | Bacteria | Bacteria | 66.2 | 4.58e-12 | NR | EPP35918.1 | 1112230 | g88635 | i0 | 69.6 | 0.505494505494505 | 46 | 14 | 50.5 | 0 | 187 | 50 | 1 | 46 | EPP35918.1 hypothetical protein CP8484711_2945, partial [Chlamydia psittaci 84-8471/1] | diamond | 138 | 66.2 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 32501405 | 32501405 | PRJNA1028258_P_NODE_80419_length_288_cov_0.853881_g79856_i0 | PRJNA1028258 | 80419 | 288 | 0.853881 | 2.45917728 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 68.6 | 2.4e-12 | NR | EPP29195.1 | 1112246 | g79856 | i0 | 95.1 | 0.427083333333333 | 41 | 2 | 42.7 | 0 | 2 | 124 | 6 | 46 | EPP29195.1 putative membrane protein, partial [Chlamydia psittaci 08-2626_L3] | diamond | 123 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 32658525 | 32658525 | PRJNA1028258_P_NODE_136860_length_234_cov_0.860606_g136297_i0 | PRJNA1028258 | 136860 | 234 | 0.860606 | 2.01381804 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 43.1 | 0.0232 | NR | MBM3208012.1 | 2081524 | g136297 | i0 | 36.3 | 1.02564102564103 | 80 | 41 | 97.4 | 4 | 3 | 230 | 130 | 203 | MBM3208012.1 hypothetical protein [Chlamydiota bacterium] | diamond | 240 | 43.1 | 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);;