contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2686304 | 2686304 | PRJEB75230_P_NODE_140363_length_248_cov_0.880000_g140181_i0 | PRJEB75230 | 140363 | 248 | 0.88 | 2.1824 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.82e-21 | NTclustered | gi|673053728|ref|XM_008882603.1| | 157072 | g140181 | i0 | 82.812 | 1.64112903225806 | 128 | 22 | 52 | 0 | 119 | 246 | 1490 | 1617 | Aphanomyces invadans hypothetical protein mRNA | blastn | 407 | 115 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 3961997 | 3961997 | PRJEB75230_P_NODE_111584_length_255_cov_1.269231_g111402_i0 | PRJEB75230 | 111584 | 255 | 1.269231 | 3.23653905 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 6.259999999999999e-23 | NTclustered | gi|695408334|ref|XM_009526318.1| | 67593 | g111402 | i0 | 87.5 | 1.27058823529412 | 104 | 13 | 41 | 0 | 97 | 200 | 1393 | 1496 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 324 | 121 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 3962137 | 3962137 | PRJEB75230_P_NODE_121284_length_251_cov_0.865169_g121102_i0 | PRJEB75230 | 121284 | 251 | 0.865169 | 2.17157419 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 3.75e-10 | NTclustered | gi|813180878|ref|XM_012350718.1| | 695850 | g121102 | i0 | 95.918 | 0.195219123505976 | 49 | 1 | 19 | 1 | 155 | 202 | 654 | 606 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 49 | 78.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 3962572 | 3962572 | PRJEB75230_P_NODE_156524_length_245_cov_0.895349_g156342_i0 | PRJEB75230 | 156524 | 245 | 0.895349 | 2.19360505 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 9.79e-36 | NTclustered | gi|187424037|gb|EU652939.1| | 67593 | g156342 | i0 | 79.253 | 52.6938775510204 | 241 | 44 | 97 | 6 | 4 | 241 | 611 | 848 | Phytophthora sojae G protein alpha subunit (GPA1) gene, complete cds | blastn | 12910 | 163 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 3964042 | 3964042 | PRJEB75230_P_NODE_844_length_1323_cov_3.839200_g749_i0 | PRJEB75230 | 844 | 1323 | 3.8392 | 50.792616 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 872 | 0 | NTclustered | gi|695434305|ref|XM_009533098.1| | 67593 | g749 | i0 | 79.157 | 88.3257747543462 | 1305 | 238 | 97 | 23 | 2 | 1286 | 1325 | 35 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 116855 | 872 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 6515537 | 6515537 | PRJEB75230_P_NODE_50966_length_311_cov_0.970588_g50784_i0 | PRJEB75230 | 50966 | 311 | 0.970588 | 3.01852868 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|669164015|ref|XM_008619348.1| | 1156394 | g50784 | i0 | 94.444 | 0.385852090032154 | 36 | 2 | 12 | 0 | 46 | 81 | 328 | 363 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 120 | 56.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 6516198 | 6516198 | PRJEB75230_P_NODE_93506_length_268_cov_2.358974_g93324_i0 | PRJEB75230 | 93506 | 268 | 2.358974 | 6.32205032 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 6.63e-23 | NTclustered | gi|669140187|ref|XM_008607440.1| | 1156394 | g93324 | i0 | 94.805 | 7.17910447761194 | 77 | 4 | 29 | 0 | 32 | 108 | 1428 | 1504 | Saprolegnia diclina VS20 ATP-binding cassette, subfamily F, member 2 mRNA | blastn | 1924 | 121 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 6516278 | 6516278 | PRJEB75230_P_NODE_9966_length_472_cov_1.090226_g9784_i0 | PRJEB75230 | 9966 | 472 | 1.090226 | 5.14586672 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 1.14e-82 | NTclustered | gi|2795026849|ref|XM_067926286.1| | 4785 | g9784 | i0 | 80.282 | 9.10593220338983 | 426 | 82 | 90 | 2 | 41 | 465 | 305 | 729 | Phytophthora cinnamomi succinyl-CoA ligase [GDP-forming] subunit alpha, mitochondrial (IUM83_02375), partial mRNA | blastn | 4298 | 320 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 8648966 | 8648966 | PRJEB75230_P_NODE_129627_length_249_cov_1.312500_g129445_i0 | PRJEB75230 | 129627 | 249 | 1.3125 | 3.268125 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 2.72e-51 | NTclustered | gi|2795038971|ref|XM_067942088.1| | 4785 | g129445 | i0 | 83.193 | 55.2771084337349 | 238 | 36 | 95 | 4 | 9 | 244 | 730 | 965 | Phytophthora cinnamomi adenosylhomocysteinase (IUM83_17157), partial mRNA | blastn | 13764 | 215 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9063097 | 9063097 | PRJEB75230_P_NODE_109188_length_257_cov_1.141304_g109006_i0 | PRJEB75230 | 109188 | 257 | 1.141304 | 2.93315128 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.88e-5 | NTclustered | gi|698785190|ref|XM_009827337.1| | 112090 | g109006 | i0 | 100 | 1.80544747081712 | 33 | 0 | 13 | 0 | 18 | 50 | 1131 | 1099 | Aphanomyces astaci hypothetical protein partial mRNA | blastn | 464 | 62.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 9064229 | 9064229 | PRJEB75230_P_NODE_27568_length_356_cov_1.434629_g27386_i0 | PRJEB75230 | 27568 | 356 | 1.434629 | 5.1072792400000004 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.86e-59 | NTclustered | gi|673015481|ref|XM_008863480.1| | 157072 | g27386 | i0 | 83.083 | 49.7191011235955 | 266 | 45 | 75 | 0 | 20 | 285 | 106 | 371 | Aphanomyces invadans 60S ribosomal protein L44 mRNA | blastn | 17700 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 10340951 | 10340951 | PRJEB75230_P_NODE_8649_length_495_cov_2.976303_g8467_i0 | PRJEB75230 | 8649 | 495 | 2.976303 | 14.73269985 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 2.6700000000000008e-59 | NTclustered | gi|698791735|ref|XM_009830598.1| | 112090 | g8467 | i0 | 79.235 | 19.2585858585859 | 366 | 63 | 72 | 11 | 124 | 481 | 554 | 194 | Aphanomyces astaci malate dehydrogenase, NAD-dependent mRNA | blastn | 9533 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11615353 | 11615353 | PRJEB75230_P_NODE_184930_length_237_cov_4.432927_g184748_i0 | PRJEB75230 | 184930 | 237 | 4.432927 | 10.50603699 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 5.51e-53 | NTclustered | gi|675203540|ref|XM_008912407.1| | 761204 | g184748 | i0 | 86.207 | 80.2616033755274 | 203 | 28 | 86 | 0 | 35 | 237 | 213 | 415 | Phytophthora parasitica INRA-310 actin-1 mRNA | blastn | 19022 | 220 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 14165768 | 14165768 | PRJEB75230_P_NODE_4932_length_620_cov_1.745887_g4751_i0 | PRJEB75230 | 4932 | 620 | 1.745887 | 10.8244994 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 2.52e-90 | NTclustered | gi|2795021165|ref|XM_067935669.1| | 4785 | g4751 | i0 | 78.664 | 69.3967741935484 | 539 | 101 | 86 | 10 | 90 | 620 | 1459 | 927 | Phytophthora cinnamomi ATP synthase subunit beta, mitochondrial (IUM83_11126), partial mRNA | blastn | 43026 | 346 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 17574004 | 17574004 | PRJEB75230_P_NODE_4274_length_661_cov_6.098639_g4098_i0 | PRJEB75230 | 4274 | 661 | 6.098639 | 40.31200379 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 1e-64 | NTclustered | gi|189083887|gb|BT031403.1| | 4784 | g4098 | i0 | 81.62 | 45.679273827534 | 321 | 53 | 48 | 6 | 214 | 531 | 459 | 142 | Phytophthora capsici clone CBOT69-P12 mRNA sequence | blastn | 30194 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 17987977 | 17987977 | PRJEB75230_P_NODE_155615_length_245_cov_0.895349_g155433_i0 | PRJEB75230 | 155615 | 245 | 0.895349 | 2.19360505 | Peronospora lata | 3235042 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 5.1900000000000006e-123 | NTclustered | gi|2214966176|gb|ON130195.1| | 3235042 | g155433 | i0 | 100 | 101.375510204082 | 245 | 0 | 100 | 0 | 1 | 245 | 364 | 608 | Peronospora sp. MM-2022f voucher RD1544 large subunit ribosomal RNA gene, partial sequence | blastn | 24837 | 453 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora lata | ||
| 19263392 | 19263392 | PRJEB75230_P_NODE_8456_length_499_cov_2.321596_g8274_i0 | PRJEB75230 | 8456 | 499 | 2.321596 | 11.58476404 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 4.23e-102 | NTclustered | gi|2795027172|ref|XM_067926257.1| | 4785 | g8274 | i0 | 80.754 | 85.5350701402806 | 504 | 87 | 100 | 6 | 1 | 499 | 772 | 1270 | Phytophthora cinnamomi citrate (Si)-synthase, eukaryotic (IUM83_02347), partial mRNA | blastn | 42682 | 385 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 20122201 | 20122201 | PRJEB75230_P_NODE_10056_length_470_cov_1.342569_g9874_i0 | PRJEB75230 | 10056 | 470 | 1.342569 | 6.3100743 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 2.58e-44 | NTclustered | gi|301107266|ref|XM_002902670.1| | 403677 | g9874 | i0 | 85.405 | 43.1510638297872 | 185 | 27 | 39 | 0 | 1 | 185 | 143 | 327 | Phytophthora infestans T30-4 ubiquitin, putative (PITG_10193), partial mRNA | blastn | 20281 | 193 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 20538476 | 20538476 | PRJEB75230_P_NODE_6297_length_560_cov_1.632444_g6115_i0 | PRJEB75230 | 6297 | 560 | 1.632444 | 9.1416864 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 7.899999999999999e-110 | NTclustered | gi|695382442|ref|XM_009519107.1| | 67593 | g6115 | i0 | 80.292 | 91.7732142857143 | 548 | 104 | 98 | 4 | 15 | 560 | 721 | 1266 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 51393 | 411 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 21813645 | 21813645 | PRJEB75230_P_NODE_22078_length_375_cov_4.298013_g21896_i0 | PRJEB75230 | 22078 | 375 | 4.298013 | 16.11754875 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 1.16e-71 | NTclustered | gi|695460853|ref|XM_009539792.1| | 67593 | g21896 | i0 | 84.014 | 65.4106666666667 | 294 | 47 | 78 | 0 | 76 | 369 | 309 | 16 | Phytophthora sojae hypothetical protein mRNA | blastn | 24529 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 22672775 | 22672775 | PRJEB75230_P_NODE_1578_length_1030_cov_11.047022_g1444_i0 | PRJEB75230 | 1578 | 1030 | 11.047022 | 113.7843266 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 1.64e-44 | NTclustered | gi|1470016579|gb|MG701996.1| | 2065309 | g1444 | i0 | 81.435 | 24.8009708737864 | 237 | 44 | 23 | 0 | 668 | 904 | 388 | 624 | Phytophthora taxon juncus isolate SCVWD615 cytochrome c oxidase subunit 2 (cox2) gene, partial cds; orf32 (orf32) gene, complete cds; and cytochrome c oxidase subunit 1 (cox1) gene, partial cds; mitochondrial | blastn | 25545 | 195 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora taxon juncus | ||
| 23088011 | 23088011 | PRJEB75230_P_NODE_134539_length_248_cov_2.640000_g134357_i0 | PRJEB75230 | 134539 | 248 | 2.64 | 6.5472 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.76e-36 | NTclustered | gi|675213812|ref|XM_008917543.1| | 761204 | g134357 | i0 | 78.947 | 46.8629032258064 | 247 | 48 | 99 | 4 | 1 | 245 | 277 | 521 | Phytophthora parasitica INRA-310 heat shock protein 90-2 mRNA | blastn | 11622 | 165 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 24363191 | 24363191 | PRJEB75230_P_NODE_5100_length_611_cov_3.163569_g4919_i0 | PRJEB75230 | 5100 | 611 | 3.163569 | 19.32940659 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 8.859999999999999e-95 | NTclustered | gi|695406446|ref|XM_009525816.1| | 67593 | g4919 | i0 | 80.04 | 78.240589198036 | 496 | 91 | 81 | 8 | 17 | 508 | 573 | 82 | Phytophthora sojae hypothetical protein mRNA | blastn | 47805 | 361 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae |
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);;