contig_metadata
26 rows where bioproject = "PRJNA939415", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3808605 | 3808605 | PRJNA939415_P_NODE_56603_length_277_cov_2.181373_g56181_i0 | PRJNA939415 | 56603 | 277 | 2.181373 | 6.04240321 | Waddlia | 71666 | Bacteria | Bacteria | 76.8 | 1.51e-9 | NTclustered | gi|297375547|gb|CP001928.1| | 716544 | g56181 | i0 | 92.453 | 26.7545126353791 | 53 | 4 | 19 | 0 | 82 | 134 | 1439021 | 1439073 | Waddlia chondrophila WSU 86-1044, complete genome | blastn | 7411 | 76.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Waddliaceae | Waddlia | Waddlia chondrophila | |
| 6019054 | 6019054 | PRJNA939415_P_NODE_60765_length_273_cov_1.970000_g60343_i0 | PRJNA939415 | 60765 | 273 | 1.97 | 5.3781 | uncultured Chlamydiae bacterium | 305355 | Bacteria | Bacteria | 108 | 5.27e-19 | NTclustered | gi|2874254045|emb|OY970369.1| | 305355 | g60343 | i0 | 100 | 3.91575091575092 | 58 | 0 | 21 | 0 | 1 | 58 | 779975 | 779918 | MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1 | blastn | 1069 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | uncultured Chlamydiae bacterium | ||||
| 26803458 | 26803458 | PRJNA939415_P_NODE_49421_length_284_cov_2.450237_g48999_i0 | PRJNA939415 | 49421 | 284 | 2.450237 | 6.95867308 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 70.5 | 2.34e-12 | NR | MBJ7449244.1 | 2052178 | g48999 | i0 | 38.6 | 0.929577464788732 | 88 | 54 | 93 | 0 | 12 | 275 | 72 | 159 | MBJ7449244.1 hypothetical protein [Parachlamydiales bacterium] | diamond | 264 | 70.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 27341387 | 27341387 | PRJNA939415_P_NODE_97983_length_237_cov_6.353659_g97561_i0 | PRJNA939415 | 97983 | 237 | 6.353659 | 15.05817183 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 70.1 | 8.22e-12 | NR | MDR3624009.1 | 2047757 | g97561 | i0 | 43.4 | 1.92405063291139 | 76 | 43 | 96.2 | 0 | 237 | 10 | 563 | 638 | MDR3624009.1 insulinase family protein [Chlamydiales bacterium] | diamond | 456 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 27379913 | 27379913 | PRJNA939415_P_NODE_59203_length_274_cov_3.786070_g58781_i0 | PRJNA939415 | 59203 | 274 | 3.78607 | 10.3738318 | Parachlamydiaceae | 92713 | Bacteria | Bacteria | 115 | 1.4e-27 | NR | WP_059062666.1 | 389348 | g58781 | i0 | 61.5 | 3.90875912408759 | 91 | 34 | 99.6 | 1 | 273 | 1 | 318 | 407 | WP_059062666.1 type IV conjugative transfer system coupling protein TraD [Candidatus Protochlamydia naegleriophila] | diamond | 1071 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 27814983 | 27814983 | PRJNA939415_P_NODE_106064_length_224_cov_5.529801_g105642_i0 | PRJNA939415 | 106064 | 224 | 5.529801 | 12.38675424 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 69.7 | 3.02e-12 | NR | WP_059060319.1 | 389348 | g105642 | i0 | 62.2 | 1.84821428571429 | 45 | 17 | 60.3 | 0 | 137 | 3 | 5 | 49 | WP_059060319.1 SDR family NAD(P)-dependent oxidoreductase [Candidatus Protochlamydia naegleriophila] | diamond | 414 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 28130719 | 28130719 | PRJNA939415_P_NODE_67465_length_266_cov_2.782383_g67043_i0 | PRJNA939415 | 67465 | 266 | 2.782383 | 7.40113878 | Candidatus Protochlamydia phocaeensis | 1414722 | Bacteria | Bacteria | 142 | 3.6399999999999997e-40 | NR | WP_068471218.1 | 1414722 | g67043 | i0 | 76.1 | 1.98496240601504 | 88 | 20 | 98.1 | 1 | 261 | 1 | 115 | 202 | WP_068471218.1 DsbA family protein [Candidatus Protochlamydia phocaeensis] | diamond | 528 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia phocaeensis | |
| 28162253 | 28162253 | PRJNA939415_P_NODE_36785_length_298_cov_3.977778_g36363_i0 | PRJNA939415 | 36785 | 298 | 3.977778 | 11.85377844 | Chlamydiae bacterium CG1 | 2081524 | Bacteria | Bacteria | 156 | 3.63e-44 | NR | PIS02181.1 | 1973936 | g36363 | i0 | 78.8 | 1.98322147651007 | 99 | 21 | 99.7 | 0 | 2 | 298 | 163 | 261 | PIS02181.1 MAG: aminotransferase class V-fold PLP-dependent enzyme [Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_42_34] | diamond | 591 | 156 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_42_34 | |||||
| 28761994 | 28761994 | PRJNA939415_P_NODE_98807_length_236_cov_4.349693_g98385_i0 | PRJNA939415 | 98807 | 236 | 4.349693 | 10.26527548 | Chlamydia trachomatis | 813 | Bacteria | Bacteria | 151 | 7.94e-44 | NR | CQB88612.1 | 813 | g98385 | i0 | 97.4 | 0.991525423728814 | 78 | 2 | 99.2 | 0 | 234 | 1 | 70 | 147 | CQB88612.1 Uncharacterised protein [Chlamydia trachomatis] | diamond | 234 | 151 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis | |
| 28800304 | 28800304 | PRJNA939415_P_NODE_108207_length_214_cov_6.418440_g107785_i0 | PRJNA939415 | 108207 | 214 | 6.41844 | 13.7354616 | Candidatus Protochlamydia | 282132 | Bacteria | Bacteria | 112 | 8.78e-27 | NR | WP_213106205.1 | 362787 | g107785 | i0 | 77.1 | 3.91121495327103 | 70 | 16 | 98.1 | 0 | 212 | 3 | 230 | 299 | WP_213106205.1 translation elongation factor 4 [Candidatus Protochlamydia amoebophila] | diamond | 837 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia amoebophila | |
| 28888296 | 28888296 | PRJNA939415_P_NODE_91248_length_244_cov_3.473684_g90826_i0 | PRJNA939415 | 91248 | 244 | 3.473684 | 8.47578896 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 82 | 5.38e-16 | NR | MBA3817192.1 | 2052176 | g90826 | i0 | 47.5 | 0.983606557377049 | 80 | 42 | 98.4 | 0 | 242 | 3 | 573 | 652 | MBA3817192.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 240 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 29141182 | 29141182 | PRJNA939415_P_NODE_70349_length_263_cov_3.342105_g69927_i0 | PRJNA939415 | 70349 | 263 | 3.342105 | 8.78973615 | Chlamydiae bacterium CG1 | 2081524 | Bacteria | Bacteria | 112 | 3.18e-27 | NR | PIS02461.1 | 1973936 | g69927 | i0 | 66.3 | 1.97338403041825 | 86 | 29 | 98.1 | 0 | 1 | 258 | 178 | 263 | PIS02461.1 MAG: M18 family aminopeptidase [Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_42_34] | diamond | 519 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_42_34 | |||||
| 29204316 | 29204316 | PRJNA939415_P_NODE_97489_length_238_cov_3.939394_g97067_i0 | PRJNA939415 | 97489 | 238 | 3.939394 | 9.37575772 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 56.6 | 1.18e-7 | NR | WP_059062463.1 | 389348 | g97067 | i0 | 47.5 | 1.5 | 59 | 29 | 71.8 | 2 | 1 | 171 | 88 | 146 | WP_059062463.1 disulfide bond formation protein B [Candidatus Protochlamydia naegleriophila] | diamond | 357 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 29740608 | 29740608 | PRJNA939415_P_NODE_83730_length_250_cov_3.587571_g83308_i0 | PRJNA939415 | 83730 | 250 | 3.587571 | 8.9689275 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 58.9 | 6.83e-8 | NR | MCB1181773.1 | 2052156 | g83308 | i0 | 49.3 | 0.804 | 67 | 31 | 80.4 | 1 | 248 | 48 | 247 | 310 | MCB1181773.1 IS3 family transposase [Chlamydiia bacterium] | diamond | 201 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 30025203 | 30025203 | PRJNA939415_P_NODE_109751_length_207_cov_7.589552_g109329_i0 | PRJNA939415 | 109751 | 207 | 7.589552 | 15.71037264 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 50.1 | 4.4e-5 | NR | MDR3625037.1 | 2047757 | g109329 | i0 | 40.6 | 1 | 69 | 40 | 98.6 | 1 | 4 | 207 | 13 | 81 | MDR3625037.1 LysM peptidoglycan-binding domain-containing protein [Chlamydiales bacterium] | diamond | 207 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 30025236 | 30025236 | PRJNA939415_P_NODE_29531_length_310_cov_3.324895_g29109_i0 | PRJNA939415 | 29531 | 310 | 3.324895 | 10.3071745 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 81.6 | 1.82e-15 | NR | HRD56308.1 | 2052176 | g29109 | i0 | 38.9 | 2.09032258064516 | 113 | 57 | 97.7 | 1 | 5 | 307 | 257 | 369 | HRD56308.1 type II secretion system protein GspD [Parachlamydiaceae bacterium] | diamond | 648 | 81.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 30032136 | 30032136 | PRJNA939415_P_NODE_74951_length_259_cov_2.145161_g74529_i0 | PRJNA939415 | 74951 | 259 | 2.145161 | 5.55596699 | Chlamydiia | 204429 | Bacteria | Bacteria | 147 | 5.28e-41 | NR | MDR3624062.1 | 2047757 | g74529 | i0 | 89.5 | 1.99227799227799 | 86 | 9 | 99.6 | 0 | 1 | 258 | 259 | 344 | MDR3624062.1 DNA-directed RNA polymerase subunit alpha [Chlamydiales bacterium] | diamond | 516 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 30214514 | 30214514 | PRJNA939415_P_NODE_58212_length_275_cov_3.747525_g57790_i0 | PRJNA939415 | 58212 | 275 | 3.747525 | 10.30569375 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 80.9 | 2.19e-15 | NR | MFI5343001.1 | 2047757 | g57790 | i0 | 52.1 | 1.04727272727273 | 96 | 40 | 98.2 | 2 | 271 | 2 | 1643 | 1738 | MFI5343001.1 alpha-2-macroglobulin [Chlamydiales bacterium] | diamond | 288 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 31169255 | 31169255 | PRJNA939415_P_NODE_70435_length_263_cov_3.021053_g70013_i0 | PRJNA939415 | 70435 | 263 | 3.021053 | 7.94536939 | Chlamydiia | 204429 | Bacteria | Bacteria | 114 | 8.39e-28 | NR | MDR3624088.1 | 2047757 | g70013 | i0 | 63.2 | 6.86692015209125 | 87 | 32 | 99.2 | 0 | 261 | 1 | 179 | 265 | MDR3624088.1 sodium-dependent transporter [Chlamydiales bacterium] | diamond | 1806 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 31257374 | 31257374 | PRJNA939415_P_NODE_67935_length_266_cov_1.388601_g67513_i0 | PRJNA939415 | 67935 | 266 | 1.388601 | 3.69367866 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 43.1 | 0.0366 | NR | PJD94528.1 | 2052048 | g67513 | i0 | 34.3 | 0.755639097744361 | 67 | 43 | 74.4 | 1 | 2 | 199 | 728 | 794 | PJD94528.1 MAG: hypothetical protein CK425_11135 [Parachlamydia sp.] | diamond | 201 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 31320547 | 31320547 | PRJNA939415_P_NODE_34355_length_310_cov_1.953586_g33933_i0 | PRJNA939415 | 34355 | 310 | 1.953586 | 6.0561166 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 48.1 | 0.00102 | NR | MFI5343022.1 | 2047757 | g33933 | i0 | 41.3 | 0.445161290322581 | 46 | 27 | 44.5 | 0 | 171 | 308 | 585 | 630 | MFI5343022.1 hypothetical protein [Chlamydiales bacterium] | diamond | 138 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 32245287 | 32245287 | PRJNA939415_P_NODE_41778_length_292_cov_2.301370_g41356_i0 | PRJNA939415 | 41778 | 292 | 2.30137 | 6.7200004 | Candidatus Protochlamydia | 282132 | Bacteria | Bacteria | 105 | 6.21e-24 | NR | WP_059062465.1 | 389348 | g41356 | i0 | 59.1 | 1.94178082191781 | 93 | 37 | 95.5 | 1 | 2 | 280 | 676 | 767 | WP_059062465.1 AAA family ATPase [Candidatus Protochlamydia naegleriophila] | diamond | 567 | 106 | 0.990566037735849 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 32523060 | 32523060 | PRJNA939415_P_NODE_32039_length_310_cov_2.835443_g31617_i0 | PRJNA939415 | 32039 | 310 | 2.835443 | 8.7898733 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 95.1 | 3.26e-20 | NR | NGX61524.1 | 2081524 | g31617 | i0 | 81.6 | 0.474193548387097 | 49 | 9 | 47.4 | 0 | 148 | 2 | 163 | 211 | NGX61524.1 4-hydroxybenzoate decarboxylase subunit C [Chlamydiota bacterium] | diamond | 147 | 95.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 32586218 | 32586218 | PRJNA939415_P_NODE_85699_length_249_cov_1.380682_g85277_i0 | PRJNA939415 | 85699 | 249 | 1.380682 | 3.43789818 | Candidatus Protochlamydia phocaeensis | 1414722 | Bacteria | Bacteria | 124 | 5.889999999999999e-31 | NR | WP_068467969.1 | 1414722 | g85277 | i0 | 82.9 | 0.987951807228916 | 82 | 14 | 98.8 | 0 | 2 | 247 | 361 | 442 | WP_068467969.1 efflux RND transporter permease subunit [Candidatus Protochlamydia phocaeensis] | diamond | 246 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia phocaeensis | |
| 32648642 | 32648642 | PRJNA939415_P_NODE_67780_length_266_cov_1.865285_g67358_i0 | PRJNA939415 | 67780 | 266 | 1.865285 | 4.9616581 | Candidatus Protochlamydia sp. | 2687294 | Bacteria | Bacteria | 112 | 2.5800000000000004e-27 | NR | MBA2367500.1 | 2687294 | g67358 | i0 | 65.9 | 0.992481203007519 | 88 | 30 | 99.2 | 0 | 3 | 266 | 177 | 264 | MBA2367500.1 branched-chain amino acid transport system II carrier protein [Candidatus Protochlamydia sp.] | diamond | 264 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia sp. | |
| 32655518 | 32655518 | PRJNA939415_P_NODE_54420_length_279_cov_2.621359_g53998_i0 | PRJNA939415 | 54420 | 279 | 2.621359 | 7.31359161 | Chlamydiia | 204429 | Bacteria | Bacteria | 155 | 5.18e-43 | NR | WP_079992903.1 | 389348 | g53998 | i0 | 76.8 | 9.05376344086022 | 95 | 19 | 98.9 | 1 | 2 | 277 | 214 | 308 | WP_079992903.1 NADH:ubiquinone reductase (Na(+)-transporting) subunit F [Candidatus Protochlamydia naegleriophila] | diamond | 2526 | 156 | 0.993589743589744 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila |
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);;