contig_metadata
21 rows where bioproject = "PRJEB28062", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8951079 | 8951079 | PRJEB28062_P_NODE_133708_length_230_cov_3.337580_g131344_i0 | PRJEB28062 | 133708 | 230 | 3.33758 | 7.676434 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 313 | 8.53e-81 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g131344 | i0 | 93.75 | 69.395652173913 | 208 | 13 | 90 | 0 | 23 | 230 | 1249073 | 1249280 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 15961 | 313 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 12778880 | 12778880 | PRJEB28062_P_NODE_69571_length_413_cov_2.988235_g67210_i0 | PRJEB28062 | 69571 | 413 | 2.988235 | 12.34141055 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 176 | 3.34e-48 | NR | HSX13640.1 | 2047757 | g67210 | i0 | 68.5 | 0.900726392251816 | 124 | 34 | 90.1 | 1 | 22 | 393 | 792 | 910 | HSX13640.1 penicillin-binding transpeptidase domain-containing protein [Chlamydiales bacterium] | diamond | 372 | 176 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 14051802 | 14051802 | PRJEB28062_P_NODE_111632_length_282_cov_1.842105_g109269_i0 | PRJEB28062 | 111632 | 282 | 1.842105 | 5.1947361 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 353 | 6.37e-93 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g109269 | i0 | 90.335 | 171.691489361702 | 269 | 26 | 98 | 0 | 3 | 271 | 2060685 | 2060953 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 48417 | 353 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 17877549 | 17877549 | PRJEB28062_P_NODE_99255_length_317_cov_2.118852_g96893_i0 | PRJEB28062 | 99255 | 317 | 2.118852 | 6.71676084 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 141 | 5.24e-39 | NR | HXF29337.1 | 2047757 | g96893 | i0 | 87.7 | 0.766561514195584 | 81 | 10 | 76.7 | 0 | 6 | 248 | 83 | 163 | HXF29337.1 IS3 family transposase [Chlamydiales bacterium] | diamond | 243 | 141 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 26747902 | 26747902 | PRJEB28062_P_NODE_86801_length_355_cov_5.464539_g84439_i0 | PRJEB28062 | 86801 | 355 | 5.464539 | 19.39911345 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 144 | 2.11e-39 | NR | MFI0434098.1 | 2052176 | g84439 | i0 | 82.8 | 0.735211267605634 | 87 | 15 | 73.5 | 0 | 351 | 91 | 222 | 308 | MFI0434098.1 tetratricopeptide repeat protein [Parachlamydiaceae bacterium] | diamond | 261 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27001349 | 27001349 | PRJEB28062_P_NODE_130582_length_241_cov_1.666667_g128218_i0 | PRJEB28062 | 130582 | 241 | 1.666667 | 4.01666747 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 88.2 | 5.25e-20 | NR | MBX9923789.1 | 2047756 | g128218 | i0 | 55.8 | 0.95850622406639 | 77 | 34 | 95.9 | 0 | 11 | 241 | 45 | 121 | MBX9923789.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 231 | 88.2 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 27001350 | 27001350 | PRJEB28062_P_NODE_131822_length_237_cov_7.445122_g129458_i0 | PRJEB28062 | 131822 | 237 | 7.445122 | 17.64493914 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 53.5 | 2.92e-7 | NR | PWU16011.1 | 2081524 | g129458 | i0 | 46 | 0.632911392405063 | 50 | 27 | 63.3 | 0 | 220 | 71 | 17 | 66 | PWU16011.1 MAG: hypothetical protein C5B45_01490 [Chlamydiota bacterium] | diamond | 150 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 27222653 | 27222653 | PRJEB28062_P_NODE_63463_length_437_cov_3.038462_g61102_i0 | PRJEB28062 | 63463 | 437 | 3.038462 | 13.27807894 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 244 | 7.31e-77 | NR | WP_059059511.1 | 389348 | g61102 | i0 | 79.3 | 1.9908466819222 | 145 | 30 | 99.5 | 0 | 1 | 435 | 200 | 344 | WP_059059511.1 cbb3-type cytochrome c oxidase subunit II [Candidatus Protochlamydia naegleriophila] | diamond | 870 | 244 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 27317862 | 27317862 | PRJEB28062_P_NODE_53923_length_482_cov_4.542787_g51570_i0 | PRJEB28062 | 53923 | 482 | 4.542787 | 21.89623334 | Chlamydia ibidis | 1405396 | Bacteria | Bacteria | 94.7 | 1.46e-22 | NR | EPP35752.1 | 1405396 | g51570 | i0 | 93.6 | 0.29253112033195 | 47 | 3 | 29.3 | 0 | 421 | 281 | 1 | 47 | EPP35752.1 hypothetical protein CP10139811_1360, partial [Chlamydia ibidis] | diamond | 141 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia ibidis | |
| 27791481 | 27791481 | PRJEB28062_P_NODE_64764_length_431_cov_15.837989_g62403_i0 | PRJEB28062 | 64764 | 431 | 15.837989 | 68.26173259 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 180 | 4.55e-53 | NR | MES2200355.1 | 2081524 | g62403 | i0 | 60.3 | 0.946635730858469 | 136 | 54 | 94.7 | 0 | 3 | 410 | 161 | 296 | MES2200355.1 glycosyltransferase family 2 protein [Chlamydiota bacterium] | diamond | 408 | 180 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 28928008 | 28928008 | PRJEB28062_P_NODE_48728_length_512_cov_65.810934_g46381_i0 | PRJEB28062 | 48728 | 512 | 65.810934 | 336.95198208 | Simkania sp. | 34094 | Bacteria | Bacteria | 71.2 | 3.27e-12 | NR | MBS3903906.1 | 34094 | g46381 | i0 | 33.3 | 0.685546875 | 117 | 73 | 65.6 | 1 | 141 | 476 | 4 | 120 | MBS3903906.1 hypothetical protein [Simkania sp.] | diamond | 351 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 29306853 | 29306853 | PRJEB28062_P_NODE_58409_length_459_cov_12.637306_g56050_i0 | PRJEB28062 | 58409 | 459 | 12.637306 | 58.00523454 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 152 | 1.6099999999999996e-43 | NR | MBX9924663.1 | 2047756 | g56050 | i0 | 62.7 | 0.77124183006536 | 118 | 44 | 77.1 | 0 | 457 | 104 | 81 | 198 | MBX9924663.1 guanylate kinase [Rhabdochlamydiaceae bacterium] | diamond | 354 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 30033344 | 30033344 | PRJEB28062_P_NODE_81511_length_372_cov_3.230769_g79149_i0 | PRJEB28062 | 81511 | 372 | 3.230769 | 12.01846068 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 72.8 | 1.12e-13 | NR | MCB1112684.1 | 2052156 | g79149 | i0 | 54.7 | 0.42741935483871 | 53 | 24 | 42.7 | 0 | 169 | 11 | 1 | 53 | MCB1112684.1 DUF4339 domain-containing protein [Chlamydiia bacterium] | diamond | 159 | 72.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 30159309 | 30159309 | PRJEB28062_P_NODE_100412_length_313_cov_21.925000_g98049_i0 | PRJEB28062 | 100412 | 313 | 21.925 | 68.62525 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 96.7 | 7.430000000000001e-21 | NR | MBX9922548.1 | 2047756 | g98049 | i0 | 87.7 | 0.546325878594249 | 57 | 7 | 54.6 | 0 | 143 | 313 | 1 | 57 | MBX9922548.1 ATP-binding protein [Rhabdochlamydiaceae bacterium] | diamond | 171 | 96.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 30222696 | 30222696 | PRJEB28062_P_NODE_110452_length_285_cov_2.962264_g108089_i0 | PRJEB28062 | 110452 | 285 | 2.962264 | 8.4424524 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 167 | 1.07e-45 | NR | MBX9744316.1 | 2047757 | g108089 | i0 | 81.9 | 1.97894736842105 | 94 | 17 | 98.9 | 0 | 285 | 4 | 439 | 532 | MBX9744316.1 hypothetical protein [Chlamydiales bacterium] | diamond | 564 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 30507165 | 30507165 | PRJEB28062_P_NODE_132993_length_233_cov_2.712500_g130629_i0 | PRJEB28062 | 132993 | 233 | 2.7125 | 6.320125 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 115 | 9.87e-30 | NR | MBM3197656.1 | 2081524 | g130629 | i0 | 73 | 2.85836909871245 | 74 | 20 | 95.3 | 0 | 224 | 3 | 58 | 131 | MBM3197656.1 glycosyltransferase family 2 protein [Chlamydiota bacterium] | diamond | 666 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 30507195 | 30507195 | PRJEB28062_P_NODE_64373_length_433_cov_3.477778_g62012_i0 | PRJEB28062 | 64373 | 433 | 3.477778 | 15.05877874 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 192 | 1.18e-58 | NR | PJD95972.1 | 2052048 | g62012 | i0 | 64.9 | 0.928406466512702 | 134 | 47 | 92.8 | 0 | 415 | 14 | 110 | 243 | PJD95972.1 MAG: carboxymethylenebutenolidase [Parachlamydia sp.] | diamond | 402 | 192 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 30563547 | 30563547 | PRJEB28062_P_NODE_91333_length_341_cov_1.932836_g88971_i0 | PRJEB28062 | 91333 | 341 | 1.932836 | 6.59097076 | Candidatus Protochlamydia | 282132 | Bacteria | Bacteria | 104 | 7.98e-26 | NR | WP_052236502.1 | 362787 | g88971 | i0 | 56.3 | 3.03519061583578 | 87 | 38 | 76.5 | 0 | 267 | 7 | 1 | 87 | WP_052236502.1 histidine phosphatase family protein [Candidatus Protochlamydia amoebophila] | diamond | 1035 | 105 | 0.990476190476191 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia amoebophila | |
| 30981257 | 30981257 | PRJEB28062_P_NODE_100714_length_313_cov_1.283333_g98351_i0 | PRJEB28062 | 100714 | 313 | 1.283333 | 4.01683229 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 51.6 | 5.52e-5 | NR | MBM3193255.1 | 2081524 | g98351 | i0 | 32.5 | 0.795527156549521 | 83 | 53 | 76.7 | 1 | 312 | 73 | 168 | 250 | MBM3193255.1 hypothetical protein [Chlamydiota bacterium] | diamond | 249 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 32278016 | 32278016 | PRJEB28062_P_NODE_49099_length_510_cov_5.864989_g46752_i0 | PRJEB28062 | 49099 | 510 | 5.864989 | 29.9114439 | Chlamydia ibidis | 1405396 | Bacteria | Bacteria | 91.3 | 1.28e-20 | NR | EPP34989.1 | 1405396 | g46752 | i0 | 92 | 0.511764705882353 | 87 | 7 | 51.2 | 0 | 381 | 121 | 1 | 87 | EPP34989.1 hypothetical protein CP10139811_1527, partial [Chlamydia ibidis] | diamond | 261 | 91.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia ibidis | |
| 32871013 | 32871013 | PRJEB28062_P_NODE_68200_length_418_cov_4.202899_g65839_i0 | PRJEB28062 | 68200 | 418 | 4.202899 | 17.56811782 | PVC group | 1783257 | Bacteria | Bacteria | 141 | 5.85e-41 | NR | CRH76161.1 | 813 | g65839 | i0 | 94.3 | 1.00478468899522 | 70 | 4 | 50.2 | 0 | 413 | 204 | 6 | 75 | CRH76161.1 Uncharacterised protein [Chlamydia trachomatis] | diamond | 420 | 141 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis |
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);;