contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA312899" and tax_phylum = "Oomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6757006 | 6757006 | PRJNA312899_P_NODE_30006_length_337_cov_2.805556_g29564_i0 | PRJNA312899 | 30006 | 337 | 2.805556 | 9.45472372 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 2.0199999999999997e-37 | NR | XP_008618752.1 | 1156394 | g29564 | i0 | 74.7 | 0.738872403560831 | 83 | 20 | 73 | 1 | 337 | 92 | 5 | 87 | XP_008618752.1 hypothetical protein SDRG_14406 [Saprolegnia diclina VS20] | diamond | 249 | 131 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 6757843 | 6757843 | PRJNA312899_P_NODE_7766_length_671_cov_7.372990_g7393_i0 | PRJNA312899 | 7766 | 671 | 7.37299 | 49.4727629 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 9.15e-17 | NR | CCI48717.1 | 65357 | g7393 | i0 | 50 | 2.26229508196721 | 76 | 34 | 33.5 | 2 | 647 | 423 | 5 | 77 | CCI48717.1 unnamed protein product [Albugo candida] | diamond | 1518 | 83.2 | 0.995192307692308 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 13134147 | 13134147 | PRJNA312899_P_NODE_9291_length_620_cov_5.611208_g8896_i0 | PRJNA312899 | 9291 | 620 | 5.611208 | 34.7894896 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 275 | 1.1799999999999997e-89 | NR | KAJ0411878.1 | 114742 | g8896 | i0 | 65.6 | 9.09193548387097 | 209 | 69 | 99.7 | 2 | 620 | 3 | 66 | 274 | KAJ0411878.1 hypothetical protein ATCC90586_005973 [Pythium insidiosum] | diamond | 5637 | 277 | 0.992779783393502 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 13818557 | 13818557 | PRJNA312899_P_NODE_9371_length_617_cov_74.239437_g8976_i0 | PRJNA312899 | 9371 | 617 | 74.239437 | 458.05732629 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 5.62e-40 | NR | KAJ8578052.1 | 4785 | g8976 | i0 | 53.3 | 4.78930307941653 | 167 | 49 | 80.7 | 4 | 615 | 118 | 122 | 260 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 2955 | 147 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 24605021 | 24605021 | PRJNA312899_P_NODE_13360_length_517_cov_3.715812_g12930_i0 | PRJNA312899 | 13360 | 517 | 3.715812 | 19.21074804 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.18e-21 | NR | KAF1314525.1 | 82926 | g12930 | i0 | 37.5 | 0.835589941972921 | 144 | 89 | 83 | 1 | 429 | 1 | 974 | 1117 | KAF1314525.1 Regulator of chromosome condensation, partial [Globisporangium splendens] | diamond | 432 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 26821285 | 26821285 | PRJNA312899_P_NODE_11241_length_564_cov_5.157282_g10822_i0 | PRJNA312899 | 11241 | 564 | 5.157282 | 29.08707048 | Phytophthora infestans T3 | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.4900000000000002e-27 | NR | XP_002902687.1 | 403677 | g10822 | i0 | 50.9 | 0.563829787234043 | 106 | 52 | 56.4 | 0 | 239 | 556 | 556 | 661 | XP_002902687.1 NADPH-cytochrome P450 reductase, putative [Phytophthora infestans T30-4] | diamond | 318 | 119 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 27123141 | 27123141 | PRJNA312899_P_NODE_45782_length_260_cov_2.658768_g45340_i0 | PRJNA312899 | 45782 | 260 | 2.658768 | 6.9127968 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.14e-26 | NR | RHY87967.1 | 112090 | g45340 | i0 | 60.7 | 12.5423076923077 | 84 | 32 | 95.8 | 1 | 250 | 2 | 97 | 180 | RHY87967.1 hypothetical protein DYB35_007045 [Aphanomyces astaci] | diamond | 3261 | 110 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 27597501 | 27597501 | PRJNA312899_P_NODE_12844_length_527_cov_33.663180_g12415_i0 | PRJNA312899 | 12844 | 527 | 33.66318 | 177.4049586 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 2.67e-33 | NR | KAG1710905.1 | 4784 | g12415 | i0 | 59 | 4.65085388994307 | 117 | 34 | 66.6 | 1 | 525 | 175 | 399 | 501 | KAG1710905.1 hypothetical protein DVH05_013627 [Phytophthora capsici] | diamond | 2451 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 27629108 | 27629108 | PRJNA312899_P_NODE_3464_length_934_cov_7.715254_g3209_i0 | PRJNA312899 | 3464 | 934 | 7.715254 | 72.06047236 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 299 | 5.459999999999998e-96 | NR | TMW60187.1 | 41045 | g3209 | i0 | 56.3 | 5.06852248394004 | 263 | 110 | 84.5 | 2 | 934 | 146 | 132 | 389 | TMW60187.1 hypothetical protein Poli38472_000229 [Pythium oligandrum] | diamond | 4734 | 301 | 0.993355481727575 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27818582 | 27818582 | PRJNA312899_P_NODE_9264_length_620_cov_44.697023_g8870_i0 | PRJNA312899 | 9264 | 620 | 44.697023 | 277.1215426 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 2.68e-27 | NR | KUF98385.1 | 4792 | g8870 | i0 | 44.8 | 2.29838709677419 | 116 | 64 | 56.1 | 0 | 43 | 390 | 535 | 650 | KUF98385.1 Aladin [Phytophthora nicotianae] | diamond | 1425 | 120 | 0.991666666666667 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 27895458 | 27895458 | PRJNA312899_P_NODE_40405_length_281_cov_1.310345_g39963_i0 | PRJNA312899 | 40405 | 281 | 1.310345 | 3.68206945 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 3.59e-16 | NR | OQR91845.1 | 1202772 | g39963 | i0 | 44.7 | 1.00355871886121 | 94 | 50 | 98.2 | 1 | 6 | 281 | 191 | 284 | OQR91845.1 transmembrane protein [Achlya hypogyna] | diamond | 282 | 83.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 28495594 | 28495594 | PRJNA312899_P_NODE_16987_length_458_cov_4.843521_g16548_i0 | PRJNA312899 | 16987 | 458 | 4.843521 | 22.18332618 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.87e-8 | NR | XP_012209850.1 | 695850 | g16548 | i0 | 28.6 | 0.962882096069869 | 147 | 102 | 94.3 | 3 | 451 | 20 | 55 | 201 | XP_012209850.1 hypothetical protein SPRG_15414 [Saprolegnia parasitica CBS 223.65] | diamond | 441 | 63.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 28748037 | 28748037 | PRJNA312899_P_NODE_31427_length_328_cov_2.193548_g30985_i0 | PRJNA312899 | 31427 | 328 | 2.193548 | 7.19483744 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 2.32e-5 | NR | KAG1700710.1 | 4784 | g30985 | i0 | 41.3 | 1.3719512195122 | 75 | 43 | 68.6 | 1 | 297 | 73 | 7 | 80 | KAG1700710.1 hypothetical protein DVH05_011569 [Phytophthora capsici] | diamond | 450 | 50.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 28765494 | 28765494 | PRJNA312899_P_NODE_52267_length_239_cov_3.721053_g51825_i0 | PRJNA312899 | 52267 | 239 | 3.721053 | 8.89331667 | root | 1 | Root_unresolved | Root_unresolved | 45.8 | 0.00222 | NR | AIG56449.1 | 1202772 | g51825 | i0 | 69.6 | 1.15481171548117 | 23 | 7 | 28.9 | 0 | 1 | 69 | 91 | 113 | AIG56449.1 secreted protein [Achlya hypogyna] | diamond | 276 | 45.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 29428399 | 29428399 | PRJNA312899_P_NODE_64349_length_207_cov_1.873418_g63907_i0 | PRJNA312899 | 64349 | 207 | 1.873418 | 3.87797526 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 1.49e-15 | NR | KAI9996756.1 | 4787 | g63907 | i0 | 89.7 | 3.33333333333333 | 39 | 4 | 56.5 | 0 | 203 | 87 | 252 | 290 | KAI9996756.1 hypothetical protein PInf_000017 [Phytophthora infestans] | diamond | 690 | 79 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 29726560 | 29726560 | PRJNA312899_P_NODE_10710_length_578_cov_5.319471_g10296_i0 | PRJNA312899 | 10710 | 578 | 5.319471 | 30.74654238 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 3.71e-28 | NR | CAH0517053.1 | 622444 | g10296 | i0 | 72.8 | 0.752595155709343 | 81 | 22 | 42 | 0 | 41 | 283 | 450 | 530 | CAH0517053.1 unnamed protein product [Peronospora belbahrii] | diamond | 435 | 121 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 29870693 | 29870693 | PRJNA312899_P_NODE_57651_length_224_cov_1.725714_g57209_i0 | PRJNA312899 | 57651 | 224 | 1.725714 | 3.86559936 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 2.27e-11 | NR | RQM20636.1 | 112090 | g57209 | i0 | 50 | 3.42857142857143 | 64 | 32 | 85.7 | 0 | 29 | 220 | 325 | 388 | RQM20636.1 hypothetical protein B5M09_000397 [Aphanomyces astaci] | diamond | 768 | 68.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30011261 | 30011261 | PRJNA312899_P_NODE_7351_length_687_cov_6.637931_g6986_i0 | PRJNA312899 | 7351 | 687 | 6.637931 | 45.60258597 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.05e-7 | NR | KAF1328509.1 | 82926 | g6986 | i0 | 27 | 0.663755458515284 | 152 | 100 | 65.5 | 2 | 686 | 237 | 3418 | 3560 | KAF1328509.1 Ubiquitin carboxyl-terminal hydrolase 34, partial [Globisporangium splendens] | diamond | 456 | 63.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 30074156 | 30074156 | PRJNA312899_P_NODE_60972_length_215_cov_9.180723_g60530_i0 | PRJNA312899 | 60972 | 215 | 9.180723 | 19.73855445 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 5.42e-9 | NR | OQR80448.1 | 74557 | g60530 | i0 | 49.1 | 1.57674418604651 | 57 | 28 | 78.1 | 1 | 48 | 215 | 9 | 65 | OQR80448.1 ankyrin repeat domain-containing protein 50-like, partial [Thraustotheca clavata] | diamond | 339 | 60.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 30105753 | 30105753 | PRJNA312899_P_NODE_10872_length_574_cov_8.028571_g10456_i0 | PRJNA312899 | 10872 | 574 | 8.028571 | 46.08399754 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 3.2e-4 | NR | OQR89238.1 | 74557 | g10456 | i0 | 51 | 1.57839721254355 | 51 | 24 | 26.1 | 1 | 239 | 90 | 88 | 138 | OQR89238.1 hypothetical protein THRCLA_22722 [Thraustotheca clavata] | diamond | 906 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 30769479 | 30769479 | PRJNA312899_P_NODE_29994_length_337_cov_4.013889_g29552_i0 | PRJNA312899 | 29994 | 337 | 4.013889 | 13.52680593 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 4.53e-7 | NR | DAZ99657.1 | 4803 | g29552 | i0 | 49 | 0.454005934718101 | 51 | 26 | 45.4 | 0 | 228 | 76 | 47 | 97 | DAZ99657.1 TPA: hypothetical protein N0F65_001894 [Lagenidium giganteum] | diamond | 153 | 55.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31148117 | 31148117 | PRJNA312899_P_NODE_71875_length_190_cov_1.248227_g71433_i0 | PRJNA312899 | 71875 | 190 | 1.248227 | 2.3716313 | Hyaloperonospora arabidopsidis | 272952 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.78e-30 | NR | YP_010394014.1 | 272952 | g71433 | i0 | 92.1 | 0.994736842105263 | 63 | 5 | 99.5 | 0 | 2 | 190 | 67 | 129 | YP_010394014.1 ribosomal protein S13 [Hyaloperonospora arabidopsidis] | diamond | 189 | 113 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora arabidopsidis | ||
| 31514229 | 31514229 | PRJNA312899_P_NODE_50976_length_243_cov_2.608247_g50534_i0 | PRJNA312899 | 50976 | 243 | 2.608247 | 6.33804021 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.5399999999999999e-24 | NR | RQM20060.1 | 112090 | g50534 | i0 | 70.1 | 3.80246913580247 | 77 | 21 | 92.6 | 1 | 226 | 2 | 22 | 98 | RQM20060.1 hypothetical protein B5M09_010909 [Aphanomyces astaci] | diamond | 924 | 107 | 0.990654205607477 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 32083298 | 32083298 | PRJNA312899_P_NODE_41998_length_274_cov_4.071111_g41556_i0 | PRJNA312899 | 41998 | 274 | 4.071111 | 11.15484414 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.25e-26 | NR | XP_024572896.1 | 4781 | g41556 | i0 | 69 | 19.8613138686131 | 71 | 22 | 77.7 | 0 | 5 | 217 | 662 | 732 | XP_024572896.1 amp deaminase [Plasmopara halstedii] | diamond | 5442 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 32097382 | 32097382 | PRJNA312899_P_NODE_18198_length_442_cov_36.249364_g17757_i0 | PRJNA312899 | 18198 | 442 | 36.249364 | 160.22218888 | Phytophthora nicotianae P1 | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 4.6e-92 | NR | ETP28243.1 | 1317064 | g17757 | i0 | 99.3 | 0.997737556561086 | 147 | 1 | 99.8 | 0 | 442 | 2 | 6 | 152 | ETP28243.1 hypothetical protein F442_22471, partial [Phytophthora nicotianae P10297] | diamond | 441 | 274 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 32589672 | 32589672 | PRJNA312899_P_NODE_29019_length_343_cov_9.605442_g28577_i0 | PRJNA312899 | 29019 | 343 | 9.605442 | 32.94666606 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 2.88e-10 | NR | OQR99551.1 | 74557 | g28577 | i0 | 43.3 | 3.30612244897959 | 97 | 53 | 84 | 2 | 340 | 53 | 186 | 281 | OQR99551.1 hypothetical protein THRCLA_06462 [Thraustotheca clavata] | diamond | 1134 | 67 | 0.994029850746269 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata |
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);;