contig_metadata
22 rows where bioproject = "PRJNA1129273", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1557845 | 1557845 | PRJNA1129273_P_NODE_5062_length_316_cov_0.950617_g4782_i0 | PRJNA1129273 | 5062 | 316 | 0.950617 | 3.00394972 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 7.169999999999998e-43 | NR | RLN58565.1 | 325452 | g4782 | i0 | 71.3 | 39.3417721518987 | 101 | 29 | 95.9 | 0 | 10 | 312 | 286 | 386 | RLN58565.1 hypothetical protein BBP00_00006943 [Phytophthora kernoviae] | diamond | 12432 | 157 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 4110305 | 4110305 | PRJNA1129273_P_NODE_9004_length_249_cov_1.710227_g8724_i0 | PRJNA1129273 | 9004 | 249 | 1.710227 | 4.25846523 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 9.799999999999999e-35 | NR | DBA04472.1 | 4803 | g8724 | i0 | 72 | 20.7228915662651 | 82 | 23 | 98.8 | 0 | 4 | 249 | 606 | 687 | DBA04472.1 TPA: hypothetical protein N0F65_010068 [Lagenidium giganteum] | diamond | 5160 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 6661165 | 6661165 | PRJNA1129273_P_NODE_9486_length_247_cov_0.890805_g9206_i0 | PRJNA1129273 | 9486 | 247 | 0.890805 | 2.20028835 | root | 1 | Root_unresolved | Root_unresolved | 116 | 1.22e-31 | NR | KAE9065155.1 | 53985 | g9206 | i0 | 81.8 | 2.84210526315789 | 77 | 14 | 93.5 | 0 | 232 | 2 | 30 | 106 | KAE9065155.1 hypothetical protein PF010_g28318, partial [Phytophthora fragariae] | diamond | 702 | 116 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 7409587 | 7409587 | PRJNA1129273_P_NODE_8106_length_257_cov_1.771739_g7826_i0 | PRJNA1129273 | 8106 | 257 | 1.771739 | 4.55336923 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.46e-22 | NR | XP_009520350.1 | 67593 | g7826 | i0 | 60 | 4.70428015564202 | 85 | 32 | 99.2 | 1 | 256 | 2 | 5 | 87 | XP_009520350.1 hypothetical protein PHYSODRAFT_344860 [Phytophthora sojae] | diamond | 1209 | 100 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 17609354 | 17609354 | PRJNA1129273_P_NODE_8894_length_250_cov_0.870056_g8614_i0 | PRJNA1129273 | 8894 | 250 | 0.870056 | 2.17514 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.1399999999999998e-124 | NTclustered | gi|33520246|gb|AY273991.1| | 4787 | g8614 | i0 | 100 | 99.208 | 248 | 0 | 99 | 0 | 2 | 249 | 411 | 164 | Phytophthora infestans large subunit ribosomal RNA gene, partial sequence | blastn | 24802 | 459 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 21960025 | 21960025 | PRJNA1129273_P_NODE_3158_length_418_cov_2.866667_g2879_i0 | PRJNA1129273 | 3158 | 418 | 2.866667 | 11.98266806 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 5.08e-45 | NR | OQR94730.1 | 74557 | g2879 | i0 | 65.7 | 171.574162679426 | 140 | 36 | 99.8 | 3 | 2 | 418 | 1 | 129 | OQR94730.1 hypothetical protein THRCLA_22217 [Thraustotheca clavata] | diamond | 71718 | 154 | 0.993506493506494 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 26616168 | 26616168 | PRJNA1129273_P_NODE_3781_length_374_cov_1.784053_g3501_i0 | PRJNA1129273 | 3781 | 374 | 1.7840530000000001 | 6.67235822 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.09e-62 | NR | XP_067822870.1 | 4779 | g3501 | i0 | 84 | 241.163101604278 | 106 | 17 | 85 | 0 | 3 | 320 | 210 | 315 | XP_067822870.1 uncharacterized protein CCR75_007277 [Bremia lactucae] | diamond | 90195 | 206 | 0.990291262135922 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 26943676 | 26943676 | PRJNA1129273_P_NODE_3802_length_373_cov_1.713333_g3522_i0 | PRJNA1129273 | 3802 | 373 | 1.713333 | 6.39073209 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 7.3900000000000007e-08 | NR | KUF84593.1 | 4792 | g3522 | i0 | 31.4 | 2.7828418230563 | 105 | 59 | 74 | 1 | 329 | 54 | 372 | 476 | KUF84593.1 Ubiquitin and WLM domain-containing protein [Phytophthora nicotianae] | diamond | 1038 | 60.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 27006912 | 27006912 | PRJNA1129273_P_NODE_2842_length_448_cov_1.682667_g2563_i0 | PRJNA1129273 | 2842 | 448 | 1.682667 | 7.53834816 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 4.73e-4 | NR | KAG9408400.1 | 112091 | g2563 | i0 | 41.5 | 0.435267857142857 | 65 | 34 | 41.5 | 2 | 227 | 42 | 86 | 149 | KAG9408400.1 hypothetical protein AC1031_021638 [Aphanomyces cochlioides] | diamond | 195 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 28049451 | 28049451 | PRJNA1129273_P_NODE_1865_length_590_cov_2.553191_g1595_i0 | PRJNA1129273 | 1865 | 590 | 2.553191 | 15.0638269 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 162 | 2.4899999999999996e-47 | NR | KAE8911393.1 | 53985 | g1595 | i0 | 57 | 1.67796610169492 | 165 | 50 | 83.9 | 3 | 50 | 544 | 1 | 144 | KAE8911393.1 hypothetical protein PF003_g4481 [Phytophthora fragariae] | diamond | 990 | 162 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 28543984 | 28543984 | PRJNA1129273_P_NODE_5767_length_293_cov_3.104545_g5487_i0 | PRJNA1129273 | 5767 | 293 | 3.104545 | 9.09631685 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 3.77e-28 | NR | KAH9103988.1 | 100861 | g5487 | i0 | 64 | 3.67576791808874 | 89 | 29 | 88.1 | 1 | 258 | 1 | 29 | 117 | KAH9103988.1 hypothetical protein LEN26_015148 [Aphanomyces euteiches] | diamond | 1077 | 114 | 0.991228070175439 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29017708 | 29017708 | PRJNA1129273_P_NODE_4068_length_357_cov_1.838028_g3788_i0 | PRJNA1129273 | 4068 | 357 | 1.838028 | 6.56175996 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.2500000000000001e-22 | NR | XP_067782380.1 | 4785 | g3788 | i0 | 44.2 | 11.2268907563025 | 113 | 60 | 94.1 | 3 | 340 | 5 | 75 | 185 | XP_067782380.1 CMGC/MAPK protein Kinase [Phytophthora cinnamomi] | diamond | 4008 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29269756 | 29269756 | PRJNA1129273_P_NODE_6469_length_281_cov_1.110577_g6189_i0 | PRJNA1129273 | 6469 | 281 | 1.110577 | 3.12072137 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 5.32e-14 | NR | KAJ8576524.1 | 4785 | g6189 | i0 | 44.3 | 6.14946619217082 | 88 | 49 | 94 | 0 | 13 | 276 | 899 | 986 | KAJ8576524.1 hypothetical protein ON010_g2687 [Phytophthora cinnamomi] | diamond | 1728 | 77 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29533460 | 29533460 | PRJNA1129273_P_NODE_5710_length_295_cov_3.945946_g5430_i0 | PRJNA1129273 | 5710 | 295 | 3.945946 | 11.6405407 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 6.78e-20 | NR | KAF1783772.1 | 29920 | g5430 | i0 | 56.5 | 1.40338983050847 | 69 | 30 | 70.2 | 0 | 87 | 293 | 177 | 245 | KAF1783772.1 Ribosomal protein L35Ae, conserved site [Phytophthora cactorum] | diamond | 414 | 91.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 29585351 | 29585351 | PRJNA1129273_P_NODE_8130_length_257_cov_1.467391_g7850_i0 | PRJNA1129273 | 8130 | 257 | 1.467391 | 3.77119487 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.9499999999999994e-24 | NR | KAK1941687.1 | 4793 | g7850 | i0 | 57 | 42.0350194552529 | 79 | 34 | 92.2 | 0 | 257 | 21 | 169 | 247 | KAK1941687.1 Alpha-centractin [Phytophthora citrophthora] | diamond | 10803 | 105 | 0.990476190476191 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 29817440 | 29817440 | PRJNA1129273_P_NODE_1351_length_723_cov_3.300000_g1096_i0 | PRJNA1129273 | 1351 | 723 | 3.3 | 23.859 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 6.64e-35 | NR | OQS00341.1 | 74557 | g1096 | i0 | 40.4 | 2.35269709543568 | 183 | 107 | 75.5 | 2 | 715 | 170 | 66 | 247 | OQS00341.1 hypothetical protein THRCLA_06000 [Thraustotheca clavata] | diamond | 1701 | 137 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 30260161 | 30260161 | PRJNA1129273_P_NODE_1032_length_853_cov_2.515385_g806_i0 | PRJNA1129273 | 1032 | 853 | 2.515385 | 21.45623405 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 1.23e-5 | NR | XP_012197413.1 | 695850 | g806 | i0 | 51 | 0.555685814771395 | 51 | 25 | 17.9 | 0 | 3 | 155 | 1197 | 1247 | XP_012197413.1 hypothetical protein SPRG_19488 [Saprolegnia parasitica CBS 223.65] | diamond | 474 | 58.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 30860236 | 30860236 | PRJNA1129273_P_NODE_4054_length_357_cov_7.633803_g3774_i0 | PRJNA1129273 | 4054 | 357 | 7.633803 | 27.25267671 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 1.89e-12 | NR | KAF0732248.1 | 100861 | g3774 | i0 | 46.6 | 4.38655462184874 | 103 | 52 | 86.6 | 2 | 311 | 3 | 16 | 115 | KAF0732248.1 hypothetical protein Ae201684_010540 [Aphanomyces euteiches] | diamond | 1566 | 70.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 31713834 | 31713834 | PRJNA1129273_P_NODE_3437_length_395_cov_3.922360_g3157_i0 | PRJNA1129273 | 3437 | 395 | 3.92236 | 15.493322 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.38e-4 | NR | KAG9412244.1 | 112091 | g3157 | i0 | 34.6 | 0.615189873417721 | 81 | 50 | 61.5 | 2 | 85 | 327 | 110 | 187 | KAG9412244.1 hypothetical protein AC1031_015185 [Aphanomyces cochlioides] | diamond | 243 | 51.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 32209154 | 32209154 | PRJNA1129273_P_NODE_11158_length_227_cov_2.019481_g10878_i0 | PRJNA1129273 | 11158 | 227 | 2.019481 | 4.58422187 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 2.51e-6 | NR | DBA04150.1 | 4803 | g10878 | i0 | 56.1 | 5.93392070484582 | 41 | 17 | 54.2 | 1 | 102 | 224 | 404 | 443 | DBA04150.1 TPA: hypothetical protein N0F65_004258 [Lagenidium giganteum] | diamond | 1347 | 54.7 | 0.992687385740402 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32283603 | 32283603 | PRJNA1129273_P_NODE_6959_length_273_cov_1.535000_g6679_i0 | PRJNA1129273 | 6959 | 273 | 1.535 | 4.19055 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 9.12e-11 | NR | RHY27603.1 | 157072 | g6679 | i0 | 40.9 | 0.967032967032967 | 88 | 49 | 93.4 | 2 | 268 | 14 | 42 | 129 | RHY27603.1 hypothetical protein DYB32_007655 [Aphanomyces invadans] | diamond | 264 | 67.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 32462351 | 32462351 | PRJNA1129273_P_NODE_6099_length_287_cov_1.411215_g5819_i0 | PRJNA1129273 | 6099 | 287 | 1.411215 | 4.05018705 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 1.11e-13 | NR | POM79695.1 | 4796 | g5819 | i0 | 49.4 | 5.86411149825784 | 77 | 37 | 78.4 | 1 | 22 | 246 | 180 | 256 | POM79695.1 Dolichyl-diphosphooligosaccharide-protein glycosyltransferase subunit, partial [Phytophthora palmivora] | diamond | 1683 | 74.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora |
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);;