contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA934332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2185947 | 2185947 | PRJNA934332_P_NODE_4002_length_327_cov_0.976378_g3915_i0 | PRJNA934332 | 4002 | 327 | 0.976378 | 3.19275606 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 2.22e-50 | NR | TMW62875.1 | 41045 | g3915 | i0 | 74.1 | 12.8532110091743 | 108 | 28 | 99.1 | 0 | 4 | 327 | 3 | 110 | TMW62875.1 hypothetical protein Poli38472_005493 [Pythium oligandrum] | diamond | 4203 | 166 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 13664259 | 13664259 | PRJNA934332_P_NODE_9611_length_246_cov_0.867052_g9524_i0 | PRJNA934332 | 9611 | 246 | 0.867052 | 2.13294792 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 1.94e-14 | NR | KAG9399474.1 | 112091 | g9524 | i0 | 79.1 | 1.08536585365854 | 43 | 8 | 52.4 | 1 | 245 | 117 | 52 | 93 | KAG9399474.1 60S ribosomal protein L18A [Aphanomyces cochlioides] | diamond | 267 | 73.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 14938503 | 14938503 | PRJNA934332_P_NODE_2232_length_414_cov_1.193548_g2145_i0 | PRJNA934332 | 2232 | 414 | 1.193548 | 4.94128872 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 1.48e-50 | NR | TMW61715.1 | 41045 | g2145 | i0 | 58 | 8.96376811594203 | 138 | 56 | 99.3 | 2 | 412 | 2 | 29 | 165 | TMW61715.1 hypothetical protein Poli38472_010778 [Pythium oligandrum] | diamond | 3711 | 174 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 18762292 | 18762292 | PRJNA934332_P_NODE_4515_length_310_cov_2.379747_g4428_i0 | PRJNA934332 | 4515 | 310 | 2.379747 | 7.3772157 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.1999999999999999e-41 | NR | RHY63942.1 | 112090 | g4428 | i0 | 74.5 | 76.8483870967742 | 106 | 24 | 99.7 | 2 | 310 | 2 | 356 | 461 | RHY63942.1 hypothetical protein DYB30_004637 [Aphanomyces astaci] | diamond | 23823 | 157 | 0.993630573248408 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21312661 | 21312661 | PRJNA934332_P_NODE_1377_length_517_cov_1.270270_g1292_i0 | PRJNA934332 | 1377 | 517 | 1.27027 | 6.5672959 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 162 | 3.44e-46 | NR | KAL0584308.1 | 65357 | g1292 | i0 | 62 | 5.58220502901354 | 137 | 51 | 79.5 | 1 | 2 | 412 | 126 | 261 | KAL0584308.1 hypothetical protein ABG067_005809 [Albugo candida] | diamond | 2886 | 162 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 21312673 | 21312673 | PRJNA934332_P_NODE_3217_length_355_cov_2.528369_g3130_i0 | PRJNA934332 | 3217 | 355 | 2.528369 | 8.97570995 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.86e-38 | NR | KAF0738261.1 | 100861 | g3130 | i0 | 64.1 | 3.93802816901408 | 117 | 40 | 98.9 | 1 | 353 | 3 | 246 | 360 | KAF0738261.1 hypothetical protein Ae201684_005821 [Aphanomyces euteiches] | diamond | 1398 | 143 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 25136763 | 25136763 | PRJNA934332_P_NODE_2780_length_378_cov_2.019672_g2693_i0 | PRJNA934332 | 2780 | 378 | 2.019672 | 7.63436016 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 7.319999999999999e-31 | NR | KAE8911393.1 | 53985 | g2693 | i0 | 55.2 | 1.66666666666667 | 105 | 41 | 78.6 | 2 | 370 | 74 | 13 | 117 | KAE8911393.1 hypothetical protein PF003_g4481 [Phytophthora fragariae] | diamond | 630 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 26866969 | 26866969 | PRJNA934332_P_NODE_6281_length_272_cov_1.547739_g6194_i0 | PRJNA934332 | 6281 | 272 | 1.547739 | 4.20985008 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 2.51e-4 | NR | XP_067818293.1 | 4779 | g6194 | i0 | 37 | 1.61029411764706 | 73 | 45 | 80.5 | 1 | 230 | 12 | 335 | 406 | XP_067818293.1 hypothetical protein CCR75_005396 [Bremia lactucae] | diamond | 438 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 26898506 | 26898506 | PRJNA934332_P_NODE_5981_length_277_cov_1.509804_g5894_i0 | PRJNA934332 | 5981 | 277 | 1.509804 | 4.18215708 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.32e-7 | NR | XP_008873528.1 | 157072 | g5894 | i0 | 37.3 | 4.93862815884477 | 102 | 46 | 97.5 | 4 | 272 | 3 | 225 | 320 | XP_008873528.1 hypothetical protein H310_09274 [Aphanomyces invadans] | diamond | 1368 | 58.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 27214436 | 27214436 | PRJNA934332_P_NODE_10162_length_244_cov_0.900585_g10075_i0 | PRJNA934332 | 10162 | 244 | 0.900585 | 2.1974274 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00786 | NR | KAJ0404173.1 | 114742 | g10075 | i0 | 35.7 | 2.63114754098361 | 70 | 40 | 81.1 | 2 | 242 | 45 | 354 | 422 | KAJ0404173.1 hypothetical protein ATCC90586_008624 [Pythium insidiosum] | diamond | 642 | 44.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 27404374 | 27404374 | PRJNA934332_P_NODE_4283_length_318_cov_0.942857_g4196_i0 | PRJNA934332 | 4283 | 318 | 0.942857 | 2.99828526 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0236 | NR | OWZ13888.1 | 4795 | g4196 | i0 | 28 | 0.707547169811321 | 75 | 54 | 70.8 | 0 | 91 | 315 | 3 | 77 | OWZ13888.1 hypothetical protein PHMEG_00012714 [Phytophthora megakarya] | diamond | 225 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 27909132 | 27909132 | PRJNA934332_P_NODE_11445_length_236_cov_2.552147_g11358_i0 | PRJNA934332 | 11445 | 236 | 2.552147 | 6.02306692 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 1.05e-16 | NR | DAZ95244.1 | 4803 | g11358 | i0 | 48.1 | 0.978813559322034 | 77 | 40 | 97.9 | 0 | 232 | 2 | 584 | 660 | DAZ95244.1 TPA: hypothetical protein N0F65_002356 [Lagenidium giganteum] | diamond | 231 | 84 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 27909135 | 27909135 | PRJNA934332_P_NODE_9565_length_246_cov_0.890173_g9478_i0 | PRJNA934332 | 9565 | 246 | 0.890173 | 2.18982558 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 4.5e-14 | NR | TYZ61732.1 | 1485010 | g9478 | i0 | 55.6 | 0.98780487804878 | 81 | 35 | 98.8 | 1 | 245 | 3 | 867 | 946 | TYZ61732.1 hypothetical protein PybrP1_012406 [[Pythium] brassicae (nom. inval.)] | diamond | 243 | 76.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 28035803 | 28035803 | PRJNA934332_P_NODE_4225_length_319_cov_2.609756_g4138_i0 | PRJNA934332 | 4225 | 319 | 2.609756 | 8.32512164 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 3.5e-52 | NR | OQR91137.1 | 74557 | g4138 | i0 | 79.2 | 2.99059561128527 | 106 | 22 | 99.7 | 0 | 2 | 319 | 2 | 107 | OQR91137.1 60S ribosomal protein L3 [Thraustotheca clavata] | diamond | 954 | 178 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 28824789 | 28824789 | PRJNA934332_P_NODE_1948_length_438_cov_1.789041_g1861_i0 | PRJNA934332 | 1948 | 438 | 1.789041 | 7.83599958 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.39e-22 | NR | OQR80584.1 | 1202772 | g1861 | i0 | 43.4 | 2.08904109589041 | 152 | 74 | 98.6 | 3 | 5 | 436 | 656 | 803 | OQR80584.1 ATP-binding Cassette (ABC) Superfamily [Achlya hypogyna] | diamond | 915 | 102 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 29519643 | 29519643 | PRJNA934332_P_NODE_9470_length_246_cov_0.890173_g9383_i0 | PRJNA934332 | 9470 | 246 | 0.890173 | 2.18982558 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.54e-9 | NR | KAH9099005.1 | 100861 | g9383 | i0 | 47.6 | 1 | 82 | 39 | 100 | 2 | 1 | 246 | 342 | 419 | KAH9099005.1 hypothetical protein LEN26_016428, partial [Aphanomyces euteiches] | diamond | 246 | 63.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30411498 | 30411498 | PRJNA934332_P_NODE_6633_length_266_cov_1.595855_g6546_i0 | PRJNA934332 | 6633 | 266 | 1.595855 | 4.2449743 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 3.02e-33 | NR | RHY39674.1 | 112090 | g6546 | i0 | 71.6 | 12.9022556390977 | 88 | 25 | 99.2 | 0 | 266 | 3 | 96 | 183 | RHY39674.1 hypothetical protein DYB34_013934 [Aphanomyces astaci] | diamond | 3432 | 125 | 0.992 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30436011 | 30436011 | PRJNA934332_P_NODE_5253_length_290_cov_1.364055_g5166_i0 | PRJNA934332 | 5253 | 290 | 1.364055 | 3.9557595 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.56e-28 | NR | KAJ8578052.1 | 4785 | g5166 | i0 | 59.6 | 3.63103448275862 | 89 | 35 | 91 | 1 | 265 | 2 | 116 | 204 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 1053 | 113 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30467640 | 30467640 | PRJNA934332_P_NODE_8373_length_249_cov_0.875000_g8286_i0 | PRJNA934332 | 8373 | 249 | 0.875 | 2.17875 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 1.08e-13 | NR | OQR85592.1 | 1202772 | g8286 | i0 | 55.8 | 0.626506024096386 | 52 | 23 | 62.7 | 0 | 2 | 157 | 144 | 195 | OQR85592.1 WD domain-containing protein [Achlya hypogyna] | diamond | 156 | 75.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 31422426 | 31422426 | PRJNA934332_P_NODE_5876_length_279_cov_1.495146_g5789_i0 | PRJNA934332 | 5876 | 279 | 1.495146 | 4.17145734 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 1.83e-30 | NR | XP_067789141.1 | 4785 | g5789 | i0 | 62.4 | 2.74193548387097 | 85 | 31 | 90.3 | 1 | 26 | 277 | 1 | 85 | XP_067789141.1 40S ribosomal protein S10 [Phytophthora cinnamomi] | diamond | 765 | 114 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 31454207 | 31454207 | PRJNA934332_P_NODE_8556_length_248_cov_0.880000_g8469_i0 | PRJNA934332 | 8556 | 248 | 0.88 | 2.1824 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 4.44e-19 | NR | KAH9122749.1 | 100861 | g8469 | i0 | 65.7 | 3.42338709677419 | 67 | 23 | 81 | 0 | 48 | 248 | 358 | 424 | KAH9122749.1 hypothetical protein LEN26_010131 [Aphanomyces euteiches] | diamond | 849 | 90.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 31485911 | 31485911 | PRJNA934332_P_NODE_6276_length_272_cov_2.005025_g6189_i0 | PRJNA934332 | 6276 | 272 | 2.005025 | 5.453668 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 2.59e-33 | NR | KAJ0401890.1 | 114742 | g6189 | i0 | 69 | 26.8676470588235 | 87 | 27 | 96 | 0 | 261 | 1 | 1 | 87 | KAJ0401890.1 hypothetical protein ATCC90586_009012 [Pythium insidiosum] | diamond | 7308 | 132 | 0.992424242424242 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31542034 | 31542034 | PRJNA934332_P_NODE_5176_length_292_cov_1.054795_g5089_i0 | PRJNA934332 | 5176 | 292 | 1.054795 | 3.0800014 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 5.68e-17 | NR | TYZ62966.1 | 1485010 | g5089 | i0 | 48.9 | 3.84246575342466 | 92 | 46 | 94.5 | 1 | 287 | 12 | 189 | 279 | TYZ62966.1 hypothetical protein PybrP1_008104 [[Pythium] brassicae (nom. inval.)] | diamond | 1122 | 84.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 32111382 | 32111382 | PRJNA934332_P_NODE_1298_length_529_cov_1.105263_g1213_i0 | PRJNA934332 | 1298 | 529 | 1.105263 | 5.84684127 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 234 | 6.1e-68 | NR | KAF0715748.1 | 120398 | g1213 | i0 | 68.2 | 18.3345935727788 | 173 | 55 | 98.1 | 0 | 520 | 2 | 733 | 905 | KAF0715748.1 hypothetical protein As57867_003200 [Aphanomyces stellatus] | diamond | 9699 | 234 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 32750306 | 32750306 | PRJNA934332_P_NODE_9740_length_245_cov_0.895349_g9653_i0 | PRJNA934332 | 9740 | 245 | 0.895349 | 2.19360505 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00603 | NR | KAG1699540.1 | 4784 | g9653 | i0 | 61.5 | 4.54285714285714 | 26 | 10 | 31.8 | 0 | 3 | 80 | 1753 | 1778 | KAG1699540.1 hypothetical protein DVH05_012950 [Phytophthora capsici] | diamond | 1113 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici |
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);;