contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA950981" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2209163 | 2209163 | PRJNA950981_P_NODE_19782_length_246_cov_0.901734_g19606_i0 | PRJNA950981 | 19782 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 1.18e-13 | NR | OQR82037.1 | 74557 | g19606 | i0 | 53.3 | 4.39024390243902 | 60 | 28 | 73.2 | 0 | 67 | 246 | 18 | 77 | OQR82037.1 leucyl-tRNA synthetase, cytoplasmic [Thraustotheca clavata] | diamond | 1080 | 75.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 21664782 | 21664782 | PRJNA950981_P_NODE_13937_length_276_cov_1.408867_g13761_i0 | PRJNA950981 | 13937 | 276 | 1.408867 | 3.88847292 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 4.009999999999999e-32 | NR | KAG1683926.1 | 4784 | g13761 | i0 | 66.3 | 27.9782608695652 | 89 | 30 | 96.7 | 0 | 276 | 10 | 418 | 506 | KAG1683926.1 hypothetical protein DVH05_012501 [Phytophthora capsici] | diamond | 7722 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 27380032 | 27380032 | PRJNA950981_P_NODE_13463_length_281_cov_1.125000_g13287_i0 | PRJNA950981 | 13463 | 281 | 1.125 | 3.16125 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 1.21e-47 | NR | POM64608.1 | 4796 | g13287 | i0 | 84.8 | 14.7330960854093 | 92 | 14 | 98.2 | 0 | 3 | 278 | 25 | 116 | POM64608.1 Cell differentiation protein rcd1 [Phytophthora palmivora] | diamond | 4140 | 161 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 27531087 | 27531087 | PRJNA950981_P_NODE_21543_length_242_cov_0.923077_g21367_i0 | PRJNA950981 | 21543 | 242 | 0.923077 | 2.23384634 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 9.46e-13 | NR | DAZ98753.1 | 4803 | g21367 | i0 | 52.8 | 1.92148760330579 | 72 | 33 | 89.3 | 1 | 25 | 240 | 4 | 74 | DAZ98753.1 TPA: hypothetical protein N0F65_003809 [Lagenidium giganteum] | diamond | 465 | 72.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 27594395 | 27594395 | PRJNA950981_P_NODE_19384_length_247_cov_0.896552_g19208_i0 | PRJNA950981 | 19384 | 247 | 0.896552 | 2.21448344 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.4e-28 | NR | KAF0688604.1 | 120398 | g19208 | i0 | 64.2 | 0.983805668016194 | 81 | 29 | 98.4 | 0 | 245 | 3 | 244 | 324 | KAF0688604.1 hypothetical protein As57867_019712 [Aphanomyces stellatus] | diamond | 243 | 115 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27594397 | 27594397 | PRJNA950981_P_NODE_7144_length_370_cov_0.747475_g6968_i0 | PRJNA950981 | 7144 | 370 | 0.747475 | 2.7656575 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 2.82e-15 | NR | RHX99013.1 | 112090 | g6968 | i0 | 42.1 | 4.08648648648649 | 126 | 63 | 99.7 | 2 | 369 | 1 | 426 | 544 | RHX99013.1 hypothetical protein DYB36_009748 [Aphanomyces astaci] | diamond | 1512 | 82 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28421957 | 28421957 | PRJNA950981_P_NODE_20226_length_245_cov_0.906977_g20050_i0 | PRJNA950981 | 20226 | 245 | 0.906977 | 2.22209365 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 2.08e-10 | NR | KAF1327062.1 | 82926 | g20050 | i0 | 44.3 | 1.95918367346939 | 79 | 42 | 96.7 | 1 | 238 | 2 | 27 | 103 | KAF1327062.1 Guanylate kinase, partial [Globisporangium splendens] | diamond | 480 | 65.9 | 0.993930197268589 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28509961 | 28509961 | PRJNA950981_P_NODE_11507_length_302_cov_1.620087_g11331_i0 | PRJNA950981 | 11507 | 302 | 1.620087 | 4.89266274 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 2.57e-4 | NR | RHY25324.1 | 112090 | g11331 | i0 | 51.9 | 0.764900662251656 | 77 | 37 | 76.5 | 0 | 300 | 70 | 220 | 296 | RHY25324.1 hypothetical protein DYB25_003324 [Aphanomyces astaci] | diamond | 231 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28604660 | 28604660 | PRJNA950981_P_NODE_16507_length_253_cov_0.866667_g16331_i0 | PRJNA950981 | 16507 | 253 | 0.866667 | 2.19266751 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.0019 | NR | OQR84814.1 | 1202772 | g16331 | i0 | 33.3 | 0.889328063241107 | 75 | 50 | 88.9 | 0 | 22 | 246 | 177 | 251 | OQR84814.1 importin-like protein [Achlya hypogyna] | diamond | 225 | 46.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 29299290 | 29299290 | PRJNA950981_P_NODE_13029_length_285_cov_1.471698_g12853_i0 | PRJNA950981 | 13029 | 285 | 1.471698 | 4.1943393 | Phytophthora boehmeriae | 109152 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 1.13e-15 | NR | KAG7399116.1 | 109152 | g12853 | i0 | 51.1 | 0.989473684210526 | 94 | 44 | 96.8 | 1 | 9 | 284 | 12 | 105 | KAG7399116.1 Nucleoside diphosphate kinase III, chloroplastic/mitochondrial [Phytophthora boehmeriae] | diamond | 282 | 79.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 29337456 | 29337456 | PRJNA950981_P_NODE_17689_length_250_cov_1.745763_g17513_i0 | PRJNA950981 | 17689 | 250 | 1.745763 | 4.3644075 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 6.52e-14 | NR | KAG1683943.1 | 4784 | g17513 | i0 | 42.9 | 6.096 | 84 | 46 | 98.4 | 1 | 250 | 5 | 179 | 262 | KAG1683943.1 hypothetical protein DVH05_012284 [Phytophthora capsici] | diamond | 1524 | 75.5 | 0.994701986754967 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 29583117 | 29583117 | PRJNA950981_P_NODE_13250_length_283_cov_1.314286_g13074_i0 | PRJNA950981 | 13250 | 283 | 1.314286 | 3.71942938 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.013 | NR | KAG1689414.1 | 4784 | g13074 | i0 | 33.3 | 1.68551236749117 | 81 | 39 | 70 | 3 | 71 | 268 | 796 | 876 | KAG1689414.1 hypothetical protein DVH05_002215 [Phytophthora capsici] | diamond | 477 | 44.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 29994103 | 29994103 | PRJNA950981_P_NODE_17131_length_252_cov_0.871508_g16955_i0 | PRJNA950981 | 17131 | 252 | 0.871508 | 2.19620016 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.0299999999999998e-37 | NR | KAG9414105.1 | 112091 | g16955 | i0 | 88 | 5.90476190476191 | 83 | 10 | 98.8 | 0 | 251 | 3 | 54 | 136 | KAG9414105.1 Histone-arginine methyltransferase carm1 [Aphanomyces cochlioides] | diamond | 1488 | 139 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 30499528 | 30499528 | PRJNA950981_P_NODE_17433_length_251_cov_0.876404_g17257_i0 | PRJNA950981 | 17433 | 251 | 0.876404 | 2.19977404 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 8.5000000000000007e-36 | NR | XP_024585418.1 | 4781 | g17257 | i0 | 74.4 | 2.92828685258964 | 82 | 21 | 98 | 0 | 251 | 6 | 640 | 721 | XP_024585418.1 valine-trna partial [Plasmopara halstedii] | diamond | 735 | 138 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 31257813 | 31257813 | PRJNA950981_P_NODE_14535_length_270_cov_1.979695_g14359_i0 | PRJNA950981 | 14535 | 270 | 1.979695 | 5.3451765 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 7.1e-15 | NR | XP_009838760.1 | 112090 | g14359 | i0 | 46.2 | 9.07777777777778 | 91 | 45 | 96.7 | 1 | 2 | 262 | 3861 | 3951 | XP_009838760.1 hypothetical protein H257_13041 [Aphanomyces astaci] | diamond | 2451 | 79.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31352809 | 31352809 | PRJNA950981_P_NODE_956_length_934_cov_4.781649_g829_i0 | PRJNA950981 | 956 | 934 | 4.781649 | 44.66060166 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 1.16e-5 | NR | GLD93914.1 | 114742 | g829 | i0 | 54.9 | 0.668094218415418 | 51 | 21 | 15.7 | 1 | 316 | 462 | 330 | 380 | GLD93914.1 hypothetical protein PINS_up002519 [Pythium insidiosum] | diamond | 624 | 59.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31605830 | 31605830 | PRJNA950981_P_NODE_12136_length_295_cov_1.234234_g11960_i0 | PRJNA950981 | 12136 | 295 | 1.234234 | 3.6409903 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 3.45e-39 | NR | KAH9116551.1 | 100861 | g11960 | i0 | 75 | 0.935593220338983 | 92 | 21 | 91.5 | 2 | 270 | 1 | 3 | 94 | KAH9116551.1 hypothetical protein AeMF1_009507 [Aphanomyces euteiches] | diamond | 276 | 140 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 31953649 | 31953649 | PRJNA950981_P_NODE_20757_length_244_cov_0.912281_g20581_i0 | PRJNA950981 | 20757 | 244 | 0.912281 | 2.22596564 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 2.11e-5 | NR | KAF1325803.1 | 82926 | g20581 | i0 | 38 | 0.971311475409836 | 79 | 48 | 97.1 | 1 | 8 | 244 | 775 | 852 | KAF1325803.1 Ap-1 complex subunit beta, partial [Globisporangium splendens] | diamond | 237 | 52 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 32055150 | 32055150 | PRJNA950981_P_NODE_17498_length_251_cov_0.876404_g17322_i0 | PRJNA950981 | 17498 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 2.02e-17 | NR | KAH9070578.1 | 100861 | g17322 | i0 | 50 | 4.66135458167331 | 78 | 39 | 93.2 | 0 | 244 | 11 | 1274 | 1351 | KAH9070578.1 hypothetical protein Ae201684P_002935 [Aphanomyces euteiches] | diamond | 1170 | 86.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32333736 | 32333736 | PRJNA950981_P_NODE_17379_length_251_cov_0.876404_g17203_i0 | PRJNA950981 | 17379 | 251 | 0.876404 | 2.19977404 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 4.19e-30 | NR | KAF0689689.1 | 120398 | g17203 | i0 | 69.5 | 0.9800796812749 | 82 | 25 | 98 | 0 | 250 | 5 | 111 | 192 | KAF0689689.1 hypothetical protein As57867_018808 [Aphanomyces stellatus] | diamond | 246 | 118 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 32333738 | 32333738 | PRJNA950981_P_NODE_5359_length_420_cov_2.089337_g5183_i0 | PRJNA950981 | 5359 | 420 | 2.089337 | 8.7752154 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 3.17e-11 | NR | XP_009526256.1 | 67593 | g5183 | i0 | 50.5 | 1.3 | 91 | 39 | 65 | 2 | 101 | 373 | 231 | 315 | XP_009526256.1 hypothetical protein PHYSODRAFT_354553 [Phytophthora sojae] | diamond | 546 | 70.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 32466860 | 32466860 | PRJNA950981_P_NODE_17619_length_251_cov_0.876404_g17443_i0 | PRJNA950981 | 17619 | 251 | 0.876404 | 2.19977404 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 164 | 1.2999999999999999e-46 | NR | XP_009832428.1 | 112090 | g17443 | i0 | 88 | 2.97609561752988 | 83 | 10 | 99.2 | 0 | 3 | 251 | 289 | 371 | XP_009832428.1 hypothetical protein H257_08298 [Aphanomyces astaci] | diamond | 747 | 165 | 0.993939393939394 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 32617903 | 32617903 | PRJNA950981_P_NODE_16980_length_252_cov_0.871508_g16804_i0 | PRJNA950981 | 16980 | 252 | 0.871508 | 2.19620016 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 5.06e-11 | NR | DAZ97105.1 | 4803 | g16804 | i0 | 39.2 | 0.94047619047619 | 79 | 45 | 92.9 | 2 | 2 | 235 | 194 | 270 | DAZ97105.1 TPA: hypothetical protein N0F65_010428 [Lagenidium giganteum] | diamond | 237 | 67.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32876337 | 32876337 | PRJNA950981_P_NODE_8520_length_343_cov_2.051852_g8344_i0 | PRJNA950981 | 8520 | 343 | 2.051852 | 7.03785236 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 4.94e-57 | NR | KAL0583279.1 | 65357 | g8344 | i0 | 75.2 | 6.91836734693878 | 113 | 28 | 98.8 | 0 | 339 | 1 | 22 | 134 | KAL0583279.1 hypothetical protein ABG067_006780 [Albugo candida] | diamond | 2373 | 185 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida |
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);;