contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25792559 | 25792559 | PRJEB20058_P_NODE_53947_length_572_cov_10.708415_g51206_i0 | PRJEB20058 | 53947 | 572 | 10.708415 | 61.2521338 | Phytophthora pseudosyringae | 221518 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 8.05e-82 | NR | KAG7382785.1 | 221518 | g51206 | i0 | 72.7 | 4.83041958041958 | 187 | 46 | 96 | 2 | 549 | 1 | 71 | 256 | KAG7382785.1 regulator of nonsense transcription [Phytophthora pseudosyringae] | diamond | 2763 | 259 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora pseudosyringae | ||
| 25928388 | 25928388 | PRJEB20058_P_NODE_47028_length_613_cov_59.710145_g44327_i0 | PRJEB20058 | 47028 | 613 | 59.710145 | 366.02318885 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 1.52e-25 | NR | KAG2522616.1 | 325452 | g44327 | i0 | 52.8 | 3.62153344208809 | 106 | 50 | 51.9 | 0 | 585 | 268 | 600 | 705 | KAG2522616.1 hypothetical protein JM16_003408 [Phytophthora kernoviae] | diamond | 2220 | 114 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 26331003 | 26331003 | PRJEB20058_P_NODE_143375_length_323_cov_20.007634_g140554_i0 | PRJEB20058 | 143375 | 323 | 20.007634 | 64.62465782 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 1.8e-15 | NR | YP_009167020.1 | 114742 | g140554 | i0 | 52.6 | 2.1733746130031 | 78 | 37 | 72.4 | 0 | 76 | 309 | 10 | 87 | YP_009167020.1 NADH dehydrogenase subunit 4L [Pythium insidiosum] | diamond | 702 | 76.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32910578 | 32910578 | PRJEB20058_P_NODE_140025_length_328_cov_44.779026_g137204_i0 | PRJEB20058 | 140025 | 328 | 44.779026 | 146.87520528 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 2.47e-9 | NR | KAF0694661.1 | 120398 | g137204 | i0 | 57.9 | 0.521341463414634 | 57 | 24 | 52.1 | 0 | 284 | 114 | 197 | 253 | KAF0694661.1 hypothetical protein As57867_014446 [Aphanomyces stellatus] | diamond | 171 | 63.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 32922715 | 32922715 | PRJEB20058_P_NODE_102265_length_402_cov_2.252199_g99458_i0 | PRJEB20058 | 102265 | 402 | 2.252199 | 9.05383998 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 2.95e-40 | NR | OQS00817.1 | 74557 | g99458 | i0 | 62.3 | 10.2611940298507 | 114 | 43 | 85.1 | 0 | 20 | 361 | 22 | 135 | OQS00817.1 60S ribosomal protein L32-1 [Thraustotheca clavata] | diamond | 4125 | 141 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32922746 | 32922746 | PRJEB20058_P_NODE_132745_length_341_cov_2.542857_g129925_i0 | PRJEB20058 | 132745 | 341 | 2.542857 | 8.67114237 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 1.61e-7 | NR | RLN45717.1 | 325452 | g129925 | i0 | 81.8 | 1.74193548387097 | 33 | 6 | 29 | 0 | 313 | 215 | 348 | 380 | RLN45717.1 hypothetical protein BBI17_005902 [Phytophthora kernoviae] | diamond | 594 | 59.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 32940013 | 32940013 | PRJEB20058_P_NODE_176177_length_280_cov_3.762557_g173354_i0 | PRJEB20058 | 176177 | 280 | 3.762557 | 10.5351596 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 8.75e-11 | NR | KAF1794368.1 | 29920 | g173354 | i0 | 66.7 | 3.66428571428571 | 42 | 14 | 45 | 0 | 56 | 181 | 1 | 42 | KAF1794368.1 hypothetical protein GQ600_2384 [Phytophthora cactorum] | diamond | 1026 | 67.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 32945587 | 32945587 | PRJEB20058_P_NODE_46170_length_619_cov_4.593190_g43473_i0 | PRJEB20058 | 46170 | 619 | 4.59319 | 28.4318461 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 312 | 1.81e-94 | NR | CAI5724092.1 | 134698 | g43473 | i0 | 95.4 | 1.69628432956381 | 175 | 6 | 83.8 | 1 | 618 | 100 | 2126 | 2300 | CAI5724092.1 unnamed protein product [Peronospora farinosa] | diamond | 1050 | 312 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 32962356 | 32962356 | PRJEB20058_P_NODE_179050_length_277_cov_2.060185_g176227_i0 | PRJEB20058 | 179050 | 277 | 2.060185 | 5.70671245 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.0115 | NR | KAF0688124.1 | 120398 | g176227 | i0 | 35.7 | 0.75812274368231 | 70 | 39 | 69.3 | 1 | 245 | 54 | 371 | 440 | KAF0688124.1 hypothetical protein As57867_020164 [Aphanomyces stellatus] | diamond | 210 | 44.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 32962667 | 32962667 | PRJEB20058_P_NODE_236434_length_223_cov_4.740741_g233609_i0 | PRJEB20058 | 236434 | 223 | 4.740741 | 10.57185243 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 3.44e-22 | NR | CAH0475341.1 | 622444 | g233609 | i0 | 71.6 | 0.901345291479821 | 67 | 17 | 90.1 | 2 | 223 | 23 | 21 | 85 | CAH0475341.1 unnamed protein product [Peronospora belbahrii] | diamond | 201 | 92.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 32979047 | 32979047 | PRJEB20058_P_NODE_110387_length_384_cov_2.606811_g107575_i0 | PRJEB20058 | 110387 | 384 | 2.606811 | 10.01015424 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 3.29e-41 | NR | KAF1334048.1 | 82926 | g107575 | i0 | 83 | 1.3671875 | 88 | 15 | 68.8 | 0 | 376 | 113 | 626 | 713 | KAF1334048.1 Trehalase, partial [Globisporangium splendens] | diamond | 525 | 155 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 32979214 | 32979214 | PRJEB20058_P_NODE_137315_length_333_cov_3.996324_g134494_i0 | PRJEB20058 | 137315 | 333 | 3.996324 | 13.30775892 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 5.99e-39 | NR | YP_003734820.1 | 2052682 | g134494 | i0 | 91 | 0.702702702702703 | 78 | 7 | 70.3 | 0 | 22 | 255 | 77 | 154 | YP_003734820.1 orf245 [Globisporangium ultimum] | diamond | 234 | 140 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 33008358 | 33008358 | PRJEB20058_P_NODE_245651_length_203_cov_10.373239_g242826_i0 | PRJEB20058 | 245651 | 203 | 10.373239 | 21.05767517 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 5.98e-11 | NR | XP_067742527.1 | 164328 | g242826 | i0 | 86.5 | 1.61083743842365 | 37 | 5 | 54.7 | 0 | 185 | 75 | 273 | 309 | XP_067742527.1 uncharacterized protein KRP23_9349 [Phytophthora ramorum] | diamond | 327 | 66.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 33025432 | 33025432 | PRJEB20058_P_NODE_114828_length_374_cov_35.536741_g112013_i0 | PRJEB20058 | 114828 | 374 | 35.536741 | 132.90741134 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 4.09e-10 | NR | KAG6967645.1 | 29920 | g112013 | i0 | 41 | 4.1951871657754 | 83 | 41 | 65.8 | 2 | 298 | 53 | 18 | 93 | KAG6967645.1 hypothetical protein JG687_00004185 [Phytophthora cactorum] | diamond | 1569 | 63.5 | 0.995275590551181 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 33030214 | 33030214 | PRJEB20058_P_NODE_129820_length_346_cov_3.421053_g127001_i0 | PRJEB20058 | 129820 | 346 | 3.421053 | 11.83684338 | Phytophthora citrophthora | 4793 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0346 | NR | KAK1946811.1 | 4793 | g127001 | i0 | 45.6 | 0.494219653179191 | 57 | 28 | 46.8 | 1 | 213 | 52 | 9 | 65 | KAK1946811.1 Craniofacial development protein 2 [Phytophthora citrophthora] | diamond | 171 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 33042514 | 33042514 | PRJEB20058_P_NODE_39644_length_668_cov_11.461285_g37010_i0 | PRJEB20058 | 39644 | 668 | 11.461285 | 76.5613838 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 6.5e-72 | NR | XP_009536013.1 | 67593 | g37010 | i0 | 59.5 | 1.74251497005988 | 195 | 75 | 86.2 | 2 | 34 | 609 | 70 | 263 | XP_009536013.1 hypothetical protein PHYSODRAFT_339745 [Phytophthora sojae] | diamond | 1164 | 229 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 33059584 | 33059584 | PRJEB20058_P_NODE_61805_length_532_cov_236.991507_g59043_i0 | PRJEB20058 | 61805 | 532 | 236.991507 | 1260.79481724 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 2.5099999999999996e-29 | NR | KAJ0391848.1 | 114742 | g59043 | i0 | 51.3 | 2.43609022556391 | 113 | 55 | 63.7 | 0 | 98 | 436 | 7 | 119 | KAJ0391848.1 hypothetical protein P43SY_006045 [Pythium insidiosum] | diamond | 1296 | 114 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 33076614 | 33076614 | PRJEB20058_P_NODE_60077_length_540_cov_38.787056_g57318_i0 | PRJEB20058 | 60077 | 540 | 38.787056 | 209.4501024 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 2.72e-6 | NR | TMW67786.1 | 41045 | g57318 | i0 | 38.7 | 3.32222222222222 | 93 | 55 | 50.6 | 1 | 159 | 431 | 48 | 140 | TMW67786.1 hypothetical protein Poli38472_007458 [Pythium oligandrum] | diamond | 1794 | 55.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 33081605 | 33081605 | PRJEB20058_P_NODE_183022_length_272_cov_14.360190_g180199_i0 | PRJEB20058 | 183022 | 272 | 14.36019 | 39.0597168 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0289 | NR | XP_067815656.1 | 4779 | g180199 | i0 | 39.1 | 0.507352941176471 | 46 | 28 | 50.7 | 0 | 252 | 115 | 401 | 446 | XP_067815656.1 hypothetical protein CCR75_009096 [Bremia lactucae] | diamond | 138 | 43.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 33098250 | 33098250 | PRJEB20058_P_NODE_10926_length_1259_cov_17.828881_g9404_i0 | PRJEB20058 | 10926 | 1259 | 17.828881 | 224.46561179 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 177 | 5.14e-46 | NR | GLD97938.1 | 114742 | g9404 | i0 | 39.7 | 0.569499602859412 | 239 | 133 | 54.6 | 4 | 27 | 713 | 172 | 409 | GLD97938.1 hypothetical protein PINS_up006635 [Pythium insidiosum] | diamond | 717 | 177 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 33127680 | 33127680 | PRJEB20058_P_NODE_112415_length_379_cov_48.783019_g109602_i0 | PRJEB20058 | 112415 | 379 | 48.783019 | 184.88764201 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0141 | NR | XP_067821031.1 | 4779 | g109602 | i0 | 47.4 | 2.98416886543536 | 57 | 23 | 41.2 | 2 | 74 | 229 | 50 | 104 | XP_067821031.1 hypothetical protein CCR75_002175 [Bremia lactucae] | diamond | 1131 | 43.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 33132464 | 33132464 | PRJEB20058_P_NODE_115735_length_373_cov_1.487179_g112920_i0 | PRJEB20058 | 115735 | 373 | 1.487179 | 5.54717767 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 7.810000000000001e-26 | NR | KAF1336094.1 | 82926 | g112920 | i0 | 81.1 | 0.595174262734584 | 74 | 13 | 58.7 | 1 | 50 | 268 | 550 | 623 | KAF1336094.1 Acyl-coa dehydrogenase family member 9, mitochondrial precursor, partial [Globisporangium splendens] | diamond | 222 | 112 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 33144768 | 33144768 | PRJEB20058_P_NODE_106599_length_392_cov_5.791541_g103791_i0 | PRJEB20058 | 106599 | 392 | 5.791541 | 22.70284072 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 3.5e-29 | NR | RAW31032.1 | 29920 | g103791 | i0 | 76 | 4.01785714285714 | 75 | 18 | 57.4 | 0 | 266 | 42 | 1 | 75 | RAW31032.1 hypothetical protein PC110_g12609 [Phytophthora cactorum] | diamond | 1575 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 33161739 | 33161739 | PRJEB20058_P_NODE_152168_length_310_cov_12.767068_g149345_i0 | PRJEB20058 | 152168 | 310 | 12.767068 | 39.5779108 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 1.11e-21 | NR | KAG1695779.1 | 4784 | g149345 | i0 | 81.4 | 5.16774193548387 | 59 | 11 | 57.1 | 0 | 11 | 187 | 706 | 764 | KAG1695779.1 hypothetical protein DVH05_019118 [Phytophthora capsici] | diamond | 1602 | 100 | 0.994 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 33161748 | 33161748 | PRJEB20058_P_NODE_157576_length_303_cov_2.359504_g154753_i0 | PRJEB20058 | 157576 | 303 | 2.359504 | 7.14929712 | Globisporangium | 1448052 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 3e-30 | NR | KAF1322691.1 | 82926 | g154753 | i0 | 96.9 | 1.93069306930693 | 65 | 2 | 64.4 | 0 | 303 | 109 | 370 | 434 | KAF1322691.1 Alcohol dehydrogenase 3, partial [Globisporangium splendens] | diamond | 585 | 122 | 0.991803278688525 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 33179061 | 33179061 | PRJEB20058_P_NODE_175584_length_281_cov_1.645455_g172761_i0 | PRJEB20058 | 175584 | 281 | 1.645455 | 4.62372855 | Globisporangium | 1448052 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.37e-11 | NR | KAF1336683.1 | 82926 | g172761 | i0 | 100 | 4.44128113879004 | 32 | 0 | 34.2 | 0 | 3 | 98 | 466 | 497 | KAF1336683.1 Nadh-ubiquinone oxidoreductase, partial [Globisporangium splendens] | diamond | 1248 | 70.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens |
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);;