contig_metadata
18 rows where bioproject = "PRJNA529241" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1775742 | 1775742 | PRJNA529241_P_NODE_380342_length_173_cov_2.573529_g378020_i0 | PRJNA529241 | 380342 | 173 | 2.573529 | 4.45220517 | Candidatus Criblamydia sequanensis | 340071 | Bacteria | Bacteria | 111 | 2.36e-20 | NTclustered | gi|678241437|emb|LK031773.1| | 1437425 | g378020 | i0 | 94.444 | 0.416184971098266 | 72 | 4 | 42 | 0 | 4 | 75 | 43522 | 43451 | Criblamydia sequanensis plasmid 1, strain CRIB-18, complete sequence | blastn | 72 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Criblamydiaceae | Candidatus Criblamydia | Candidatus Criblamydia sequanensis | |
| 20902865 | 20902865 | PRJNA529241_P_NODE_405797_length_172_cov_3.066667_g403475_i0 | PRJNA529241 | 405797 | 172 | 3.066667 | 5.27466724 | Neochlamydia sp. S13 | 1353976 | Bacteria | Bacteria | 86.1 | 1.42e-12 | NTclustered | gi|1550189844|dbj|AP017977.1| | 1353976 | g403475 | i0 | 86.842 | 0.441860465116279 | 76 | 10 | 44 | 0 | 1 | 76 | 1821853 | 1821928 | Neochlamydia sp. S13 DNA, complete genome | blastn | 76 | 86.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Neochlamydia | Neochlamydia sp. S13 | |
| 26602467 | 26602467 | PRJNA529241_P_NODE_541041_length_151_cov_3.184211_g538719_i0 | PRJNA529241 | 541041 | 151 | 3.184211 | 4.8081586100000004 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 43.1 | 0.00788 | NR | MBN9378765.1 | 2047757 | g538719 | i0 | 76 | 0.496688741721854 | 25 | 6 | 49.7 | 0 | 151 | 77 | 25 | 49 | MBN9378765.1 dipeptidase [Chlamydiales bacterium] | diamond | 75 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 27140320 | 27140320 | PRJNA529241_P_NODE_283682_length_173_cov_3.786765_g281360_i0 | PRJNA529241 | 283682 | 173 | 3.786765 | 6.55110345 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 50.4 | 2.67e-5 | NR | QLH36959.1 | 2052176 | g281360 | i0 | 88 | 0.433526011560694 | 25 | 3 | 43.4 | 0 | 172 | 98 | 154 | 178 | QLH36959.1 MAG: hypothetical protein HWD61_13140 [Parachlamydiaceae bacterium] | diamond | 75 | 50.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 28088130 | 28088130 | PRJNA529241_P_NODE_99605_length_218_cov_3.712707_g97283_i0 | PRJNA529241 | 99605 | 218 | 3.712707 | 8.09370126 | Chlamydia psittaci 1 | 83554 | Bacteria | Bacteria | 40.4 | 0.0167 | NR | EPP37169.1 | 1238236 | g97283 | i0 | 89.5 | 0.261467889908257 | 19 | 2 | 26.1 | 0 | 143 | 87 | 1 | 19 | EPP37169.1 hypothetical protein CP10743SC13_2441, partial [Chlamydia psittaci 10_743_SC13] | diamond | 57 | 40.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 28309275 | 28309275 | PRJNA529241_P_NODE_405126_length_172_cov_3.355556_g402804_i0 | PRJNA529241 | 405126 | 172 | 3.355556 | 5.77155632 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 51.6 | 1.06e-5 | NR | WP_059061619.1 | 389348 | g402804 | i0 | 96 | 0.436046511627907 | 25 | 1 | 43.6 | 0 | 75 | 1 | 3 | 27 | WP_059061619.1 zinc-dependent alcohol dehydrogenase [Candidatus Protochlamydia naegleriophila] | diamond | 75 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 30077291 | 30077291 | PRJNA529241_P_NODE_313652_length_173_cov_3.338235_g311330_i0 | PRJNA529241 | 313652 | 173 | 3.338235 | 5.77514655 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 47 | 4.65e-4 | NR | MDB6081688.1 | 2052156 | g311330 | i0 | 36.2 | 1.00578034682081 | 58 | 36 | 98.8 | 1 | 1 | 171 | 480 | 537 | MDB6081688.1 hypothetical protein [Chlamydiia bacterium] | diamond | 174 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 30172142 | 30172142 | PRJNA529241_P_NODE_241972_length_173_cov_4.625000_g239650_i0 | PRJNA529241 | 241972 | 173 | 4.625 | 8.00125 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 43.9 | 0.00568 | NR | MEI8301362.1 | 2081524 | g239650 | i0 | 80 | 0.433526011560694 | 25 | 5 | 43.4 | 0 | 98 | 172 | 138 | 162 | MEI8301362.1 AAA family ATPase [Chlamydiota bacterium] | diamond | 75 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 30488233 | 30488233 | PRJNA529241_P_NODE_338933_length_173_cov_3.036765_g336611_i0 | PRJNA529241 | 338933 | 173 | 3.036765 | 5.25360345 | Neochlamydia sp. AcF84 | 2315858 | Bacteria | Bacteria | 47 | 4.67e-4 | NR | WP_166155580.1 | 2315858 | g336611 | i0 | 95.7 | 0.815028901734104 | 23 | 1 | 39.9 | 0 | 100 | 168 | 70 | 92 | WP_166155580.1 hypothetical protein [Neochlamydia sp. AcF84] | diamond | 141 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Neochlamydia | Neochlamydia sp. AcF84 | |
| 30519757 | 30519757 | PRJNA529241_P_NODE_11313_length_779_cov_5.913747_g4936_i2 | PRJNA529241 | 11313 | 779 | 5.913747 | 46.06808913 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 181 | 2.35e-51 | NR | NDD59539.1 | 2081524 | g4936 | i2 | 76.5 | 0.442875481386393 | 115 | 25 | 43.5 | 1 | 183 | 521 | 67 | 181 | NDD59539.1 hypothetical protein [Chlamydiota bacterium] | diamond | 345 | 181 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 30614408 | 30614408 | PRJNA529241_P_NODE_135453_length_193_cov_4.153846_g133131_i0 | PRJNA529241 | 135453 | 193 | 4.153846 | 8.01692278 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 39.7 | 0.0392 | NR | EPJ32152.1 | 1112244 | g133131 | i0 | 83.6 | 0.854922279792746 | 55 | 9 | 85.5 | 0 | 179 | 15 | 4 | 58 | EPJ32152.1 hypothetical protein CP061683_2283, partial [Chlamydia psittaci 06-1683] | diamond | 165 | 39.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 30993762 | 30993762 | PRJNA529241_P_NODE_14954_length_612_cov_11.481739_g12966_i0 | PRJNA529241 | 14954 | 612 | 11.481739 | 70.26824268 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 170 | 1.17e-48 | NR | MEI8329982.1 | 2052156 | g12966 | i0 | 57.7 | 0.799019607843137 | 163 | 60 | 76.5 | 4 | 607 | 140 | 99 | 259 | MEI8329982.1 tRNA(His) guanylyltransferase Thg1 family protein [Chlamydiia bacterium] | diamond | 489 | 170 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 31626062 | 31626062 | PRJNA529241_P_NODE_457256_length_154_cov_2.333333_g454934_i0 | PRJNA529241 | 457256 | 154 | 2.333333 | 3.59333282 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 92.4 | 1.28e-20 | NR | MDP1880795.1 | 2052176 | g454934 | i0 | 86.3 | 0.993506493506494 | 51 | 7 | 99.4 | 0 | 153 | 1 | 220 | 270 | MDP1880795.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Parachlamydiaceae bacterium] | diamond | 153 | 92.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31735993 | 31735993 | PRJNA529241_P_NODE_213737_length_173_cov_5.573529_g211415_i0 | PRJNA529241 | 213737 | 173 | 5.573529 | 9.64220517 | Bacteria | 2 | Bacteria | Bacteria | 56.6 | 1.83e-7 | NR | CQB87362.1 | 813 | g211415 | i0 | 100 | 1.73410404624277 | 25 | 0 | 43.4 | 0 | 98 | 172 | 515 | 539 | CQB87362.1 Glutamine-dependent NAD(+) synthetase [Chlamydia trachomatis] | diamond | 300 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis | |
| 32005753 | 32005753 | PRJNA529241_P_NODE_346978_length_173_cov_2.897059_g344656_i0 | PRJNA529241 | 346978 | 173 | 2.897059 | 5.01191207 | Chlamydia trachomatis | 813 | Bacteria | Bacteria | 45.8 | 0.00119 | NR | CRH64103.1 | 813 | g344656 | i0 | 91.7 | 0.416184971098266 | 24 | 2 | 41.6 | 0 | 75 | 4 | 333 | 356 | CRH64103.1 Internalin-A precursor [Chlamydia trachomatis] | diamond | 72 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis | |
| 32020930 | 32020930 | PRJNA529241_P_NODE_387638_length_173_cov_2.463235_g385316_i0 | PRJNA529241 | 387638 | 173 | 2.463235 | 4.26139655 | Parachlamydia | 83551 | Bacteria | Bacteria | 60.5 | 6.47e-9 | NR | MCE5315994.1 | 2052048 | g385316 | i0 | 53.5 | 9.88439306358381 | 71 | 19 | 98.8 | 1 | 2 | 172 | 154 | 224 | MCE5315994.1 sodium:solute symporter family protein [Parachlamydia sp.] | diamond | 1710 | 60.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 32132510 | 32132510 | PRJNA529241_P_NODE_9678_length_897_cov_6.177907_g4936_i1 | PRJNA529241 | 9678 | 897 | 6.177907 | 55.41582579 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 182 | 5.84e-51 | NR | NDD59539.1 | 2081524 | g4936 | i1 | 76.5 | 0.384615384615385 | 115 | 25 | 37.8 | 1 | 33 | 371 | 67 | 181 | NDD59539.1 hypothetical protein [Chlamydiota bacterium] | diamond | 345 | 182 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 32575505 | 32575505 | PRJNA529241_P_NODE_7979_length_1064_cov_8.801363_g6721_i0 | PRJNA529241 | 7979 | 1064 | 8.801363 | 93.64650232 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 135 | 6.919999999999999e-34 | NR | MCE5293500.1 | 2047757 | g6721 | i0 | 65.2 | 0.25093984962406 | 89 | 31 | 25.1 | 0 | 146 | 412 | 156 | 244 | MCE5293500.1 hypothetical protein [Chlamydiales bacterium] | diamond | 267 | 135 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales 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);;