contig_metadata
24 rows where bioproject = "PRJNA1010780", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1429996 | 1429996 | PRJNA1010780_S_NODE_55722_length_163_cov_1.140625_g54433_i0 | PRJNA1010780 | 55722 | 163 | 1.140625 | 1.85921875 | Paramarteilia canceri | 2844372 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 3.39e-14 | NR | MES1902243.1 | 2844372 | g54433 | i0 | 64.2 | 9.86503067484663 | 53 | 19 | 97.5 | 0 | 162 | 4 | 363 | 415 | MES1902243.1 translation initiation factor eIF4A [Paramarteilia canceri] | diamond | 1608 | 75.5 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Paramyxida | Marteiliidae | Paramarteilia | Paramarteilia canceri | ||
| 26710172 | 26710172 | PRJNA1010780_S_NODE_58221_length_158_cov_1.731707_g56932_i0 | PRJNA1010780 | 58221 | 158 | 1.731707 | 2.73609706 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 8.71e-15 | NR | AAT42195.1 | 35217 | g56932 | i0 | 60.8 | 18.5316455696203 | 51 | 20 | 96.8 | 0 | 3 | 155 | 196 | 246 | AAT42195.1 actin, partial [Gromia oviformis] | diamond | 2928 | 77 | 0.994805194805195 | Eukaryota | Sar | Endomyxa | Gromiida | Gromiidae | Gromia | Gromia oviformis | |||
| 26717686 | 26717686 | PRJNA1010780_S_NODE_44701_length_190_cov_1.322581_g43412_i0 | PRJNA1010780 | 44701 | 190 | 1.322581 | 2.5129039 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0255 | NR | CEP01484.1 | 37360 | g43412 | i0 | 34.9 | 0.994736842105263 | 63 | 38 | 97.9 | 2 | 1 | 186 | 55 | 115 | CEP01484.1 hypothetical protein PBRA_002090 [Plasmodiophora brassicae] | diamond | 189 | 42.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27414065 | 27414065 | PRJNA1010780_S_NODE_15083_length_539_cov_4.658730_g13872_i0 | PRJNA1010780 | 15083 | 539 | 4.65873 | 25.1105547 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 1.07e-14 | NR | SPR00082.1 | 37360 | g13872 | i0 | 34.6 | 2.71614100185529 | 162 | 99 | 89.6 | 4 | 538 | 56 | 1723 | 1878 | SPR00082.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1464 | 82.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28487523 | 28487523 | PRJNA1010780_S_NODE_38167_length_215_cov_1.594444_g36878_i0 | PRJNA1010780 | 38167 | 215 | 1.594444 | 3.4280546 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 5.35e-19 | NR | CEO97640.1 | 37360 | g36878 | i0 | 58 | 5.6093023255814 | 69 | 29 | 96.3 | 0 | 3 | 209 | 331 | 399 | CEO97640.1 hypothetical protein PBRA_000985 [Plasmodiophora brassicae] | diamond | 1206 | 90.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28519094 | 28519094 | PRJNA1010780_S_NODE_40207_length_206_cov_1.736842_g38918_i0 | PRJNA1010780 | 40207 | 206 | 1.736842 | 3.57789452 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 2.74e-9 | NR | SPR00082.1 | 37360 | g38918 | i0 | 46.9 | 0.932038834951456 | 64 | 33 | 91.7 | 1 | 1 | 189 | 1813 | 1876 | SPR00082.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 192 | 62.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28676914 | 28676914 | PRJNA1010780_S_NODE_22127_length_360_cov_7.400000_g20838_i0 | PRJNA1010780 | 22127 | 360 | 7.4 | 26.64 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 8.53e-8 | NR | CEO98171.1 | 37360 | g20838 | i0 | 43.9 | 2.99166666666667 | 82 | 31 | 68.3 | 3 | 115 | 360 | 36 | 102 | CEO98171.1 hypothetical protein PBRA_006285 [Plasmodiophora brassicae] | diamond | 1077 | 60.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30027176 | 30027176 | PRJNA1010780_S_NODE_12731_length_631_cov_1.921141_g11625_i0 | PRJNA1010780 | 12731 | 631 | 1.921141 | 12.12239971 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 2.08e-4 | NR | MES1920134.1 | 126728 | g11625 | i0 | 36.9 | 0.75594294770206 | 84 | 49 | 38 | 1 | 250 | 11 | 27 | 110 | MES1920134.1 hypothetical protein [Bonamia ostreae] | diamond | 477 | 51.6 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 30160747 | 30160747 | PRJNA1010780_S_NODE_29292_length_271_cov_2.097458_g28003_i0 | PRJNA1010780 | 29292 | 271 | 2.097458 | 5.68411118 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 1.1e-22 | NR | SPQ93806.1 | 37360 | g28003 | i0 | 56.3 | 0.96309963099631 | 87 | 36 | 94.1 | 1 | 2 | 256 | 37 | 123 | SPQ93806.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 261 | 97.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30184925 | 30184925 | PRJNA1010780_S_NODE_14352_length_567_cov_3.684211_g13163_i0 | PRJNA1010780 | 14352 | 567 | 3.684211 | 20.88947637 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.47e-22 | NR | SPR00082.1 | 37360 | g13163 | i0 | 37.1 | 7.69312169312169 | 170 | 90 | 86.8 | 5 | 74 | 565 | 4751 | 4909 | SPR00082.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 4362 | 105 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30192512 | 30192512 | PRJNA1010780_S_NODE_36892_length_221_cov_1.586022_g35603_i0 | PRJNA1010780 | 36892 | 221 | 1.586022 | 3.50510862 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 5.39e-13 | NR | CEP01441.1 | 37360 | g35603 | i0 | 53.4 | 4.91402714932127 | 58 | 27 | 78.7 | 0 | 197 | 24 | 2010 | 2067 | CEP01441.1 hypothetical protein PBRA_002047 [Plasmodiophora brassicae] | diamond | 1086 | 73.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30224035 | 30224035 | PRJNA1010780_S_NODE_10192_length_760_cov_4.223448_g9236_i0 | PRJNA1010780 | 10192 | 760 | 4.223448 | 32.0982048 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 1.32e-16 | NR | SPR00082.1 | 37360 | g9236 | i0 | 36.1 | 2.64473684210526 | 158 | 92 | 62 | 4 | 135 | 605 | 1710 | 1859 | SPR00082.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 2010 | 90.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30256043 | 30256043 | PRJNA1010780_S_NODE_11212_length_702_cov_4.233883_g9236_i1 | PRJNA1010780 | 11212 | 702 | 4.233883 | 29.72185866 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 5.97e-17 | NR | SPR00082.1 | 37360 | g9236 | i1 | 36.1 | 1.34188034188034 | 158 | 92 | 67.1 | 4 | 626 | 156 | 1710 | 1859 | SPR00082.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 942 | 91.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30382511 | 30382511 | PRJNA1010780_S_NODE_10993_length_714_cov_4.182622_g9980_i0 | PRJNA1010780 | 10993 | 714 | 4.182622 | 29.86392108 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 6.63e-5 | NR | SPQ94865.1 | 37360 | g9980 | i0 | 46.9 | 0.53781512605042 | 64 | 34 | 26.9 | 0 | 209 | 18 | 66 | 129 | SPQ94865.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 384 | 55.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30508568 | 30508568 | PRJNA1010780_S_NODE_31253_length_255_cov_2.709091_g29964_i0 | PRJNA1010780 | 31253 | 255 | 2.709091 | 6.90818205 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 6.89e-9 | NR | CEP02772.1 | 37360 | g29964 | i0 | 36.8 | 0.894117647058824 | 76 | 42 | 84.7 | 2 | 218 | 3 | 177 | 250 | CEP02772.1 hypothetical protein PBRA_002739 [Plasmodiophora brassicae] | diamond | 228 | 62 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30603132 | 30603132 | PRJNA1010780_S_NODE_12133_length_657_cov_3.752412_g11055_i0 | PRJNA1010780 | 12133 | 657 | 3.752412 | 24.65334684 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 6.58e-24 | NR | SPR00082.1 | 37360 | g11055 | i0 | 37.6 | 0.776255707762557 | 170 | 94 | 75.3 | 6 | 163 | 657 | 1697 | 1859 | SPR00082.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 510 | 110 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30634812 | 30634812 | PRJNA1010780_S_NODE_55973_length_162_cov_1.811024_g54684_i0 | PRJNA1010780 | 55973 | 162 | 1.811024 | 2.93385888 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 5.06e-20 | NR | CEO99905.1 | 37360 | g54684 | i0 | 72.2 | 1 | 54 | 15 | 100 | 0 | 162 | 1 | 23 | 76 | CEO99905.1 hypothetical protein PBRA_007640 [Plasmodiophora brassicae] | diamond | 162 | 91.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31014046 | 31014046 | PRJNA1010780_S_NODE_33975_length_236_cov_3.791045_g32686_i0 | PRJNA1010780 | 33975 | 236 | 3.791045 | 8.9468662 | Paramarteilia canceri | 2844372 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 1.2e-14 | NR | MES1906354.1 | 2844372 | g32686 | i0 | 43.4 | 0.966101694915254 | 76 | 43 | 96.6 | 0 | 9 | 236 | 114 | 189 | MES1906354.1 Serine/threonine-protein phosphatase 6 catalytic subunit [Paramarteilia canceri] | diamond | 228 | 76.3 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Paramyxida | Marteiliidae | Paramarteilia | Paramarteilia canceri | ||
| 31014123 | 31014123 | PRJNA1010780_S_NODE_9775_length_784_cov_4.248331_g8844_i0 | PRJNA1010780 | 9775 | 784 | 4.248331 | 33.30691504 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 1.37e-15 | NR | SPR00082.1 | 37360 | g8844 | i0 | 31.8 | 1.4234693877551 | 195 | 112 | 74.2 | 8 | 77 | 658 | 4558 | 4732 | SPR00082.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1116 | 88.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31544108 | 31544108 | PRJNA1010780_S_NODE_49556_length_176_cov_1.829787_g48267_i0 | PRJNA1010780 | 49556 | 176 | 1.829787 | 3.22042512 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 5.4e-8 | NR | CEP02392.1 | 37360 | g48267 | i0 | 48.3 | 9.85227272727273 | 58 | 30 | 98.9 | 0 | 3 | 176 | 337 | 394 | CEP02392.1 hypothetical protein PBRA_008976 [Plasmodiophora brassicae] | diamond | 1734 | 58.5 | 0.994871794871795 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32089364 | 32089364 | PRJNA1010780_S_NODE_4038_length_1348_cov_7.987814_g3637_i0 | PRJNA1010780 | 4038 | 1348 | 7.987814 | 107.67573272 | Bonamia ostreae | 126728 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 3.05e-29 | NR | MES1920001.1 | 126728 | g3637 | i0 | 26 | 0.812314540059347 | 365 | 242 | 79.2 | 9 | 130 | 1197 | 162 | 507 | MES1920001.1 E3 ubiquitin-protein ligase HTD1 [Bonamia ostreae] | diamond | 1095 | 132 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 32089376 | 32089376 | PRJNA1010780_S_NODE_45038_length_189_cov_1.259740_g43749_i0 | PRJNA1010780 | 45038 | 189 | 1.25974 | 2.3809086 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 2.31e-7 | NR | SPQ94663.1 | 37360 | g43749 | i0 | 50.9 | 3.19047619047619 | 53 | 25 | 84.1 | 1 | 2 | 160 | 4009 | 4060 | SPQ94663.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 603 | 56.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32121218 | 32121218 | PRJNA1010780_S_NODE_55038_length_164_cov_1.666667_g53749_i0 | PRJNA1010780 | 55038 | 164 | 1.666667 | 2.73333388 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 7.74e-4 | NR | SPR00082.1 | 37360 | g53749 | i0 | 50 | 0.621951219512195 | 34 | 17 | 62.2 | 0 | 2 | 103 | 3087 | 3120 | SPR00082.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 102 | 46.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32619376 | 32619376 | PRJNA1010780_S_NODE_48080_length_180_cov_1.662069_g46791_i0 | PRJNA1010780 | 48080 | 180 | 1.662069 | 2.9917242 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 1.73e-7 | NR | CEO96956.1 | 37360 | g46791 | i0 | 72.4 | 7.63333333333333 | 29 | 8 | 48.3 | 0 | 178 | 92 | 87 | 115 | CEO96956.1 hypothetical protein PBRA_005560 [Plasmodiophora brassicae] | diamond | 1374 | 54.3 | 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);;