contig_metadata
8 rows where bioproject = "PRJNA924320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9827232 | 9827232 | PRJNA924320_S_NODE_708_length_1019_cov_8.151546_g644_i0 | PRJNA924320 | 708 | 1019 | 8.151546 | 83.06425374 | Simkania sp. | 34094 | Bacteria | Bacteria | 281 | 8.01e-91 | NR | MCB1084310.1 | 34094 | g644 | i0 | 69.9 | 0.577036310107949 | 196 | 59 | 57.7 | 0 | 757 | 170 | 1 | 196 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 588 | 281 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 26707858 | 26707858 | PRJNA924320_S_NODE_48401_length_166_cov_0.871795_g48259_i0 | PRJNA924320 | 48401 | 166 | 0.871795 | 1.4471797 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 42 | 0.024 | NR | MCH9621607.1 | 2052156 | g48259 | i0 | 47.4 | 0.686746987951807 | 38 | 20 | 68.7 | 0 | 1 | 114 | 114 | 151 | MCH9621607.1 hypothetical protein [Chlamydiia bacterium] | diamond | 114 | 42 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 28287854 | 28287854 | PRJNA924320_S_NODE_3986_length_471_cov_2.080569_g3845_i0 | PRJNA924320 | 3986 | 471 | 2.080569 | 9.79947999 | Candidatus Neptunochlamydia sp. REUL1 | 3064277 | Bacteria | Bacteria | 61.2 | 1.06e-7 | NR | WP_316357043.1 | 3064277 | g3845 | i0 | 50 | 0.707006369426752 | 48 | 24 | 30.6 | 0 | 309 | 166 | 199 | 246 | WP_316357043.1 ubiquitin-like protein [Candidatus Neptunochlamydia sp. REUL1] | diamond | 333 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Candidatus Neptunichlamydia | Candidatus Neptunichlamydia sp. REUL1 | |
| 30656594 | 30656594 | PRJNA924320_S_NODE_8673_length_330_cov_2.359431_g8531_i0 | PRJNA924320 | 8673 | 330 | 2.359431 | 7.7861223 | Simkania sp. | 34094 | Bacteria | Bacteria | 59.3 | 1.13e-8 | NR | MCB1084226.1 | 34094 | g8531 | i0 | 58.9 | 0.509090909090909 | 56 | 23 | 50.9 | 0 | 330 | 163 | 53 | 108 | MCB1084226.1 hypothetical protein [Simkania sp.] | diamond | 168 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 31067550 | 31067550 | PRJNA924320_S_NODE_37655_length_182_cov_1.135338_g37513_i0 | PRJNA924320 | 37655 | 182 | 1.135338 | 2.06631516 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 85.5 | 5.63e-20 | NR | MCP5470419.1 | 2047757 | g37513 | i0 | 67.2 | 0.956043956043956 | 58 | 19 | 95.6 | 0 | 179 | 6 | 26 | 83 | MCP5470419.1 dynein light chain family protein [Chlamydiales bacterium] | diamond | 174 | 85.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 31794500 | 31794500 | PRJNA924320_S_NODE_7997_length_342_cov_3.218430_g7855_i0 | PRJNA924320 | 7997 | 342 | 3.21843 | 11.0070306 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 189 | 3.6400000000000003e-59 | NR | MCP5470420.1 | 2047757 | g7855 | i0 | 82.1 | 0.982456140350877 | 112 | 20 | 98.2 | 0 | 341 | 6 | 4 | 115 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 336 | 189 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 31794501 | 31794501 | PRJNA924320_S_NODE_8637_length_331_cov_1.407801_g8495_i0 | PRJNA924320 | 8637 | 331 | 1.407801 | 4.65982131 | Parachlamydia sp. AcF125 | 2795736 | Bacteria | Bacteria | 60.8 | 4.52e-8 | NR | WP_213157390.1 | 2795736 | g8495 | i0 | 43.6 | 1.50453172205438 | 78 | 43 | 69.8 | 1 | 296 | 66 | 388 | 465 | WP_213157390.1 ankyrin repeat domain-containing protein [Parachlamydia sp. AcF125] | diamond | 498 | 60.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. AcF125 | |
| 32585815 | 32585815 | PRJNA924320_S_NODE_4839_length_429_cov_4.650000_g4698_i0 | PRJNA924320 | 4839 | 429 | 4.65 | 19.9485 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 112 | 1.82e-28 | NR | MCP5470420.1 | 2047757 | g4698 | i0 | 80 | 0.454545454545455 | 65 | 13 | 45.5 | 0 | 428 | 234 | 15 | 79 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 195 | 112 | 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);;