contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA874604" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 851388 | 851388 | PRJNA874604_P_NODE_13881_length_469_cov_1.646465_g13529_i0 | PRJNA874604 | 13881 | 469 | 1.646465 | 7.72192085 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 5.42e-61 | NTclustered | gi|698791735|ref|XM_009830598.1| | 112090 | g13529 | i0 | 79.508 | 29.319829424307 | 366 | 62 | 76 | 11 | 4 | 361 | 194 | 554 | Aphanomyces astaci malate dehydrogenase, NAD-dependent mRNA | blastn | 13751 | 248 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 852061 | 852061 | PRJNA874604_P_NODE_51681_length_281_cov_1.336538_g51329_i0 | PRJNA874604 | 51681 | 281 | 1.336538 | 3.75567178 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 3.33e-6 | NTclustered | gi|7274153|gb|AF063106.1|AF063106 | 4766 | g51329 | i0 | 95.122 | 2.34875444839858 | 41 | 2 | 15 | 0 | 1 | 41 | 956 | 996 | Achlya bisexualis glyceraldehyde-3-phosphate dehydrogenase (GapC1) mRNA, complete cds | blastn | 660 | 65.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 1238103 | 1238103 | PRJNA874604_P_NODE_57961_length_269_cov_2.346939_g57609_i0 | PRJNA874604 | 57961 | 269 | 2.346939 | 6.31326591 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.11e-25 | NTclustered | gi|698807045|ref|XM_009838250.1| | 112090 | g57609 | i0 | 81.761 | 1.63568773234201 | 159 | 25 | 58 | 4 | 3 | 159 | 360 | 516 | Aphanomyces astaci 60S ribosomal protein mRNA | blastn | 440 | 130 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 3789835 | 3789835 | PRJNA874604_P_NODE_36223_length_321_cov_1.241935_g35871_i0 | PRJNA874604 | 36223 | 321 | 1.241935 | 3.98661135 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 2.09e-78 | NTclustered | gi|695434207|ref|XM_009533074.1| | 67593 | g35871 | i0 | 85.714 | 48.7227414330218 | 294 | 36 | 91 | 6 | 30 | 320 | 1 | 291 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 15640 | 305 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 4679995 | 4679995 | PRJNA874604_P_NODE_28244_length_352_cov_2.537634_g27892_i0 | PRJNA874604 | 28244 | 352 | 2.537634 | 8.93247168 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 1.12e-46 | NTclustered | gi|669170408|ref|XM_008622331.1| | 1156394 | g27892 | i0 | 84.058 | 46.9346590909091 | 207 | 33 | 59 | 0 | 2 | 208 | 277 | 483 | Saprolegnia diclina VS20 40S ribosomal protein S23 mRNA | blastn | 16521 | 200 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 4680197 | 4680197 | PRJNA874604_P_NODE_39584_length_310_cov_2.206751_g39232_i0 | PRJNA874604 | 39584 | 310 | 2.206751 | 6.8409281 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 6.989999999999998e-103 | NTclustered | gi|675199806|ref|XM_008910540.1| | 761204 | g39232 | i0 | 91.727 | 89.5967741935484 | 278 | 23 | 90 | 0 | 1 | 278 | 308 | 585 | Phytophthora parasitica INRA-310 calmodulin mRNA | blastn | 27775 | 387 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 4681306 | 4681306 | PRJNA874604_P_NODE_94864_length_242_cov_1.822485_g94512_i0 | PRJNA874604 | 94864 | 242 | 1.822485 | 4.4104137 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.6399999999999998e-23 | NTclustered | gi|2795047393|ref|XM_067937896.1| | 4785 | g94512 | i0 | 87.156 | 1.23553719008264 | 109 | 12 | 45 | 2 | 48 | 155 | 10 | 117 | Phytophthora cinnamomi Nucleoside diphosphate kinase B (IUM83_13233), partial mRNA | blastn | 299 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 7230232 | 7230232 | PRJNA874604_P_NODE_52426_length_279_cov_2.830097_g52074_i0 | PRJNA874604 | 52426 | 279 | 2.830097 | 7.89597063 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.46e-39 | NTclustered | gi|2794908691|ref|XM_067890661.1| | 164328 | g52074 | i0 | 81.333 | 5.58781362007168 | 225 | 35 | 79 | 5 | 20 | 239 | 223 | 1 | Phytophthora ramorum 40S ribosomal protein S25 (KRP23_5578), partial mRNA | blastn | 1559 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 8504793 | 8504793 | PRJNA874604_P_NODE_40687_length_307_cov_1.683761_g40335_i0 | PRJNA874604 | 40687 | 307 | 1.683761 | 5.16914627 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.66e-24 | NTclustered | gi|2795027745|ref|XM_067926220.1| | 4785 | g40335 | i0 | 81.935 | 1.79153094462541 | 155 | 23 | 49 | 4 | 156 | 306 | 118 | 271 | Phytophthora cinnamomi 40S ribosomal protein S2 (IUM83_02311), partial mRNA | blastn | 550 | 126 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9779321 | 9779321 | PRJNA874604_P_NODE_20468_length_400_cov_0.941896_g20116_i0 | PRJNA874604 | 20468 | 400 | 0.941896 | 3.767584 | Phytophthora thermophila | 880414 | SAR_Eukaryotes | SAR_Eukaryotes | 353 | 9.38e-93 | NTclustered | gi|310770349|gb|HQ012916.1| | 880414 | g20116 | i0 | 83 | 98.0575 | 400 | 58 | 98 | 8 | 7 | 398 | 983 | 586 | Phytophthora thermophila strain CBS 127954 heat shock protein 90 (HSP90) gene, partial cds | blastn | 39223 | 353 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora thermophila | ||
| 10166665 | 10166665 | PRJNA874604_P_NODE_57348_length_271_cov_1.106061_g56996_i0 | PRJNA874604 | 57348 | 271 | 1.106061 | 2.99742531 | Bigyra | 2683628 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 2.2199999999999995e-82 | NTclustered | gi|538261478|gb|JX999125.1| | 135482 | g56996 | i0 | 88.06 | 98.4391143911439 | 268 | 32 | 99 | 0 | 1 | 268 | 315 | 582 | Lagenidium humanum strain ATCC 76726 beta-tubulin gene, partial cds | blastn | 26677 | 318 | 1 | Eukaryota | Sar | Oomycota | Myzocytiopsidales | Myzocytiopsidaceae | Myzocytiopsis | Myzocytiopsis humana | |||
| 11055100 | 11055100 | PRJNA874604_P_NODE_14449_length_461_cov_1.659794_g14097_i0 | PRJNA874604 | 14449 | 461 | 1.659794 | 7.65165034 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 8.84e-64 | NTclustered | gi|673014017|ref|XM_008862748.1| | 157072 | g14097 | i0 | 81.505 | 22.6182212581345 | 319 | 53 | 69 | 5 | 88 | 403 | 480 | 165 | Aphanomyces invadans archaeal ribosomal protein S17P mRNA | blastn | 10427 | 257 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 11441991 | 11441991 | PRJNA874604_P_NODE_76829_length_249_cov_0.875000_g76477_i0 | PRJNA874604 | 76829 | 249 | 0.875 | 2.17875 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 7.29e-77 | NTclustered | gi|1233048380|gb|KX251078.1| | 1642459 | g76477 | i0 | 88.4 | 97.3694779116466 | 250 | 27 | 100 | 2 | 1 | 249 | 264 | 16 | Phytophthora agathidicida isolate 67D5(ex-type) translation elongation factor 1-alpha gene, partial cds | blastn | 24245 | 300 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora agathidicida | ||
| 13605390 | 13605390 | PRJNA874604_P_NODE_34791_length_326_cov_1.217391_g34439_i0 | PRJNA874604 | 34791 | 326 | 1.217391 | 3.96869466 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 7.94e-53 | NTclustered | gi|2794922612|ref|XM_067881576.1| | 164328 | g34439 | i0 | 80.333 | 3.34969325153374 | 300 | 51 | 91 | 7 | 9 | 304 | 314 | 19 | Phytophthora ramorum 40S ribosomal protein S3-1 (KRP23_11061), partial mRNA | blastn | 1092 | 220 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 14879346 | 14879346 | PRJNA874604_P_NODE_11892_length_500_cov_3.175644_g11541_i0 | PRJNA874604 | 11892 | 500 | 3.175644 | 15.87822 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 6.659999999999998e-145 | NTclustered | gi|166303|gb|J05116.1|ACKCAL | 4767 | g11541 | i0 | 87.665 | 87.8 | 454 | 54 | 91 | 2 | 32 | 484 | 945 | 493 | A.klebsiana calmodulin gene, complete cds | blastn | 43900 | 527 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 16540906 | 16540906 | PRJNA874604_P_NODE_88513_length_245_cov_0.895349_g88161_i0 | PRJNA874604 | 88513 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.6e-48 | NTclustered | gi|2794914530|ref|XM_067892428.1| | 164328 | g88161 | i0 | 82.553 | 27.4285714285714 | 235 | 39 | 96 | 2 | 12 | 245 | 3939 | 3706 | Phytophthora ramorum Serine/threonine-protein phosphatase 5 (KRP23_7150), partial mRNA | blastn | 6720 | 206 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 19978448 | 19978448 | PRJNA874604_P_NODE_38776_length_313_cov_1.250000_g38424_i0 | PRJNA874604 | 38776 | 313 | 1.25 | 3.9125 | Pythium sp. 'quercum' | 403825 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 9.4e-82 | NTclustered | gi|114865163|gb|DQ911408.1| | 403825 | g38424 | i0 | 85.161 | 87.2779552715655 | 310 | 44 | 99 | 2 | 1 | 309 | 237 | 545 | Pythium sp. quercum strain OW340 clone 2 translation elongation factor 1-alpha gene, partial cds | blastn | 27318 | 316 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium sp. 'quercum' | ||
| 19978726 | 19978726 | PRJNA874604_P_NODE_52416_length_279_cov_3.296117_g52064_i0 | PRJNA874604 | 52416 | 279 | 3.296117 | 9.19616643 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 4.0899999999999995e-35 | NTclustered | gi|698822200|ref|XM_009845827.1| | 112090 | g52064 | i0 | 81.095 | 32.3297491039427 | 201 | 38 | 72 | 0 | 69 | 269 | 551 | 351 | Aphanomyces astaci peptidyl-prolyl cis-trans isomerase 1 mRNA | blastn | 9020 | 161 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21253480 | 21253480 | PRJNA874604_P_NODE_15517_length_447_cov_1.647059_g15165_i0 | PRJNA874604 | 15517 | 447 | 1.647059 | 7.36235373 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 3.07e-63 | NTclustered | gi|675207712|ref|XM_008914493.1| | 761204 | g15165 | i0 | 79.515 | 84.8881431767338 | 371 | 66 | 82 | 8 | 78 | 443 | 28 | 393 | Phytophthora parasitica INRA-310 hsp70-like protein partial mRNA | blastn | 37945 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 21254605 | 21254605 | PRJNA874604_P_NODE_76837_length_249_cov_0.869318_g76485_i0 | PRJNA874604 | 76837 | 249 | 0.869318 | 2.16460182 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|2794926232|ref|XM_067883499.1| | 164328 | g76485 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 217 | 244 | 491 | 464 | Phytophthora ramorum Coiled-coil domain-containing protein 6 (KRP23_12857), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 21254702 | 21254702 | PRJNA874604_P_NODE_82057_length_247_cov_0.885057_g81705_i0 | PRJNA874604 | 82057 | 247 | 0.885057 | 2.18609079 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 7.750000000000001e-27 | NTclustered | gi|187467965|emb|CU694539.4| | 123356 | g81705 | i0 | 95.238 | 34.8947368421053 | 84 | 4 | 34 | 0 | 158 | 241 | 56337 | 56254 | H.parasitica DNA sequence from clone HpEmoy2-1B11, complete sequence | blastn | 8619 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 21640254 | 21640254 | PRJNA874604_P_NODE_63897_length_259_cov_1.397849_g63545_i0 | PRJNA874604 | 63897 | 259 | 1.397849 | 3.6204289099999998 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.36e-29 | NTclustered | gi|813164367|ref|XM_012347854.1| | 695850 | g63545 | i0 | 77.459 | 1.88416988416988 | 244 | 51 | 93 | 4 | 16 | 257 | 331 | 90 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L37-A mRNA | blastn | 488 | 143 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 22528549 | 22528549 | PRJNA874604_P_NODE_40138_length_309_cov_1.279661_g39786_i0 | PRJNA874604 | 40138 | 309 | 1.279661 | 3.95415249 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 6.07e-19 | NTclustered | gi|813156599|ref|XM_012346259.1| | 695850 | g39786 | i0 | 88.043 | 1.13915857605178 | 92 | 10 | 30 | 1 | 87 | 178 | 313 | 403 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 352 | 108 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 22529219 | 22529219 | PRJNA874604_P_NODE_74498_length_249_cov_1.312500_g74146_i0 | PRJNA874604 | 74498 | 249 | 1.3125 | 3.268125 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 4.709999999999999e-24 | NTclustered | gi|2795017041|ref|XM_067930511.1| | 4785 | g74146 | i0 | 90.426 | 26.3534136546185 | 94 | 9 | 38 | 0 | 156 | 249 | 369 | 462 | Phytophthora cinnamomi papain-like cysteine protease C1 (IUM83_06316), partial mRNA | blastn | 6562 | 124 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 22915536 | 22915536 | PRJNA874604_P_NODE_27758_length_355_cov_1.049645_g27406_i0 | PRJNA874604 | 27758 | 355 | 1.049645 | 3.72623975 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 5.2e-55 | NTclustered | gi|813141930|ref|XM_012343733.1| | 695850 | g27406 | i0 | 80.612 | 3.34366197183099 | 294 | 57 | 83 | 0 | 60 | 353 | 13 | 306 | Saprolegnia parasitica CBS 223.65 serine/threonine protein kinase mRNA | blastn | 1187 | 228 | 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);;