contig_metadata
21 rows where bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5386809 | 5386809 | PRJNA1132896_P_NODE_2245_length_364_cov_1.034364_g2154_i0 | PRJNA1132896 | 2245 | 364 | 1.034364 | 3.76508496 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1e-27 | NR | KAI9907769.1 | 230839 | g2154 | i0 | 72.4 | 1.92857142857143 | 76 | 21 | 62.6 | 0 | 132 | 359 | 23 | 98 | KAI9907769.1 hypothetical protein PsorP6_003339 [Peronosclerospora sorghi] | diamond | 702 | 109 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 7936705 | 7936705 | PRJNA1132896_P_NODE_8627_length_246_cov_0.890173_g8536_i0 | PRJNA1132896 | 8627 | 246 | 0.890173 | 2.18982558 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.8199999999999993e-46 | NR | KAJ0409334.1 | 114742 | g8536 | i0 | 92.7 | 135 | 82 | 6 | 100 | 0 | 1 | 246 | 743 | 824 | KAJ0409334.1 hypothetical protein ATCC90586_000571 [Pythium insidiosum] | diamond | 33210 | 169 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 16334182 | 16334182 | PRJNA1132896_P_NODE_4393_length_283_cov_1.833333_g4302_i0 | PRJNA1132896 | 4393 | 283 | 1.833333 | 5.18833239 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 1.97e-18 | NR | GMF48105.1 | 1490495 | g4302 | i0 | 62.9 | 0.657243816254417 | 62 | 21 | 65.7 | 1 | 96 | 281 | 9 | 68 | GMF48105.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 186 | 88.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia | ||
| 16860833 | 16860833 | PRJNA1132896_P_NODE_6114_length_259_cov_1.419355_g6023_i0 | PRJNA1132896 | 6114 | 259 | 1.419355 | 3.67612945 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 4.52e-43 | NR | KAF0727766.1 | 100861 | g6023 | i0 | 85.2 | 6.62548262548263 | 81 | 12 | 93.8 | 0 | 250 | 8 | 1 | 81 | KAF0727766.1 hypothetical protein Ae201684_014280 [Aphanomyces euteiches] | diamond | 1716 | 147 | 0.993197278911565 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20158171 | 20158171 | PRJNA1132896_P_NODE_3716_length_295_cov_2.081081_g3625_i0 | PRJNA1132896 | 3716 | 295 | 2.081081 | 6.13918895 | root | 1 | Root_unresolved | Root_unresolved | 164 | 1.41e-44 | NR | XP_008610586.1 | 1156394 | g3625 | i0 | 79.4 | 11.8271186440678 | 97 | 20 | 98.6 | 0 | 293 | 3 | 4 | 100 | XP_008610586.1 hypothetical protein SDRG_06578 [Saprolegnia diclina VS20] | diamond | 3489 | 164 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 21960438 | 21960438 | PRJNA1132896_P_NODE_7098_length_250_cov_0.870056_g7007_i0 | PRJNA1132896 | 7098 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 91.3 | 2.61e-21 | NR | CAI5712365.1 | 162125 | g7007 | i0 | 54.8 | 16.704 | 73 | 32 | 87.6 | 1 | 32 | 250 | 5 | 76 | CAI5712365.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 4176 | 91.7 | 0.995637949836423 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 27122303 | 27122303 | PRJNA1132896_P_NODE_3362_length_308_cov_1.336170_g3271_i0 | PRJNA1132896 | 3362 | 308 | 1.33617 | 4.1154036 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.79e-28 | NR | TMW61584.1 | 41045 | g3271 | i0 | 59.4 | 6.6525974025974 | 96 | 38 | 92.5 | 1 | 299 | 15 | 3 | 98 | TMW61584.1 hypothetical protein Poli38472_012775 [Pythium oligandrum] | diamond | 2049 | 111 | 0.990990990990991 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27691598 | 27691598 | PRJNA1132896_P_NODE_3204_length_314_cov_1.834025_g3113_i0 | PRJNA1132896 | 3204 | 314 | 1.834025 | 5.7588385 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 9.64e-4 | NR | XP_024579005.1 | 4781 | g3113 | i0 | 34.1 | 2.52229299363057 | 85 | 54 | 79.3 | 1 | 3 | 251 | 64 | 148 | XP_024579005.1 amp-binding protein [Plasmopara halstedii] | diamond | 792 | 48.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 27891449 | 27891449 | PRJNA1132896_P_NODE_1165_length_482_cov_1.217604_g1074_i0 | PRJNA1132896 | 1165 | 482 | 1.217604 | 5.86885128 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 273 | 2.819999999999999e-87 | NR | CAI5721072.1 | 162125 | g1074 | i0 | 80.6 | 3.97717842323651 | 160 | 30 | 99.6 | 1 | 481 | 2 | 75 | 233 | CAI5721072.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 1917 | 273 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 28954455 | 28954455 | PRJNA1132896_P_NODE_9228_length_244_cov_0.900585_g9137_i0 | PRJNA1132896 | 9228 | 244 | 0.900585 | 2.1974274 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00811 | NR | XP_067817214.1 | 4779 | g9137 | i0 | 34.8 | 3.41803278688525 | 69 | 37 | 77.5 | 2 | 210 | 22 | 28 | 94 | XP_067817214.1 hypothetical protein CCR75_001961 [Bremia lactucae] | diamond | 834 | 44.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 29154835 | 29154835 | PRJNA1132896_P_NODE_8969_length_245_cov_0.883721_g8878_i0 | PRJNA1132896 | 8969 | 245 | 0.883721 | 2.16511645 | Phytophthora nicotianae P1569 | 1317065 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00605 | NR | ETI35468.1 | 1317065 | g8878 | i0 | 37 | 0.661224489795918 | 54 | 30 | 66.1 | 1 | 22 | 183 | 2684 | 2733 | ETI35468.1 hypothetical protein F443_18193 [Phytophthora nicotianae P1569] | diamond | 162 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 30007329 | 30007329 | PRJNA1132896_P_NODE_6951_length_251_cov_0.865169_g6860_i0 | PRJNA1132896 | 6951 | 251 | 0.865169 | 2.17157419 | Nothophytophthora sp. Chile5 | 2483409 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 1.52e-20 | NR | RLN92073.1 | 2483409 | g6860 | i0 | 51.3 | 2.7609561752988 | 80 | 30 | 84.9 | 1 | 246 | 34 | 310 | 389 | RLN92073.1 hypothetical protein BBJ28_00021708 [Nothophytophthora sp. Chile5] | diamond | 693 | 95.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. Chile5 | ||
| 30691242 | 30691242 | PRJNA1132896_P_NODE_10273_length_241_cov_0.916667_g10182_i0 | PRJNA1132896 | 10273 | 241 | 0.916667 | 2.20916747 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 8.32e-31 | NR | CCI41595.1 | 65357 | g10182 | i0 | 72.2 | 11.5269709543568 | 79 | 22 | 98.3 | 0 | 239 | 3 | 136 | 214 | CCI41595.1 unnamed protein product [Albugo candida] | diamond | 2778 | 123 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 30955237 | 30955237 | PRJNA1132896_P_NODE_5094_length_273_cov_1.850000_g5003_i0 | PRJNA1132896 | 5094 | 273 | 1.85 | 5.0505 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 2.7e-12 | NR | XP_008619044.1 | 1156394 | g5003 | i0 | 41 | 1.7032967032967 | 78 | 46 | 85.7 | 0 | 241 | 8 | 768 | 845 | XP_008619044.1 hypothetical protein SDRG_14673 [Saprolegnia diclina VS20] | diamond | 465 | 72 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 31682002 | 31682002 | PRJNA1132896_P_NODE_537_length_706_cov_3.529226_g448_i0 | PRJNA1132896 | 537 | 706 | 3.529226 | 24.91633556 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 6.5599999999999986e-40 | NR | KAI9916449.1 | 230839 | g448 | i0 | 58.6 | 4.48725212464589 | 128 | 53 | 54.4 | 0 | 392 | 9 | 8 | 135 | KAI9916449.1 hypothetical protein PsorP6_017147 [Peronosclerospora sorghi] | diamond | 3168 | 154 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 31871917 | 31871917 | PRJNA1132896_P_NODE_4277_length_285_cov_1.334906_g4186_i0 | PRJNA1132896 | 4277 | 285 | 1.334906 | 3.8044821 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 8.2e-7 | NR | CAH0514662.1 | 622444 | g4186 | i0 | 47.4 | 1.02105263157895 | 57 | 28 | 60 | 1 | 285 | 115 | 199 | 253 | CAH0514662.1 unnamed protein product [Peronospora belbahrii] | diamond | 291 | 56.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 31892697 | 31892697 | PRJNA1132896_P_NODE_6077_length_259_cov_3.059140_g5986_i0 | PRJNA1132896 | 6077 | 259 | 3.05914 | 7.9231726 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0335 | NR | KAG1694300.1 | 4784 | g5986 | i0 | 41.7 | 4.54054054054054 | 60 | 32 | 66 | 1 | 87 | 257 | 1395 | 1454 | KAG1694300.1 hypothetical protein DVH05_021652 [Phytophthora capsici] | diamond | 1176 | 43.5 | 0.990804597701149 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 32050897 | 32050897 | PRJNA1132896_P_NODE_7838_length_248_cov_0.880000_g7747_i0 | PRJNA1132896 | 7838 | 248 | 0.88 | 2.1824 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 4.08e-33 | NR | DAZ94775.1 | 4803 | g7747 | i0 | 72 | 10.9112903225806 | 82 | 23 | 99.2 | 0 | 3 | 248 | 34 | 115 | DAZ94775.1 TPA: hypothetical protein N0F65_012355 [Lagenidium giganteum] | diamond | 2706 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32272601 | 32272601 | PRJNA1132896_P_NODE_4538_length_281_cov_2.028846_g4447_i0 | PRJNA1132896 | 4538 | 281 | 2.028846 | 5.70105726 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 9.69e-24 | NR | KAI9989638.1 | 4787 | g4447 | i0 | 60.2 | 14.2526690391459 | 83 | 33 | 88.6 | 0 | 252 | 4 | 86 | 168 | KAI9989638.1 hypothetical protein PInf_019923 [Phytophthora infestans] | diamond | 4005 | 102 | 0.990196078431373 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 32409987 | 32409987 | PRJNA1132896_P_NODE_6219_length_257_cov_2.119565_g6128_i0 | PRJNA1132896 | 6219 | 257 | 2.119565 | 5.44728205 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 2.22e-40 | NR | KAF0745081.1 | 100861 | g6128 | i0 | 75 | 4.93774319066148 | 84 | 21 | 98.1 | 0 | 257 | 6 | 156 | 239 | KAF0745081.1 hypothetical protein Ae201684_000654 [Aphanomyces euteiches] | diamond | 1269 | 144 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32630851 | 32630851 | PRJNA1132896_P_NODE_3440_length_305_cov_1.327586_g3349_i0 | PRJNA1132896 | 3440 | 305 | 1.327586 | 4.0491373 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 4.28e-44 | NR | KAG9404282.1 | 112091 | g3349 | i0 | 74 | 5.9016393442623 | 100 | 26 | 98.4 | 0 | 3 | 302 | 222 | 321 | KAG9404282.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Aphanomyces cochlioides] | diamond | 1800 | 155 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides |
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);;