contig_metadata
23 rows where bioproject = "PRJEB12237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20718 | 20718 | PRJEB12237_P_NODE_861_length_787_cov_4.428191_g719_i0 | PRJEB12237 | 861 | 787 | 4.428191 | 34.84986317 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 286 | 6.65e-94 | NR | CEP02495.1 | 37360 | g719 | i0 | 61.7 | 13.7191867852605 | 230 | 88 | 87.7 | 0 | 786 | 97 | 13 | 242 | CEP02495.1 hypothetical protein PBRA_009079 [Plasmodiophora brassicae] | diamond | 10797 | 288 | 0.993055555555556 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 20720 | 20720 | PRJEB12237_P_NODE_881_length_781_cov_4.703753_g737_i0 | PRJEB12237 | 881 | 781 | 4.703753 | 36.73631093 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 2.5999999999999998e-73 | NR | CEP01997.1 | 37360 | g737 | i0 | 58.7 | 1.66709346991037 | 213 | 85 | 81.4 | 2 | 30 | 665 | 1 | 211 | CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] | diamond | 1302 | 233 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 1294909 | 1294909 | PRJEB12237_P_NODE_3822_length_333_cov_2.409396_g3626_i0 | PRJEB12237 | 3822 | 333 | 2.409396 | 8.02328868 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 1.37e-44 | NR | CEP01219.1 | 37360 | g3626 | i0 | 77 | 2.59459459459459 | 100 | 17 | 84.7 | 2 | 3 | 284 | 218 | 317 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 864 | 157 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 9913743 | 9913743 | PRJEB12237_P_NODE_2468_length_448_cov_3.416465_g2272_i0 | PRJEB12237 | 2468 | 448 | 3.416465 | 15.3057632 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 5.73e-38 | NR | SPQ93437.1 | 37360 | g2272 | i0 | 62.2 | 2.97991071428571 | 111 | 42 | 74.3 | 0 | 24 | 356 | 32 | 142 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1335 | 136 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 10223467 | 10223467 | PRJEB12237_P_NODE_649_length_888_cov_4.808910_g534_i0 | PRJEB12237 | 649 | 888 | 4.80891 | 42.7031208 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 2.219999999999999e-118 | NR | CEO96095.1 | 37360 | g534 | i0 | 58.2 | 2.72972972972973 | 273 | 114 | 92.2 | 0 | 865 | 47 | 1 | 273 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 2424 | 351 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 14048814 | 14048814 | PRJEB12237_P_NODE_452_length_1050_cov_4.007882_g358_i0 | PRJEB12237 | 452 | 1050 | 4.007882 | 42.082761 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 314 | 1.45e-102 | NR | CEO97280.1 | 37360 | g358 | i0 | 54.1 | 0.865714285714286 | 303 | 137 | 86.6 | 1 | 70 | 978 | 12 | 312 | CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] | diamond | 909 | 314 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 18837402 | 18837402 | PRJEB12237_P_NODE_4055_length_321_cov_1.940559_g3859_i0 | PRJEB12237 | 4055 | 321 | 1.940559 | 6.22919439 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 5.83e-37 | NR | CEO96420.1 | 37360 | g3859 | i0 | 73 | 0.831775700934579 | 89 | 24 | 83.2 | 0 | 4 | 270 | 327 | 415 | CEO96420.1 hypothetical protein PBRA_005091 [Plasmodiophora brassicae] | diamond | 267 | 139 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27159119 | 27159119 | PRJEB12237_P_NODE_9142_length_179_cov_1.111111_g8946_i0 | PRJEB12237 | 9142 | 179 | 1.111111 | 1.98888869 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 1.62e-16 | NR | CEP02236.1 | 37360 | g8946 | i0 | 66.1 | 0.93854748603352 | 56 | 19 | 93.9 | 0 | 10 | 177 | 1 | 56 | CEP02236.1 hypothetical protein PBRA_002501 [Plasmodiophora brassicae] | diamond | 168 | 78.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27444149 | 27444149 | PRJEB12237_P_NODE_11363_length_156_cov_1.322314_g11167_i0 | PRJEB12237 | 11363 | 156 | 1.322314 | 2.06280984 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 5.54e-15 | NR | CEO96533.1 | 37360 | g11167 | i0 | 63.3 | 0.942307692307692 | 49 | 18 | 94.2 | 0 | 3 | 149 | 43 | 91 | CEO96533.1 hypothetical protein PBRA_005142 [Plasmodiophora brassicae] | diamond | 147 | 73.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27570065 | 27570065 | PRJEB12237_P_NODE_6744_length_220_cov_1.513514_g6548_i0 | PRJEB12237 | 6744 | 220 | 1.513514 | 3.3297308 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0217 | NR | CEP02643.1 | 37360 | g6548 | i0 | 33.8 | 1.05 | 77 | 45 | 98.2 | 2 | 217 | 2 | 53 | 128 | CEP02643.1 hypothetical protein PBRA_002610 [Plasmodiophora brassicae] | diamond | 231 | 42 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28264605 | 28264605 | PRJEB12237_P_NODE_8006_length_195_cov_1.500000_g7810_i0 | PRJEB12237 | 8006 | 195 | 1.5 | 2.925 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 1.31e-15 | NR | CEO95191.1 | 37360 | g7810 | i0 | 62.5 | 0.984615384615385 | 64 | 23 | 96.9 | 1 | 192 | 4 | 20 | 83 | CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] | diamond | 192 | 80.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28448078 | 28448078 | PRJEB12237_P_NODE_7546_length_203_cov_1.190476_g7350_i0 | PRJEB12237 | 7546 | 203 | 1.190476 | 2.41666628 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 1.3e-30 | NR | CEO95191.1 | 37360 | g7350 | i0 | 90.8 | 1.935960591133 | 65 | 6 | 96.1 | 0 | 195 | 1 | 242 | 306 | CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] | diamond | 393 | 121 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28517434 | 28517434 | PRJEB12237_P_NODE_2727_length_422_cov_1.666667_g2531_i0 | PRJEB12237 | 2727 | 422 | 1.666667 | 7.03333474 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 5.07e-6 | NR | CEP02334.1 | 37360 | g2531 | i0 | 33.6 | 1.84123222748815 | 119 | 73 | 82.5 | 3 | 352 | 5 | 122 | 237 | CEP02334.1 hypothetical protein PBRA_008918 [Plasmodiophora brassicae] | diamond | 777 | 55.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28833045 | 28833045 | PRJEB12237_P_NODE_8288_length_191_cov_0.987179_g8092_i0 | PRJEB12237 | 8288 | 191 | 0.987179 | 1.88551189 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 2.38e-18 | NR | CEP01776.1 | 37360 | g8092 | i0 | 63.3 | 0.942408376963351 | 60 | 22 | 94.2 | 0 | 182 | 3 | 289 | 348 | CEP01776.1 hypothetical protein PBRA_008718 [Plasmodiophora brassicae] | diamond | 180 | 87.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30190881 | 30190881 | PRJEB12237_P_NODE_1352_length_621_cov_2.491468_g1184_i0 | PRJEB12237 | 1352 | 621 | 2.491468 | 15.47201628 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 4.49e-19 | NR | CEP02593.1 | 37360 | g1184 | i0 | 58.3 | 1.1207729468599 | 72 | 30 | 34.8 | 0 | 614 | 399 | 31 | 102 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 696 | 89 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30349512 | 30349512 | PRJEB12237_P_NODE_1832_length_530_cov_3.228283_g1648_i0 | PRJEB12237 | 1832 | 530 | 3.228283 | 17.1098999 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 170 | 7.89e-51 | NR | CEO99081.1 | 37360 | g1648 | i0 | 60.3 | 0.79811320754717 | 141 | 51 | 79.8 | 1 | 490 | 68 | 8 | 143 | CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] | diamond | 423 | 170 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30886066 | 30886066 | PRJEB12237_P_NODE_5574_length_252_cov_2.580645_g5378_i0 | PRJEB12237 | 5574 | 252 | 2.580645 | 6.5032254 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 2.31e-27 | NR | CEP01968.1 | 37360 | g5378 | i0 | 74.3 | 0.880952380952381 | 74 | 17 | 88.1 | 1 | 29 | 250 | 1 | 72 | CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] | diamond | 222 | 109 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31201609 | 31201609 | PRJEB12237_P_NODE_10475_length_164_cov_1.062016_g10279_i0 | PRJEB12237 | 10475 | 164 | 1.062016 | 1.74170624 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 8.66e-8 | NR | CEO97451.1 | 37360 | g10279 | i0 | 50 | 0.98780487804878 | 54 | 26 | 98.8 | 1 | 3 | 164 | 734 | 786 | CEO97451.1 hypothetical protein PBRA_000795, partial [Plasmodiophora brassicae] | diamond | 162 | 57.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31423419 | 31423419 | PRJEB12237_P_NODE_9236_length_178_cov_1.076923_g9040_i0 | PRJEB12237 | 9236 | 178 | 1.076923 | 1.91692294 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 2.16e-13 | NR | SPR01254.1 | 37360 | g9040 | i0 | 55.9 | 0.99438202247191 | 59 | 26 | 99.4 | 0 | 177 | 1 | 2851 | 2909 | SPR01254.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 177 | 73.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32024527 | 32024527 | PRJEB12237_P_NODE_6898_length_217_cov_1.098901_g6702_i0 | PRJEB12237 | 6898 | 217 | 1.098901 | 2.38461517 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 5.28e-16 | NR | SPR01560.1 | 37360 | g6702 | i0 | 66.7 | 0.746543778801843 | 54 | 18 | 74.7 | 0 | 1 | 162 | 658 | 711 | SPR01560.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 162 | 81.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32492918 | 32492918 | PRJEB12237_P_NODE_9499_length_174_cov_2.230216_g9303_i0 | PRJEB12237 | 9499 | 174 | 2.230216 | 3.88057584 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00162 | NR | CAM98718.1 | 37360 | g9303 | i0 | 48 | 3.53448275862069 | 50 | 25 | 84.5 | 1 | 148 | 2 | 186 | 235 | CAM98718.1 hypothetical protein [Plasmodiophora brassicae] | diamond | 615 | 45.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32688172 | 32688172 | PRJEB12237_P_NODE_11620_length_154_cov_1.411765_g11424_i0 | PRJEB12237 | 11620 | 154 | 1.411765 | 2.1741181 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 1.13e-19 | NR | CEO94766.1 | 37360 | g11424 | i0 | 83.7 | 17.4350649350649 | 49 | 8 | 95.5 | 0 | 152 | 6 | 39 | 87 | CEO94766.1 hypothetical protein PBRA_003579 [Plasmodiophora brassicae] | diamond | 2685 | 85.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32877205 | 32877205 | PRJEB12237_P_NODE_9500_length_174_cov_2.215827_g9304_i0 | PRJEB12237 | 9500 | 174 | 2.215827 | 3.85553898 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 4.45e-17 | NR | CEO98337.1 | 37360 | g9304 | i0 | 63.8 | 2 | 58 | 21 | 100 | 0 | 174 | 1 | 281 | 338 | CEO98337.1 hypothetical protein PBRA_006451 [Plasmodiophora brassicae] | diamond | 348 | 84 | 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);;