contig_metadata
6 rows where bioproject = "PRJNA929922", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27877773 | 27877773 | PRJNA929922_P_NODE_111485_length_250_cov_0.870056_g110945_i0 | PRJNA929922 | 111485 | 250 | 0.870056 | 2.17514 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 130 | 3.78e-33 | NR | MBN9379105.1 | 2047757 | g110945 | i0 | 70.7 | 0.984 | 82 | 24 | 98.4 | 0 | 5 | 250 | 147 | 228 | MBN9379105.1 GreA/GreB family elongation factor [Chlamydiales bacterium] | diamond | 246 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 28509302 | 28509302 | PRJNA929922_P_NODE_141387_length_245_cov_0.895349_g140847_i0 | PRJNA929922 | 141387 | 245 | 0.895349 | 2.19360505 | Chlamydiales bacterium STE3 | 1910938 | Bacteria | Bacteria | 155 | 8.569999999999996e-42 | NR | KAF3362093.1 | 1910938 | g140847 | i0 | 93.8 | 2.97551020408163 | 81 | 5 | 99.2 | 0 | 245 | 3 | 350 | 430 | KAF3362093.1 Aconitate hydratase, mitochondrial [Chlamydiales bacterium STE3] | diamond | 729 | 155 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium STE3 | |||
| 31067749 | 31067749 | PRJNA929922_P_NODE_151895_length_243_cov_0.905882_g151355_i0 | PRJNA929922 | 151895 | 243 | 0.905882 | 2.20129326 | Candidatus Protochlamydia sp. | 2687294 | Bacteria | Bacteria | 154 | 1.6899999999999996e-41 | NR | MBA2369045.1 | 2687294 | g151355 | i0 | 93.8 | 7.97530864197531 | 81 | 5 | 100 | 0 | 243 | 1 | 709 | 789 | MBA2369045.1 transcription-repair coupling factor [Candidatus Protochlamydia sp.] | diamond | 1938 | 154 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia sp. | |
| 32238127 | 32238127 | PRJNA929922_P_NODE_120258_length_249_cov_0.875000_g119718_i0 | PRJNA929922 | 120258 | 249 | 0.875 | 2.17875 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 161 | 7.85e-44 | NR | WP_079992924.1 | 389348 | g119718 | i0 | 95.1 | 0.987951807228916 | 82 | 4 | 98.8 | 0 | 2 | 247 | 126 | 207 | WP_079992924.1 sensor histidine kinase [Candidatus Protochlamydia naegleriophila] | diamond | 246 | 161 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 32269688 | 32269688 | PRJNA929922_P_NODE_96278_length_261_cov_1.090426_g95738_i0 | PRJNA929922 | 96278 | 261 | 1.090426 | 2.84601186 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 42.7 | 0.0468 | NR | MCX6986823.1 | 2081524 | g95738 | i0 | 32.1 | 0.64367816091954 | 56 | 38 | 64.4 | 0 | 70 | 237 | 269 | 324 | MCX6986823.1 4-alpha-glucanotransferase [Chlamydiota bacterium] | diamond | 168 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 32459459 | 32459459 | PRJNA929922_P_NODE_152379_length_243_cov_0.905882_g151839_i0 | PRJNA929922 | 152379 | 243 | 0.905882 | 2.20129326 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 130 | 2.11e-33 | NR | MBA3816824.1 | 2052176 | g151839 | i0 | 78.8 | 0.987654320987654 | 80 | 17 | 98.8 | 0 | 3 | 242 | 321 | 400 | MBA3816824.1 single-stranded-DNA-specific exonuclease RecJ [Parachlamydiaceae bacterium] | diamond | 240 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae 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);;