contig_metadata
21 rows where bioproject = "PRJNA594101", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14595790 | 14595790 | PRJNA594101_S_NODE_1212_length_1321_cov_3.402244_g1082_i0 | PRJNA594101 | 1212 | 1321 | 3.402244 | 44.94364324 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 129 | 1.35e-32 | NR | HNA62975.1 | 2047756 | g1082 | i0 | 98.5 | 0.295230885692657 | 65 | 1 | 14.8 | 0 | 794 | 988 | 4 | 68 | HNA62975.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 390 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 26604718 | 26604718 | PRJNA594101_S_NODE_50381_length_249_cov_1.142045_g50079_i0 | PRJNA594101 | 50381 | 249 | 1.142045 | 2.84369205 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 44.7 | 0.00787 | NR | MFA6915736.1 | 2052178 | g50079 | i0 | 46.3 | 0.493975903614458 | 41 | 22 | 49.4 | 0 | 185 | 63 | 32 | 72 | MFA6915736.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Parachlamydiales bacterium] | diamond | 123 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 26890161 | 26890161 | PRJNA594101_S_NODE_35221_length_291_cov_3.509174_g34919_i0 | PRJNA594101 | 35221 | 291 | 3.509174 | 10.21169634 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 78.2 | 1.38e-16 | NR | MCP5470428.1 | 2047757 | g34919 | i0 | 55.4 | 0.670103092783505 | 65 | 29 | 67 | 0 | 289 | 95 | 14 | 78 | MCP5470428.1 hypothetical protein [Chlamydiales bacterium] | diamond | 195 | 78.2 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 27837660 | 27837660 | PRJNA594101_S_NODE_12804_length_461_cov_2.036082_g12502_i0 | PRJNA594101 | 12804 | 461 | 2.036082 | 9.38633802 | Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11 | 1797603 | Bacteria | Bacteria | 63.5 | 1.16e-8 | NR | OGN62353.1 | 1797603 | g12502 | i0 | 40.3 | 0.501084598698482 | 77 | 44 | 50.1 | 1 | 230 | 460 | 44 | 118 | OGN62353.1 MAG: hypothetical protein A3F09_03785 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11] | diamond | 231 | 63.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11 | |||||
| 27869270 | 27869270 | PRJNA594101_S_NODE_20645_length_369_cov_1.888514_g20343_i0 | PRJNA594101 | 20645 | 369 | 1.888514 | 6.96861666 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 67.4 | 8.49e-11 | NR | MCB1136078.1 | 2052156 | g20343 | i0 | 47.7 | 0.528455284552846 | 65 | 34 | 52.8 | 0 | 321 | 127 | 131 | 195 | MCB1136078.1 U-box domain-containing protein [Chlamydiia bacterium] | diamond | 195 | 67.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 28058825 | 28058825 | PRJNA594101_S_NODE_21025_length_366_cov_1.668942_g20723_i0 | PRJNA594101 | 21025 | 366 | 1.668942 | 6.10832772 | Candidatus Neptunochlamydia sp. REUL1 | 3064277 | Bacteria | Bacteria | 84 | 1.9e-16 | NR | WP_316357043.1 | 3064277 | g20723 | i0 | 52 | 0.614754098360656 | 75 | 36 | 61.5 | 0 | 344 | 120 | 162 | 236 | WP_316357043.1 ubiquitin-like protein [Candidatus Neptunochlamydia sp. REUL1] | diamond | 225 | 84 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Candidatus Neptunichlamydia | Candidatus Neptunichlamydia sp. REUL1 | |
| 28090363 | 28090363 | PRJNA594101_S_NODE_2225_length_1039_cov_5.428571_g2033_i0 | PRJNA594101 | 2225 | 1039 | 5.428571 | 56.40285269 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 117 | 2.15e-27 | NR | MCB1108916.1 | 2052156 | g2033 | i0 | 48.3 | 0.346487006737247 | 120 | 58 | 34.6 | 1 | 362 | 3 | 27 | 142 | MCB1108916.1 methyltransferase domain-containing protein [Chlamydiia bacterium] | diamond | 360 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 28184945 | 28184945 | PRJNA594101_S_NODE_45066_length_260_cov_1.647059_g44764_i0 | PRJNA594101 | 45066 | 260 | 1.647059 | 4.2823534 | Candidatus Amphrikana amoebophyrae | 3076870 | Bacteria | Bacteria | 47 | 0.00135 | NR | MDN3504658.1 | 3076870 | g44764 | i0 | 41.5 | 0.611538461538462 | 53 | 24 | 54.2 | 2 | 245 | 105 | 130 | 181 | MDN3504658.1 glycosyltransferase family A protein [Candidatus Amphrikana amoebophyrae] | diamond | 159 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Candidatus Amphrikana | Candidatus Amphrikana amoebophyrae | |
| 28469500 | 28469500 | PRJNA594101_S_NODE_10806_length_499_cov_87.518779_g10505_i0 | PRJNA594101 | 10806 | 499 | 87.518779 | 436.71870721 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 257 | 2.44e-85 | NR | MCP5470421.1 | 2047757 | g10505 | i0 | 81.6 | 0.913827655310621 | 152 | 28 | 91.4 | 0 | 2 | 457 | 7 | 158 | MCP5470421.1 hypothetical protein [Chlamydiales bacterium] | diamond | 456 | 257 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 28690610 | 28690610 | PRJNA594101_S_NODE_58587_length_232_cov_2.069182_g58285_i0 | PRJNA594101 | 58587 | 232 | 2.069182 | 4.80050224 | Simkania sp. | 34094 | Bacteria | Bacteria | 132 | 2.42e-38 | NR | MCB1084366.1 | 34094 | g58285 | i0 | 92.1 | 0.982758620689655 | 76 | 6 | 98.3 | 0 | 3 | 230 | 22 | 97 | MCB1084366.1 hypothetical protein [Simkania sp.] | diamond | 228 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 28703903 | 28703903 | PRJNA594101_S_NODE_37207_length_284_cov_2.023697_g36905_i0 | PRJNA594101 | 37207 | 284 | 2.023697 | 5.74729948 | Bacteria | 2 | Bacteria | Bacteria | 43.9 | 0.0211 | NR | WP_194847945.1 | 1651774 | g36905 | i0 | 45.7 | 1.54225352112676 | 46 | 24 | 47.5 | 1 | 261 | 127 | 183 | 228 | WP_194847945.1 glycosyltransferase family A protein [Candidatus Neptunochlamydia vexilliferae] | diamond | 438 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Candidatus Neptunichlamydia | Candidatus Neptunichlamydia vexilliferae | |
| 29037909 | 29037909 | PRJNA594101_S_NODE_2228_length_1038_cov_102.234197_g2036_i0 | PRJNA594101 | 2228 | 1038 | 102.234197 | 1061.19096486 | Simkania sp. | 34094 | Bacteria | Bacteria | 257 | 4.7e-81 | NR | MCB1084310.1 | 34094 | g2036 | i0 | 74.7 | 0.491329479768786 | 170 | 43 | 49.1 | 0 | 275 | 784 | 1 | 170 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 510 | 257 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 29195647 | 29195647 | PRJNA594101_S_NODE_11389_length_487_cov_5.289855_g11088_i0 | PRJNA594101 | 11389 | 487 | 5.289855 | 25.76159385 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 208 | 6.22e-66 | NR | MCP5470421.1 | 2047757 | g11088 | i0 | 83.2 | 0.73305954825462 | 119 | 20 | 73.3 | 0 | 485 | 129 | 3 | 121 | MCP5470421.1 hypothetical protein [Chlamydiales bacterium] | diamond | 357 | 208 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29542757 | 29542757 | PRJNA594101_S_NODE_33150_length_299_cov_1.650442_g32848_i0 | PRJNA594101 | 33150 | 299 | 1.650442 | 4.93482158 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 63.5 | 3.47e-9 | NR | MBM3193275.1 | 2081524 | g32848 | i0 | 37.4 | 0.993311036789298 | 99 | 56 | 98.3 | 4 | 296 | 3 | 64 | 157 | MBM3193275.1 glycosyltransferase family 2 protein [Chlamydiota bacterium] | diamond | 297 | 63.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 29921974 | 29921974 | PRJNA594101_S_NODE_7871_length_582_cov_73.811395_g7571_i0 | PRJNA594101 | 7871 | 582 | 73.811395 | 429.5823189 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 213 | 2.24e-67 | NR | MCP5470420.1 | 2047757 | g7571 | i0 | 79.3 | 0.747422680412371 | 145 | 28 | 74.7 | 1 | 582 | 148 | 3 | 145 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 435 | 213 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 30648210 | 30648210 | PRJNA594101_S_NODE_24233_length_343_cov_1.803704_g23931_i0 | PRJNA594101 | 24233 | 343 | 1.803704 | 6.18670472 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 46.6 | 0.00476 | NR | MBM3208012.1 | 2081524 | g23931 | i0 | 41.2 | 0.594752186588921 | 68 | 36 | 59.5 | 3 | 343 | 140 | 193 | 256 | MBM3208012.1 hypothetical protein [Chlamydiota bacterium] | diamond | 204 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 31248798 | 31248798 | PRJNA594101_S_NODE_51015_length_248_cov_1.697143_g50713_i0 | PRJNA594101 | 51015 | 248 | 1.697143 | 4.20891464 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 64.7 | 7.27e-10 | NR | MEC7839451.1 | 2081524 | g50713 | i0 | 55.6 | 2.6491935483871 | 54 | 24 | 65.3 | 0 | 13 | 174 | 750 | 803 | MEC7839451.1 endopeptidase La [Chlamydiota bacterium] | diamond | 657 | 64.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 31533707 | 31533707 | PRJNA594101_S_NODE_2756_length_950_cov_4.379704_g2536_i0 | PRJNA594101 | 2756 | 950 | 4.379704 | 41.607188 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 117 | 3.97e-29 | NR | HNA63020.1 | 2047756 | g2536 | i0 | 70.4 | 0.224210526315789 | 71 | 21 | 22.4 | 0 | 488 | 700 | 4 | 74 | HNA63020.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 213 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 31628371 | 31628371 | PRJNA594101_S_NODE_52376_length_247_cov_0.885057_g52074_i0 | PRJNA594101 | 52376 | 247 | 0.885057 | 2.18609079 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 55.1 | 1.72e-6 | NR | MCX6990349.1 | 2081524 | g52074 | i0 | 33.8 | 1.88259109311741 | 80 | 52 | 97.2 | 1 | 245 | 6 | 464 | 542 | MCX6990349.1 hypothetical protein [Chlamydiota bacterium] | diamond | 465 | 55.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 32514527 | 32514527 | PRJNA594101_S_NODE_12979_length_458_cov_1.625974_g12677_i0 | PRJNA594101 | 12979 | 458 | 1.625974 | 7.44696092 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 84 | 5.37e-18 | NR | MCP5470423.1 | 2047757 | g12677 | i0 | 83 | 0.307860262008734 | 47 | 8 | 30.8 | 0 | 2 | 142 | 13 | 59 | MCP5470423.1 DUF2039 domain-containing protein [Chlamydiales bacterium] | diamond | 141 | 84 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 32671818 | 32671818 | PRJNA594101_S_NODE_11340_length_488_cov_7.703614_g11039_i0 | PRJNA594101 | 11340 | 488 | 7.703614 | 37.59363632 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 146 | 1.86e-41 | NR | MCP5470421.1 | 2047757 | g11039 | i0 | 52.3 | 1.84426229508197 | 151 | 66 | 91.6 | 2 | 484 | 38 | 11 | 157 | MCP5470421.1 hypothetical protein [Chlamydiales bacterium] | diamond | 900 | 146 | 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);;