contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1158727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2855429 | 2855429 | PRJNA1158727_P_NODE_16823_length_1231_cov_6.658895_g12415_i0 | PRJNA1158727 | 16823 | 1231 | 6.658895 | 81.97099745 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 577 | 7.6e-204 | NR | TMW60420.1 | 41045 | g12415 | i0 | 72.2 | 4.7229894394801 | 388 | 107 | 94.6 | 1 | 27 | 1190 | 1 | 387 | TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] | diamond | 5814 | 580 | 0.994827586206897 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 6681398 | 6681398 | PRJNA1158727_P_NODE_121186_length_266_cov_1.357513_g113725_i0 | PRJNA1158727 | 121186 | 266 | 1.357513 | 3.6109845800000002 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 5.27e-18 | NR | DBA03690.1 | 4803 | g113725 | i0 | 58 | 9.81203007518797 | 81 | 32 | 89.1 | 1 | 29 | 265 | 228 | 308 | DBA03690.1 TPA: hypothetical protein N0F65_004107 [Lagenidium giganteum] | diamond | 2610 | 87.8 | 0.990888382687927 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 11784612 | 11784612 | PRJNA1158727_P_NODE_61570_length_416_cov_1.903790_g54109_i0 | PRJNA1158727 | 61570 | 416 | 1.90379 | 7.9197664 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.1e-46 | NR | DBA01302.1 | 4803 | g54109 | i0 | 59.4 | 3.76442307692308 | 133 | 48 | 92.3 | 2 | 2 | 385 | 51 | 182 | DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum] | diamond | 1566 | 160 | 0.99375 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 20163970 | 20163970 | PRJNA1158727_P_NODE_163956_length_241_cov_0.916667_g156494_i0 | PRJNA1158727 | 163956 | 241 | 0.916667 | 2.20916747 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 1.09e-11 | NR | RHY92071.1 | 112090 | g156494 | i0 | 86.8 | 2.83817427385892 | 38 | 5 | 47.3 | 0 | 114 | 1 | 58 | 95 | RHY92071.1 hypothetical protein DYB35_003480 [Aphanomyces astaci] | diamond | 684 | 67.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 24529360 | 24529360 | PRJNA1158727_P_NODE_113960_length_274_cov_2.084577_g106499_i0 | PRJNA1158727 | 113960 | 274 | 2.084577 | 5.71174098 | Nothophytophthora sp. Chile5 | 2483409 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 1.7599999999999998e-46 | NR | RLN90219.1 | 2483409 | g106499 | i0 | 87.8 | 15.4270072992701 | 82 | 10 | 89.8 | 0 | 4 | 249 | 121 | 202 | RLN90219.1 hypothetical protein BBJ28_00016662 [Nothophytophthora sp. Chile5] | diamond | 4227 | 157 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. Chile5 | ||
| 26628747 | 26628747 | PRJNA1158727_P_NODE_139841_length_249_cov_1.590909_g132379_i0 | PRJNA1158727 | 139841 | 249 | 1.590909 | 3.96136341 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 1.92e-14 | NR | KAL4169058.1 | 164328 | g132379 | i0 | 50.6 | 2 | 83 | 41 | 100 | 0 | 249 | 1 | 1202 | 1284 | KAL4169058.1 hypothetical protein KRP22_009987 [Phytophthora ramorum] | diamond | 498 | 77.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 26806521 | 26806521 | PRJNA1158727_P_NODE_157861_length_243_cov_0.905882_g150399_i0 | PRJNA1158727 | 157861 | 243 | 0.905882 | 2.20129326 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 3.75e-8 | NR | OWZ20808.1 | 4795 | g150399 | i0 | 59.2 | 3.02469135802469 | 49 | 20 | 60.5 | 0 | 240 | 94 | 316 | 364 | OWZ20808.1 hypothetical protein PHMEG_0004745 [Phytophthora megakarya] | diamond | 735 | 60.1 | 0.993344425956739 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 27388185 | 27388185 | PRJNA1158727_P_NODE_152203_length_245_cov_0.895349_g144741_i0 | PRJNA1158727 | 152203 | 245 | 0.895349 | 2.19360505 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 3.58e-30 | NR | KAH9109352.1 | 100861 | g144741 | i0 | 67.1 | 0.96734693877551 | 79 | 26 | 96.7 | 0 | 3 | 239 | 177 | 255 | KAH9109352.1 hypothetical protein AeMF1_015537 [Aphanomyces euteiches] | diamond | 237 | 119 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27419835 | 27419835 | PRJNA1158727_P_NODE_16683_length_1237_cov_4.377148_g12314_i0 | PRJNA1158727 | 16683 | 1237 | 4.377148 | 54.14532076 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 1.8199999999999994e-153 | NR | GLE01825.1 | 114742 | g12314 | i0 | 59.5 | 11.4882780921584 | 365 | 142 | 88 | 3 | 16 | 1104 | 8 | 368 | GLE01825.1 hypothetical protein PINS_up010663 [Pythium insidiosum] | diamond | 14211 | 448 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 27849230 | 27849230 | PRJNA1158727_P_NODE_147244_length_247_cov_0.885057_g139782_i0 | PRJNA1158727 | 147244 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.88e-23 | NR | DBA05234.1 | 4803 | g139782 | i0 | 57.3 | 32.7570850202429 | 82 | 34 | 98.4 | 1 | 3 | 245 | 1229 | 1310 | DBA05234.1 TPA: hypothetical protein N0F65_007396 [Lagenidium giganteum] | diamond | 8091 | 103 | 0.990291262135922 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28070391 | 28070391 | PRJNA1158727_P_NODE_50345_length_497_cov_2.983491_g42890_i0 | PRJNA1158727 | 50345 | 497 | 2.983491 | 14.82795027 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 6.65e-43 | NR | XP_024573476.1 | 4781 | g42890 | i0 | 64.7 | 8.25150905432596 | 116 | 41 | 70 | 0 | 477 | 130 | 533 | 648 | XP_024573476.1 dead deah box helicase [Plasmopara halstedii] | diamond | 4101 | 162 | 0.993827160493827 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 28208748 | 28208748 | PRJNA1158727_P_NODE_103786_length_287_cov_1.537383_g96325_i0 | PRJNA1158727 | 103786 | 287 | 1.537383 | 4.41228921 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 6.83e-30 | NR | OQR89707.1 | 74557 | g96325 | i0 | 62.9 | 22.9024390243902 | 97 | 34 | 99.3 | 1 | 285 | 1 | 52 | 148 | OQR89707.1 60S acidic ribosomal protein P0, partial [Thraustotheca clavata] | diamond | 6573 | 122 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 28449489 | 28449489 | PRJNA1158727_P_NODE_136126_length_251_cov_0.865169_g128664_i0 | PRJNA1158727 | 136126 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 8.640000000000001e-27 | NR | XP_009830926.1 | 112090 | g128664 | i0 | 65.8 | 6.63346613545817 | 79 | 26 | 94.4 | 1 | 14 | 250 | 6 | 83 | XP_009830926.1 hypothetical protein, variant [Aphanomyces astaci] | diamond | 1665 | 106 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28682754 | 28682754 | PRJNA1158727_P_NODE_42367_length_585_cov_1.996094_g34960_i0 | PRJNA1158727 | 42367 | 585 | 1.996094 | 11.6771499 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 266 | 1.6e-83 | NR | OQS07615.1 | 74557 | g34960 | i0 | 69 | 1.88717948717949 | 184 | 56 | 93.8 | 1 | 584 | 36 | 324 | 507 | OQS07615.1 thioredoxin reductase [Thraustotheca clavata] | diamond | 1104 | 266 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 28871897 | 28871897 | PRJNA1158727_P_NODE_120748_length_266_cov_2.046632_g113287_i0 | PRJNA1158727 | 120748 | 266 | 2.046632 | 5.44404112 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 5.9699999999999996e-24 | NR | DAZ99415.1 | 4803 | g113287 | i0 | 58.6 | 0.981203007518797 | 87 | 36 | 98.1 | 0 | 265 | 5 | 4915 | 5001 | DAZ99415.1 TPA: hypothetical protein N0F65_004048 [Lagenidium giganteum] | diamond | 261 | 105 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28998659 | 28998659 | PRJNA1158727_P_NODE_86548_length_322_cov_1.044177_g79087_i0 | PRJNA1158727 | 86548 | 322 | 1.044177 | 3.36224994 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00562 | NR | XP_012200150.1 | 695850 | g79087 | i0 | 37.9 | 0.885093167701863 | 95 | 51 | 85.7 | 4 | 18 | 293 | 847 | 936 | XP_012200150.1 hypothetical protein SPRG_19925 [Saprolegnia parasitica CBS 223.65] | diamond | 285 | 46.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 29850926 | 29850926 | PRJNA1158727_P_NODE_71811_length_367_cov_1.761905_g64350_i0 | PRJNA1158727 | 71811 | 367 | 1.761905 | 6.46619135 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.28e-36 | NR | CAI5735026.1 | 162125 | g64350 | i0 | 55.3 | 7.01362397820164 | 123 | 51 | 98.1 | 3 | 365 | 6 | 195 | 316 | CAI5735026.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 2574 | 137 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 30925272 | 30925272 | PRJNA1158727_P_NODE_99274_length_294_cov_1.398190_g91813_i0 | PRJNA1158727 | 99274 | 294 | 1.39819 | 4.1106786 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.47e-23 | NR | DAZ93677.1 | 4803 | g91813 | i0 | 57.7 | 4.93877551020408 | 97 | 39 | 96.9 | 2 | 6 | 290 | 225 | 321 | DAZ93677.1 TPA: hypothetical protein N0F65_008185 [Lagenidium giganteum] | diamond | 1452 | 104 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31418480 | 31418480 | PRJNA1158727_P_NODE_160776_length_242_cov_0.911243_g153314_i0 | PRJNA1158727 | 160776 | 242 | 0.911243 | 2.20520806 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 7.11e-29 | NR | OQR82163.1 | 74557 | g153314 | i0 | 73.8 | 8.90082644628099 | 80 | 21 | 99.2 | 0 | 2 | 241 | 507 | 586 | OQR82163.1 hsp70 [Thraustotheca clavata] | diamond | 2154 | 118 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31734663 | 31734663 | PRJNA1158727_P_NODE_142657_length_248_cov_1.457143_g135195_i0 | PRJNA1158727 | 142657 | 248 | 1.457143 | 3.61371464 | root | 1 | Root_unresolved | Root_unresolved | 121 | 2.8199999999999996e-32 | NR | ETO99862.1 | 1317063 | g135195 | i0 | 69.5 | 1.98387096774194 | 82 | 25 | 99.2 | 0 | 247 | 2 | 131 | 212 | ETO99862.1 hypothetical protein F441_22714, partial [Phytophthora nicotianae CJ01A1] | diamond | 492 | 121 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 31968435 | 31968435 | PRJNA1158727_P_NODE_140738_length_249_cov_0.875000_g133276_i0 | PRJNA1158727 | 140738 | 249 | 0.875 | 2.17875 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 3.21e-5 | NR | OQR83813.1 | 1202772 | g133276 | i0 | 55.1 | 0.590361445783133 | 49 | 22 | 59 | 0 | 247 | 101 | 1 | 49 | OQR83813.1 hypothetical protein ACHHYP_14256 [Achlya hypogyna] | diamond | 147 | 48.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 32126925 | 32126925 | PRJNA1158727_P_NODE_159838_length_242_cov_0.911243_g152376_i0 | PRJNA1158727 | 159838 | 242 | 0.911243 | 2.20520806 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.26e-4 | NR | XP_067800973.1 | 4785 | g152376 | i0 | 37.5 | 0.793388429752066 | 64 | 40 | 79.3 | 0 | 203 | 12 | 322 | 385 | XP_067800973.1 Superoxide-generating NADPH oxidase heavy chain subunit A [Phytophthora cinnamomi] | diamond | 192 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 32714884 | 32714884 | PRJNA1158727_P_NODE_103320_length_288_cov_1.195349_g95859_i0 | PRJNA1158727 | 103320 | 288 | 1.195349 | 3.44260512 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 3.2000000000000003e-23 | NR | KAH9103331.1 | 100861 | g95859 | i0 | 52 | 3.9375 | 100 | 34 | 92.7 | 3 | 283 | 17 | 446 | 542 | KAH9103331.1 hypothetical protein AeMF1_020311 [Aphanomyces euteiches] | diamond | 1134 | 104 | 0.990384615384615 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;