contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax_phylum = "Planctomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4224734 | 4224734 | PRJNA356682_P_NODE_27244_length_283_cov_1.395238_g26553_i0 | PRJNA356682 | 27244 | 283 | 1.395238 | 3.94852354 | Isosphaeraceae bacterium | 2691532 | Bacteria | Bacteria | 176 | 5.98e-49 | NR | MFO0953044.1 | 2691532 | g26553 | i0 | 83 | 1.99293286219081 | 94 | 16 | 99.6 | 0 | 283 | 2 | 489 | 582 | MFO0953044.1 glycosyl hydrolase [Isosphaeraceae bacterium] | diamond | 564 | 176 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium | ||
| 5501441 | 5501441 | PRJNA356682_P_NODE_40105_length_246_cov_0.890173_g39414_i0 | PRJNA356682 | 40105 | 246 | 0.890173 | 2.18982558 | Fimbriiglobus | 1914234 | Bacteria | Bacteria | 130 | 1.48e-36 | NR | MCU0703645.1 | 1914235 | g39414 | i0 | 76 | 7.29268292682927 | 75 | 18 | 91.5 | 0 | 225 | 1 | 1 | 75 | MCU0703645.1 50S ribosomal protein L13 [Fimbriiglobus sp.] | diamond | 1794 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Fimbriiglobus | Fimbriiglobus sp. | |
| 18249468 | 18249468 | PRJNA356682_P_NODE_40795_length_245_cov_1.593023_g40104_i0 | PRJNA356682 | 40795 | 245 | 1.593023 | 3.90290635 | Tautonia marina | 2653855 | Bacteria | Bacteria | 79.3 | 6.38e-17 | NR | WP_152050931.1 | 2653855 | g40104 | i0 | 69.2 | 1.46938775510204 | 52 | 16 | 63.7 | 0 | 161 | 6 | 17 | 68 | WP_152050931.1 DUF4313 domain-containing protein [Tautonia marina] | diamond | 360 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Tautonia | Tautonia marina | |
| 26694879 | 26694879 | PRJNA356682_P_NODE_38401_length_248_cov_0.880000_g37710_i0 | PRJNA356682 | 38401 | 248 | 0.88 | 2.1824 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 157 | 5.02e-43 | NR | MEI8380696.1 | 2026780 | g37710 | i0 | 98.8 | 1.98387096774194 | 82 | 1 | 99.2 | 0 | 1 | 246 | 428 | 509 | MEI8380696.1 aldehyde ferredoxin oxidoreductase family protein [Planctomycetota bacterium] | diamond | 492 | 157 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27201075 | 27201075 | PRJNA356682_P_NODE_45062_length_241_cov_0.916667_g44371_i0 | PRJNA356682 | 45062 | 241 | 0.916667 | 2.20916747 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 76.3 | 3.26e-14 | NR | HJZ94682.1 | 2052164 | g44371 | i0 | 51.9 | 1.9792531120332 | 79 | 38 | 98.3 | 0 | 2 | 238 | 172 | 250 | HJZ94682.1 hypothetical protein [Gemmataceae bacterium] | diamond | 477 | 76.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 27296098 | 27296098 | PRJNA356682_P_NODE_23643_length_300_cov_2.030837_g22952_i0 | PRJNA356682 | 23643 | 300 | 2.030837 | 6.092511 | Isosphaeraceae bacterium | 2691532 | Bacteria | Bacteria | 48.1 | 8.59e-4 | NR | MDX2039050.1 | 2691532 | g22952 | i0 | 52.5 | 0.59 | 59 | 26 | 58 | 2 | 292 | 119 | 59 | 116 | MDX2039050.1 DUF3466 family protein [Isosphaeraceae bacterium] | diamond | 177 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium | ||
| 27327816 | 27327816 | PRJNA356682_P_NODE_43003_length_243_cov_0.905882_g42312_i0 | PRJNA356682 | 43003 | 243 | 0.905882 | 2.20129326 | Candidatus Brocadia sp. WS118 | 2040625 | Bacteria | Bacteria | 63.2 | 1.07e-9 | NR | TVL99009.1 | 2040625 | g42312 | i0 | 44.2 | 0.950617283950617 | 77 | 42 | 95.1 | 1 | 233 | 3 | 110 | 185 | TVL99009.1 MAG: hypothetical protein CV087_19700 [Candidatus Brocadia sp. WS118] | diamond | 231 | 63.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiales | Candidatus Brocadiaceae | Candidatus Brocadia | Candidatus Brocadia sp. WS118 | |
| 28085450 | 28085450 | PRJNA356682_P_NODE_40285_length_246_cov_0.890173_g39594_i0 | PRJNA356682 | 40285 | 246 | 0.890173 | 2.18982558 | Planctomycetia bacterium | 2052181 | Bacteria | Bacteria | 88.2 | 2.17e-18 | NR | MBL8823424.1 | 2052181 | g39594 | i0 | 55.7 | 0.963414634146341 | 79 | 35 | 96.3 | 0 | 6 | 242 | 216 | 294 | MBL8823424.1 DUF1573 domain-containing protein [Planctomycetia bacterium] | diamond | 237 | 88.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetia bacterium | ||||
| 28527804 | 28527804 | PRJNA356682_P_NODE_42047_length_244_cov_0.900585_g41356_i0 | PRJNA356682 | 42047 | 244 | 0.900585 | 2.1974274 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 155 | 6.2e-42 | NR | MEI8381335.1 | 2026780 | g41356 | i0 | 85.2 | 0.995901639344262 | 81 | 12 | 99.6 | 0 | 243 | 1 | 17 | 97 | MEI8381335.1 thioredoxin-like domain-containing protein [Planctomycetota bacterium] | diamond | 243 | 155 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28906245 | 28906245 | PRJNA356682_P_NODE_23688_length_300_cov_1.356828_g22997_i0 | PRJNA356682 | 23688 | 300 | 1.356828 | 4.070484 | Singulisphaera acidiphila | 466153 | Bacteria | Bacteria | 166 | 2.24e-46 | NR | WP_015250257.1 | 466153 | g22997 | i0 | 78.6 | 1.96 | 98 | 21 | 98 | 0 | 3 | 296 | 397 | 494 | WP_015250257.1 kelch repeat-containing protein [Singulisphaera acidiphila] | diamond | 588 | 166 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Singulisphaera | Singulisphaera acidiphila | |
| 29064481 | 29064481 | PRJNA356682_P_NODE_36028_length_251_cov_0.865169_g35337_i0 | PRJNA356682 | 36028 | 251 | 0.865169 | 2.17157419 | Pirellulales bacterium | 2715253 | Bacteria | Bacteria | 105 | 2.24e-26 | NR | HJS08024.1 | 2715253 | g35337 | i0 | 96.2 | 0.621513944223108 | 52 | 2 | 62.2 | 0 | 95 | 250 | 1 | 52 | HJS08024.1 quinol:electron acceptor oxidoreductase subunit ActD [Pirellulales bacterium] | diamond | 156 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 29064486 | 29064486 | PRJNA356682_P_NODE_44748_length_241_cov_0.916667_g44057_i0 | PRJNA356682 | 44748 | 241 | 0.916667 | 2.20916747 | Caulifigura sp. | 2795792 | Bacteria | Bacteria | 51.2 | 1.21e-5 | NR | HVJ86290.1 | 2795792 | g44057 | i0 | 71.9 | 1.25726141078838 | 32 | 8 | 38.6 | 1 | 132 | 40 | 19 | 50 | HVJ86290.1 hypothetical protein [Caulifigura sp.] | diamond | 303 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Caulifigura | Caulifigura sp. | |
| 29190761 | 29190761 | PRJNA356682_P_NODE_43249_length_243_cov_0.864706_g42558_i0 | PRJNA356682 | 43249 | 243 | 0.864706 | 2.10123558 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 93.2 | 6.33e-20 | NR | MFO0808116.1 | 2052164 | g42558 | i0 | 53.2 | 0.950617283950617 | 77 | 34 | 95.1 | 1 | 8 | 238 | 225 | 299 | MFO0808116.1 DUF1570 domain-containing protein [Gemmataceae bacterium] | diamond | 231 | 93.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 29253539 | 29253539 | PRJNA356682_P_NODE_44929_length_241_cov_0.916667_g44238_i0 | PRJNA356682 | 44929 | 241 | 0.916667 | 2.20916747 | Isosphaeraceae bacterium | 2691532 | Bacteria | Bacteria | 147 | 2.5299999999999993e-42 | NR | MBX6311653.1 | 2691532 | g44238 | i0 | 82.5 | 2.98755186721992 | 80 | 14 | 99.6 | 0 | 240 | 1 | 107 | 186 | MBX6311653.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Isosphaeraceae bacterium] | diamond | 720 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium | ||
| 29821859 | 29821859 | PRJNA356682_P_NODE_40371_length_246_cov_0.890173_g39680_i0 | PRJNA356682 | 40371 | 246 | 0.890173 | 2.18982558 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 92 | 1.77e-19 | NR | MCA9048126.1 | 2026779 | g39680 | i0 | 58.5 | 2 | 82 | 33 | 98.8 | 1 | 4 | 246 | 178 | 259 | MCA9048126.1 protein kinase [Planctomycetaceae bacterium] | diamond | 492 | 92 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 29853777 | 29853777 | PRJNA356682_P_NODE_35931_length_251_cov_0.865169_g35240_i0 | PRJNA356682 | 35931 | 251 | 0.865169 | 2.17157419 | Isosphaeraceae bacterium | 2691532 | Bacteria | Bacteria | 108 | 1.3e-28 | NR | MDX2037055.1 | 2691532 | g35240 | i0 | 68.5 | 1.74501992031873 | 73 | 23 | 87.3 | 0 | 249 | 31 | 15 | 87 | MDX2037055.1 hypothetical protein [Isosphaeraceae bacterium] | diamond | 438 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium | ||
| 30106332 | 30106332 | PRJNA356682_P_NODE_31352_length_266_cov_1.481865_g30661_i0 | PRJNA356682 | 31352 | 266 | 1.481865 | 3.9417609 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 117 | 2.89e-29 | NR | MCC7420551.1 | 2026779 | g30661 | i0 | 72.7 | 0.992481203007519 | 88 | 23 | 99.2 | 1 | 266 | 3 | 58 | 144 | MCC7420551.1 universal stress protein [Planctomycetaceae bacterium] | diamond | 264 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 30232805 | 30232805 | PRJNA356682_P_NODE_37412_length_249_cov_1.670455_g36721_i0 | PRJNA356682 | 37412 | 249 | 1.670455 | 4.15943295 | Paludisphaera borealis | 1387353 | Bacteria | Bacteria | 45.8 | 0.00329 | NR | APW58645.1 | 1387353 | g36721 | i0 | 63.6 | 0.397590361445783 | 33 | 12 | 39.8 | 0 | 1 | 99 | 443 | 475 | APW58645.1 Tyrosine recombinase XerC [Paludisphaera borealis] | diamond | 99 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Paludisphaera | Paludisphaera borealis | |
| 30801423 | 30801423 | PRJNA356682_P_NODE_37874_length_249_cov_0.875000_g37183_i0 | PRJNA356682 | 37874 | 249 | 0.875 | 2.17875 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 119 | 7.409999999999999e-31 | NR | MCE9635641.1 | 2026780 | g37183 | i0 | 69.6 | 0.951807228915663 | 79 | 24 | 95.2 | 0 | 249 | 13 | 11 | 89 | MCE9635641.1 hypothetical protein [Planctomycetota bacterium] | diamond | 237 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31243847 | 31243847 | PRJNA356682_P_NODE_35715_length_251_cov_1.730337_g35024_i0 | PRJNA356682 | 35715 | 251 | 1.730337 | 4.34314587 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 122 | 3.08e-31 | NR | MFN9343688.1 | 2026780 | g35024 | i0 | 79.1 | 2.40239043824701 | 67 | 14 | 80.1 | 0 | 250 | 50 | 327 | 393 | MFN9343688.1 FAD/NAD(P)-binding oxidoreductase [Planctomycetota bacterium] | diamond | 603 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31338720 | 31338720 | PRJNA356682_P_NODE_36836_length_250_cov_0.870056_g36145_i0 | PRJNA356682 | 36836 | 250 | 0.870056 | 2.17514 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 103 | 1.33e-26 | NR | HJZ90207.1 | 2052164 | g36145 | i0 | 83.9 | 0.672 | 56 | 9 | 67.2 | 0 | 82 | 249 | 1 | 56 | HJZ90207.1 RNA-binding protein [Gemmataceae bacterium] | diamond | 168 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 31497093 | 31497093 | PRJNA356682_P_NODE_15196_length_364_cov_1.058419_g14506_i0 | PRJNA356682 | 15196 | 364 | 1.058419 | 3.85264516 | Singulisphaera sp. Ch | 1906241 | Bacteria | Bacteria | 154 | 1.15e-41 | NR | WP_406694151.1 | 3120278 | g14506 | i0 | 60.9 | 5.1510989010989 | 128 | 42 | 98.9 | 2 | 362 | 3 | 146 | 273 | WP_406694151.1 kelch repeat-containing protein [Singulisphaera sp. Ch08] | diamond | 1875 | 154 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Singulisphaera | Singulisphaera sp. Ch08 | |
| 31528697 | 31528697 | PRJNA356682_P_NODE_37176_length_250_cov_0.870056_g36485_i0 | PRJNA356682 | 37176 | 250 | 0.870056 | 2.17514 | Pirellulales bacterium | 2715253 | Bacteria | Bacteria | 160 | 4.5e-45 | NR | MFO0884181.1 | 2715253 | g36485 | i0 | 92.8 | 0.996 | 83 | 6 | 99.6 | 0 | 250 | 2 | 279 | 361 | MFO0884181.1 NAD(P)/FAD-dependent oxidoreductase [Pirellulales bacterium] | diamond | 249 | 160 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 31686620 | 31686620 | PRJNA356682_P_NODE_39357_length_247_cov_0.885057_g38666_i0 | PRJNA356682 | 39357 | 247 | 0.885057 | 2.18609079 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 163 | 5.3999999999999996e-48 | NR | MEI8381084.1 | 2026780 | g38666 | i0 | 93.8 | 0.983805668016194 | 81 | 5 | 98.4 | 0 | 3 | 245 | 21 | 101 | MEI8381084.1 methyltransferase domain-containing protein [Planctomycetota bacterium] | diamond | 243 | 163 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32003104 | 32003104 | PRJNA356682_P_NODE_41118_length_245_cov_0.895349_g40427_i0 | PRJNA356682 | 41118 | 245 | 0.895349 | 2.19360505 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 43.9 | 0.0145 | NR | HUO07241.1 | 2026778 | g40427 | i0 | 50 | 0.489795918367347 | 40 | 18 | 49 | 2 | 85 | 204 | 297 | 334 | HUO07241.1 radical SAM family heme chaperone HemW [Phycisphaerae bacterium] | diamond | 120 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 32509602 | 32509602 | PRJNA356682_P_NODE_11819_length_408_cov_1.838806_g11129_i0 | PRJNA356682 | 11819 | 408 | 1.838806 | 7.50232848 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 77.4 | 1.59e-14 | NR | MBS0267013.1 | 2026780 | g11129 | i0 | 40.1 | 1.00735294117647 | 137 | 78 | 97.8 | 3 | 400 | 2 | 36 | 172 | MBS0267013.1 PEP-CTERM sorting domain-containing protein [Planctomycetota bacterium] | diamond | 411 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota 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);;