contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924808 | 924808 | PRJNA944406_P_NODE_6641_length_492_cov_7.940334_g5685_i0 | PRJNA944406 | 6641 | 492 | 7.940334 | 39.06644328 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 821 | 0 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g5685 | i0 | 96.939 | 96.9959349593496 | 490 | 14 | 99 | 1 | 3 | 492 | 509 | 21 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 47722 | 821 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 2199533 | 2199533 | PRJNA944406_P_NODE_112402_length_230_cov_2.382166_g111443_i0 | PRJNA944406 | 112402 | 230 | 2.382166 | 5.4789818 | Phytophthora pinifolia | 538568 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.49e-46 | NTclustered | gi|1434829014|gb|MH493999.1| | 538568 | g111443 | i0 | 82.533 | 51.5913043478261 | 229 | 36 | 99 | 4 | 4 | 230 | 370 | 144 | Phytophthora pinifolia strain ex-type CPHST BL 49 beta-tubulin gene, partial cds | blastn | 11866 | 198 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora pinifolia | ||
| 2199943 | 2199943 | PRJNA944406_P_NODE_44922_length_268_cov_1.333333_g43963_i0 | PRJNA944406 | 44922 | 268 | 1.333333 | 3.57333244 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 2.06e-127 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g43963 | i0 | 98.134 | 1.51492537313433 | 268 | 5 | 100 | 0 | 1 | 268 | 1104 | 837 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 406 | 468 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7302238 | 7302238 | PRJNA944406_P_NODE_111726_length_233_cov_9.162500_g110767_i0 | PRJNA944406 | 111726 | 233 | 9.1625 | 21.348625 | Peronospora arvensis | 162115 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 2.2899999999999996e-116 | NTclustered | gi|33520212|gb|AY273957.1| | 162115 | g110767 | i0 | 100 | 100.064377682403 | 233 | 0 | 100 | 0 | 1 | 233 | 742 | 510 | Peronospora arvensis large subunit ribosomal RNA gene, partial sequence | blastn | 23315 | 431 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora arvensis | ||
| 8577790 | 8577790 | PRJNA944406_P_NODE_73827_length_249_cov_0.875000_g72868_i0 | PRJNA944406 | 73827 | 249 | 0.875 | 2.17875 | Phytophthora agathidicida | 1642459 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|2046503726|tpg|BK014403.1| | 1642459 | g72868 | i0 | 100 | 1.79919678714859 | 28 | 0 | 11 | 0 | 156 | 183 | 5679 | 5652 | TPA_asm: Phytophthora agathidicida mitochondrion, complete genome | blastn | 448 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora agathidicida | ||
| 8912136 | 8912136 | PRJNA944406_P_NODE_112447_length_229_cov_3.634615_g111488_i0 | PRJNA944406 | 112447 | 229 | 3.634615 | 8.32326835 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 2.36e-81 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g111488 | i0 | 91.379 | 85.2445414847162 | 232 | 17 | 100 | 2 | 1 | 229 | 3623 | 3392 | P.megasperma gene for 28S ribosomal RNA | blastn | 19521 | 315 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 8912148 | 8912148 | PRJNA944406_P_NODE_12227_length_360_cov_7.222997_g11268_i0 | PRJNA944406 | 12227 | 360 | 7.222997 | 26.0027892 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 582 | 9.779999999999996e-162 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g11268 | i0 | 95.856 | 99.7138888888889 | 362 | 12 | 100 | 3 | 1 | 360 | 3065 | 2705 | P.megasperma gene for 28S ribosomal RNA | blastn | 35897 | 582 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 8912165 | 8912165 | PRJNA944406_P_NODE_16087_length_321_cov_3.342742_g15128_i0 | PRJNA944406 | 16087 | 321 | 3.342742 | 10.73020182 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.9399999999999996e-133 | NTclustered | gi|58202010|gb|AY898628.1| | 4787 | g15128 | i0 | 94.099 | 100.171339563863 | 322 | 18 | 100 | 1 | 1 | 321 | 8242 | 8563 | Phytophthora infestans haplotype IIb mitochondrion, complete genome | blastn | 32155 | 488 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 10188253 | 10188253 | PRJNA944406_P_NODE_6948_length_480_cov_1.250614_g5992_i0 | PRJNA944406 | 6948 | 480 | 1.250614 | 6.0029472 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 832 | 0 | NTclustered | gi|2314988938|ref|NC_067073.1| | 89334 | g5992 | i0 | 97.917 | 100.995833333333 | 480 | 10 | 100 | 0 | 1 | 480 | 32251 | 32730 | Phytophthora clandestina voucher P3942 mitochondrion, complete genome | blastn | 48478 | 837 | 0.994026284348865 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora clandestina | ||
| 11128642 | 11128642 | PRJNA944406_P_NODE_83029_length_247_cov_0.885057_g82070_i0 | PRJNA944406 | 83029 | 247 | 0.885057 | 2.18609079 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 5.87e-43 | NTclustered | gi|325194852|emb|FR825649.1| | 890382 | g82070 | i0 | 91.791 | 1.34817813765182 | 134 | 11 | 54 | 0 | 114 | 247 | 680 | 547 | Albugo laibachii Nc14, genomic contig CONTIG_2615_NC14_v4_682_163 | blastn | 333 | 187 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 12404206 | 12404206 | PRJNA944406_P_NODE_93490_length_244_cov_1.649123_g92531_i0 | PRJNA944406 | 93490 | 244 | 1.649123 | 4.02386012 | Plectospira myriandra | 100863 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.57e-29 | NTclustered | gi|34329028|gb|AY292379.1| | 100863 | g92531 | i0 | 81.765 | 32.9836065573771 | 170 | 29 | 69 | 2 | 31 | 199 | 590 | 422 | Plectospira myriandra glyceraldehyde-3-phosphate dehydrogenase (GAPDH) gene, partial cds | blastn | 8048 | 141 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Plectospira | Plectospira myriandra | ||
| 12738960 | 12738960 | PRJNA944406_P_NODE_78870_length_248_cov_0.880000_g77911_i0 | PRJNA944406 | 78870 | 248 | 0.88 | 2.1824 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 6.19e-8 | NTclustered | gi|698818146|ref|XM_009843800.1| | 112090 | g77911 | i0 | 95.455 | 0.354838709677419 | 44 | 2 | 18 | 0 | 3 | 46 | 270 | 313 | Aphanomyces astaci 40S ribosomal protein S27-like protein mRNA | blastn | 88 | 71.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 15287242 | 15287242 | PRJNA944406_P_NODE_111192_length_236_cov_2.822086_g110233_i0 | PRJNA944406 | 111192 | 236 | 2.822086 | 6.66012296 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 4.999999999999999e-118 | NTclustered | gi|1663822467|gb|MH730839.1| | 120572 | g110233 | i0 | 100 | 99.978813559322 | 236 | 0 | 100 | 0 | 1 | 236 | 1031 | 796 | Peronospora bulbocapni voucher GLM64102 28S ribosomal RNA gene, partial sequence | blastn | 23595 | 436 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora bulbocapni | ||
| 18776051 | 18776051 | PRJNA944406_P_NODE_20115_length_294_cov_3.529412_g19156_i0 | PRJNA944406 | 20115 | 294 | 3.529412 | 10.37647128 | Peronospora effusa | 542832 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.7800000000000002e-123 | NTclustered | gi|1534885766|gb|MH142315.1| | 542832 | g19156 | i0 | 94.576 | 99.2040816326531 | 295 | 15 | 100 | 1 | 1 | 294 | 5403 | 5697 | Peronospora effusa isolate R13 mitochondrion, complete genome | blastn | 29166 | 455 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 20385600 | 20385600 | PRJNA944406_P_NODE_10856_length_378_cov_29.868852_g9897_i0 | PRJNA944406 | 10856 | 378 | 29.868852 | 112.90426056 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 678 | 0 | NTclustered | gi|189084716|gb|BT032234.1| | 4784 | g9897 | i0 | 99.204 | 99.7089947089947 | 377 | 2 | 99 | 1 | 3 | 378 | 1 | 377 | Phytophthora capsici clone CBOT157-J12 mRNA sequence | blastn | 37690 | 682 | 0.994134897360704 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 20385765 | 20385765 | PRJNA944406_P_NODE_5036_length_579_cov_25.575099_g4097_i0 | PRJNA944406 | 5036 | 579 | 25.575099 | 148.07982321 | Peronosporales | 4776 | SAR_Eukaryotes | SAR_Eukaryotes | 922 | 0 | NTclustered | gi|1238675774|gb|MF783088.1| | 4784 | g4097 | i0 | 95.369 | 100.692573402418 | 583 | 21 | 100 | 5 | 1 | 579 | 1133 | 553 | Phytophthora capsici isolate CACAO small subunit ribosomal RNA gene, partial sequence | blastn | 58301 | 928 | 0.993534482758621 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 21326881 | 21326881 | PRJNA944406_P_NODE_59777_length_254_cov_1.497238_g58818_i0 | PRJNA944406 | 59777 | 254 | 1.497238 | 3.80298452 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 6.19e-28 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g58818 | i0 | 78.44 | 88.6614173228347 | 218 | 42 | 85 | 3 | 40 | 254 | 2247 | 2462 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 22520 | 137 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21661880 | 21661880 | PRJNA944406_P_NODE_9157_length_411_cov_2.414201_g8198_i0 | PRJNA944406 | 9157 | 411 | 2.414201 | 9.92236611 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 699 | 0 | NTclustered | gi|2314988899|ref|NC_067072.1| | 89335 | g8198 | i0 | 97.324 | 100.226277372263 | 411 | 11 | 100 | 0 | 1 | 411 | 19367 | 19777 | Phytophthora ilicis voucher P3939 mitochondrion, complete genome | blastn | 41193 | 699 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ilicis | ||
| 22602221 | 22602221 | PRJNA944406_P_NODE_98498_length_243_cov_0.905882_g97539_i0 | PRJNA944406 | 98498 | 243 | 0.905882 | 2.20129326 | Elongisporangium undulatum | 127444 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 9.1e-81 | NTclustered | gi|33520249|gb|AY273994.1| | 127444 | g97539 | i0 | 89.796 | 101.251028806584 | 245 | 23 | 100 | 2 | 1 | 243 | 697 | 453 | Pythium undulatum large subunit ribosomal RNA gene, partial sequence | blastn | 24604 | 313 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Elongisporangium | Elongisporangium undulatum | ||
| 22937231 | 22937231 | PRJNA944406_P_NODE_56958_length_256_cov_5.978142_g55999_i0 | PRJNA944406 | 56958 | 256 | 5.978142 | 15.30404352 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 7.37e-92 | NTclustered | gi|90655139|gb|DQ361260.1| | 4792 | g55999 | i0 | 91.473 | 100.8046875 | 258 | 16 | 100 | 5 | 1 | 256 | 487 | 740 | Phytophthora nicotianae large subunit ribosomal RNA gene, partial sequence | blastn | 25806 | 351 | 0.997150997150997 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 22937234 | 22937234 | PRJNA944406_P_NODE_5738_length_536_cov_13.943844_g4789_i0 | PRJNA944406 | 5738 | 536 | 13.943844 | 74.73900384 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 946 | 0 | NTclustered | gi|33520246|gb|AY273991.1| | 4787 | g4789 | i0 | 98.689 | 99.6305970149254 | 534 | 6 | 99 | 1 | 3 | 536 | 540 | 8 | Phytophthora infestans large subunit ribosomal RNA gene, partial sequence | blastn | 53402 | 953 | 0.992654774396642 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans |
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);;