contig_metadata
26 rows where bioproject = "PRJNA795983", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 780281 | 780281 | PRJNA795983_S_NODE_8501_length_412_cov_1.477876_g8376_i0 | PRJNA795983 | 8501 | 412 | 1.477876 | 6.08884912 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 192 | 2.2300000000000003e-58 | NR | CEO96095.1 | 37360 | g8376 | i0 | 61.8 | 0.990291262135922 | 136 | 52 | 99 | 0 | 3 | 410 | 63 | 198 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 408 | 192 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 4608648 | 4608648 | PRJNA795983_S_NODE_5304_length_490_cov_1.357314_g5180_i0 | PRJNA795983 | 5304 | 490 | 1.357314 | 6.6508386 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 8.64e-71 | NR | CEO99151.1 | 37360 | g5180 | i0 | 76.4 | 13.7510204081633 | 140 | 33 | 85.7 | 0 | 8 | 427 | 7 | 146 | CEO99151.1 hypothetical protein PBRA_001056 [Plasmodiophora brassicae] | diamond | 6738 | 220 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 5044661 | 5044661 | PRJNA795983_S_NODE_39764_length_245_cov_1.162791_g39639_i0 | PRJNA795983 | 39764 | 245 | 1.162791 | 2.84883795 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 9.21e-29 | NR | CEP02640.1 | 37360 | g39639 | i0 | 82.9 | 0.857142857142857 | 70 | 12 | 85.7 | 0 | 244 | 35 | 95 | 164 | CEP02640.1 hypothetical protein PBRA_002607 [Plasmodiophora brassicae] | diamond | 210 | 110 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 8433392 | 8433392 | PRJNA795983_S_NODE_6507_length_454_cov_2.698163_g6382_i0 | PRJNA795983 | 6507 | 454 | 2.698163 | 12.24966002 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 2.87e-50 | NR | CEO96095.1 | 37360 | g6382 | i0 | 53.5 | 2.5704845814978 | 144 | 67 | 95.2 | 0 | 7 | 438 | 130 | 273 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 1167 | 172 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 12259495 | 12259495 | PRJNA795983_S_NODE_14990_length_337_cov_2.784091_g14865_i0 | PRJNA795983 | 14990 | 337 | 2.784091 | 9.38238667 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 173 | 7.55e-52 | NR | CEP01968.1 | 37360 | g14865 | i0 | 77.1 | 0.970326409495549 | 109 | 25 | 97 | 0 | 336 | 10 | 53 | 161 | CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] | diamond | 327 | 173 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 12259811 | 12259811 | PRJNA795983_S_NODE_8030_length_421_cov_1.324713_g7905_i0 | PRJNA795983 | 8030 | 421 | 1.324713 | 5.57704173 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 1.3799999999999998e-48 | NR | CEO98592.1 | 37360 | g7905 | i0 | 63.9 | 1.6603325415677 | 119 | 43 | 84.8 | 0 | 419 | 63 | 95 | 213 | CEO98592.1 hypothetical protein PBRA_006706 [Plasmodiophora brassicae] | diamond | 699 | 165 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 16082619 | 16082619 | PRJNA795983_S_NODE_28173_length_274_cov_0.970149_g28048_i0 | PRJNA795983 | 28173 | 274 | 0.970149 | 2.65820826 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 6.54e-26 | NR | CEP01219.1 | 37360 | g28048 | i0 | 71.2 | 3.71167883211679 | 73 | 15 | 73.4 | 1 | 272 | 72 | 246 | 318 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 1017 | 108 | 0.990740740740741 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 16519423 | 16519423 | PRJNA795983_S_NODE_5213_length_493_cov_1.897619_g5089_i0 | PRJNA795983 | 5213 | 493 | 1.897619 | 9.35526167 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 4.29e-64 | NR | CEO97280.1 | 37360 | g5089 | i0 | 67.1 | 0.979716024340771 | 161 | 53 | 98 | 0 | 492 | 10 | 29 | 189 | CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] | diamond | 483 | 209 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21182664 | 21182664 | PRJNA795983_S_NODE_37997_length_248_cov_0.880000_g37872_i0 | PRJNA795983 | 37997 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 1.47e-36 | NR | SPR01674.1 | 37360 | g37872 | i0 | 74.4 | 11.7459677419355 | 82 | 21 | 99.2 | 0 | 247 | 2 | 23 | 104 | SPR01674.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 2913 | 136 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 22457453 | 22457453 | PRJNA795983_S_NODE_5218_length_493_cov_1.452381_g5094_i0 | PRJNA795983 | 5218 | 493 | 1.452381 | 7.16023833 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 3.4499999999999995e-57 | NR | CEP00157.1 | 37360 | g5094 | i0 | 70.9 | 1.81947261663286 | 148 | 35 | 90.1 | 1 | 3 | 446 | 48 | 187 | CEP00157.1 hypothetical protein PBRA_007891 [Plasmodiophora brassicae] | diamond | 897 | 189 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 25006439 | 25006439 | PRJNA795983_S_NODE_18700_length_314_cov_1.746888_g18575_i0 | PRJNA795983 | 18700 | 314 | 1.746888 | 5.48522832 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 7.56e-42 | NR | CEP01219.1 | 37360 | g18575 | i0 | 74.7 | 2.70382165605096 | 99 | 19 | 88.9 | 2 | 313 | 35 | 221 | 319 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 849 | 149 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 25006731 | 25006731 | PRJNA795983_S_NODE_8300_length_416_cov_1.209913_g8175_i0 | PRJNA795983 | 8300 | 416 | 1.209913 | 5.03323808 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 236 | 1.94e-74 | NR | SPR00005.1 | 37360 | g8175 | i0 | 81.2 | 6.96634615384615 | 138 | 26 | 99.5 | 0 | 416 | 3 | 135 | 272 | SPR00005.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 2898 | 236 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 25443240 | 25443240 | PRJNA795983_S_NODE_12740_length_356_cov_1.858657_g12615_i0 | PRJNA795983 | 12740 | 356 | 1.858657 | 6.61681892 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 7.48e-20 | NR | CEP00723.1 | 37360 | g12615 | i0 | 52.4 | 1.85393258426966 | 105 | 50 | 88.5 | 0 | 40 | 354 | 5 | 109 | CEP00723.1 hypothetical protein PBRA_001777 [Plasmodiophora brassicae] | diamond | 660 | 91.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28515792 | 28515792 | PRJNA795983_S_NODE_20747_length_304_cov_1.077922_g20622_i0 | PRJNA795983 | 20747 | 304 | 1.077922 | 3.27688288 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 5.229999999999999e-23 | NR | CEO98408.1 | 37360 | g20622 | i0 | 56.3 | 2.66447368421053 | 80 | 35 | 78.9 | 0 | 303 | 64 | 434 | 513 | CEO98408.1 hypothetical protein PBRA_006522 [Plasmodiophora brassicae] | diamond | 810 | 103 | 0.990291262135922 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28569657 | 28569657 | PRJNA795983_S_NODE_28087_length_274_cov_1.368159_g27962_i0 | PRJNA795983 | 28087 | 274 | 1.368159 | 3.74875566 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 4.73e-31 | NR | CEO98730.1 | 37360 | g27962 | i0 | 65.9 | 4.98175182481752 | 88 | 30 | 96.4 | 0 | 273 | 10 | 96 | 183 | CEO98730.1 hypothetical protein PBRA_006844 [Plasmodiophora brassicae] | diamond | 1365 | 117 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28664504 | 28664504 | PRJNA795983_S_NODE_13847_length_347_cov_1.032847_g13722_i0 | PRJNA795983 | 13847 | 347 | 1.032847 | 3.58397909 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 9.02e-46 | NR | CEP02640.1 | 37360 | g13722 | i0 | 71.9 | 0.985590778097983 | 114 | 29 | 98.6 | 1 | 2 | 343 | 21 | 131 | CEP02640.1 hypothetical protein PBRA_002607 [Plasmodiophora brassicae] | diamond | 342 | 155 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28759090 | 28759090 | PRJNA795983_S_NODE_43067_length_241_cov_0.916667_g42942_i0 | PRJNA795983 | 43067 | 241 | 0.916667 | 2.20916747 | Bonamia ostreae | 126728 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 1.47e-13 | NR | MES1918847.1 | 126728 | g42942 | i0 | 43.7 | 2.16597510373444 | 87 | 41 | 98.3 | 1 | 2 | 238 | 184 | 270 | MES1918847.1 hypothetical protein [Bonamia ostreae] | diamond | 522 | 75.1 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 28916821 | 28916821 | PRJNA795983_S_NODE_43088_length_241_cov_0.916667_g42963_i0 | PRJNA795983 | 43088 | 241 | 0.916667 | 2.20916747 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 4.85e-20 | NR | CEO98004.1 | 37360 | g42963 | i0 | 60 | 1.96680497925311 | 80 | 32 | 99.6 | 0 | 1 | 240 | 1738 | 1817 | CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae] | diamond | 474 | 93.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29273287 | 29273287 | PRJNA795983_S_NODE_27749_length_275_cov_1.519802_g27624_i0 | PRJNA795983 | 27749 | 275 | 1.519802 | 4.1794555 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.45e-22 | NR | CEP01973.1 | 37360 | g27624 | i0 | 70.5 | 12.9272727272727 | 61 | 18 | 66.5 | 0 | 274 | 92 | 535 | 595 | CEP01973.1 hypothetical protein PBRA_002238 [Plasmodiophora brassicae] | diamond | 3555 | 101 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29453452 | 29453452 | PRJNA795983_S_NODE_20970_length_303_cov_0.926087_g20845_i0 | PRJNA795983 | 20970 | 303 | 0.926087 | 2.80604361 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.55e-20 | NR | CEP02593.1 | 37360 | g20845 | i0 | 58.3 | 2.2970297029703 | 72 | 30 | 71.3 | 0 | 8 | 223 | 31 | 102 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 696 | 89 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29715206 | 29715206 | PRJNA795983_S_NODE_37130_length_249_cov_0.875000_g37005_i0 | PRJNA795983 | 37130 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 4.12e-18 | NR | SPQ96161.1 | 37360 | g37005 | i0 | 56.4 | 4.80722891566265 | 78 | 34 | 94 | 0 | 238 | 5 | 2957 | 3034 | SPQ96161.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1197 | 88.6 | 0.99548532731377 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29927645 | 29927645 | PRJNA795983_S_NODE_2551_length_653_cov_2.374138_g2437_i0 | PRJNA795983 | 2551 | 653 | 2.374138 | 15.50312114 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 240 | 3.03e-77 | NR | CEP03344.1 | 37360 | g2437 | i0 | 63.8 | 0.863705972434916 | 188 | 68 | 86.4 | 0 | 617 | 54 | 3 | 190 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 564 | 240 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30717210 | 30717210 | PRJNA795983_S_NODE_43174_length_241_cov_0.916667_g43049_i0 | PRJNA795983 | 43174 | 241 | 0.916667 | 2.20916747 | Bonamia ostreae | 126728 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 7.93e-27 | NR | MES1921007.1 | 126728 | g43049 | i0 | 62.7 | 1.89211618257261 | 75 | 28 | 93.4 | 0 | 227 | 3 | 7 | 81 | MES1921007.1 hypothetical protein [Bonamia ostreae] | diamond | 456 | 106 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 31263696 | 31263696 | PRJNA795983_S_NODE_4375_length_528_cov_2.531868_g4252_i0 | PRJNA795983 | 4375 | 528 | 2.531868 | 13.36826304 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 3.6999999999999996e-58 | NR | CEO97171.1 | 37360 | g4252 | i0 | 55.9 | 13.1647727272727 | 177 | 75 | 99.4 | 2 | 526 | 2 | 328 | 503 | CEO97171.1 hypothetical protein PBRA_005775 [Plasmodiophora brassicae] | diamond | 6951 | 202 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31317725 | 31317725 | PRJNA795983_S_NODE_36335_length_250_cov_1.485876_g36210_i0 | PRJNA795983 | 36335 | 250 | 1.485876 | 3.71469 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 2.2599999999999996e-31 | NR | CEO96711.1 | 37360 | g36210 | i0 | 78.9 | 4.452 | 71 | 15 | 85.2 | 0 | 35 | 247 | 1 | 71 | CEO96711.1 hypothetical protein PBRA_005315 [Plasmodiophora brassicae] | diamond | 1113 | 120 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32013683 | 32013683 | PRJNA795983_S_NODE_20078_length_307_cov_1.316239_g19953_i0 | PRJNA795983 | 20078 | 307 | 1.316239 | 4.04085373 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 9.05e-11 | NR | CEO95766.1 | 37360 | g19953 | i0 | 47.5 | 0.576547231270358 | 59 | 31 | 57.7 | 0 | 248 | 72 | 93 | 151 | CEO95766.1 hypothetical protein PBRA_004479 [Plasmodiophora brassicae] | diamond | 177 | 68.2 | 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);;