contig_metadata
22 rows where bioproject = "PRJNA562549", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2406287 | 2406287 | PRJNA562549_P_NODE_35902_length_203_cov_0.915493_g35669_i0 | PRJNA562549 | 35902 | 203 | 0.915493 | 1.85845079 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.08e-25 | NR | OQS01905.1 | 74557 | g35669 | i0 | 69.7 | 10.7290640394089 | 66 | 20 | 97.5 | 0 | 3 | 200 | 338 | 403 | OQS01905.1 coatomer subunit beta' [Thraustotheca clavata] | diamond | 2178 | 109 | 0.990825688073395 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 4958871 | 4958871 | PRJNA562549_P_NODE_16544_length_284_cov_1.170404_g16311_i0 | PRJNA562549 | 16544 | 284 | 1.170404 | 3.32394736 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 1.14e-41 | NR | TMW62875.1 | 41045 | g16311 | i0 | 73.6 | 8.67253521126761 | 91 | 24 | 96.1 | 0 | 11 | 283 | 3 | 93 | TMW62875.1 hypothetical protein Poli38472_005493 [Pythium oligandrum] | diamond | 2463 | 145 | 0.993103448275862 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 6923727 | 6923727 | PRJNA562549_P_NODE_19046_length_266_cov_1.765854_g18813_i0 | PRJNA562549 | 19046 | 266 | 1.765854 | 4.69717164 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.0599999999999998e-37 | NR | OQS04692.1 | 74557 | g18813 | i0 | 85.2 | 3.7218045112782 | 81 | 12 | 91.4 | 0 | 244 | 2 | 1 | 81 | OQS04692.1 aspartyl/Asparaginyl beta-hydroxylase [Thraustotheca clavata] | diamond | 990 | 139 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 8783729 | 8783729 | PRJNA562549_P_NODE_21227_length_253_cov_1.458333_g20994_i0 | PRJNA562549 | 21227 | 253 | 1.458333 | 3.68958249 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 2.71e-66 | NTclustered | gi|1917931691|gb|MT811915.1| | 82946 | g20994 | i0 | 85.714 | 87.7470355731225 | 252 | 34 | 99 | 2 | 1 | 251 | 1084 | 1334 | Pythium periplocum culture CBS:532.74 tubulin alpha chain (Tua) mRNA, complete cds | blastn | 22200 | 265 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium periplocum | ||
| 10750124 | 10750124 | PRJNA562549_P_NODE_31609_length_211_cov_0.866667_g31376_i0 | PRJNA562549 | 31609 | 211 | 0.866667 | 1.82866737 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.05e-22 | NR | XP_067821135.1 | 4779 | g31376 | i0 | 69.1 | 5.80094786729858 | 68 | 21 | 96.7 | 0 | 209 | 6 | 355 | 422 | XP_067821135.1 hypothetical protein CCR75_001768 [Bremia lactucae] | diamond | 1224 | 101 | 0.99009900990099 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 10750230 | 10750230 | PRJNA562549_P_NODE_8329_length_398_cov_1.477745_g8096_i0 | PRJNA562549 | 8329 | 398 | 1.477745 | 5.8814251 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 1.26e-61 | NR | XP_012205266.1 | 695850 | g8096 | i0 | 72 | 58.6206030150754 | 132 | 37 | 99.5 | 0 | 2 | 397 | 92 | 223 | XP_012205266.1 guanine nucleotide-binding protein subunit beta-2-like 1 [Saprolegnia parasitica CBS 223.65] | diamond | 23331 | 199 | 0.994974874371859 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14574654 | 14574654 | PRJNA562549_P_NODE_14912_length_298_cov_1.624473_g14679_i0 | PRJNA562549 | 14912 | 298 | 1.624473 | 4.84092954 | root | 1 | Root_unresolved | Root_unresolved | 102 | 5.7e-23 | NR | XP_024571672.1 | 4781 | g14679 | i0 | 82 | 4.97315436241611 | 61 | 11 | 61.4 | 0 | 8 | 190 | 624 | 684 | XP_024571672.1 polyadenylate-binding protein 1-like isoform 1 [Plasmopara halstedii] | diamond | 1482 | 103 | 0.990291262135922 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 19672278 | 19672278 | PRJNA562549_P_NODE_32096_length_210_cov_0.872483_g31863_i0 | PRJNA562549 | 32096 | 210 | 0.872483 | 1.8322143 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.3500000000000006e-27 | NR | TMW55108.1 | 41045 | g31863 | i0 | 85 | 10.4142857142857 | 60 | 9 | 85.7 | 0 | 188 | 9 | 130 | 189 | TMW55108.1 hypothetical protein Poli38472_013870 [Pythium oligandrum] | diamond | 2187 | 109 | 0.990825688073395 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 20947787 | 20947787 | PRJNA562549_P_NODE_14937_length_298_cov_1.092827_g14704_i0 | PRJNA562549 | 14937 | 298 | 1.092827 | 3.25662446 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 2.7899999999999993e-43 | NR | XP_024577953.1 | 4781 | g14704 | i0 | 77.8 | 7.82214765100671 | 99 | 22 | 99.7 | 0 | 298 | 2 | 22 | 120 | XP_024577953.1 ribosomal protein s4 [Plasmopara halstedii] | diamond | 2331 | 150 | 0.993333333333333 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 23498003 | 23498003 | PRJNA562549_P_NODE_14139_length_306_cov_1.061224_g13906_i0 | PRJNA562549 | 14139 | 306 | 1.061224 | 3.24734544 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.59e-54 | NTclustered | gi|301107276|ref|XM_002902675.1| | 403677 | g13906 | i0 | 81.404 | 73.921568627451 | 285 | 45 | 92 | 6 | 20 | 300 | 592 | 872 | Phytophthora infestans T30-4 adenosylhomocysteinase (PITG_10198), partial mRNA | blastn | 22620 | 226 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 24772026 | 24772026 | PRJNA562549_P_NODE_31680_length_210_cov_3.006711_g31447_i0 | PRJNA562549 | 31680 | 210 | 3.006711 | 6.3140931 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 4.77e-53 | NTclustered | gi|166047767|emb|CU362882.1| | 100861 | g31447 | i0 | 92.258 | 76.5333333333333 | 155 | 12 | 74 | 0 | 45 | 199 | 98 | 252 | Aphanomyces euteiches cDNA | blastn | 16072 | 220 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 26699121 | 26699121 | PRJNA562549_P_NODE_29841_length_216_cov_1.612903_g29608_i0 | PRJNA562549 | 29841 | 216 | 1.612903 | 3.48387048 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 2.01e-5 | NR | TMW59429.1 | 41045 | g29608 | i0 | 46.5 | 1.97222222222222 | 71 | 33 | 98.6 | 2 | 215 | 3 | 164 | 229 | TMW59429.1 hypothetical protein Poli38472_004498 [Pythium oligandrum] | diamond | 426 | 51.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27251023 | 27251023 | PRJNA562549_P_NODE_36403_length_202_cov_0.921986_g36170_i0 | PRJNA562549 | 36403 | 202 | 0.921986 | 1.86241172 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 7.27e-25 | NR | KAG2784318.1 | 29920 | g36170 | i0 | 75.4 | 9.08910891089109 | 61 | 15 | 90.6 | 0 | 19 | 201 | 135 | 195 | KAG2784318.1 hypothetical protein Pcac1_g5706 [Phytophthora cactorum] | diamond | 1836 | 104 | 0.990384615384615 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 29005924 | 29005924 | PRJNA562549_P_NODE_29108_length_219_cov_1.120253_g28875_i0 | PRJNA562549 | 29108 | 219 | 1.120253 | 2.45335407 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 2.99e-13 | NR | KUF91740.1 | 4792 | g28875 | i0 | 47.3 | 1.01369863013699 | 74 | 35 | 98.6 | 2 | 1 | 216 | 41 | 112 | KUF91740.1 hypothetical protein AM588_10004643 [Phytophthora nicotianae] | diamond | 222 | 69.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 29257847 | 29257847 | PRJNA562549_P_NODE_21569_length_251_cov_1.957895_g21336_i0 | PRJNA562549 | 21569 | 251 | 1.957895 | 4.91431645 | Phytophthora rubi | 129364 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.29e-27 | NR | KAE9308873.1 | 129364 | g21336 | i0 | 62.2 | 5.8804780876494 | 82 | 31 | 98 | 0 | 248 | 3 | 7 | 88 | KAE9308873.1 hypothetical protein PR003_g20640 [Phytophthora rubi] | diamond | 1476 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora rubi | ||
| 29335130 | 29335130 | PRJNA562549_P_NODE_15089_length_296_cov_2.531915_g14856_i0 | PRJNA562549 | 15089 | 296 | 2.531915 | 7.4944684 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.4799999999999998e-32 | NR | XP_024573476.1 | 4781 | g14856 | i0 | 64.1 | 10.0033783783784 | 92 | 33 | 93.2 | 0 | 276 | 1 | 533 | 624 | XP_024573476.1 dead deah box helicase [Plasmopara halstedii] | diamond | 2961 | 129 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 30724872 | 30724872 | PRJNA562549_P_NODE_32214_length_210_cov_0.872483_g31981_i0 | PRJNA562549 | 32214 | 210 | 0.872483 | 1.8322143 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 3.71e-19 | NR | GLE05944.1 | 114742 | g31981 | i0 | 67.1 | 2.01428571428571 | 70 | 23 | 100 | 0 | 210 | 1 | 337 | 406 | GLE05944.1 hypothetical protein PINS_up015155 [Pythium insidiosum] | diamond | 423 | 90.9 | 0.995599559955996 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31103942 | 31103942 | PRJNA562549_P_NODE_36575_length_202_cov_0.921986_g36342_i0 | PRJNA562549 | 36575 | 202 | 0.921986 | 1.86241172 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 2.89e-5 | NR | TMW66516.1 | 41045 | g36342 | i0 | 37.9 | 6.65346534653465 | 58 | 36 | 86.1 | 0 | 179 | 6 | 94 | 151 | TMW66516.1 hypothetical protein Poli38472_004281 [Pythium oligandrum] | diamond | 1344 | 51.2 | 0.9921875 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31343142 | 31343142 | PRJNA562549_P_NODE_22436_length_247_cov_1.064516_g22203_i0 | PRJNA562549 | 22436 | 247 | 1.064516 | 2.62935452 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 6.18e-16 | NR | RLO11541.1 | 112090 | g22203 | i0 | 48.7 | 0.947368421052632 | 78 | 35 | 94.7 | 1 | 236 | 3 | 124 | 196 | RLO11541.1 hypothetical protein DYB28_000642 [Aphanomyces astaci] | diamond | 234 | 80.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 32527797 | 32527797 | PRJNA562549_P_NODE_24039_length_239_cov_1.460674_g23806_i0 | PRJNA562549 | 24039 | 239 | 1.460674 | 3.49101086 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 3.43e-34 | NR | KAJ0410394.1 | 114742 | g23806 | i0 | 72.7 | 6.82845188284519 | 77 | 21 | 96.7 | 0 | 238 | 8 | 51 | 127 | KAJ0410394.1 hypothetical protein P43SY_002726 [Pythium insidiosum] | diamond | 1632 | 125 | 0.992 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32559420 | 32559420 | PRJNA562549_P_NODE_21419_length_252_cov_1.701571_g21186_i0 | PRJNA562549 | 21419 | 252 | 1.701571 | 4.28795892 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 85.1 | 4.81e-17 | NR | CCI43303.1 | 65357 | g21186 | i0 | 62 | 13.8095238095238 | 71 | 26 | 83.3 | 1 | 211 | 2 | 409 | 479 | CCI43303.1 unnamed protein product [Albugo candida] | diamond | 3480 | 85.9 | 0.990686845168801 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 32828894 | 32828894 | PRJNA562549_P_NODE_31560_length_211_cov_0.866667_g31327_i0 | PRJNA562549 | 31560 | 211 | 0.866667 | 1.82866737 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 5.47e-21 | NR | KAJ0405492.1 | 114742 | g31327 | i0 | 57.1 | 2.98578199052133 | 70 | 30 | 99.5 | 0 | 2 | 211 | 90 | 159 | KAJ0405492.1 hypothetical protein ATCC90586_000155 [Pythium insidiosum] | diamond | 630 | 92.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum |
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);;