contig_metadata
22 rows where bioproject = "PRJNA635874" and tax_phylum = "Endomyxa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8260064 | 8260064 | PRJNA635874_P_NODE_16527_length_379_cov_1.176471_g16380_i0 | PRJNA635874 | 16527 | 379 | 1.176471 | 4.45882509 | root | 1 | Root_unresolved | Root_unresolved | 164 | 1.7e-45 | NR | CEO95191.1 | 37360 | g16380 | i0 | 59.1 | 5.17678100263852 | 132 | 47 | 98.9 | 1 | 5 | 379 | 40 | 171 | CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] | diamond | 1962 | 165 | 0.993939393939394 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 9535380 | 9535380 | PRJNA635874_P_NODE_17948_length_367_cov_1.302721_g17801_i0 | PRJNA635874 | 17948 | 367 | 1.302721 | 4.78098607 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 1.5399999999999998e-57 | NR | CEO99397.1 | 37360 | g17801 | i0 | 73.8 | 0.997275204359673 | 122 | 31 | 99.7 | 1 | 367 | 2 | 130 | 250 | CEO99397.1 hypothetical protein PBRA_001303 [Plasmodiophora brassicae] | diamond | 366 | 191 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 9536833 | 9536833 | PRJNA635874_P_NODE_73708_length_241_cov_0.916667_g73561_i0 | PRJNA635874 | 73708 | 241 | 0.916667 | 2.20916747 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 1.09e-16 | NR | AVG22654.1 | 37360 | g73561 | i0 | 57.9 | 0.70954356846473 | 57 | 24 | 71 | 0 | 239 | 69 | 640 | 696 | AVG22654.1 MAPKKK7 [Plasmodiophora brassicae] | diamond | 171 | 84 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 10811408 | 10811408 | PRJNA635874_P_NODE_2869_length_761_cov_1.325581_g2741_i0 | PRJNA635874 | 2869 | 761 | 1.325581 | 10.08767141 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 3.1e-83 | NR | CEO97530.1 | 37360 | g2741 | i0 | 80.8 | 0.59526938239159 | 151 | 29 | 59.5 | 0 | 756 | 304 | 1 | 151 | CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] | diamond | 453 | 255 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 10812285 | 10812285 | PRJNA635874_P_NODE_62349_length_245_cov_0.895349_g62202_i0 | PRJNA635874 | 62349 | 245 | 0.895349 | 2.19360505 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.27e-33 | NR | CEP00240.1 | 37360 | g62202 | i0 | 79 | 4.95918367346939 | 81 | 17 | 99.2 | 0 | 244 | 2 | 96 | 176 | CEP00240.1 hypothetical protein PBRA_007974 [Plasmodiophora brassicae] | diamond | 1215 | 129 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 13361483 | 13361483 | PRJNA635874_P_NODE_3391_length_715_cov_3.651090_g3254_i0 | PRJNA635874 | 3391 | 715 | 3.65109 | 26.1052935 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 1.19e-70 | NR | CEP02379.1 | 37360 | g3254 | i0 | 57.1 | 1.71188811188811 | 219 | 87 | 89 | 3 | 701 | 66 | 92 | 310 | CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] | diamond | 1224 | 229 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 15911150 | 15911150 | PRJNA635874_P_NODE_72273_length_241_cov_0.916667_g72126_i0 | PRJNA635874 | 72273 | 241 | 0.916667 | 2.20916747 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.37e-25 | NR | CEO94948.1 | 37360 | g72126 | i0 | 63.5 | 2.11618257261411 | 85 | 26 | 99.6 | 1 | 241 | 2 | 26 | 110 | CEO94948.1 hypothetical protein PBRA_003761 [Plasmodiophora brassicae] | diamond | 510 | 109 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 19733674 | 19733674 | PRJNA635874_P_NODE_22376_length_338_cov_1.162264_g22229_i0 | PRJNA635874 | 22376 | 338 | 1.162264 | 3.92845232 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 1.9e-17 | NR | CEO96338.1 | 37360 | g22229 | i0 | 63.8 | 3.99408284023669 | 69 | 25 | 61.2 | 0 | 208 | 2 | 14 | 82 | CEO96338.1 hypothetical protein PBRA_005008 [Plasmodiophora brassicae] | diamond | 1350 | 87.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 20281062 | 20281062 | PRJNA635874_P_NODE_4476_length_645_cov_1.354895_g4333_i0 | PRJNA635874 | 4476 | 645 | 1.354895 | 8.73907275 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 2.76e-45 | NR | SPQ93437.1 | 37360 | g4333 | i0 | 66.4 | 1.56279069767442 | 113 | 38 | 52.6 | 0 | 638 | 300 | 32 | 144 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1008 | 157 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 22285496 | 22285496 | PRJNA635874_P_NODE_9878_length_466_cov_1.554707_g9731_i0 | PRJNA635874 | 9878 | 466 | 1.554707 | 7.24493462 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 216 | 4.4599999999999985e-68 | NR | CEP01968.1 | 37360 | g9731 | i0 | 70.7 | 11.6008583690987 | 150 | 42 | 96.6 | 1 | 16 | 465 | 1 | 148 | CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] | diamond | 5406 | 216 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26637742 | 26637742 | PRJNA635874_P_NODE_41361_length_265_cov_1.203125_g41214_i0 | PRJNA635874 | 41361 | 265 | 1.203125 | 3.18828125 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.56e-28 | NR | CEO96095.1 | 37360 | g41214 | i0 | 57 | 0.973584905660377 | 86 | 37 | 97.4 | 0 | 2 | 259 | 130 | 215 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 258 | 113 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27143759 | 27143759 | PRJNA635874_P_NODE_29022_length_306_cov_1.849785_g28875_i0 | PRJNA635874 | 29022 | 306 | 1.849785 | 5.6603421 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 5.5500000000000004e-36 | NR | CEP02451.1 | 37360 | g28875 | i0 | 65 | 0.980392156862745 | 100 | 35 | 98 | 0 | 1 | 300 | 4242 | 4341 | CEP02451.1 hypothetical protein PBRA_009035 [Plasmodiophora brassicae] | diamond | 300 | 140 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27270554 | 27270554 | PRJNA635874_P_NODE_12563_length_423_cov_1.097143_g12416_i0 | PRJNA635874 | 12563 | 423 | 1.097143 | 4.64091489 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 6.66e-22 | NR | CEO95180.1 | 37360 | g12416 | i0 | 38.8 | 1.85815602836879 | 129 | 78 | 91.5 | 1 | 4 | 390 | 66 | 193 | CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] | diamond | 786 | 101 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27365747 | 27365747 | PRJNA635874_P_NODE_28283_length_310_cov_1.050633_g28136_i0 | PRJNA635874 | 28283 | 310 | 1.050633 | 3.2569623 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 4.1e-7 | NR | CEP02632.1 | 37360 | g28136 | i0 | 39.4 | 0.687096774193548 | 71 | 18 | 68.7 | 2 | 302 | 90 | 93 | 138 | CEP02632.1 hypothetical protein PBRA_002599 [Plasmodiophora brassicae] | diamond | 213 | 57.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27649724 | 27649724 | PRJNA635874_P_NODE_16824_length_376_cov_2.033003_g16677_i0 | PRJNA635874 | 16824 | 376 | 2.033003 | 7.64409128 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.3899999999999999e-46 | NR | CEP03344.1 | 37360 | g16677 | i0 | 66.1 | 2.81648936170213 | 115 | 39 | 91.8 | 0 | 375 | 31 | 76 | 190 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 1059 | 159 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29669982 | 29669982 | PRJNA635874_P_NODE_24390_length_327_cov_1.212598_g24243_i0 | PRJNA635874 | 24390 | 327 | 1.212598 | 3.96519546 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 7.92e-22 | NR | CEO97683.1 | 37360 | g24243 | i0 | 46.8 | 2 | 109 | 53 | 100 | 1 | 327 | 1 | 250 | 353 | CEO97683.1 hypothetical protein PBRA_005797 [Plasmodiophora brassicae] | diamond | 654 | 99 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29764924 | 29764924 | PRJNA635874_P_NODE_28431_length_309_cov_1.305085_g28284_i0 | PRJNA635874 | 28431 | 309 | 1.305085 | 4.03271265 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 3.22e-39 | NR | CEO95693.1 | 37360 | g28284 | i0 | 63.7 | 0.990291262135922 | 102 | 37 | 99 | 0 | 4 | 309 | 295 | 396 | CEO95693.1 hypothetical protein PBRA_004406 [Plasmodiophora brassicae] | diamond | 306 | 147 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30207092 | 30207092 | PRJNA635874_P_NODE_8312_length_501_cov_2.306075_g8166_i0 | PRJNA635874 | 8312 | 501 | 2.306075 | 11.55343575 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 1.0999999999999999e-89 | NR | CEP01219.1 | 37360 | g8166 | i0 | 78.3 | 0.994011976047904 | 166 | 30 | 95.8 | 1 | 482 | 3 | 132 | 297 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 498 | 274 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30283453 | 30283453 | PRJNA635874_P_NODE_13952_length_405_cov_1.436747_g13805_i0 | PRJNA635874 | 13952 | 405 | 1.436747 | 5.81882535 | Endomyxa | 2604748 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 5.53e-36 | NR | CEP02236.1 | 37360 | g13805 | i0 | 55.5 | 2.64444444444444 | 119 | 53 | 88.1 | 0 | 383 | 27 | 1 | 119 | CEP02236.1 hypothetical protein PBRA_002501 [Plasmodiophora brassicae] | diamond | 1071 | 130 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31692815 | 31692815 | PRJNA635874_P_NODE_52657_length_249_cov_0.875000_g52510_i0 | PRJNA635874 | 52657 | 249 | 0.875 | 2.17875 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 6.6000000000000005e-34 | NR | SPQ95814.1 | 37360 | g52510 | i0 | 77.1 | 1 | 83 | 19 | 100 | 0 | 1 | 249 | 945 | 1027 | SPQ95814.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 249 | 133 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31756107 | 31756107 | PRJNA635874_P_NODE_38757_length_272_cov_2.713568_g38610_i0 | PRJNA635874 | 38757 | 272 | 2.713568 | 7.38090496 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 5.32e-28 | NR | CEP02593.1 | 37360 | g38610 | i0 | 64 | 0.948529411764706 | 86 | 31 | 94.9 | 0 | 259 | 2 | 11 | 96 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 258 | 107 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32230912 | 32230912 | PRJNA635874_P_NODE_35778_length_282_cov_1.368421_g35631_i0 | PRJNA635874 | 35778 | 282 | 1.368421 | 3.85894722 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.85e-34 | NR | CEO96023.1 | 37360 | g35631 | i0 | 67.4 | 2.01063829787234 | 95 | 27 | 100 | 2 | 1 | 282 | 122 | 213 | CEO96023.1 hypothetical protein PBRA_004713 [Plasmodiophora brassicae] | diamond | 567 | 130 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae |
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);;