contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1092581" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6574097 | 6574097 | PRJNA1092581_P_NODE_17286_length_668_cov_3.132773_g16776_i0 | PRJNA1092581 | 17286 | 668 | 3.132773 | 20.92692364 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 7.92e-117 | NR | KAI9992435.1 | 4787 | g16776 | i0 | 86.9 | 16.6302395209581 | 222 | 12 | 99.7 | 2 | 667 | 2 | 709 | 913 | KAI9992435.1 hypothetical protein PInf_017844 [Phytophthora infestans] | diamond | 11109 | 372 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 26877988 | 26877988 | PRJNA1092581_P_NODE_24401_length_563_cov_3.995918_g23875_i0 | PRJNA1092581 | 24401 | 563 | 3.995918 | 22.49701834 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 2.63e-4 | NR | KAG3065807.1 | 29920 | g23875 | i0 | 92 | 0.532859680284192 | 25 | 2 | 13.3 | 0 | 467 | 393 | 488 | 512 | KAG3065807.1 hypothetical protein PC121_g11159 [Phytophthora cactorum] | diamond | 300 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 27257227 | 27257227 | PRJNA1092581_P_NODE_79563_length_290_cov_3.046083_g79030_i0 | PRJNA1092581 | 79563 | 290 | 3.046083 | 8.8336407 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 2.08e-14 | NR | OWZ22933.1 | 4795 | g79030 | i0 | 66.1 | 1.15862068965517 | 56 | 19 | 57.9 | 0 | 218 | 51 | 370 | 425 | OWZ22933.1 hypothetical protein PHMEG_0002284 [Phytophthora megakarya] | diamond | 336 | 78.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 27762812 | 27762812 | PRJNA1092581_P_NODE_20624_length_612_cov_4.155844_g20103_i0 | PRJNA1092581 | 20624 | 612 | 4.155844 | 25.43376528 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 386 | 6.189999999999998e-132 | NR | KAF4135675.1 | 4787 | g20103 | i0 | 98.4 | 0.941176470588235 | 192 | 3 | 94.1 | 0 | 578 | 3 | 1 | 192 | KAF4135675.1 hypothetical protein GN958_ATG15137 [Phytophthora infestans] | diamond | 576 | 386 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 28299240 | 28299240 | PRJNA1092581_P_NODE_83886_length_281_cov_2.625000_g83353_i0 | PRJNA1092581 | 83886 | 281 | 2.625 | 7.37625 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 2.22e-10 | NR | CCI41133.1 | 65357 | g83353 | i0 | 41.7 | 1.62277580071174 | 84 | 44 | 89.7 | 1 | 27 | 278 | 96 | 174 | CCI41133.1 unnamed protein product [Albugo candida] | diamond | 456 | 65.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 28353803 | 28353803 | PRJNA1092581_P_NODE_79066_length_291_cov_3.697248_g78533_i0 | PRJNA1092581 | 79066 | 291 | 3.697248 | 10.75899168 | root | 1 | Root_unresolved | Root_unresolved | 64.3 | 1.71e-9 | NR | GMF23042.1 | 1490495 | g78533 | i0 | 40.7 | 2.31958762886598 | 91 | 52 | 91.8 | 1 | 6 | 272 | 294 | 384 | GMF23042.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 675 | 64.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia | ||
| 28709923 | 28709923 | PRJNA1092581_P_NODE_110647_length_239_cov_3.036145_g110114_i0 | PRJNA1092581 | 110647 | 239 | 3.036145 | 7.25638655 | Phytophthora idaei | 53986 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.08e-16 | NR | KAG3234205.1 | 53986 | g110114 | i0 | 67.8 | 1.48117154811715 | 59 | 19 | 74.1 | 0 | 63 | 239 | 1 | 59 | KAG3234205.1 hypothetical protein PI124_g20737 [Phytophthora idaei] | diamond | 354 | 80.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora idaei | ||
| 29277916 | 29277916 | PRJNA1092581_P_NODE_18889_length_640_cov_3.104056_g18372_i0 | PRJNA1092581 | 18889 | 640 | 3.104056 | 19.8659584 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.49e-81 | NR | KAF4039341.1 | 4787 | g18372 | i0 | 100 | 0.6046875 | 129 | 0 | 60.5 | 0 | 437 | 51 | 1 | 129 | KAF4039341.1 hypothetical protein GN244_ATG08474 [Phytophthora infestans] | diamond | 387 | 248 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 30257471 | 30257471 | PRJNA1092581_P_NODE_127112_length_200_cov_5.590551_g126579_i0 | PRJNA1092581 | 127112 | 200 | 5.590551 | 11.181102 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 1.94e-10 | NR | KAI9979422.1 | 4787 | g126579 | i0 | 53.5 | 1.065 | 71 | 8 | 69 | 1 | 186 | 49 | 320 | 390 | KAI9979422.1 hypothetical protein PInf_029840 [Phytophthora infestans] | diamond | 213 | 65.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 30509908 | 30509908 | PRJNA1092581_P_NODE_84153_length_280_cov_6.574879_g83620_i0 | PRJNA1092581 | 84153 | 280 | 6.574879 | 18.4096612 | Peronospora effusa | 542832 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 1.03e-24 | NR | RMX63336.1 | 542832 | g83620 | i0 | 81.3 | 1.43571428571429 | 64 | 12 | 68.6 | 0 | 260 | 69 | 629 | 692 | RMX63336.1 hypothetical protein DD238_007419 [Peronospora effusa] | diamond | 402 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 30564171 | 30564171 | PRJNA1092581_P_NODE_41793_length_422_cov_1.916905_g41260_i0 | PRJNA1092581 | 41793 | 422 | 1.916905 | 8.0893391 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 6.27e-14 | NR | KAF0734040.1 | 100861 | g41260 | i0 | 43 | 4.23696682464455 | 100 | 50 | 71.1 | 2 | 342 | 43 | 43 | 135 | KAF0734040.1 hypothetical protein Ae201684_009213 [Aphanomyces euteiches] | diamond | 1788 | 74.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30794175 | 30794175 | PRJNA1092581_P_NODE_37094_length_451_cov_3.595238_g36562_i0 | PRJNA1092581 | 37094 | 451 | 3.595238 | 16.21452338 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 2.82e-12 | NR | XP_009825362.1 | 112090 | g36562 | i0 | 56.5 | 0.824833702882483 | 62 | 25 | 40.6 | 2 | 390 | 208 | 359 | 419 | XP_009825362.1 hypothetical protein H257_03107 [Aphanomyces astaci] | diamond | 372 | 74.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30857409 | 30857409 | PRJNA1092581_P_NODE_97094_length_257_cov_4.695652_g96561_i0 | PRJNA1092581 | 97094 | 257 | 4.695652 | 12.06782564 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0233 | NR | KAG1689214.1 | 4784 | g96561 | i0 | 71.4 | 0.326848249027237 | 28 | 8 | 32.7 | 0 | 118 | 35 | 30 | 57 | KAG1689214.1 hypothetical protein DVH05_002707 [Phytophthora capsici] | diamond | 84 | 43.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 31070205 | 31070205 | PRJNA1092581_P_NODE_58675_length_347_cov_1.802920_g58142_i0 | PRJNA1092581 | 58675 | 347 | 1.80292 | 6.2561324 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 7.55e-51 | NR | KAE8894770.1 | 53985 | g58142 | i0 | 82.4 | 19.7377521613833 | 108 | 17 | 91.6 | 1 | 1 | 318 | 183 | 290 | KAE8894770.1 hypothetical protein PF003_g21372 [Phytophthora fragariae] | diamond | 6849 | 175 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 31173065 | 31173065 | PRJNA1092581_P_NODE_14875_length_716_cov_4.734059_g14383_i0 | PRJNA1092581 | 14875 | 716 | 4.734059 | 33.89586244 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 1.17e-25 | NR | KAF4140891.1 | 4787 | g14383 | i0 | 100 | 0.213687150837989 | 51 | 0 | 21.4 | 0 | 155 | 3 | 1 | 51 | KAF4140891.1 hypothetical protein GN958_ATG09739 [Phytophthora infestans] | diamond | 153 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31426390 | 31426390 | PRJNA1092581_P_NODE_94436_length_261_cov_102.973404_g93903_i0 | PRJNA1092581 | 94436 | 261 | 102.973404 | 268.76058444 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00204 | NR | KAJ8576161.1 | 4785 | g93903 | i0 | 43.2 | 0.931034482758621 | 81 | 42 | 89.7 | 2 | 246 | 13 | 60 | 139 | KAJ8576161.1 hypothetical protein ON010_g3053 [Phytophthora cinnamomi] | diamond | 243 | 46.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 31639080 | 31639080 | PRJNA1092581_P_NODE_87796_length_273_cov_5.155000_g87263_i0 | PRJNA1092581 | 87796 | 273 | 5.155 | 14.07315 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 6.9e-7 | NR | XP_024584955.1 | 4781 | g87263 | i0 | 49.2 | 1.3956043956044 | 59 | 30 | 64.8 | 0 | 257 | 81 | 106 | 164 | XP_024584955.1 60s ribosomal protein [Plasmopara halstedii] | diamond | 381 | 55.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 31679309 | 31679309 | PRJNA1092581_P_NODE_14017_length_736_cov_4.591252_g13528_i0 | PRJNA1092581 | 14017 | 736 | 4.591252 | 33.79161472 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 4.26e-5 | NR | DAZ94965.1 | 4803 | g13528 | i0 | 39.5 | 0.309782608695652 | 76 | 39 | 31 | 3 | 23 | 250 | 1183 | 1251 | DAZ94965.1 TPA: hypothetical protein N0F65_000060, partial [Lagenidium giganteum] | diamond | 228 | 56.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31837425 | 31837425 | PRJNA1092581_P_NODE_82837_length_283_cov_3.290476_g82304_i0 | PRJNA1092581 | 82837 | 283 | 3.290476 | 9.31204708 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 7.77e-22 | NR | KUF76843.1 | 4792 | g82304 | i0 | 87.3 | 2.91519434628975 | 55 | 7 | 58.3 | 0 | 43 | 207 | 688 | 742 | KUF76843.1 Spore wall maturation protein DIT1 [Phytophthora nicotianae] | diamond | 825 | 99.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 31995837 | 31995837 | PRJNA1092581_P_NODE_40518_length_429_cov_5.772472_g39985_i0 | PRJNA1092581 | 40518 | 429 | 5.772472 | 24.76390488 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 214 | 1.12e-68 | NR | KAF4046866.1 | 4787 | g39985 | i0 | 98.2 | 0.783216783216783 | 112 | 2 | 78.3 | 0 | 378 | 43 | 9 | 120 | KAF4046866.1 hypothetical protein GN244_ATG00694 [Phytophthora infestans] | diamond | 336 | 214 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 32090739 | 32090739 | PRJNA1092581_P_NODE_107298_length_243_cov_6.488235_g106765_i0 | PRJNA1092581 | 107298 | 243 | 6.488235 | 15.76641105 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 7.37e-8 | NR | KAG1708694.1 | 4784 | g106765 | i0 | 100 | 0.358024691358025 | 29 | 0 | 35.8 | 0 | 224 | 138 | 1197 | 1225 | KAG1708694.1 hypothetical protein DVH05_022320 [Phytophthora capsici] | diamond | 87 | 58.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 32312509 | 32312509 | PRJNA1092581_P_NODE_90319_length_269_cov_1.887755_g89786_i0 | PRJNA1092581 | 90319 | 269 | 1.887755 | 5.07806095 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.82e-31 | NR | KAI9981165.1 | 4787 | g89786 | i0 | 79.7 | 0.8810408921933092 | 79 | 16 | 88.1 | 0 | 6 | 242 | 157 | 235 | KAI9981165.1 hypothetical protein PInf_010795 [Phytophthora infestans] | diamond | 237 | 120 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 32650924 | 32650924 | PRJNA1092581_P_NODE_60140_length_342_cov_1.776952_g59607_i0 | PRJNA1092581 | 60140 | 342 | 1.776952 | 6.07717584 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.73e-37 | NR | KAJ8509205.1 | 4785 | g59607 | i0 | 78.1 | 23.0438596491228 | 73 | 16 | 64 | 0 | 294 | 76 | 48 | 120 | KAJ8509205.1 hypothetical protein ON010_g18793 [Phytophthora cinnamomi] | diamond | 7881 | 136 | 0.992647058823529 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;