contig_metadata
22 rows where bioproject = "PRJNA473201", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1719396 | 1719396 | PRJNA473201_P_NODE_78762_length_244_cov_1.046784_g78020_i0 | PRJNA473201 | 78762 | 244 | 1.046784 | 2.55415296 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 6.56e-30 | NR | CEP01997.1 | 37360 | g78020 | i0 | 71.1 | 4.70901639344262 | 76 | 22 | 93.4 | 0 | 229 | 2 | 1 | 76 | CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] | diamond | 1149 | 115 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 5548236 | 5548236 | PRJNA473201_P_NODE_81485_length_243_cov_0.905882_g80743_i0 | PRJNA473201 | 81485 | 243 | 0.905882 | 2.20129326 | Phytomyxea | 2779609 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 2.88e-31 | NR | CEO96359.1 | 37360 | g80743 | i0 | 72.5 | 4.9382716049382704 | 80 | 22 | 98.8 | 0 | 241 | 2 | 502 | 581 | CEO96359.1 hypothetical protein PBRA_005030 [Plasmodiophora brassicae] | diamond | 1200 | 125 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 6821195 | 6821195 | PRJNA473201_P_NODE_25746_length_389_cov_0.974684_g25004_i0 | PRJNA473201 | 25746 | 389 | 0.974684 | 3.79152076 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 9.369999999999999e-61 | NR | CEP01299.1 | 37360 | g25004 | i0 | 74.4 | 6.94087403598972 | 129 | 33 | 99.5 | 0 | 387 | 1 | 57 | 185 | CEP01299.1 hypothetical protein PBRA_001905 [Plasmodiophora brassicae] | diamond | 2700 | 201 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 6821882 | 6821882 | PRJNA473201_P_NODE_6306_length_813_cov_1.772973_g5682_i0 | PRJNA473201 | 6306 | 813 | 1.772973 | 14.41427049 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 332 | 1.44e-111 | NR | CEP01968.1 | 37360 | g5682 | i0 | 68.2 | 6.06642066420664 | 239 | 70 | 88.2 | 1 | 812 | 96 | 12 | 244 | CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] | diamond | 4932 | 332 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 6822102 | 6822102 | PRJNA473201_P_NODE_73566_length_247_cov_0.885057_g72824_i0 | PRJNA473201 | 73566 | 247 | 0.885057 | 2.18609079 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 1.14e-28 | NR | CEP02402.1 | 37360 | g72824 | i0 | 64.2 | 0.983805668016194 | 81 | 29 | 98.4 | 0 | 2 | 244 | 273 | 353 | CEP02402.1 hypothetical protein PBRA_008986 [Plasmodiophora brassicae] | diamond | 243 | 116 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 9371438 | 9371438 | PRJNA473201_P_NODE_30768_length_356_cov_2.176678_g30026_i0 | PRJNA473201 | 30768 | 356 | 2.176678 | 7.74897368 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.1599999999999999e-47 | NR | CEP01968.1 | 37360 | g30026 | i0 | 71.7 | 1.94662921348315 | 113 | 30 | 95.2 | 1 | 16 | 354 | 1 | 111 | CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] | diamond | 693 | 163 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 18294923 | 18294923 | PRJNA473201_P_NODE_13075_length_555_cov_1.831950_g12336_i0 | PRJNA473201 | 13075 | 555 | 1.83195 | 10.1673225 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 234 | 5.59e-76 | NR | CEO97530.1 | 37360 | g12336 | i0 | 80.7 | 0.756756756756757 | 140 | 27 | 75.7 | 0 | 555 | 136 | 12 | 151 | CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] | diamond | 420 | 234 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21496165 | 21496165 | PRJNA473201_P_NODE_19297_length_450_cov_1.509284_g18555_i0 | PRJNA473201 | 19297 | 450 | 1.509284 | 6.791778 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 3.23e-30 | NR | SPQ93437.1 | 37360 | g18555 | i0 | 63.2 | 1.74 | 87 | 32 | 58 | 0 | 393 | 133 | 58 | 144 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 783 | 117 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 24670035 | 24670035 | PRJNA473201_P_NODE_44980_length_304_cov_1.389610_g44238_i0 | PRJNA473201 | 44980 | 304 | 1.38961 | 4.2244144 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 8.500000000000001e-30 | NR | SPQ93437.1 | 37360 | g44238 | i0 | 61.9 | 1.65789473684211 | 84 | 32 | 82.9 | 0 | 1 | 252 | 61 | 144 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 504 | 114 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 25320739 | 25320739 | PRJNA473201_P_NODE_25580_length_390_cov_1.214511_g24838_i0 | PRJNA473201 | 25580 | 390 | 1.214511 | 4.7365929 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 170 | 1.05e-50 | NR | CEP01997.1 | 37360 | g24838 | i0 | 66.9 | 0.953846153846154 | 124 | 41 | 95.4 | 0 | 17 | 388 | 1 | 124 | CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] | diamond | 372 | 170 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26854921 | 26854921 | PRJNA473201_P_NODE_82001_length_243_cov_0.905882_g81259_i0 | PRJNA473201 | 82001 | 243 | 0.905882 | 2.20129326 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.34e-9 | NR | CEO97265.1 | 37360 | g81259 | i0 | 61 | 0.506172839506173 | 41 | 16 | 50.6 | 0 | 119 | 241 | 240 | 280 | CEO97265.1 hypothetical protein PBRA_000608 [Plasmodiophora brassicae] | diamond | 123 | 63.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28244561 | 28244561 | PRJNA473201_P_NODE_33546_length_342_cov_2.003717_g32804_i0 | PRJNA473201 | 33546 | 342 | 2.003717 | 6.85271214 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 1.54e-41 | NR | CEO99081.1 | 37360 | g32804 | i0 | 66.7 | 1.67543859649123 | 96 | 32 | 84.2 | 0 | 3 | 290 | 47 | 142 | CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] | diamond | 573 | 144 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28244572 | 28244572 | PRJNA473201_P_NODE_7226_length_758_cov_2.366423_g6555_i0 | PRJNA473201 | 7226 | 758 | 2.366423 | 17.93748634 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 8.58e-41 | NR | CEP01632.1 | 37360 | g6555 | i0 | 63.9 | 2.48548812664908 | 122 | 44 | 48.3 | 0 | 51 | 416 | 7 | 128 | CEP01632.1 hypothetical protein PBRA_008575 [Plasmodiophora brassicae] | diamond | 1884 | 147 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28307976 | 28307976 | PRJNA473201_P_NODE_79506_length_244_cov_0.900585_g78764_i0 | PRJNA473201 | 79506 | 244 | 0.900585 | 2.1974274 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 3.76e-20 | NR | SPQ93437.1 | 37360 | g78764 | i0 | 58.4 | 2.84016393442623 | 77 | 32 | 94.7 | 0 | 8 | 238 | 61 | 137 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 693 | 88.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28812734 | 28812734 | PRJNA473201_P_NODE_33748_length_341_cov_2.854478_g33006_i0 | PRJNA473201 | 33748 | 341 | 2.854478 | 9.73376998 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 9.599999999999999e-41 | NR | SPQ93792.1 | 37360 | g33006 | i0 | 67.3 | 1.87390029325513 | 107 | 34 | 94.1 | 1 | 321 | 1 | 157 | 262 | SPQ93792.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 639 | 146 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29823220 | 29823220 | PRJNA473201_P_NODE_44591_length_305_cov_1.991379_g43849_i0 | PRJNA473201 | 44591 | 305 | 1.991379 | 6.07370595 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 8.91e-19 | NR | CEP03344.1 | 37360 | g43849 | i0 | 70.2 | 0.560655737704918 | 57 | 17 | 56.1 | 0 | 304 | 134 | 136 | 192 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 171 | 87 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29839609 | 29839609 | PRJNA473201_P_NODE_67971_length_250_cov_0.870056_g67229_i0 | PRJNA473201 | 67971 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 3.16e-16 | NR | CEO94374.1 | 37360 | g67229 | i0 | 67.7 | 5.88 | 62 | 13 | 66 | 1 | 248 | 84 | 757 | 818 | CEO94374.1 hypothetical protein PBRA_000159 [Plasmodiophora brassicae] | diamond | 1470 | 82.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30455666 | 30455666 | PRJNA473201_P_NODE_32333_length_348_cov_1.418182_g31591_i0 | PRJNA473201 | 32333 | 348 | 1.418182 | 4.93527336 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 1.51e-43 | NR | CEO97280.1 | 37360 | g31591 | i0 | 68.1 | 0.974137931034483 | 113 | 36 | 97.4 | 0 | 346 | 8 | 77 | 189 | CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] | diamond | 339 | 154 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31134673 | 31134673 | PRJNA473201_P_NODE_28675_length_368_cov_2.081356_g27933_i0 | PRJNA473201 | 28675 | 368 | 2.081356 | 7.65939008 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 8.5e-26 | NR | CAL69925.1 | 37360 | g27933 | i0 | 61.5 | 5.77989130434783 | 78 | 30 | 63.6 | 0 | 128 | 361 | 24 | 101 | CAL69925.1 hypothetical protein [Plasmodiophora brassicae] | diamond | 2127 | 107 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32036016 | 32036016 | PRJNA473201_P_NODE_53898_length_282_cov_1.473684_g53156_i0 | PRJNA473201 | 53898 | 282 | 1.473684 | 4.15578888 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 5.579999999999999e-31 | NR | CEO96095.1 | 37360 | g53156 | i0 | 54.8 | 0.98936170212766 | 93 | 42 | 98.9 | 0 | 281 | 3 | 99 | 191 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 279 | 120 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32352718 | 32352718 | PRJNA473201_P_NODE_17599_length_474_cov_3.371571_g16857_i0 | PRJNA473201 | 17599 | 474 | 3.371571 | 15.98124654 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 1.39e-28 | NR | CEP02593.1 | 37360 | g16857 | i0 | 59.8 | 0.582278481012658 | 92 | 37 | 58.2 | 0 | 447 | 172 | 11 | 102 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 276 | 111 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32590215 | 32590215 | PRJNA473201_P_NODE_73419_length_247_cov_0.885057_g72677_i0 | PRJNA473201 | 73419 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 1.22e-22 | NR | CEP01656.1 | 37360 | g72677 | i0 | 58.3 | 2.02834008097166 | 84 | 31 | 99.6 | 2 | 246 | 1 | 53 | 134 | CEP01656.1 hypothetical protein PBRA_008598 [Plasmodiophora brassicae] | diamond | 501 | 98.2 | 0.991853360488798 | 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);;