contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA940501" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 917450 | 917450 | PRJNA940501_S_NODE_107821_length_233_cov_1.431579_g107003_i0 | PRJNA940501 | 107821 | 233 | 1.431579 | 3.33557907 | Nothophytophthora sp. | 2853999 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|2240249467|gb|MW648547.1| | 2853999 | g107003 | i0 | 96.774 | 0.133047210300429 | 31 | 1 | 13 | 0 | 51 | 81 | 6788 | 6818 | Nothophytophthora sp. culture ICMP:18719 mitochondrion, complete genome | blastn | 31 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. | ||
| 921640 | 921640 | PRJNA940501_S_NODE_5941_length_614_cov_26.684764_g5282_i0 | PRJNA940501 | 5941 | 614 | 26.684764 | 163.84445096 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 7.13e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g5282 | i0 | 80.533 | 55.0944625407166 | 375 | 65 | 60 | 4 | 54 | 421 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 922149 | 922149 | PRJNA940501_S_NODE_88561_length_246_cov_1.546798_g87743_i0 | PRJNA940501 | 88561 | 246 | 1.546798 | 3.80512308 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 2.77e-26 | NTclustered | gi|2795049776|ref|XM_067938656.1| | 4785 | g87743 | i0 | 84.173 | 1.1219512195122 | 139 | 18 | 56 | 4 | 110 | 246 | 229 | 365 | Phytophthora cinnamomi polyadenylate-binding protein 1-B (IUM83_13951), partial mRNA | blastn | 276 | 132 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 1258358 | 1258358 | PRJNA940501_S_NODE_6541_length_579_cov_23.662313_g5849_i0 | PRJNA940501 | 6541 | 579 | 23.662313 | 137.00479227 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 8.13e-115 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g5849 | i0 | 86.216 | 66.4490500863558 | 399 | 50 | 69 | 4 | 26 | 422 | 88 | 483 | Pythium splendens calmodulin mRNA, complete cds | blastn | 38474 | 431 | 0.990719257540603 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 5085454 | 5085454 | PRJNA940501_S_NODE_114084_length_229_cov_1.897849_g113266_i0 | PRJNA940501 | 114084 | 229 | 1.897849 | 4.34607421 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.3e-25 | NTclustered | gi|698807045|ref|XM_009838250.1| | 112090 | g113266 | i0 | 81.646 | 1.91266375545852 | 158 | 25 | 68 | 4 | 23 | 178 | 361 | 516 | Aphanomyces astaci 60S ribosomal protein mRNA | blastn | 438 | 128 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 7299540 | 7299540 | PRJNA940501_S_NODE_46206_length_290_cov_4.421053_g45388_i0 | PRJNA940501 | 46206 | 290 | 4.421053 | 12.8210537 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.9299999999999999e-53 | NTclustered | gi|813141452|ref|XM_012343573.1| | 695850 | g45388 | i0 | 82.677 | 18.1275862068966 | 254 | 41 | 87 | 3 | 12 | 264 | 767 | 516 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L8 mRNA | blastn | 5257 | 222 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 7636192 | 7636192 | PRJNA940501_S_NODE_322326_length_163_cov_1.175000_g321508_i0 | PRJNA940501 | 322326 | 163 | 1.175 | 1.91525 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|698812251|ref|XM_009840853.1| | 112090 | g321508 | i0 | 100 | 0.398773006134969 | 28 | 0 | 17 | 0 | 21 | 48 | 210 | 183 | Aphanomyces astaci hypothetical protein partial mRNA | blastn | 65 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 7636465 | 7636465 | PRJNA940501_S_NODE_5026_length_686_cov_6.930016_g4456_i0 | PRJNA940501 | 5026 | 686 | 6.930016 | 47.53990976 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 7.85e-86 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g4456 | i0 | 85.942 | 42.8877551020408 | 313 | 40 | 45 | 2 | 1 | 310 | 1231 | 1542 | A.klebsiana beta-tubulin gene, complete cds | blastn | 29421 | 333 | 0.993993993993994 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 9849751 | 9849751 | PRJNA940501_S_NODE_6168_length_600_cov_3.278276_g5494_i0 | PRJNA940501 | 6168 | 600 | 3.278276 | 19.669656 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 5.3e-82 | NTclustered | gi|2248513156|ref|NC_063798.1| | 325452 | g5494 | i0 | 80 | 60.4216666666667 | 435 | 83 | 72 | 4 | 168 | 600 | 19707 | 20139 | Phytophthora kernoviae isolate 00844/4 mitochondrion, complete genome | blastn | 36253 | 318 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 10185858 | 10185858 | PRJNA940501_S_NODE_11568_length_440_cov_4.209068_g10762_i0 | PRJNA940501 | 11568 | 440 | 4.209068 | 18.5198992 | root | 1 | Root_unresolved | Root_unresolved | 206 | 3.0899999999999996e-48 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g10762 | i0 | 79.461 | 57.9159090909091 | 297 | 55 | 67 | 6 | 138 | 431 | 15280 | 15573 | Saprolegnia ferax mitochondrion, complete genome | blastn | 25483 | 206 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 12401208 | 12401208 | PRJNA940501_S_NODE_80150_length_252_cov_3.928230_g79332_i0 | PRJNA940501 | 80150 | 252 | 3.92823 | 9.8991396 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 8.05e-17 | NTclustered | gi|675165376|ref|XM_008893325.1| | 761204 | g79332 | i0 | 95.312 | 20.297619047619 | 64 | 1 | 25 | 2 | 67 | 129 | 638 | 700 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 5115 | 100 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 13672090 | 13672090 | PRJNA940501_S_NODE_162011_length_206_cov_2.171779_g161193_i0 | PRJNA940501 | 162011 | 206 | 2.171779 | 4.47386474 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 3.76e-24 | NTclustered | gi|675192356|ref|XM_008906815.1| | 761204 | g161193 | i0 | 89.691 | 45.3495145631068 | 97 | 10 | 47 | 0 | 65 | 161 | 320 | 416 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 9342 | 124 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 13673991 | 13673991 | PRJNA940501_S_NODE_29431_length_326_cov_2.155477_g28613_i0 | PRJNA940501 | 29431 | 326 | 2.155477 | 7.02685502 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 7.94e-53 | NTclustered | gi|1111669769|ref|NC_032052.1| | 157072 | g28613 | i0 | 84.211 | 51.0276073619632 | 228 | 34 | 70 | 2 | 2 | 228 | 9533 | 9307 | Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome | blastn | 16635 | 220 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 14950190 | 14950190 | PRJNA940501_S_NODE_92232_length_243_cov_2.380000_g91414_i0 | PRJNA940501 | 92232 | 243 | 2.38 | 5.7834 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 7.14e-72 | NTclustered | gi|1780534031|gb|MK753001.1| | 2052683 | g91414 | i0 | 87.654 | 84.7654320987654 | 243 | 30 | 100 | 0 | 1 | 243 | 320 | 78 | Globisporangium ultimum var. ultimum isolate KSSO_5-45 beta-tubulin mRNA, complete cds | blastn | 20598 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 16223951 | 16223951 | PRJNA940501_S_NODE_3673_length_904_cov_4.743322_g3270_i0 | PRJNA940501 | 3673 | 904 | 4.743322 | 42.87963088 | Achlya ambisexualis | 4768 | SAR_Eukaryotes | SAR_Eukaryotes | 547 | 9.549999999999997e-151 | NTclustered | gi|22086552|gb|AF402101.1| | 4768 | g3270 | i0 | 78.035 | 82.212389380531 | 906 | 174 | 99 | 19 | 10 | 904 | 648 | 1539 | Achlya ambisexualis isolate JS855 heat shock protein Hsp90 mRNA, complete cds | blastn | 74320 | 547 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya ambisexualis | ||
| 17498864 | 17498864 | PRJNA940501_S_NODE_324814_length_162_cov_1.579832_g323996_i0 | PRJNA940501 | 324814 | 162 | 1.579832 | 2.55932784 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 2.84e-19 | NTclustered | gi|328802538|emb|FR832890.1| | 890382 | g323996 | i0 | 82.54 | 0.777777777777778 | 126 | 19 | 77 | 3 | 36 | 160 | 2030 | 1907 | Albugo laibachii Nc14, mitochondrial genomic contig NODE_36_length_2553_cov_1396.121460 | blastn | 126 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 18769908 | 18769908 | PRJNA940501_S_NODE_145475_length_213_cov_2.441176_g144657_i0 | PRJNA940501 | 145475 | 213 | 2.441176 | 5.19970488 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 3.92e-24 | NTclustered | gi|166303|gb|J05116.1|ACKCAL | 4767 | g144657 | i0 | 91.209 | 7.8075117370892 | 91 | 8 | 43 | 0 | 123 | 213 | 948 | 858 | A.klebsiana calmodulin gene, complete cds | blastn | 1663 | 124 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 18770436 | 18770436 | PRJNA940501_S_NODE_179955_length_200_cov_0.898089_g179137_i0 | PRJNA940501 | 179955 | 200 | 0.898089 | 1.796178 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 9.95e-35 | NTclustered | gi|675183624|ref|XM_008902449.1| | 761204 | g179137 | i0 | 81.675 | 26.075 | 191 | 35 | 96 | 0 | 9 | 199 | 440 | 250 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 5215 | 159 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 21323344 | 21323344 | PRJNA940501_S_NODE_39477_length_302_cov_2.853282_g38659_i0 | PRJNA940501 | 39477 | 302 | 2.853282 | 8.61691164 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.98e-68 | NTclustered | gi|166044823|emb|CU351082.1| | 100861 | g38659 | i0 | 86.166 | 63.1258278145695 | 253 | 33 | 83 | 2 | 44 | 295 | 401 | 150 | Aphanomyces euteiches cDNA | blastn | 19064 | 272 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22594538 | 22594538 | PRJNA940501_S_NODE_10818_length_453_cov_3.834146_g10015_i0 | PRJNA940501 | 10818 | 453 | 3.834146 | 17.36868138 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 5.44e-31 | NTclustered | gi|675185160|ref|XM_008903217.1| | 761204 | g10015 | i0 | 83.648 | 0.695364238410596 | 159 | 25 | 35 | 1 | 250 | 407 | 648 | 490 | Phytophthora parasitica INRA-310 ubiquitin-conjugating enzyme E2-16 kDa mRNA | blastn | 315 | 148 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 22594838 | 22594838 | PRJNA940501_S_NODE_128238_length_222_cov_1.050279_g127420_i0 | PRJNA940501 | 128238 | 222 | 1.050279 | 2.33161938 | Nothophytophthora intricata | 2025991 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 4.0599999999999986e-34 | NTclustered | gi|2499019119|gb|OQ605407.1| | 2025991 | g127420 | i0 | 81.579 | 20.1081081081081 | 190 | 35 | 86 | 0 | 9 | 198 | 417 | 606 | Nothophytophthora intricata isolate TJ275 cytochrome oxidase subunit II (cox2) gene, partial cds; hypothetical protein (orf32) gene, complete cds; and cytochrome oxidase subunit I (coxI) gene, partial cds; mitochondrial | blastn | 4464 | 158 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora intricata | ||
| 22599042 | 22599042 | PRJNA940501_S_NODE_79098_length_253_cov_2.757143_g78280_i0 | PRJNA940501 | 79098 | 253 | 2.757143 | 6.97557179 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.71e-25 | NTclustered | gi|698820854|ref|XM_009845154.1| | 112090 | g78280 | i0 | 80.702 | 2.53754940711462 | 171 | 28 | 66 | 4 | 72 | 238 | 288 | 119 | Aphanomyces astaci hypothetical protein mRNA | blastn | 642 | 128 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 25145254 | 25145254 | PRJNA940501_S_NODE_202900_length_192_cov_1.422819_g202082_i0 | PRJNA940501 | 202900 | 192 | 1.422819 | 2.73181248 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.017 | NTclustered | gi|1378147635|ref|XM_024722424.1| | 4781 | g202082 | i0 | 100 | 0.145833333333333 | 28 | 0 | 15 | 0 | 17 | 44 | 1578 | 1605 | Plasmopara halstedii Zinc finger, BED-type predicted (PHALS_04585), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 25147652 | 25147652 | PRJNA940501_S_NODE_4680_length_726_cov_8.071742_g4147_i0 | PRJNA940501 | 4680 | 726 | 8.071742 | 58.60084692 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 2.47e-41 | NTclustered | gi|1490229970|gb|MH094138.1| | 29920 | g4147 | i0 | 90.141 | 19.9889807162534 | 142 | 12 | 20 | 2 | 565 | 706 | 675 | 536 | Phytophthora cactorum isolate KRJ1 ATP synthase protein 9 (atp9) gene, partial cds; NADH dehydrogenase subunit 9 (nad9) gene, complete cds; and apocytochrome b (cob) gene, partial cds; mitochondrial | blastn | 14512 | 183 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum |
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);;