contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA924320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7277218 | 7277218 | PRJNA924320_S_NODE_19886_length_232_cov_1.409836_g19744_i0 | PRJNA924320 | 19886 | 232 | 1.409836 | 3.27081952 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.5199999999999996e-43 | NTclustered | gi|695434207|ref|XM_009533074.1| | 67593 | g19744 | i0 | 84.817 | 4.39655172413793 | 191 | 25 | 81 | 4 | 17 | 205 | 189 | 1 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 1020 | 189 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 7630299 | 7630299 | PRJNA924320_S_NODE_43026_length_172_cov_1.105691_g42884_i0 | PRJNA924320 | 43026 | 172 | 1.105691 | 1.90178852 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.33e-25 | NTclustered | gi|1233049511|gb|KX250429.1| | 89334 | g42884 | i0 | 86.066 | 65.1976744186046 | 122 | 13 | 70 | 2 | 53 | 172 | 573 | 692 | Phytophthora clandestina isolate 33D8(authentic) heat shock protein 90 gene, partial cds | blastn | 11214 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora clandestina | ||
| 8552059 | 8552059 | PRJNA924320_S_NODE_21107_length_227_cov_1.146067_g20965_i0 | PRJNA924320 | 21107 | 227 | 1.146067 | 2.60157209 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.02 | NTclustered | gi|187467949|emb|CU694291.4| | 123356 | g20965 | i0 | 100 | 0.246696035242291 | 28 | 0 | 12 | 0 | 19 | 46 | 127711 | 127738 | H.parasitica DNA sequence from clone HpEmoy2-20H4, complete sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 11102666 | 11102666 | PRJNA924320_S_NODE_23129_length_219_cov_1.800000_g22987_i0 | PRJNA924320 | 23129 | 219 | 1.8 | 3.942 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 8.89e-11 | NTclustered | gi|813114431|ref|XM_012339984.1| | 695850 | g22987 | i0 | 94.231 | 0.698630136986301 | 52 | 3 | 24 | 0 | 99 | 150 | 951 | 900 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 153 | 80.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 12378352 | 12378352 | PRJNA924320_S_NODE_3810_length_480_cov_2.617169_g3670_i0 | PRJNA924320 | 3810 | 480 | 2.617169 | 12.5624112 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 1.2099999999999997e-52 | NTclustered | gi|2795024423|ref|XM_067938288.1| | 4785 | g3670 | i0 | 79.077 | 15.8020833333333 | 325 | 64 | 67 | 4 | 158 | 480 | 518 | 196 | Phytophthora cinnamomi 60S ribosomal protein (IUM83_13598), partial mRNA | blastn | 7585 | 220 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 12731613 | 12731613 | PRJNA924320_S_NODE_17570_length_244_cov_1.200000_g17428_i0 | PRJNA924320 | 17570 | 244 | 1.2 | 2.928 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.25e-39 | NTclustered | gi|133872858|gb|EF452181.1| | 431833 | g17428 | i0 | 79.918 | 43.9098360655738 | 244 | 45 | 99 | 4 | 1 | 242 | 262 | 503 | Phytophthora sp. H-6/02 translation elongation factor 1 alpha gene, partial cds | blastn | 10714 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. H-6/02 | ||
| 14006215 | 14006215 | PRJNA924320_S_NODE_51911_length_164_cov_0.886957_g51769_i0 | PRJNA924320 | 51911 | 164 | 0.886957 | 1.45460948 | Lagenidium | 4802 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.32e-27 | NTclustered | gi|627615088|gb|KJ506102.1| | 4803 | g51769 | i0 | 86.29 | 93.8963414634146 | 124 | 17 | 76 | 0 | 35 | 158 | 417 | 294 | Lagenidium giganteum isolate MTLA16 heat shock protein 90 (HSP90) gene, partial cds | blastn | 15399 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 14926986 | 14926986 | PRJNA924320_S_NODE_12592_length_280_cov_1.554113_g12450_i0 | PRJNA924320 | 12592 | 280 | 1.554113 | 4.3515164 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 9.02e-22 | NTclustered | gi|673039884|ref|XM_008875681.1| | 157072 | g12450 | i0 | 89.362 | 1.08571428571429 | 94 | 8 | 33 | 2 | 8 | 100 | 367 | 459 | Aphanomyces invadans 60S ribosomal protein mRNA | blastn | 304 | 117 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 16202097 | 16202097 | PRJNA924320_S_NODE_24153_length_216_cov_1.065868_g24011_i0 | PRJNA924320 | 24153 | 216 | 1.065868 | 2.30227488 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.41e-16 | NTclustered | gi|669149903|ref|XM_008612292.1| | 1156394 | g24011 | i0 | 80.137 | 1.1712962962963 | 146 | 17 | 63 | 8 | 57 | 193 | 285 | 143 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 253 | 99 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 16202289 | 16202289 | PRJNA924320_S_NODE_47393_length_166_cov_1.743590_g47251_i0 | PRJNA924320 | 47393 | 166 | 1.74359 | 2.8943594 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 6.2e-31 | NTclustered | gi|675199240|ref|XM_008910257.1| | 761204 | g47251 | i0 | 83.133 | 52.921686746988 | 166 | 22 | 100 | 3 | 1 | 166 | 831 | 990 | Phytophthora parasitica INRA-310 ATP synthase subunit beta, mitochondrial mRNA | blastn | 8785 | 147 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 17477225 | 17477225 | PRJNA924320_S_NODE_14374_length_265_cov_1.416667_g14232_i0 | PRJNA924320 | 14374 | 265 | 1.416667 | 3.75416755 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 3.0000000000000003e-31 | NTclustered | gi|675196844|ref|XM_008909059.1| | 761204 | g14232 | i0 | 79.71 | 15.788679245283 | 207 | 40 | 78 | 2 | 51 | 256 | 899 | 694 | Phytophthora parasitica INRA-310 60S ribosomal protein L3 mRNA | blastn | 4184 | 148 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 17477248 | 17477248 | PRJNA924320_S_NODE_1734_length_694_cov_4.015504_g1620_i0 | PRJNA924320 | 1734 | 694 | 4.015504 | 27.86759776 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 3e-50 | NTclustered | gi|813133999|ref|XM_012342618.1| | 695850 | g1620 | i0 | 81.89 | 3.76080691642651 | 254 | 44 | 36 | 2 | 377 | 629 | 324 | 72 | Saprolegnia parasitica CBS 223.65 ribonucleoprotein-associated protein mRNA | blastn | 2610 | 213 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 17477417 | 17477417 | PRJNA924320_S_NODE_38854_length_179_cov_2.092308_g38712_i0 | PRJNA924320 | 38854 | 179 | 2.092308 | 3.74523132 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.45e-32 | NTclustered | gi|698801103|ref|XM_009835279.1| | 112090 | g38712 | i0 | 91.818 | 71.4860335195531 | 110 | 7 | 61 | 2 | 1 | 109 | 794 | 686 | Aphanomyces astaci adenosylhomocysteinase 2 mRNA | blastn | 12796 | 152 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 17829729 | 17829729 | PRJNA924320_S_NODE_47354_length_166_cov_1.829060_g47212_i0 | PRJNA924320 | 47354 | 166 | 1.82906 | 3.0362396 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.21e-35 | NTclustered | gi|178948273|gb|EU596364.1| | 516998 | g47212 | i0 | 85.806 | 91.421686746988 | 155 | 18 | 92 | 4 | 12 | 164 | 261 | 109 | Phytophthora sp. KACC 40914 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 15176 | 161 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. KACC 40914 | ||
| 18750666 | 18750666 | PRJNA924320_S_NODE_15035_length_260_cov_1.208531_g14893_i0 | PRJNA924320 | 15035 | 260 | 1.208531 | 3.1421806 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.88e-46 | NTclustered | gi|301105358|ref|XM_002901717.1| | 403677 | g14893 | i0 | 82.251 | 22.2115384615385 | 231 | 39 | 88 | 2 | 31 | 260 | 3956 | 3727 | Phytophthora infestans T30-4 pre-mRNA-processing-splicing factor 8 (PITG_10969), partial mRNA | blastn | 5775 | 198 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 21654426 | 21654426 | PRJNA924320_S_NODE_33557_length_190_cov_2.056738_g33415_i0 | PRJNA924320 | 33557 | 190 | 2.056738 | 3.9078022 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.5099999999999998e-57 | NTclustered | gi|2795052452|ref|XM_067926699.1| | 4785 | g33415 | i0 | 88.947 | 20.1526315789474 | 190 | 21 | 100 | 0 | 1 | 190 | 353 | 164 | Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA | blastn | 3829 | 235 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 22576135 | 22576135 | PRJNA924320_S_NODE_18638_length_238_cov_1.544974_g18496_i0 | PRJNA924320 | 18638 | 238 | 1.544974 | 3.67703812 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 9.399999999999999e-41 | NTclustered | gi|301105318|ref|XM_002901697.1| | 403677 | g18496 | i0 | 80.603 | 4.95798319327731 | 232 | 45 | 97 | 0 | 1 | 232 | 1450 | 1219 | Phytophthora infestans T30-4 elongation factor 2 (PITG_10941), mRNA | blastn | 1180 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 25125095 | 25125095 | PRJNA924320_S_NODE_14680_length_262_cov_3.483568_g14538_i0 | PRJNA924320 | 14680 | 262 | 3.483568 | 9.12694816 | Halophytophthora celeris | 2874299 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 8.300000000000001e-27 | NTclustered | gi|2213903280|gb|OK091322.1| | 2874299 | g14538 | i0 | 82.895 | 45.4503816793893 | 152 | 23 | 57 | 1 | 89 | 237 | 465 | 314 | Halophytophthora sp. MHJ-2021b isolate CBS 147240 from Portugal heat shock protein 90 (hsp90) gene, partial cds | blastn | 11908 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Halophytophthora | Halophytophthora celeris | ||
| 25125223 | 25125223 | PRJNA924320_S_NODE_30700_length_197_cov_1.209459_g30558_i0 | PRJNA924320 | 30700 | 197 | 1.209459 | 2.38263423 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 4.55e-33 | NTclustered | gi|2795052452|ref|XM_067926699.1| | 4785 | g30558 | i0 | 93.269 | 48.9593908629442 | 104 | 7 | 53 | 0 | 94 | 197 | 519 | 416 | Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA | blastn | 9645 | 154 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 25125527 | 25125527 | PRJNA924320_S_NODE_7700_length_348_cov_1.474916_g7558_i0 | PRJNA924320 | 7700 | 348 | 1.474916 | 5.13270768 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|813126131|ref|XM_012341540.1| | 695850 | g7558 | i0 | 81.944 | 0.206896551724138 | 72 | 8 | 20 | 5 | 30 | 100 | 571 | 638 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 72 | 56.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica |
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);;