contig_metadata
9 rows where bioproject = "PRJNA572587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2411431 | 2411431 | PRJNA572587_P_NODE_37682_length_179_cov_1.738462_g37354_i0 | PRJNA572587 | 37682 | 179 | 1.738462 | 3.11184698 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 99.8 | 7.119999999999999e-23 | NR | HSX38134.1 | 2047757 | g37354 | i0 | 93.2 | 6.85474860335195 | 59 | 4 | 98.9 | 0 | 2 | 178 | 332 | 390 | HSX38134.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [Chlamydiales bacterium] | diamond | 1227 | 99.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 27395790 | 27395790 | PRJNA572587_P_NODE_30723_length_200_cov_12.602649_g30395_i0 | PRJNA572587 | 30723 | 200 | 12.602649 | 25.205298 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 70.1 | 4.84e-12 | NR | MBX9924569.1 | 2047756 | g30395 | i0 | 55 | 0.9 | 60 | 27 | 90 | 0 | 1 | 180 | 7 | 66 | MBX9924569.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 180 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 27504100 | 27504100 | PRJNA572587_P_NODE_47003_length_161_cov_0.910714_g46675_i0 | PRJNA572587 | 47003 | 161 | 0.910714 | 1.46624954 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 107 | 6.01e-26 | NR | WP_194845298.1 | 225148 | g46675 | i0 | 94.3 | 51.3540372670807 | 53 | 3 | 98.8 | 0 | 2 | 160 | 262 | 314 | WP_194845298.1 V-type ATP synthase subunit B [Candidatus Rhabdochlamydia porcellionis] | diamond | 8268 | 108 | 0.990740740740741 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Candidatus Rhabdochlamydia | Candidatus Rhabdochlamydia porcellionis | |
| 27553207 | 27553207 | PRJNA572587_P_NODE_18184_length_267_cov_1.316514_g17856_i0 | PRJNA572587 | 18184 | 267 | 1.316514 | 3.51509238 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 115 | 1.79e-27 | NR | MES2199072.1 | 2081524 | g17856 | i0 | 75.6 | 0.876404494382023 | 78 | 19 | 87.6 | 0 | 262 | 29 | 284 | 361 | MES2199072.1 AMP-binding protein [Chlamydiota bacterium] | diamond | 234 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 28405993 | 28405993 | PRJNA572587_P_NODE_11466_length_346_cov_28.771044_g11139_i0 | PRJNA572587 | 11466 | 346 | 28.771044 | 99.54781224 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 44.3 | 0.0349 | NR | NGX57685.1 | 2081524 | g11139 | i0 | 33.3 | 0.936416184971098 | 108 | 57 | 85.8 | 4 | 313 | 17 | 702 | 803 | NGX57685.1 ATP-dependent Clp protease ATP-binding subunit ClpC [Chlamydiota bacterium] | diamond | 324 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 29763445 | 29763445 | PRJNA572587_P_NODE_12731_length_326_cov_24.541516_g12403_i0 | PRJNA572587 | 12731 | 326 | 24.541516 | 80.00534216 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 68.6 | 9.01e-11 | NR | MBY0530076.1 | 2047756 | g12403 | i0 | 49.2 | 0.598159509202454 | 65 | 33 | 59.8 | 0 | 119 | 313 | 16 | 80 | MBY0530076.1 filamentous hemagglutinin N-terminal domain-containing protein [Rhabdochlamydiaceae bacterium] | diamond | 195 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 29921713 | 29921713 | PRJNA572587_P_NODE_10791_length_359_cov_7.541935_g10464_i0 | PRJNA572587 | 10791 | 359 | 7.541935 | 27.07554665 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 87.8 | 1.27e-17 | NR | MES2200127.1 | 2081524 | g10464 | i0 | 80.9 | 0.392757660167131 | 47 | 9 | 39.3 | 0 | 152 | 12 | 1 | 47 | MES2200127.1 citrate (Si)-synthase [Chlamydiota bacterium] | diamond | 141 | 87.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 30616520 | 30616520 | PRJNA572587_P_NODE_13553_length_314_cov_74.143396_g13225_i0 | PRJNA572587 | 13553 | 314 | 74.143396 | 232.81026344 | Candidatus Rubidus massiliensis | 1444712 | Bacteria | Bacteria | 70.1 | 2.01e-11 | NR | CDZ81263.1 | 1444712 | g13225 | i0 | 50 | 0.515923566878981 | 54 | 27 | 51.6 | 0 | 39 | 200 | 398 | 451 | CDZ81263.1 geranylgeranyl reductase family protein [Candidatus Rubidus massiliensis] | diamond | 162 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Candidatus Rubidus | Candidatus Rubidus massiliensis | |
| 32450978 | 32450978 | PRJNA572587_P_NODE_14659_length_301_cov_22.527778_g14331_i0 | PRJNA572587 | 14659 | 301 | 22.527778 | 67.80861178 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 108 | 9.33e-27 | NR | MBM3197717.1 | 2081524 | g14331 | i0 | 59.5 | 0.837209302325581 | 84 | 34 | 83.7 | 0 | 300 | 49 | 56 | 139 | MBM3197717.1 HAD family phosphatase [Chlamydiota bacterium] | diamond | 252 | 108 | 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);;