contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1120771" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2303874 | 2303874 | PRJNA1120771_S_NODE_26322_length_234_cov_1.821990_g25922_i0 | PRJNA1120771 | 26322 | 234 | 1.82199 | 4.2634566 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 1.2699999999999998e-31 | NR | KAF0738771.1 | 100861 | g25922 | i0 | 70.5 | 16.8846153846154 | 78 | 23 | 100 | 0 | 1 | 234 | 31 | 108 | KAF0738771.1 hypothetical protein Ae201684_005384 [Aphanomyces euteiches] | diamond | 3951 | 117 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18128442 | 18128442 | PRJNA1120771_S_NODE_8275_length_359_cov_10.186709_g7875_i0 | PRJNA1120771 | 8275 | 359 | 10.186709 | 36.57028531 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 7.689999999999999e-30 | NR | RHY34833.1 | 157072 | g7875 | i0 | 69 | 5.00557103064067 | 87 | 26 | 71.9 | 1 | 1 | 258 | 18 | 104 | RHY34833.1 hypothetical protein DYB32_000612 [Aphanomyces invadans] | diamond | 1797 | 118 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 27164774 | 27164774 | PRJNA1120771_S_NODE_4582_length_443_cov_63.240000_g4183_i0 | PRJNA1120771 | 4582 | 443 | 63.24 | 280.1532 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.0199999999999999e-23 | NR | TYZ60440.1 | 1485010 | g4183 | i0 | 49.5 | 0.683972911963883 | 101 | 51 | 68.4 | 0 | 23 | 325 | 176 | 276 | TYZ60440.1 hypothetical protein PybrP1_009390, partial [[Pythium] brassicae (nom. inval.)] | diamond | 303 | 103 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 27185603 | 27185603 | PRJNA1120771_S_NODE_24822_length_240_cov_1.989848_g24422_i0 | PRJNA1120771 | 24822 | 240 | 1.989848 | 4.7756352 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.03e-4 | NR | DAZ95385.1 | 4803 | g24422 | i0 | 61 | 4.6125 | 41 | 15 | 50 | 1 | 239 | 120 | 202 | 242 | DAZ95385.1 TPA: hypothetical protein N0F65_001043 [Lagenidium giganteum] | diamond | 1107 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 27280706 | 27280706 | PRJNA1120771_S_NODE_4403_length_450_cov_10.174447_g4005_i0 | PRJNA1120771 | 4403 | 450 | 10.174447 | 45.7850115 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 1.0699999999999998e-41 | NR | RHY54563.1 | 112090 | g4005 | i0 | 62.4 | 5.67333333333333 | 125 | 43 | 80.7 | 1 | 395 | 33 | 291 | 415 | RHY54563.1 hypothetical protein DYB38_000180 [Aphanomyces astaci] | diamond | 2553 | 153 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 27291418 | 27291418 | PRJNA1120771_S_NODE_28123_length_228_cov_0.940541_g27723_i0 | PRJNA1120771 | 28123 | 228 | 0.940541 | 2.14443348 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 2.37e-8 | NR | OQS06657.1 | 74557 | g27723 | i0 | 70.6 | 1.78947368421053 | 34 | 10 | 44.7 | 0 | 227 | 126 | 1359 | 1392 | OQS06657.1 ATP-binding Cassette (ABC) Superfamily [Thraustotheca clavata] | diamond | 408 | 60.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 27512536 | 27512536 | PRJNA1120771_S_NODE_12303_length_312_cov_5.137546_g11903_i0 | PRJNA1120771 | 12303 | 312 | 5.137546 | 16.02914352 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 2.82e-4 | NR | KUF97777.1 | 4792 | g11903 | i0 | 45.3 | 2.80769230769231 | 64 | 31 | 61.5 | 1 | 39 | 230 | 308 | 367 | KUF97777.1 Armadillo repeat-containing protein 6 [Phytophthora nicotianae] | diamond | 876 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 28175350 | 28175350 | PRJNA1120771_S_NODE_22106_length_251_cov_3.721154_g21706_i0 | PRJNA1120771 | 22106 | 251 | 3.721154 | 9.34009654 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0419 | NR | KAF0688416.1 | 120398 | g21706 | i0 | 38.9 | 0.645418326693227 | 54 | 30 | 64.5 | 1 | 68 | 229 | 259 | 309 | KAF0688416.1 hypothetical protein As57867_019906 [Aphanomyces stellatus] | diamond | 162 | 42.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 28301790 | 28301790 | PRJNA1120771_S_NODE_25526_length_237_cov_2.953608_g25126_i0 | PRJNA1120771 | 25526 | 237 | 2.953608 | 7.00005096 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 6.39e-19 | NR | KAJ0410394.1 | 114742 | g25126 | i0 | 64.3 | 2.65822784810127 | 70 | 24 | 88.6 | 1 | 211 | 2 | 84 | 152 | KAJ0410394.1 hypothetical protein P43SY_002726 [Pythium insidiosum] | diamond | 630 | 85.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 29248936 | 29248936 | PRJNA1120771_S_NODE_7369_length_374_cov_2.628399_g6969_i0 | PRJNA1120771 | 7369 | 374 | 2.628399 | 9.83021226 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 9.01e-12 | NR | XP_024575058.1 | 4781 | g6969 | i0 | 70.2 | 4.52406417112299 | 47 | 14 | 37.7 | 0 | 3 | 143 | 96 | 142 | XP_024575058.1 60s ribosomal protein l32-1-like [Plasmopara halstedii] | diamond | 1692 | 68.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 29375317 | 29375317 | PRJNA1120771_S_NODE_20469_length_259_cov_1.175926_g20069_i0 | PRJNA1120771 | 20469 | 259 | 1.175926 | 3.04564834 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 3.48e-17 | NR | OQR83732.1 | 1202772 | g20069 | i0 | 52.9 | 7.88803088803089 | 85 | 40 | 98.5 | 0 | 3 | 257 | 309 | 393 | OQR83732.1 phosphatidylserine decarboxylase [Achlya hypogyna] | diamond | 2043 | 85.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 29596030 | 29596030 | PRJNA1120771_S_NODE_36250_length_203_cov_3.287500_g35850_i0 | PRJNA1120771 | 36250 | 203 | 3.2875 | 6.673625 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 1.52e-8 | NR | TMW68322.1 | 41045 | g35850 | i0 | 45 | 0.886699507389163 | 60 | 31 | 88.7 | 1 | 201 | 22 | 276 | 333 | TMW68322.1 hypothetical protein Poli38472_005790 [Pythium oligandrum] | diamond | 180 | 60.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29754081 | 29754081 | PRJNA1120771_S_NODE_5211_length_424_cov_1.950131_g4811_i0 | PRJNA1120771 | 5211 | 424 | 1.950131 | 8.26855544 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 2.09e-7 | NR | RQM19845.1 | 112090 | g4811 | i0 | 48.7 | 1.07547169811321 | 76 | 36 | 53.8 | 2 | 27 | 254 | 167 | 239 | RQM19845.1 hypothetical protein B5M09_000630 [Aphanomyces astaci] | diamond | 456 | 59.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 29869817 | 29869817 | PRJNA1120771_S_NODE_19431_length_264_cov_1.968326_g19031_i0 | PRJNA1120771 | 19431 | 264 | 1.968326 | 5.19638064 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.12e-33 | NR | OQR94235.1 | 74557 | g19031 | i0 | 76.7 | 4.14772727272727 | 73 | 17 | 83 | 0 | 2 | 220 | 278 | 350 | OQR94235.1 2-oxoisovalerate dehydrogenase subunit beta, mitochondrial precursor [Thraustotheca clavata] | diamond | 1095 | 127 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 30007060 | 30007060 | PRJNA1120771_S_NODE_26611_length_233_cov_1.368421_g26211_i0 | PRJNA1120771 | 26611 | 233 | 1.368421 | 3.18842093 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 3.92e-8 | NR | GLD91582.1 | 114742 | g26211 | i0 | 48.6 | 2.78111587982833 | 72 | 29 | 92.7 | 3 | 18 | 233 | 81 | 144 | GLD91582.1 hypothetical protein PINS_up000115 [Pythium insidiosum] | diamond | 648 | 57.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30122426 | 30122426 | PRJNA1120771_S_NODE_30112_length_221_cov_4.398876_g29712_i0 | PRJNA1120771 | 30112 | 221 | 4.398876 | 9.72151596 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 4.82e-26 | NR | KAJ8571710.1 | 4785 | g29712 | i0 | 72.3 | 9.76018099547511 | 65 | 18 | 88.2 | 0 | 10 | 204 | 535 | 599 | KAJ8571710.1 hypothetical protein ON010_g5124 [Phytophthora cinnamomi] | diamond | 2157 | 110 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30185657 | 30185657 | PRJNA1120771_S_NODE_26052_length_235_cov_1.786458_g25652_i0 | PRJNA1120771 | 26052 | 235 | 1.786458 | 4.1981763 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 1.47e-16 | NR | RAW27721.1 | 29920 | g25652 | i0 | 52.6 | 5.08085106382979 | 78 | 30 | 90.6 | 1 | 2 | 214 | 153 | 230 | RAW27721.1 40S ribosomal protein [Phytophthora cactorum] | diamond | 1194 | 81.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 31207074 | 31207074 | PRJNA1120771_S_NODE_4035_length_465_cov_12.066351_g3641_i0 | PRJNA1120771 | 4035 | 465 | 12.066351 | 56.10853215 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 3.12e-7 | NR | CCI49071.1 | 65357 | g3641 | i0 | 36.9 | 0.664516129032258 | 103 | 62 | 65.2 | 2 | 441 | 139 | 295 | 396 | CCI49071.1 unnamed protein product [Albugo candida] | diamond | 309 | 60.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 31323210 | 31323210 | PRJNA1120771_S_NODE_7695_length_368_cov_3.353846_g7295_i0 | PRJNA1120771 | 7695 | 368 | 3.353846 | 12.34215328 | root | 1 | Root_unresolved | Root_unresolved | 157 | 1.73e-44 | NR | OQS04471.1 | 74557 | g7295 | i0 | 67 | 8.1929347826087 | 112 | 36 | 90.5 | 1 | 368 | 36 | 200 | 311 | OQS04471.1 nuclear migration protein nudC [Thraustotheca clavata] | diamond | 3015 | 157 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31681756 | 31681756 | PRJNA1120771_S_NODE_13957_length_298_cov_2.376471_g13557_i0 | PRJNA1120771 | 13957 | 298 | 2.376471 | 7.08188358 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 4.27e-17 | NR | GLD97402.1 | 114742 | g13557 | i0 | 51.3 | 1.67114093959732 | 80 | 38 | 80.5 | 1 | 1 | 240 | 217 | 295 | GLD97402.1 hypothetical protein PINS_up006086 [Pythium insidiosum] | diamond | 498 | 84.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31871690 | 31871690 | PRJNA1120771_S_NODE_18857_length_267_cov_2.196429_g18457_i0 | PRJNA1120771 | 18857 | 267 | 2.196429 | 5.86446543 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.21e-4 | NR | XP_008874127.1 | 157072 | g18457 | i0 | 72.4 | 0.325842696629214 | 29 | 8 | 32.6 | 0 | 256 | 170 | 153 | 181 | XP_008874127.1 ADP-ribosylation factor 1 [Aphanomyces invadans] | diamond | 87 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 32125077 | 32125077 | PRJNA1120771_S_NODE_9918_length_336_cov_11.959044_g9518_i0 | PRJNA1120771 | 9918 | 336 | 11.959044 | 40.18238784 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.2e-31 | NR | KAL0589997.1 | 65357 | g9518 | i0 | 60.8 | 4.3125 | 97 | 38 | 86.6 | 0 | 335 | 45 | 1140 | 1236 | KAL0589997.1 hypothetical protein ABG067_001964 [Albugo candida] | diamond | 1449 | 127 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 32367437 | 32367437 | PRJNA1120771_S_NODE_32379_length_215_cov_1.517442_g31979_i0 | PRJNA1120771 | 32379 | 215 | 1.517442 | 3.2625003 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.41e-23 | NR | KAG1704188.1 | 4784 | g31979 | i0 | 70.4 | 11.9720930232558 | 71 | 19 | 96.3 | 1 | 213 | 7 | 248 | 318 | KAG1704188.1 hypothetical protein DVH05_006198 [Phytophthora capsici] | diamond | 2574 | 101 | 0.99009900990099 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 32473133 | 32473133 | PRJNA1120771_S_NODE_11099_length_324_cov_1.772242_g10699_i0 | PRJNA1120771 | 11099 | 324 | 1.772242 | 5.74206408 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 7.53e-15 | NR | TMW62145.1 | 41045 | g10699 | i0 | 40.4 | 1.00925925925926 | 109 | 55 | 91.7 | 1 | 16 | 312 | 227 | 335 | TMW62145.1 hypothetical protein Poli38472_009638 [Pythium oligandrum] | diamond | 327 | 79.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum |
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);;