contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2976331 | 2976331 | PRJNA429937_P_NODE_11283_length_1084_cov_4.824645_g6277_i1 | PRJNA429937 | 11283 | 1084 | 4.824645 | 52.2991518 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 2.1199999999999993e-90 | NR | KAG1693818.1 | 4784 | g6277 | i1 | 72.7 | 13.190036900369 | 216 | 10 | 59.8 | 2 | 981 | 334 | 270 | 436 | KAG1693818.1 hypothetical protein DVH05_022920 [Phytophthora capsici] | diamond | 14298 | 302 | 0.993377483443709 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 16390015 | 16390015 | PRJNA429937_P_NODE_32033_length_642_cov_2.838499_g19609_i0 | PRJNA429937 | 32033 | 642 | 2.838499 | 18.22316358 | Phytophthora oleae | 2107226 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 3.01e-12 | NR | KAL3673387.1 | 2107226 | g19609 | i0 | 48.9 | 0.429906542056075 | 92 | 41 | 40.2 | 2 | 186 | 443 | 509 | 600 | KAL3673387.1 hypothetical protein V7S43_001100 [Phytophthora oleae] | diamond | 276 | 76.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora oleae | ||
| 27377001 | 27377001 | PRJNA429937_P_NODE_133523_length_217_cov_3.005319_g110896_i0 | PRJNA429937 | 133523 | 217 | 3.005319 | 6.52154223 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.34e-4 | NR | OWZ09397.1 | 4795 | g110896 | i0 | 58.6 | 4.36866359447005 | 29 | 12 | 40.1 | 0 | 88 | 2 | 247 | 275 | OWZ09397.1 polyprotein [Phytophthora megakarya] | diamond | 948 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 27612973 | 27612973 | PRJNA429937_P_NODE_73724_length_388_cov_4.116992_g31558_i1 | PRJNA429937 | 73724 | 388 | 4.116992 | 15.97392896 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 9.68e-50 | NR | CAH0485653.1 | 134698 | g31558 | i1 | 71.8 | 0.79639175257732 | 103 | 29 | 79.6 | 0 | 16 | 324 | 45 | 147 | CAH0485653.1 unnamed protein product [Peronospora farinosa] | diamond | 309 | 165 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 28275758 | 28275758 | PRJNA429937_P_NODE_48486_length_510_cov_3.754678_g31558_i0 | PRJNA429937 | 48486 | 510 | 3.754678 | 19.1488578 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 6.47e-30 | NR | CAH0485470.1 | 134698 | g31558 | i0 | 77.6 | 0.788235294117647 | 67 | 15 | 39.4 | 0 | 315 | 115 | 75 | 141 | CAH0485470.1 unnamed protein product [Peronospora farinosa] | diamond | 402 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 28528643 | 28528643 | PRJNA429937_P_NODE_25327_length_729_cov_2.854286_g15137_i0 | PRJNA429937 | 25327 | 729 | 2.854286 | 20.80774494 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 232 | 7.269999999999999e-72 | NR | TYZ62095.1 | 1485010 | g15137 | i0 | 80.4 | 0.588477366255144 | 143 | 28 | 58.8 | 0 | 5 | 433 | 129 | 271 | TYZ62095.1 hypothetical protein PybrP1_000907 [[Pythium] brassicae (nom. inval.)] | diamond | 429 | 232 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 30612728 | 30612728 | PRJNA429937_P_NODE_76153_length_379_cov_4.177143_g31558_i2 | PRJNA429937 | 76153 | 379 | 4.177143 | 15.83137197 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 4.27e-50 | NR | CAH0485653.1 | 134698 | g31558 | i2 | 71.8 | 0.815303430079156 | 103 | 29 | 81.5 | 0 | 16 | 324 | 45 | 147 | CAH0485653.1 unnamed protein product [Peronospora farinosa] | diamond | 309 | 166 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 30770976 | 30770976 | PRJNA429937_P_NODE_32574_length_636_cov_3.113674_g15137_i1 | PRJNA429937 | 32574 | 636 | 3.113674 | 19.80296664 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 232 | 2.3099999999999997e-72 | NR | TYZ62095.1 | 1485010 | g15137 | i1 | 80.4 | 0.674528301886792 | 143 | 28 | 67.5 | 0 | 632 | 204 | 129 | 271 | TYZ62095.1 hypothetical protein PybrP1_000907 [[Pythium] brassicae (nom. inval.)] | diamond | 429 | 232 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31514616 | 31514616 | PRJNA429937_P_NODE_46936_length_520_cov_2.861507_g30382_i0 | PRJNA429937 | 46936 | 520 | 2.861507 | 14.8798364 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 3.77e-10 | NR | OQS01886.1 | 74557 | g30382 | i0 | 36.3 | 0.934615384615385 | 80 | 51 | 46.2 | 0 | 28 | 267 | 62 | 141 | OQS01886.1 hypothetical protein THRCLA_21579 [Thraustotheca clavata] | diamond | 486 | 65.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32604943 | 32604943 | PRJNA429937_P_NODE_126480_length_233_cov_1.808824_g103853_i0 | PRJNA429937 | 126480 | 233 | 1.808824 | 4.21455992 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 7.34e-5 | NR | CCA16746.1 | 890382 | g103853 | i0 | 71.9 | 0.412017167381974 | 32 | 9 | 41.2 | 0 | 131 | 226 | 187 | 218 | CCA16746.1 putative polyprotein [Albugo laibachii Nc14] | diamond | 96 | 50.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 32730948 | 32730948 | PRJNA429937_P_NODE_129800_length_225_cov_3.897959_g107173_i0 | PRJNA429937 | 129800 | 225 | 3.897959 | 8.77040775 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 1.92e-4 | NR | TYZ62095.1 | 1485010 | g107173 | i0 | 85.2 | 0.36 | 27 | 4 | 36 | 0 | 1 | 81 | 298 | 324 | TYZ62095.1 hypothetical protein PybrP1_000907 [[Pythium] brassicae (nom. inval.)] | diamond | 81 | 48.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 32730950 | 32730950 | PRJNA429937_P_NODE_133120_length_218_cov_2.417989_g110493_i0 | PRJNA429937 | 133120 | 218 | 2.417989 | 5.27121602 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00786 | NR | GLE01126.1 | 114742 | g110493 | i0 | 58.1 | 0.591743119266055 | 43 | 18 | 59.2 | 0 | 1 | 129 | 1106 | 1148 | GLE01126.1 hypothetical protein PINS_up009956 [Pythium insidiosum] | diamond | 129 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum |
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);;