contig_metadata
24 rows where bioproject = "PRJNA1105232", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2295838 | 2295838 | PRJNA1105232_S_NODE_3042_length_322_cov_2.274725_g2826_i0 | PRJNA1105232 | 3042 | 322 | 2.274725 | 7.3246145 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 6.23e-34 | NTclustered | gi|301119740|ref|XM_002907552.1| | 403677 | g2826 | i0 | 79.149 | 49.6304347826087 | 235 | 43 | 72 | 5 | 1 | 232 | 450 | 219 | Phytophthora infestans T30-4 60S ribosomal protein L23a (PITG_02694), mRNA | blastn | 15981 | 158 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 4039357 | 4039357 | PRJNA1105232_S_NODE_1904_length_383_cov_2.278443_g1688_i0 | PRJNA1105232 | 1904 | 383 | 2.278443 | 8.72643669 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 190 | 2.219999999999999e-55 | NR | KAF1313838.1 | 82926 | g1688 | i0 | 77.6 | 7.90339425587467 | 125 | 27 | 97.1 | 1 | 3 | 374 | 340 | 464 | KAF1313838.1 Dihydrolipoyl dehydrogenase, partial [Globisporangium splendens] | diamond | 3027 | 190 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 9140206 | 9140206 | PRJNA1105232_S_NODE_5848_length_249_cov_2.860000_g5632_i0 | PRJNA1105232 | 5848 | 249 | 2.86 | 7.1214 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.7899999999999996e-31 | NTclustered | gi|675169594|ref|XM_008895434.1| | 761204 | g5632 | i0 | 79.245 | 3.71084337349398 | 212 | 44 | 85 | 0 | 35 | 246 | 482 | 271 | Phytophthora parasitica INRA-310 40S ribosomal protein S16 mRNA | blastn | 924 | 148 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 10416030 | 10416030 | PRJNA1105232_S_NODE_2889_length_328_cov_1.301075_g2673_i0 | PRJNA1105232 | 2889 | 328 | 1.301075 | 4.267526 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 1.37e-15 | NR | XP_009843210.1 | 112090 | g2673 | i0 | 44.6 | 1.875 | 101 | 53 | 92.4 | 2 | 26 | 328 | 182 | 279 | XP_009843210.1 hypothetical protein H257_16475 [Aphanomyces astaci] | diamond | 615 | 81.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 20613770 | 20613770 | PRJNA1105232_S_NODE_9397_length_207_cov_1.601266_g9181_i0 | PRJNA1105232 | 9397 | 207 | 1.601266 | 3.31462062 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 1.07e-17 | NR | TMW66879.1 | 41045 | g9181 | i0 | 63.2 | 1.97101449275362 | 68 | 22 | 98.6 | 2 | 3 | 206 | 947 | 1011 | TMW66879.1 hypothetical protein Poli38472_011995 [Pythium oligandrum] | diamond | 408 | 86.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 21889405 | 21889405 | PRJNA1105232_S_NODE_4638_length_273_cov_2.361607_g4422_i0 | PRJNA1105232 | 4638 | 273 | 2.361607 | 6.44718711 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.3299999999999995e-37 | NR | RHY25634.1 | 157072 | g4422 | i0 | 74.2 | 3.93406593406593 | 89 | 23 | 97.8 | 0 | 6 | 272 | 202 | 290 | RHY25634.1 hypothetical protein DYB32_008190 [Aphanomyces invadans] | diamond | 1074 | 138 | 0.992753623188406 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 26647281 | 26647281 | PRJNA1105232_S_NODE_10021_length_202_cov_1.013072_g9805_i0 | PRJNA1105232 | 10021 | 202 | 1.013072 | 2.04640544 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 9.4e-6 | NR | KAF0737942.1 | 100861 | g9805 | i0 | 35.4 | 3.59405940594059 | 65 | 42 | 96.5 | 0 | 202 | 8 | 135 | 199 | KAF0737942.1 hypothetical protein Ae201684_005938 [Aphanomyces euteiches] | diamond | 726 | 52.4 | 0.99236641221374 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 26750790 | 26750790 | PRJNA1105232_S_NODE_15581_length_168_cov_0.873950_g15365_i0 | PRJNA1105232 | 15581 | 168 | 0.87395 | 1.468236 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 2.13e-12 | NR | CAI5734323.1 | 162125 | g15365 | i0 | 58.7 | 1.64285714285714 | 46 | 19 | 82.1 | 0 | 27 | 164 | 241 | 286 | CAI5734323.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 276 | 70.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 27668091 | 27668091 | PRJNA1105232_S_NODE_8624_length_214_cov_1.206061_g8408_i0 | PRJNA1105232 | 8624 | 214 | 1.206061 | 2.58097054 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.72e-10 | NR | CCA17511.1 | 890382 | g8408 | i0 | 50 | 0.981308411214953 | 70 | 31 | 98.1 | 2 | 212 | 3 | 407 | 472 | CCA17511.1 3phosphoinositidedependent protein kinase putative [Albugo laibachii Nc14] | diamond | 210 | 65.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 27699849 | 27699849 | PRJNA1105232_S_NODE_8704_length_213_cov_1.902439_g8488_i0 | PRJNA1105232 | 8704 | 213 | 1.902439 | 4.05219507 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 2.25e-4 | NR | RLN49845.1 | 325452 | g8488 | i0 | 52.3 | 0.619718309859155 | 44 | 21 | 62 | 0 | 212 | 81 | 526 | 569 | RLN49845.1 hypothetical protein BBJ29_004582 [Phytophthora kernoviae] | diamond | 132 | 48.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 28646850 | 28646850 | PRJNA1105232_S_NODE_4467_length_277_cov_3.114035_g4251_i0 | PRJNA1105232 | 4467 | 277 | 3.114035 | 8.62587695 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.09e-39 | NR | GLD96127.1 | 114742 | g4251 | i0 | 87.2 | 1.86281588447653 | 86 | 11 | 93.1 | 0 | 5 | 262 | 428 | 513 | GLD96127.1 hypothetical protein PINS_up004805 [Pythium insidiosum] | diamond | 516 | 147 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 29522061 | 29522061 | PRJNA1105232_S_NODE_4070_length_287_cov_4.957983_g3854_i0 | PRJNA1105232 | 4070 | 287 | 4.957983 | 14.22941121 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 2.98e-4 | NR | XP_009825362.1 | 112090 | g3854 | i0 | 35.5 | 3.8780487804878 | 93 | 56 | 94.1 | 4 | 1 | 270 | 73 | 164 | XP_009825362.1 hypothetical protein H257_03107 [Aphanomyces astaci] | diamond | 1113 | 49.7 | 0.991951710261569 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 29964290 | 29964290 | PRJNA1105232_S_NODE_6671_length_237_cov_1.377660_g6455_i0 | PRJNA1105232 | 6671 | 237 | 1.37766 | 3.2650542 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 3.24e-4 | NR | KAG7388619.1 | 221518 | g6455 | i0 | 37.3 | 3.58227848101266 | 75 | 46 | 93.7 | 1 | 236 | 15 | 2776 | 2850 | KAG7388619.1 hypothetical protein PHYPSEUDO_012110 [Phytophthora pseudosyringae] | diamond | 849 | 48.9 | 0.991820040899796 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora pseudosyringae | ||
| 30162261 | 30162261 | PRJNA1105232_S_NODE_6452_length_240_cov_1.089005_g6236_i0 | PRJNA1105232 | 6452 | 240 | 1.089005 | 2.613612 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00283 | NR | OWZ17616.1 | 4795 | g6236 | i0 | 28.4 | 2.875 | 116 | 46 | 98.8 | 2 | 3 | 239 | 336 | 451 | OWZ17616.1 Ubiquitin-associated/translation elongation factor EF1B [Phytophthora megakarya] | diamond | 690 | 45.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 30762892 | 30762892 | PRJNA1105232_S_NODE_6294_length_242_cov_2.849741_g6078_i0 | PRJNA1105232 | 6294 | 242 | 2.849741 | 6.89637322 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0277 | NR | OQR92289.1 | 74557 | g6078 | i0 | 43.5 | 0.570247933884298 | 46 | 26 | 57 | 0 | 229 | 92 | 1618 | 1663 | OQR92289.1 transmembrane protein [Thraustotheca clavata] | diamond | 138 | 43.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31132963 | 31132963 | PRJNA1105232_S_NODE_16095_length_166_cov_1.213675_g15879_i0 | PRJNA1105232 | 16095 | 166 | 1.213675 | 2.0147005 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 1.32e-13 | NR | KAE8911393.1 | 53985 | g15879 | i0 | 59.3 | 4.86144578313253 | 54 | 22 | 97.6 | 0 | 162 | 1 | 35 | 88 | KAE8911393.1 hypothetical protein PF003_g4481 [Phytophthora fragariae] | diamond | 807 | 71.2 | 0.990168539325843 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 31164543 | 31164543 | PRJNA1105232_S_NODE_11255_length_192_cov_1.335664_g11039_i0 | PRJNA1105232 | 11255 | 192 | 1.335664 | 2.56447488 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 8e-4 | NR | OQS04165.1 | 74557 | g11039 | i0 | 44.2 | 1.53125 | 52 | 24 | 73.4 | 1 | 143 | 3 | 286 | 337 | OQS04165.1 hypothetical protein THRCLA_20950 [Thraustotheca clavata] | diamond | 294 | 47 | 0.991489361702128 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31331581 | 31331581 | PRJNA1105232_S_NODE_16176_length_166_cov_0.880342_g15960_i0 | PRJNA1105232 | 16176 | 166 | 0.880342 | 1.46136772 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 3.31e-5 | NR | GLD96156.1 | 114742 | g15960 | i0 | 48.1 | 2.92771084337349 | 54 | 28 | 97.6 | 0 | 164 | 3 | 435 | 488 | GLD96156.1 hypothetical protein PINS_up004834 [Pythium insidiosum] | diamond | 486 | 50.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32113886 | 32113886 | PRJNA1105232_S_NODE_14578_length_172_cov_1.268293_g14362_i0 | PRJNA1105232 | 14578 | 172 | 1.268293 | 2.18146396 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 7.6e-10 | NR | CCI41261.1 | 65357 | g14362 | i0 | 50.9 | 3.87209302325581 | 55 | 27 | 95.9 | 0 | 169 | 5 | 117 | 171 | CCI41261.1 unnamed protein product [Albugo candida] | diamond | 666 | 63.2 | 0.993670886075949 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 32303926 | 32303926 | PRJNA1105232_S_NODE_5699_length_252_cov_1.241379_g5483_i0 | PRJNA1105232 | 5699 | 252 | 1.241379 | 3.12827508 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 6.7e-12 | NR | XP_012207081.1 | 695850 | g5483 | i0 | 35.8 | 1.95238095238095 | 81 | 51 | 96.4 | 1 | 2 | 244 | 342 | 421 | XP_012207081.1 hypothetical protein SPRG_12331 [Saprolegnia parasitica CBS 223.65] | diamond | 492 | 71.2 | 0.990168539325843 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 32493653 | 32493653 | PRJNA1105232_S_NODE_12559_length_183_cov_2.328358_g12343_i0 | PRJNA1105232 | 12559 | 183 | 2.328358 | 4.26089514 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.00782 | NR | KAG7397295.1 | 109152 | g12343 | i0 | 34.5 | 1.81967213114754 | 58 | 37 | 93.4 | 1 | 3 | 173 | 80 | 137 | KAG7397295.1 ATP synthase subunit delta, mitochondrial [Phytophthora boehmeriae] | diamond | 333 | 43.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 32525465 | 32525465 | PRJNA1105232_S_NODE_2519_length_345_cov_4.057432_g2303_i0 | PRJNA1105232 | 2519 | 345 | 4.057432 | 13.9981404 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 173 | 1.68e-52 | NR | KAF1314619.1 | 82926 | g2303 | i0 | 72.3 | 7.89565217391304 | 112 | 31 | 97.4 | 0 | 338 | 3 | 73 | 184 | KAF1314619.1 Peroxiredoxin-2, partial [Globisporangium splendens] | diamond | 2724 | 173 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 32588479 | 32588479 | PRJNA1105232_S_NODE_9779_length_204_cov_1.341935_g9563_i0 | PRJNA1105232 | 9779 | 204 | 1.341935 | 2.7375474 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 7.49e-7 | NR | KAG3046993.1 | 29920 | g9563 | i0 | 43.5 | 8.11764705882353 | 69 | 36 | 97.1 | 1 | 204 | 7 | 716 | 784 | KAG3046993.1 AP-1 complex subunit gamma-2 [Phytophthora cactorum] | diamond | 1656 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 32840022 | 32840022 | PRJNA1105232_S_NODE_13640_length_177_cov_1.218750_g13424_i0 | PRJNA1105232 | 13640 | 177 | 1.21875 | 2.1571875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.05e-10 | NR | DBA03454.1 | 4803 | g13424 | i0 | 57.1 | 4.74576271186441 | 56 | 24 | 94.9 | 0 | 170 | 3 | 211 | 266 | DBA03454.1 TPA: hypothetical protein N0F65_002862 [Lagenidium giganteum] | diamond | 840 | 65.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum |
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);;