contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA930380" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26644861 | 26644861 | PRJNA930380_P_NODE_5981_length_291_cov_2.178899_g5928_i0 | PRJNA930380 | 5981 | 291 | 2.178899 | 6.34059609 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 67.8 | 1.01e-10 | NR | MCG8430354.1 | 2035772 | g5928 | i0 | 42.5 | 1.77319587628866 | 87 | 50 | 89.7 | 0 | 268 | 8 | 65 | 151 | MCG8430354.1 reverse transcriptase family protein [Candidatus Omnitrophota bacterium] | diamond | 516 | 67.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 26835204 | 26835204 | PRJNA930380_P_NODE_7781_length_283_cov_2.152381_g7728_i0 | PRJNA930380 | 7781 | 283 | 2.152381 | 6.09123823 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 69.3 | 5.78e-12 | NR | MEG2248925.1 | 1872421 | g7728 | i0 | 62.3 | 0.561837455830389 | 53 | 20 | 56.2 | 0 | 208 | 50 | 82 | 134 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 159 | 69.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27119494 | 27119494 | PRJNA930380_P_NODE_6182_length_290_cov_2.253456_g6129_i0 | PRJNA930380 | 6182 | 290 | 2.253456 | 6.5350224 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 72.8 | 2.95e-13 | NR | MEG2248925.1 | 1872421 | g6129 | i0 | 63.3 | 0.620689655172414 | 60 | 22 | 62.1 | 0 | 290 | 111 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 72.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27688790 | 27688790 | PRJNA930380_P_NODE_6844_length_287_cov_3.593458_g6791_i0 | PRJNA930380 | 6844 | 287 | 3.593458 | 10.31322446 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 62.4 | 2.55e-9 | NR | MEG2248925.1 | 1872421 | g6791 | i0 | 64.6 | 0.501742160278746 | 48 | 17 | 50.2 | 0 | 267 | 124 | 153 | 200 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 144 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28098754 | 28098754 | PRJNA930380_P_NODE_6345_length_290_cov_1.096774_g6292_i0 | PRJNA930380 | 6345 | 290 | 1.096774 | 3.1806446 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.1 | 0.0467 | NR | MCH8219576.1 | 2026780 | g6292 | i0 | 42.9 | 0.506896551724138 | 49 | 24 | 50.7 | 1 | 55 | 201 | 476 | 520 | MCH8219576.1 peptide chain release factor 3 [Planctomycetota bacterium] | diamond | 147 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28162148 | 28162148 | PRJNA930380_P_NODE_9985_length_271_cov_1.267677_g9932_i0 | PRJNA930380 | 9985 | 271 | 1.267677 | 3.43540467 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 48.9 | 2.29e-4 | NR | MEG2248925.1 | 1872421 | g9932 | i0 | 53.7 | 0.453874538745387 | 41 | 19 | 45.4 | 0 | 149 | 271 | 1 | 41 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 123 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28351393 | 28351393 | PRJNA930380_P_NODE_6006_length_291_cov_1.958716_g5953_i0 | PRJNA930380 | 6006 | 291 | 1.958716 | 5.69986356 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 55.5 | 1.05e-6 | NR | MEG2248925.1 | 1872421 | g5953 | i0 | 52.9 | 0.525773195876289 | 51 | 24 | 52.6 | 0 | 290 | 138 | 143 | 193 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 153 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28509340 | 28509340 | PRJNA930380_P_NODE_8867_length_278_cov_1.434146_g8814_i0 | PRJNA930380 | 8867 | 278 | 1.434146 | 3.98692588 | Tepidisphaeraceae bacterium | 2876886 | Bacteria | Bacteria | 44.7 | 0.0119 | NR | HWE04171.1 | 2876886 | g8814 | i0 | 39.7 | 0.679856115107914 | 63 | 38 | 68 | 0 | 271 | 83 | 376 | 438 | HWE04171.1 peptidylprolyl isomerase [Tepidisphaeraceae bacterium] | diamond | 189 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Tepidisphaeraceae bacterium | ||
| 28572404 | 28572404 | PRJNA930380_P_NODE_9347_length_275_cov_1.396040_g9294_i0 | PRJNA930380 | 9347 | 275 | 1.39604 | 3.83911 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 46.6 | 0.00166 | NR | MEG2248925.1 | 1872421 | g9294 | i0 | 54.1 | 0.403636363636364 | 37 | 17 | 40.4 | 0 | 151 | 261 | 1 | 37 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 111 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29014794 | 29014794 | PRJNA930380_P_NODE_6568_length_289_cov_1.180556_g6515_i0 | PRJNA930380 | 6568 | 289 | 1.180556 | 3.41180684 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 79 | 1.28e-15 | NR | MEG2248925.1 | 1872421 | g6515 | i0 | 60.7 | 0.633217993079585 | 61 | 24 | 63.3 | 0 | 107 | 289 | 83 | 143 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 183 | 79 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29046155 | 29046155 | PRJNA930380_P_NODE_6608_length_288_cov_6.665116_g6555_i0 | PRJNA930380 | 6608 | 288 | 6.665116 | 19.19553408 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 175 | 1.7299999999999998e-54 | NR | MEG2248926.1 | 1872421 | g6555 | i0 | 94.7 | 0.979166666666667 | 94 | 5 | 97.9 | 0 | 5 | 286 | 28 | 121 | MEG2248926.1 hypothetical protein [Akkermansia sp.] | diamond | 282 | 175 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29046161 | 29046161 | PRJNA930380_P_NODE_8228_length_281_cov_1.764423_g8175_i0 | PRJNA930380 | 8228 | 281 | 1.764423 | 4.95802863 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 86.7 | 1.48e-17 | NR | MCG8431411.1 | 2035772 | g8175 | i0 | 51.9 | 1.68683274021352 | 81 | 39 | 86.5 | 0 | 249 | 7 | 305 | 385 | MCG8431411.1 reverse transcriptase family protein [Candidatus Omnitrophota bacterium] | diamond | 474 | 87.4 | 0.991990846681922 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29077772 | 29077772 | PRJNA930380_P_NODE_5388_length_294_cov_2.778281_g5335_i0 | PRJNA930380 | 5388 | 294 | 2.778281 | 8.16814614 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 77.4 | 5.19e-15 | NR | MEG2248925.1 | 1872421 | g5335 | i0 | 70 | 0.612244897959184 | 60 | 18 | 61.2 | 0 | 292 | 113 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29961775 | 29961775 | PRJNA930380_P_NODE_5171_length_296_cov_2.304933_g5118_i0 | PRJNA930380 | 5171 | 296 | 2.304933 | 6.82260168 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 43.5 | 0.0384 | NR | NLF17256.1 | 1932692 | g5118 | i0 | 37.5 | 0.648648648648649 | 64 | 34 | 58.8 | 2 | 35 | 208 | 295 | 358 | NLF17256.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 192 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 30025131 | 30025131 | PRJNA930380_P_NODE_6451_length_289_cov_1.962963_g6398_i0 | PRJNA930380 | 6451 | 289 | 1.962963 | 5.67296307 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 76.3 | 1.39e-14 | NR | MEG2248925.1 | 1872421 | g6398 | i0 | 68.5 | 0.560553633217993 | 54 | 17 | 56.1 | 0 | 288 | 127 | 143 | 196 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 162 | 76.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 30372900 | 30372900 | PRJNA930380_P_NODE_6172_length_290_cov_2.576037_g6119_i0 | PRJNA930380 | 6172 | 290 | 2.576037 | 7.4705073 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 74.3 | 7.6e-14 | NR | MEG2248925.1 | 1872421 | g6119 | i0 | 60 | 0.620689655172414 | 60 | 24 | 62.1 | 0 | 290 | 111 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 31257199 | 31257199 | PRJNA930380_P_NODE_5375_length_294_cov_3.850679_g5322_i0 | PRJNA930380 | 5375 | 294 | 3.850679 | 11.32099626 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 74.7 | 5.62e-14 | NR | MEG2248925.1 | 1872421 | g5322 | i0 | 66.7 | 0.612244897959184 | 60 | 20 | 61.2 | 0 | 3 | 182 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 74.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 31383875 | 31383875 | PRJNA930380_P_NODE_5156_length_296_cov_2.744395_g5103_i0 | PRJNA930380 | 5156 | 296 | 2.744395 | 8.1234092 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 82.8 | 4.54e-17 | NR | MEG2248925.1 | 1872421 | g5103 | i0 | 41.9 | 0.942567567567568 | 93 | 54 | 94.3 | 0 | 290 | 12 | 43 | 135 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 279 | 82.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 31542016 | 31542016 | PRJNA930380_P_NODE_14296_length_241_cov_0.916667_g14243_i0 | PRJNA930380 | 14296 | 241 | 0.916667 | 2.20916747 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 43.9 | 0.00486 | NR | MFO0894886.1 | 2052180 | g14243 | i0 | 47.4 | 0.473029045643154 | 38 | 20 | 47.3 | 0 | 126 | 13 | 14 | 51 | MFO0894886.1 PQQ-binding-like beta-propeller repeat protein [Phycisphaerales bacterium] | diamond | 114 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 32111361 | 32111361 | PRJNA930380_P_NODE_6018_length_291_cov_1.811927_g5965_i0 | PRJNA930380 | 6018 | 291 | 1.811927 | 5.27270757 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 72.4 | 4.15e-13 | NR | MEG2248925.1 | 1872421 | g5965 | i0 | 61.7 | 0.618556701030928 | 60 | 23 | 61.9 | 0 | 290 | 111 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32238185 | 32238185 | PRJNA930380_P_NODE_6118_length_291_cov_0.908257_g6065_i0 | PRJNA930380 | 6118 | 291 | 0.908257 | 2.64302787 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 57 | 6.12e-7 | NR | MCG8430559.1 | 2035772 | g6065 | i0 | 45 | 0.824742268041237 | 80 | 41 | 80.4 | 3 | 42 | 275 | 390 | 468 | MCG8430559.1 reverse transcriptase family protein [Candidatus Omnitrophota bacterium] | diamond | 240 | 57 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32586033 | 32586033 | PRJNA930380_P_NODE_6179_length_290_cov_2.400922_g6126_i0 | PRJNA930380 | 6179 | 290 | 2.400922 | 6.9626738 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 63.5 | 9.68e-10 | NR | MEG2248925.1 | 1872421 | g6126 | i0 | 54.4 | 0.589655172413793 | 57 | 26 | 59 | 0 | 269 | 99 | 150 | 206 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 171 | 63.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32743400 | 32743400 | PRJNA930380_P_NODE_6420_length_289_cov_2.444444_g6367_i0 | PRJNA930380 | 6420 | 289 | 2.444444 | 7.06444316 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 73.2 | 2.11e-13 | NR | MEG2248925.1 | 1872421 | g6367 | i0 | 58.1 | 0.643598615916955 | 62 | 26 | 64.4 | 0 | 2 | 187 | 143 | 204 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 186 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32837637 | 32837637 | PRJNA930380_P_NODE_5420_length_294_cov_2.090498_g5367_i0 | PRJNA930380 | 5420 | 294 | 2.090498 | 6.14606412 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 84 | 1.57e-17 | NR | MEG2248925.1 | 1872421 | g5367 | i0 | 51.1 | 0.897959183673469 | 88 | 43 | 89.8 | 0 | 6 | 269 | 43 | 130 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 264 | 84 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. |
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);;