contig_metadata
19 rows where bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12190146 | 12190146 | PRJNA724011_P_NODE_72130_length_295_cov_1.387387_g71107_i0 | PRJNA724011 | 72130 | 295 | 1.387387 | 4.09279165 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 448 | 2.9899999999999997e-121 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g71107 | i0 | 94.218 | 133.396610169492 | 294 | 16 | 99 | 1 | 1 | 293 | 1249812 | 1249519 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 39352 | 448 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 17771723 | 17771723 | PRJNA724011_P_NODE_72514_length_294_cov_1.402715_g71491_i0 | PRJNA724011 | 72514 | 294 | 1.402715 | 4.1239821 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 414 | 3.02e-111 | NTclustered | gi|2082223669|gb|CP075585.1| | 225148 | g71491 | i0 | 94.139 | 147.214285714286 | 273 | 14 | 93 | 2 | 14 | 285 | 1020019 | 1019748 | Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome | blastn | 43281 | 414 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Candidatus Rhabdochlamydia | Candidatus Rhabdochlamydia porcellionis | |
| 18562238 | 18562238 | PRJNA724011_P_NODE_1355_length_2303_cov_8.655157_g1144_i0 | PRJNA724011 | 1355 | 2303 | 8.655157 | 199.32826571 | root | 1 | Root_unresolved | Root_unresolved | 792 | 7.12e-280 | NR | WP_059059927.1 | 389348 | g1144 | i0 | 62.9 | 9.48719062092922 | 598 | 212 | 77.9 | 5 | 1959 | 166 | 3 | 590 | WP_059059927.1 phosphoenolpyruvate carboxykinase (GTP) [Candidatus Protochlamydia naegleriophila] | diamond | 21849 | 792 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 27020561 | 27020561 | PRJNA724011_P_NODE_76602_length_285_cov_1.235849_g75579_i0 | PRJNA724011 | 76602 | 285 | 1.235849 | 3.52216965 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 45.1 | 0.00852 | NR | HNA62936.1 | 2047756 | g75579 | i0 | 44.6 | 0.589473684210526 | 56 | 31 | 58.9 | 0 | 6 | 173 | 172 | 227 | HNA62936.1 serine protease [Rhabdochlamydiaceae bacterium] | diamond | 168 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 27052280 | 27052280 | PRJNA724011_P_NODE_70462_length_299_cov_1.938053_g69439_i0 | PRJNA724011 | 70462 | 299 | 1.938053 | 5.79477847 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 116 | 8.7e-28 | NR | MCB1072267.1 | 2052156 | g69439 | i0 | 58.3 | 0.963210702341137 | 96 | 40 | 96.3 | 0 | 8 | 295 | 239 | 334 | MCB1072267.1 adenylyl cyclase [Chlamydiia bacterium] | diamond | 288 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 27715992 | 27715992 | PRJNA724011_P_NODE_83304_length_270_cov_2.370558_g82281_i0 | PRJNA724011 | 83304 | 270 | 2.370558 | 6.4005066 | Chlamydiae bacterium CG1 | 2081524 | Bacteria | Bacteria | 63.9 | 1.48e-9 | NR | PIS00663.1 | 1973935 | g82281 | i0 | 55.8 | 0.577777777777778 | 52 | 22 | 57.8 | 1 | 3 | 158 | 283 | 333 | PIS00663.1 MAG: SAM-dependent methyltransferase, partial [Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_35_9] | diamond | 156 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_35_9 | |||||
| 28483797 | 28483797 | PRJNA724011_P_NODE_74566_length_289_cov_1.837963_g73543_i0 | PRJNA724011 | 74566 | 289 | 1.837963 | 5.31171307 | Chlamydiia | 204429 | Bacteria | Bacteria | 146 | 2.69e-38 | NR | NCF70144.1 | 2047757 | g73543 | i0 | 71.6 | 8.87543252595156 | 95 | 26 | 98.6 | 1 | 285 | 1 | 325 | 418 | NCF70144.1 endopeptidase La [Chlamydiales bacterium] | diamond | 2565 | 146 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29073482 | 29073482 | PRJNA724011_P_NODE_83048_length_271_cov_1.459596_g82025_i0 | PRJNA724011 | 83048 | 271 | 1.459596 | 3.95550516 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 43.1 | 0.0145 | NR | MBM3183942.1 | 2081524 | g82025 | i0 | 45.2 | 0.907749077490775 | 42 | 23 | 46.5 | 0 | 2 | 127 | 90 | 131 | MBM3183942.1 DUF1761 domain-containing protein [Chlamydiota bacterium] | diamond | 246 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 29136685 | 29136685 | PRJNA724011_P_NODE_70209_length_300_cov_1.352423_g69186_i0 | PRJNA724011 | 70209 | 300 | 1.352423 | 4.057269 | Chlamydiae bacterium RIFCSPHIGHO2_ | 2081524 | Bacteria | Bacteria | 122 | 1.5199999999999998e-31 | NR | OGN56797.1 | 1797598 | g69186 | i0 | 57.3 | 1.8 | 89 | 38 | 89 | 0 | 268 | 2 | 15 | 103 | OGN56797.1 MAG: stomatin 2 [Chlamydiae bacterium RIFCSPHIGHO2_01_FULL_44_39] | diamond | 540 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium RIFCSPHIGHO2_01_FULL_44_39 | |||||
| 29168188 | 29168188 | PRJNA724011_P_NODE_73789_length_291_cov_1.412844_g72766_i0 | PRJNA724011 | 73789 | 291 | 1.412844 | 4.11137604 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 80.5 | 1.05e-15 | NR | MEI8365875.1 | 2052176 | g72766 | i0 | 56.9 | 0.670103092783505 | 65 | 27 | 67 | 1 | 272 | 78 | 208 | 271 | MEI8365875.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 195 | 80.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 29672885 | 29672885 | PRJNA724011_P_NODE_89070_length_259_cov_1.655914_g88047_i0 | PRJNA724011 | 89070 | 259 | 1.655914 | 4.28881726 | Candidatus Neptunochlamydia vexilliferae | 1651774 | Bacteria | Bacteria | 45.8 | 0.00388 | NR | WP_194848191.1 | 1651774 | g88047 | i0 | 35.7 | 0.810810810810811 | 70 | 45 | 81.1 | 0 | 7 | 216 | 1158 | 1227 | WP_194848191.1 putative nucleotidyltransferase substrate binding domain-containing protein [Candidatus Neptunochlamydia vexilliferae] | diamond | 210 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Candidatus Neptunichlamydia | Candidatus Neptunichlamydia vexilliferae | |
| 30589154 | 30589154 | PRJNA724011_P_NODE_32273_length_483_cov_1.112195_g31254_i0 | PRJNA724011 | 32273 | 483 | 1.112195 | 5.37190185 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 59.3 | 6.93e-7 | NR | MBA3720790.1 | 2052176 | g31254 | i0 | 38.9 | 0.447204968944099 | 72 | 43 | 44.7 | 1 | 387 | 172 | 131 | 201 | MBA3720790.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 216 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31189276 | 31189276 | PRJNA724011_P_NODE_8155_length_1108_cov_26.283092_g7447_i0 | PRJNA724011 | 8155 | 1108 | 26.283092 | 291.21665936 | Chlamydiales bacterium SCGC AG-11 | 2047757 | Bacteria | Bacteria | 48.9 | 0.0283 | NR | SCA63082.1 | 1871324 | g7447 | i0 | 30.3 | 0.240974729241877 | 89 | 54 | 21.9 | 1 | 616 | 858 | 259 | 347 | SCA63082.1 Uncharacterized protein SCG7109_AH_00380 [Chlamydiales bacterium SCGC AG-110-M15] | diamond | 267 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium SCGC AG-110-M15 | |||
| 31411034 | 31411034 | PRJNA724011_P_NODE_44436_length_394_cov_1.239875_g43413_i0 | PRJNA724011 | 44436 | 394 | 1.239875 | 4.8851075 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 124 | 1.93e-30 | NR | MFT5050156.1 | 2047757 | g43413 | i0 | 46.7 | 3.67005076142132 | 120 | 64 | 91.4 | 0 | 18 | 377 | 259 | 378 | MFT5050156.1 acetylornithine deacetylase/succinyl-diaminopimelate desuccinylase-like protein [Chlamydiales bacterium] | diamond | 1446 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 31790368 | 31790368 | PRJNA724011_P_NODE_69637_length_301_cov_2.293860_g68614_i0 | PRJNA724011 | 69637 | 301 | 2.29386 | 6.9045186 | Waddliaceae bacterium | 2026802 | Bacteria | Bacteria | 124 | 2.47e-31 | NR | MBB65584.1 | 2026802 | g68614 | i0 | 58.8 | 3.87707641196013 | 97 | 40 | 96.7 | 0 | 301 | 11 | 293 | 389 | MBB65584.1 aspartate aminotransferase family protein [Waddliaceae bacterium] | diamond | 1167 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Waddliaceae | Waddliaceae bacterium | ||
| 31980259 | 31980259 | PRJNA724011_P_NODE_45798_length_386_cov_4.099042_g44775_i0 | PRJNA724011 | 45798 | 386 | 4.099042 | 15.82230212 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 110 | 4.42e-28 | NR | MCP5470420.1 | 2047757 | g44775 | i0 | 48.7 | 1.8419689119171 | 117 | 60 | 90.9 | 0 | 6 | 356 | 1 | 117 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 711 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 32043578 | 32043578 | PRJNA724011_P_NODE_109938_length_241_cov_0.916667_g108915_i0 | PRJNA724011 | 109938 | 241 | 0.916667 | 2.20916747 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 75.1 | 5.05e-14 | NR | MBX9924004.1 | 2047756 | g108915 | i0 | 45.6 | 0.983402489626556 | 79 | 40 | 98.3 | 1 | 241 | 5 | 77 | 152 | MBX9924004.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 237 | 75.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 32328709 | 32328709 | PRJNA724011_P_NODE_14059_length_817_cov_3.040323_g13130_i0 | PRJNA724011 | 14059 | 817 | 3.040323 | 24.83943891 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 120 | 5.72e-28 | NR | MBX7066126.1 | 2052178 | g13130 | i0 | 40.7 | 1.40636474908201 | 182 | 97 | 66.8 | 5 | 206 | 751 | 133 | 303 | MBX7066126.1 NAD(P)-binding domain-containing protein [Parachlamydiales bacterium] | diamond | 1149 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 32328749 | 32328749 | PRJNA724011_P_NODE_47539_length_378_cov_1.045902_g46516_i0 | PRJNA724011 | 47539 | 378 | 1.045902 | 3.95350956 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 56.6 | 1.96e-6 | NR | MCB1113801.1 | 2052156 | g46516 | i0 | 47.1 | 1.30952380952381 | 70 | 27 | 55.6 | 3 | 211 | 2 | 164 | 223 | MCB1113801.1 hypothetical protein [Chlamydiia bacterium] | diamond | 495 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia 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);;