contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA637219" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1885005 | 1885005 | PRJNA637219_S_NODE_17702_length_156_cov_212.186916_g17657_i0 | PRJNA637219 | 17702 | 156 | 212.186916 | 331.01158896 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9e-74 | NTclustered | gi|53693101|gb|AY742752.1| | 123356 | g17657 | i0 | 100 | 100.025641025641 | 156 | 0 | 100 | 0 | 1 | 156 | 1450 | 1295 | Hyaloperonospora parasitica 18S ribosomal RNA gene, partial sequence | blastn | 15604 | 289 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 3159799 | 3159799 | PRJNA637219_S_NODE_6883_length_195_cov_67.041096_g6838_i0 | PRJNA637219 | 6883 | 195 | 67.041096 | 130.7301372 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.46e-95 | NTclustered | gi|158519323|gb|EU054883.1| | 162125 | g6838 | i0 | 100 | 100.046153846154 | 195 | 0 | 100 | 0 | 1 | 195 | 785 | 979 | Hyaloperonospora brassicae strain HV2128 (WU) large subunit ribosomal RNA gene, partial sequence | blastn | 19509 | 361 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 4436544 | 4436544 | PRJNA637219_S_NODE_3724_length_246_cov_71.974619_g3679_i0 | PRJNA637219 | 3724 | 246 | 71.974619 | 177.05756274 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4500000000000002e-123 | NTclustered | gi|33520229|gb|AY273974.1| | 162125 | g3679 | i0 | 100 | 100.451219512195 | 246 | 0 | 100 | 0 | 1 | 246 | 459 | 704 | Hyaloperonospora brassicae large subunit ribosomal RNA gene, partial sequence | blastn | 24711 | 455 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 5712503 | 5712503 | PRJNA637219_S_NODE_705_length_491_cov_101.669683_g660_i0 | PRJNA637219 | 705 | 491 | 101.669683 | 499.19814353 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 891 | 0 | NTclustered | gi|158519262|gb|EU054822.1| | 162125 | g660 | i0 | 99.389 | 99.806517311609 | 491 | 3 | 100 | 0 | 1 | 491 | 253 | 743 | Hyaloperonospora brassicae strain MG1868 (TUB 12265) large subunit ribosomal RNA gene, partial sequence | blastn | 49005 | 891 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 6987346 | 6987346 | PRJNA637219_S_NODE_266_length_688_cov_88.450704_g229_i0 | PRJNA637219 | 266 | 688 | 88.450704 | 608.54084352 | Peronospora alpicola | 230426 | SAR_Eukaryotes | SAR_Eukaryotes | 1018 | 0 | NTclustered | gi|1663822460|gb|MH730832.1| | 230426 | g229 | i0 | 93.343 | 95.3241279069767 | 691 | 42 | 100 | 3 | 1 | 688 | 821 | 132 | Peronospora alpicola voucher F0514 28S ribosomal RNA gene, partial sequence | blastn | 65583 | 1018 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora alpicola | ||
| 8261896 | 8261896 | PRJNA637219_S_NODE_1007_length_424_cov_35.202667_g962_i0 | PRJNA637219 | 1007 | 424 | 35.202667 | 149.25930808 | Phytophthora megasperma | 4788 | SAR_Eukaryotes | SAR_Eukaryotes | 678 | 0 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g962 | i0 | 96.145 | 70.1462264150943 | 415 | 16 | 98 | 0 | 10 | 424 | 3708 | 3294 | P.megasperma gene for 28S ribosomal RNA | blastn | 29742 | 678 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 9537341 | 9537341 | PRJNA637219_S_NODE_1808_length_332_cov_2.045936_g1763_i0 | PRJNA637219 | 1808 | 332 | 2.045936 | 6.79250752 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.73e-59 | NTclustered | gi|166052859|emb|CU367305.1| | 100861 | g1763 | i0 | 79.819 | 18.3192771084337 | 332 | 67 | 100 | 0 | 1 | 332 | 548 | 879 | Aphanomyces euteiches cDNA | blastn | 6082 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9537360 | 9537360 | PRJNA637219_S_NODE_4088_length_237_cov_40.276596_g4043_i0 | PRJNA637219 | 4088 | 237 | 40.276596 | 95.45553252 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 8.96e-71 | NTclustered | gi|695467755|ref|XM_009541406.1| | 67593 | g4043 | i0 | 87.967 | 98.337552742616 | 241 | 23 | 100 | 4 | 1 | 237 | 867 | 629 | Phytophthora sojae hypothetical protein mRNA | blastn | 23306 | 279 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 10083551 | 10083551 | PRJNA637219_S_NODE_1668_length_344_cov_66.379661_g1623_i0 | PRJNA637219 | 1668 | 344 | 66.379661 | 228.34603384 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 564 | 3.379999999999999e-156 | NTclustered | gi|189084007|gb|BT031523.1| | 4784 | g1623 | i0 | 98.142 | 93.6337209302326 | 323 | 6 | 94 | 0 | 1 | 323 | 1832 | 2154 | Phytophthora capsici clone CBOT29-E20 mRNA sequence | blastn | 32210 | 569 | 0.991212653778559 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 10813033 | 10813033 | PRJNA637219_S_NODE_17489_length_159_cov_56.700000_g17444_i0 | PRJNA637219 | 17489 | 159 | 56.7 | 90.153 | uncultured Hyaloperonospora | 660915 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 1.98e-75 | NTclustered | gi|254658402|gb|FJ537328.1| | 660915 | g17444 | i0 | 100 | 100 | 159 | 0 | 100 | 0 | 1 | 159 | 979 | 1137 | Uncultured Hyaloperonospora clone Biosope_T41.118 18S ribosomal RNA gene, partial sequence | blastn | 15900 | 294 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | uncultured Hyaloperonospora | ||
| 10813035 | 10813035 | PRJNA637219_S_NODE_18169_length_150_cov_83.346535_g18124_i0 | PRJNA637219 | 18169 | 150 | 83.346535 | 125.0198025 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 1.85e-70 | NTclustered | gi|53693101|gb|AY742752.1| | 123356 | g18124 | i0 | 100 | 100 | 150 | 0 | 100 | 0 | 1 | 150 | 550 | 401 | Hyaloperonospora parasitica 18S ribosomal RNA gene, partial sequence | blastn | 15000 | 278 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 12634091 | 12634091 | PRJNA637219_S_NODE_10310_length_168_cov_1.521008_g10265_i0 | PRJNA637219 | 10310 | 168 | 1.521008 | 2.55529344 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 9.81e-79 | NTclustered | gi|689595168|gb|KM068790.1| | 468623 | g10265 | i0 | 99.405 | 99.9702380952381 | 168 | 1 | 100 | 0 | 1 | 168 | 228 | 61 | Albugo lepidii isolate CA-A 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16795 | 305 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo lepidii | ||
| 13363012 | 13363012 | PRJNA637219_S_NODE_471_length_565_cov_1.649225_g428_i0 | PRJNA637219 | 471 | 565 | 1.649225 | 9.31812125 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 1.3e-127 | NTclustered | gi|669151349|ref|XM_008613015.1| | 1156394 | g428 | i0 | 83.237 | 78.6902654867257 | 519 | 79 | 91 | 6 | 51 | 565 | 734 | 1248 | Saprolegnia diclina VS20 adenosylhomocysteinase mRNA | blastn | 44460 | 470 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 13909007 | 13909007 | PRJNA637219_S_NODE_1971_length_321_cov_1.985294_g1926_i0 | PRJNA637219 | 1971 | 321 | 1.985294 | 6.37279374 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 593 | 3.9899999999999986e-165 | NTclustered | gi|158346487|gb|EU049225.1| | 162125 | g1926 | i0 | 100 | 100.102803738318 | 321 | 0 | 100 | 0 | 1 | 321 | 254 | 574 | Hyaloperonospora brassicae voucher HV2128 (WU) internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 32133 | 593 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 14637801 | 14637801 | PRJNA637219_S_NODE_832_length_461_cov_3.662621_g787_i0 | PRJNA637219 | 832 | 461 | 3.662621 | 16.88468281 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 4.08e-67 | NTclustered | gi|698822976|ref|XM_009846215.1| | 112090 | g787 | i0 | 83.505 | 56.0368763557484 | 291 | 45 | 63 | 3 | 127 | 416 | 527 | 239 | Aphanomyces astaci 40S ribosomal protein S13 mRNA | blastn | 25833 | 268 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 15911724 | 15911724 | PRJNA637219_S_NODE_9153_length_176_cov_1.055118_g9108_i0 | PRJNA637219 | 9153 | 176 | 1.055118 | 1.85700768 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.74e-71 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g9108 | i0 | 95.48 | 91.5 | 177 | 7 | 100 | 1 | 1 | 176 | 360 | 184 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 16104 | 281 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 16457753 | 16457753 | PRJNA637219_S_NODE_12173_length_166_cov_0.871795_g12128_i0 | PRJNA637219 | 12173 | 166 | 0.871795 | 1.4471797 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 4.76e-37 | NTclustered | gi|23394405|gb|AF424666.1| | 4787 | g12128 | i0 | 85.185 | 1.95180722891566 | 162 | 24 | 98 | 0 | 5 | 166 | 848 | 1009 | Phytophthora infestans clone MY-11-G-02 unknown mRNA | blastn | 324 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 16457787 | 16457787 | PRJNA637219_S_NODE_7493_length_189_cov_16.142857_g7448_i0 | PRJNA637219 | 7493 | 189 | 16.142857 | 30.50999973 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 5.14e-92 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g7448 | i0 | 100 | 100.571428571429 | 189 | 0 | 100 | 0 | 1 | 189 | 2927 | 3115 | P.megasperma gene for 28S ribosomal RNA | blastn | 19008 | 350 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 18460823 | 18460823 | PRJNA637219_S_NODE_1195_length_395_cov_1.841040_g1150_i0 | PRJNA637219 | 1195 | 395 | 1.84104 | 7.272108 | Hyaloperonospora arabidopsidis | 272952 | SAR_Eukaryotes | SAR_Eukaryotes | 665 | 0 | NTclustered | gi|2248512796|ref|NC_063789.1| | 272952 | g1150 | i0 | 96.977 | 101.212658227848 | 397 | 10 | 100 | 2 | 1 | 395 | 2288 | 1892 | Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome | blastn | 39979 | 665 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora arabidopsidis | ||
| 18460932 | 18460932 | PRJNA637219_S_NODE_3155_length_264_cov_1.358140_g3110_i0 | PRJNA637219 | 3155 | 264 | 1.35814 | 3.5854896 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.09e-20 | NTclustered | gi|695467825|ref|XM_009541424.1| | 67593 | g3110 | i0 | 87.255 | 18.0378787878788 | 102 | 10 | 38 | 3 | 165 | 264 | 313 | 413 | Phytophthora sojae hypothetical protein mRNA | blastn | 4762 | 113 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 21556953 | 21556953 | PRJNA637219_S_NODE_1617_length_348_cov_99.270903_g1572_i0 | PRJNA637219 | 1617 | 348 | 99.270903 | 345.46274244 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 643 | 4.279999999999998e-180 | NTclustered | gi|53693101|gb|AY742752.1| | 123356 | g1572 | i0 | 100 | 100.747126436782 | 348 | 0 | 100 | 0 | 1 | 348 | 24 | 371 | Hyaloperonospora parasitica 18S ribosomal RNA gene, partial sequence | blastn | 35060 | 643 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 21556961 | 21556961 | PRJNA637219_S_NODE_2757_length_279_cov_2.486957_g2712_i0 | PRJNA637219 | 2757 | 279 | 2.486957 | 6.93861003 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 3.55e-135 | NTclustered | gi|2314988977|ref|NC_067074.1| | 78237 | g2712 | i0 | 98.566 | 99.9964157706093 | 279 | 4 | 100 | 0 | 1 | 279 | 37484 | 37206 | Phytophthora gonapodyides voucher P7050 mitochondrion, complete genome | blastn | 27899 | 494 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora gonapodyides | ||
| 22285827 | 22285827 | PRJNA637219_S_NODE_1338_length_377_cov_121.134146_g1293_i0 | PRJNA637219 | 1338 | 377 | 121.134146 | 456.67573042 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 669 | 0 | NTclustered | gi|53693101|gb|AY742752.1| | 123356 | g1293 | i0 | 98.674 | 100.705570291777 | 377 | 5 | 100 | 0 | 1 | 377 | 588 | 964 | Hyaloperonospora parasitica 18S ribosomal RNA gene, partial sequence | blastn | 37966 | 669 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 22832461 | 22832461 | PRJNA637219_S_NODE_1898_length_325_cov_173.547101_g1853_i0 | PRJNA637219 | 1898 | 325 | 173.547101 | 564.02807825 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 577 | 4.069999999999999e-160 | NTclustered | gi|158519366|gb|EU054926.1| | 123356 | g1853 | i0 | 98.765 | 92.3876923076923 | 324 | 4 | 99 | 0 | 2 | 325 | 335 | 12 | Hyaloperonospora parasitica strain GG156 (MA) large subunit ribosomal RNA gene, partial sequence | blastn | 30026 | 577 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 23561444 | 23561444 | PRJNA637219_S_NODE_4079_length_238_cov_1.169312_g4034_i0 | PRJNA637219 | 4079 | 238 | 1.169312 | 2.78296256 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.1899999999999999e-54 | NTclustered | gi|675185100|ref|XM_008903187.1| | 761204 | g4034 | i0 | 84.889 | 90.4327731092437 | 225 | 32 | 94 | 2 | 7 | 230 | 1506 | 1283 | Phytophthora parasitica INRA-310 luminal-binding protein mRNA | blastn | 21523 | 226 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 25381409 | 25381409 | PRJNA637219_S_NODE_11460_length_166_cov_1.128205_g11415_i0 | PRJNA637219 | 11460 | 166 | 1.128205 | 1.8728203 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 8.13e-20 | NTclustered | gi|156986979|gb|EU080348.1| | 445398 | g11415 | i0 | 85.577 | 63.0481927710843 | 104 | 15 | 63 | 0 | 12 | 115 | 353 | 456 | Phytophthora sulawesiensis isolate PD_01297(P6306) heat shock protein 90 (HSP90) gene, partial cds | blastn | 10466 | 110 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sulawesiensis |
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);;