contig_metadata
21 rows where bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8500963 | 8500963 | PRJNA867519_P_NODE_19627_length_277_cov_1.617647_g19473_i0 | PRJNA867519 | 19627 | 277 | 1.617647 | 4.48088219 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 2.95e-25 | NR | CEO98457.1 | 37360 | g19473 | i0 | 71.4 | 16.884476534296 | 70 | 20 | 75.8 | 0 | 277 | 68 | 119 | 188 | CEO98457.1 hypothetical protein PBRA_006571 [Plasmodiophora brassicae] | diamond | 4677 | 104 | 0.990384615384615 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 8501105 | 8501105 | PRJNA867519_P_NODE_607_length_1118_cov_6.237321_g503_i0 | PRJNA867519 | 607 | 1118 | 6.237321 | 69.73324878 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 426 | 7.159999999999997e-145 | NR | CEP03396.1 | 37360 | g503 | i0 | 57.4 | 0.901610017889088 | 336 | 133 | 88.8 | 5 | 1060 | 68 | 42 | 372 | CEP03396.1 hypothetical protein PBRA_003156 [Plasmodiophora brassicae] | diamond | 1008 | 426 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 13601682 | 13601682 | PRJNA867519_P_NODE_1031_length_919_cov_2.791962_g906_i0 | PRJNA867519 | 1031 | 919 | 2.791962 | 25.65813078 | Arachnula sp. CL12 | 862247 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 7.399999999999998e-162 | NTclustered | gi|302026178|gb|GQ377695.1| | 862247 | g906 | i0 | 79.062 | 74.0163220892274 | 874 | 165 | 94 | 16 | 55 | 919 | 1302 | 438 | Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds | blastn | 68021 | 584 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | Arachnula | Arachnula sp. CL12 | |||
| 14876225 | 14876225 | PRJNA867519_P_NODE_8272_length_386_cov_2.696486_g8118_i0 | PRJNA867519 | 8272 | 386 | 2.696486 | 10.40843596 | Arachnula sp. CL12 | 862247 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 1.09e-136 | NTclustered | gi|302026178|gb|GQ377695.1| | 862247 | g8118 | i0 | 90.13 | 90.9663212435233 | 385 | 36 | 99 | 2 | 1 | 384 | 287 | 670 | Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds | blastn | 35113 | 499 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | Arachnula | Arachnula sp. CL12 | |||
| 17426256 | 17426256 | PRJNA867519_P_NODE_16374_length_292_cov_2.894977_g16220_i0 | PRJNA867519 | 16374 | 292 | 2.894977 | 8.45333284 | Bonamia ostreae | 126728 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 1e-36 | NR | MES1921291.1 | 126728 | g16220 | i0 | 66.3 | 10.6849315068493 | 95 | 26 | 97.6 | 1 | 290 | 6 | 56 | 144 | MES1921291.1 Serine/threonine-protein phosphatase PP1-beta catalytic subunit [Bonamia ostreae] | diamond | 3120 | 131 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 17814420 | 17814420 | PRJNA867519_P_NODE_2314_length_659_cov_34.462457_g2165_i0 | PRJNA867519 | 2314 | 659 | 34.462457 | 227.10759163 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 7.62e-73 | NR | CEP02281.1 | 37360 | g2165 | i0 | 61.3 | 4.70257966616085 | 204 | 76 | 92.9 | 2 | 653 | 42 | 1 | 201 | CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] | diamond | 3099 | 229 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21250209 | 21250209 | PRJNA867519_P_NODE_15437_length_300_cov_2.713656_g15283_i0 | PRJNA867519 | 15437 | 300 | 2.713656 | 8.140968 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 9.25e-46 | NR | CEO99768.1 | 37360 | g15283 | i0 | 70.4 | 12.65 | 98 | 29 | 98 | 0 | 296 | 3 | 1 | 98 | CEO99768.1 hypothetical protein PBRA_007502 [Plasmodiophora brassicae] | diamond | 3795 | 154 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 24188516 | 24188516 | PRJNA867519_P_NODE_4539_length_499_cov_3.173709_g4386_i0 | PRJNA867519 | 4539 | 499 | 3.173709 | 15.83680791 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.54e-41 | NR | SPQ93437.1 | 37360 | g4386 | i0 | 67 | 3.86573146292585 | 103 | 34 | 61.9 | 0 | 489 | 181 | 32 | 134 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1929 | 145 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26620071 | 26620071 | PRJNA867519_P_NODE_26761_length_250_cov_0.870056_g26607_i0 | PRJNA867519 | 26761 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.31e-8 | NR | CEP02772.1 | 37360 | g26607 | i0 | 42.1 | 3.264 | 76 | 41 | 91.2 | 2 | 244 | 17 | 508 | 580 | CEP02772.1 hypothetical protein PBRA_002739 [Plasmodiophora brassicae] | diamond | 816 | 60.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27907701 | 27907701 | PRJNA867519_P_NODE_29065_length_247_cov_0.885057_g28911_i0 | PRJNA867519 | 29065 | 247 | 0.885057 | 2.18609079 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 1.68e-16 | NR | SPR01295.1 | 37360 | g28911 | i0 | 50 | 1.7004048582996 | 70 | 34 | 85 | 1 | 243 | 34 | 537 | 605 | SPR01295.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 420 | 83.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28065837 | 28065837 | PRJNA867519_P_NODE_26685_length_250_cov_0.870056_g26531_i0 | PRJNA867519 | 26685 | 250 | 0.870056 | 2.17514 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.32e-6 | NR | SPQ98236.1 | 37360 | g26531 | i0 | 42.6 | 2.208 | 61 | 31 | 73.2 | 1 | 191 | 9 | 126 | 182 | SPQ98236.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 552 | 55.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28421511 | 28421511 | PRJNA867519_P_NODE_8326_length_385_cov_2.467949_g8172_i0 | PRJNA867519 | 8326 | 385 | 2.467949 | 9.50160365 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 8.69e-20 | NR | CEP00552.1 | 37360 | g8172 | i0 | 44.1 | 1.62857142857143 | 102 | 57 | 79.5 | 0 | 1 | 306 | 183 | 284 | CEP00552.1 hypothetical protein PBRA_001606 [Plasmodiophora brassicae] | diamond | 627 | 92.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28570966 | 28570966 | PRJNA867519_P_NODE_23467_length_260_cov_1.647059_g23313_i0 | PRJNA867519 | 23467 | 260 | 1.647059 | 4.2823534 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 6.43e-28 | NR | CEO96537.1 | 37360 | g23313 | i0 | 67.1 | 0.946153846153846 | 82 | 27 | 94.6 | 0 | 259 | 14 | 227 | 308 | CEO96537.1 hypothetical protein PBRA_005146 [Plasmodiophora brassicae] | diamond | 246 | 116 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29454713 | 29454713 | PRJNA867519_P_NODE_10930_length_346_cov_3.260073_g10776_i0 | PRJNA867519 | 10930 | 346 | 3.260073 | 11.27985258 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 1.98e-5 | NR | SPQ94387.1 | 37360 | g10776 | i0 | 39.8 | 0.719653179190751 | 83 | 45 | 69.4 | 2 | 271 | 32 | 540 | 620 | SPQ94387.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 249 | 53.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29581105 | 29581105 | PRJNA867519_P_NODE_32130_length_243_cov_0.905882_g31976_i0 | PRJNA867519 | 32130 | 243 | 0.905882 | 2.20129326 | Paramarteilia canceri | 2844372 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0144 | NR | MES1902316.1 | 2844372 | g31976 | i0 | 33.3 | 0.925925925925926 | 75 | 48 | 90.1 | 2 | 9 | 227 | 527 | 601 | MES1902316.1 hypothetical protein [Paramarteilia canceri] | diamond | 225 | 43.9 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Paramyxida | Marteiliidae | Paramarteilia | Paramarteilia canceri | ||
| 30434638 | 30434638 | PRJNA867519_P_NODE_27313_length_249_cov_0.875000_g27159_i0 | PRJNA867519 | 27313 | 249 | 0.875 | 2.17875 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 3.09e-17 | NR | SPQ94136.1 | 37360 | g27159 | i0 | 69.8 | 3.81927710843373 | 53 | 16 | 63.9 | 0 | 3 | 161 | 116 | 168 | SPQ94136.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 951 | 81.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30600264 | 30600264 | PRJNA867519_P_NODE_11793_length_336_cov_1.646388_g11639_i0 | PRJNA867519 | 11793 | 336 | 1.646388 | 5.53186368 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 9.479999999999999e-40 | NR | CEO97902.1 | 37360 | g11639 | i0 | 60.4 | 23.7857142857143 | 111 | 44 | 99.1 | 0 | 3 | 335 | 781 | 891 | CEO97902.1 hypothetical protein PBRA_006016 [Plasmodiophora brassicae] | diamond | 7992 | 152 | 0.993421052631579 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31856712 | 31856712 | PRJNA867519_P_NODE_18777_length_281_cov_1.480769_g18623_i0 | PRJNA867519 | 18777 | 281 | 1.480769 | 4.16096089 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 1.02e-9 | NR | CEO99637.1 | 37360 | g18623 | i0 | 39.1 | 0.98220640569395 | 92 | 54 | 98.2 | 1 | 2 | 277 | 25 | 114 | CEO99637.1 hypothetical protein PBRA_007370 [Plasmodiophora brassicae] | diamond | 276 | 64.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32363250 | 32363250 | PRJNA867519_P_NODE_11599_length_338_cov_3.237736_g11445_i0 | PRJNA867519 | 11599 | 338 | 3.237736 | 10.94354768 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 1e-12 | NR | CEO95994.1 | 37360 | g11445 | i0 | 53.9 | 0.789940828402367 | 89 | 41 | 79 | 0 | 327 | 61 | 193 | 281 | CEO95994.1 hypothetical protein PBRA_004684 [Plasmodiophora brassicae] | diamond | 267 | 73.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32458144 | 32458144 | PRJNA867519_P_NODE_7279_length_408_cov_1.838806_g7125_i0 | PRJNA867519 | 7279 | 408 | 1.838806 | 7.50232848 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 5.06e-14 | NR | CEO97289.1 | 37360 | g7125 | i0 | 39.6 | 0.705882352941177 | 96 | 55 | 69.9 | 2 | 24 | 308 | 295 | 388 | CEO97289.1 hypothetical protein PBRA_000634 [Plasmodiophora brassicae] | diamond | 288 | 78.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32844351 | 32844351 | PRJNA867519_P_NODE_19000_length_280_cov_1.468599_g18846_i0 | PRJNA867519 | 19000 | 280 | 1.468599 | 4.1120772 | Endomyxa | 2604748 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 7.29e-13 | NR | CEP00687.1 | 37360 | g18846 | i0 | 50.8 | 4.81071428571429 | 65 | 32 | 69.6 | 0 | 2 | 196 | 290 | 354 | CEP00687.1 hypothetical protein PBRA_001741 [Plasmodiophora brassicae] | diamond | 1347 | 73.6 | 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);;