contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2000028 | 2000028 | PRJNA745553_S_NODE_10422_length_376_cov_3.052805_g10227_i0 | PRJNA745553 | 10422 | 376 | 3.052805 | 11.4785468 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 1.61e-17 | NR | KAF1313269.1 | 82926 | g10227 | i0 | 74.2 | 1.97872340425532 | 62 | 15 | 48.7 | 1 | 321 | 139 | 132 | 193 | KAF1313269.1 Ubiquitin-60s ribosomal protein l40, partial [Globisporangium splendens] | diamond | 744 | 84.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 12203529 | 12203529 | PRJNA745553_S_NODE_14210_length_326_cov_6.430830_g14015_i0 | PRJNA745553 | 14210 | 326 | 6.43083 | 20.9645058 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 96.7 | 1.9e-21 | NR | KAG7389019.1 | 109152 | g14015 | i0 | 82.5 | 16.1687116564417 | 63 | 10 | 57.1 | 1 | 207 | 22 | 246 | 308 | KAG7389019.1 hypothetical protein PHYBOEH_007632 [Phytophthora boehmeriae] | diamond | 5271 | 96.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 18576106 | 18576106 | PRJNA745553_S_NODE_6535_length_458_cov_4.740260_g6341_i0 | PRJNA745553 | 6535 | 458 | 4.74026 | 21.7103908 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.3799999999999998e-31 | NR | RQM26635.1 | 112090 | g6341 | i0 | 66.3 | 3.10480349344978 | 95 | 31 | 61.6 | 1 | 455 | 174 | 202 | 296 | RQM26635.1 hypothetical protein B5M09_003301 [Aphanomyces astaci] | diamond | 1422 | 124 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 23677324 | 23677324 | PRJNA745553_S_NODE_28859_length_226_cov_6.777778_g28664_i0 | PRJNA745553 | 28859 | 226 | 6.777778 | 15.31777828 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.3399999999999994e-23 | NR | KUF97731.1 | 4792 | g28664 | i0 | 72.3 | 13.6858407079646 | 65 | 18 | 86.3 | 0 | 204 | 10 | 184 | 248 | KUF97731.1 hypothetical protein AM588_10010154 [Phytophthora nicotianae] | diamond | 3093 | 100 | 0.99 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 26672557 | 26672557 | PRJNA745553_S_NODE_1461_length_708_cov_3.233071_g1322_i0 | PRJNA745553 | 1461 | 708 | 3.233071 | 22.89014268 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.93e-24 | NR | TMW64278.1 | 41045 | g1322 | i0 | 43.7 | 1.73305084745763 | 135 | 73 | 56.8 | 3 | 707 | 306 | 34 | 166 | TMW64278.1 hypothetical protein Poli38472_012900 [Pythium oligandrum] | diamond | 1227 | 106 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 26873178 | 26873178 | PRJNA745553_S_NODE_13901_length_330_cov_1.525292_g13706_i0 | PRJNA745553 | 13901 | 330 | 1.525292 | 5.0334636 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 2.07e-7 | NR | CCI44615.1 | 65357 | g13706 | i0 | 47.8 | 3.33636363636364 | 46 | 24 | 41.8 | 0 | 329 | 192 | 534 | 579 | CCI44615.1 unnamed protein product [Albugo candida] | diamond | 1101 | 59.3 | 0.993254637436762 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 27252295 | 27252295 | PRJNA745553_S_NODE_30263_length_204_cov_5.877863_g30068_i0 | PRJNA745553 | 30263 | 204 | 5.877863 | 11.99084052 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 4.04e-10 | NR | CAI5734659.1 | 162125 | g30068 | i0 | 82.9 | 3.57352941176471 | 35 | 6 | 51.5 | 0 | 186 | 82 | 425 | 459 | CAI5734659.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 729 | 64.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 27400534 | 27400534 | PRJNA745553_S_NODE_15663_length_311_cov_4.743697_g15468_i0 | PRJNA745553 | 15663 | 311 | 4.743697 | 14.75289767 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0323 | NR | OQR90287.1 | 1202772 | g15468 | i0 | 34.2 | 0.704180064308682 | 73 | 38 | 61.7 | 2 | 68 | 259 | 581 | 652 | OQR90287.1 ABC transporter [Achlya hypogyna] | diamond | 219 | 43.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 27653149 | 27653149 | PRJNA745553_S_NODE_16964_length_300_cov_1.286344_g16769_i0 | PRJNA745553 | 16964 | 300 | 1.286344 | 3.859032 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 7.88e-13 | NR | DAZ95991.1 | 4803 | g16769 | i0 | 58 | 1.1 | 50 | 21 | 50 | 0 | 149 | 298 | 66 | 115 | DAZ95991.1 TPA: hypothetical protein N0F65_009292 [Lagenidium giganteum] | diamond | 330 | 73.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28136721 | 28136721 | PRJNA745553_S_NODE_2185_length_640_cov_1.298060_g2011_i0 | PRJNA745553 | 2185 | 640 | 1.29806 | 8.307584 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 3.95e-14 | NR | RLN47569.1 | 325452 | g2011 | i0 | 29.5 | 2.64375 | 193 | 110 | 83.9 | 7 | 1 | 537 | 95 | 275 | RLN47569.1 hypothetical protein BBJ29_005932 [Phytophthora kernoviae] | diamond | 1692 | 81.3 | 0.990159901599016 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 28189527 | 28189527 | PRJNA745553_S_NODE_14866_length_319_cov_4.865854_g14671_i0 | PRJNA745553 | 14866 | 319 | 4.865854 | 15.52207426 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 9.13e-13 | NR | KAF1334350.1 | 82926 | g14671 | i0 | 64.7 | 1.86206896551724 | 51 | 18 | 48 | 0 | 26 | 178 | 107 | 157 | KAF1334350.1 Translation elongation factor if5a, partial [Globisporangium splendens] | diamond | 594 | 70.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28325876 | 28325876 | PRJNA745553_S_NODE_18586_length_286_cov_5.769953_g18391_i0 | PRJNA745553 | 18586 | 286 | 5.769953 | 16.50206558 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 1.32e-21 | NR | KAG7389430.1 | 109152 | g18391 | i0 | 63.9 | 4.44755244755245 | 61 | 22 | 64 | 0 | 261 | 79 | 76 | 136 | KAG7389430.1 hypothetical protein PHYBOEH_007446 [Phytophthora boehmeriae] | diamond | 1272 | 92.8 | 0.995689655172414 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 30125674 | 30125674 | PRJNA745553_S_NODE_2512_length_617_cov_6.101103_g2334_i0 | PRJNA745553 | 2512 | 617 | 6.101103 | 37.64380551 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 6.63e-20 | NR | POM75838.1 | 4796 | g2334 | i0 | 45.2 | 11.3776337115073 | 115 | 63 | 55.9 | 0 | 121 | 465 | 621 | 735 | POM75838.1 TRAF3-interacting protein [Phytophthora palmivora] | diamond | 7020 | 98.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 30189012 | 30189012 | PRJNA745553_S_NODE_15512_length_313_cov_1.925000_g15317_i0 | PRJNA745553 | 15512 | 313 | 1.925 | 6.02525 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.42e-32 | NR | KUF95685.1 | 4792 | g15317 | i0 | 54.7 | 19.0255591054313 | 106 | 45 | 98.7 | 1 | 311 | 3 | 523 | 628 | KUF95685.1 hypothetical protein AM588_10009356 [Phytophthora nicotianae] | diamond | 5955 | 131 | 0.99236641221374 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 30842747 | 30842747 | PRJNA745553_S_NODE_28734_length_227_cov_5.915584_g28539_i0 | PRJNA745553 | 28734 | 227 | 5.915584 | 13.42837568 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 5.59e-10 | NR | KAF1780337.1 | 29920 | g28539 | i0 | 46.9 | 0.845814977973568 | 64 | 34 | 84.6 | 0 | 207 | 16 | 93 | 156 | KAF1780337.1 ClpP/crotonase-like domain [Phytophthora cactorum] | diamond | 192 | 62.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 30852557 | 30852557 | PRJNA745553_S_NODE_29614_length_216_cov_4.174825_g29419_i0 | PRJNA745553 | 29614 | 216 | 4.174825 | 9.017622 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 1.4500000000000002e-21 | NR | KAF0689425.1 | 120398 | g29419 | i0 | 68.7 | 3.625 | 67 | 21 | 93.1 | 0 | 9 | 209 | 308 | 374 | KAF0689425.1 hypothetical protein As57867_019067 [Aphanomyces stellatus] | diamond | 783 | 97.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 32297742 | 32297742 | PRJNA745553_S_NODE_19039_length_283_cov_3.657143_g18844_i0 | PRJNA745553 | 19039 | 283 | 3.657143 | 10.34971469 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 1.52e-14 | NR | TYZ64046.1 | 1485010 | g18844 | i0 | 64.4 | 0.625441696113074 | 59 | 21 | 62.5 | 0 | 87 | 263 | 320 | 378 | TYZ64046.1 hypothetical protein PybrP1_011904 [[Pythium] brassicae (nom. inval.)] | diamond | 177 | 78.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 32465718 | 32465718 | PRJNA745553_S_NODE_20659_length_272_cov_2.708543_g20464_i0 | PRJNA745553 | 20659 | 272 | 2.708543 | 7.36723696 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 2.33e-21 | NR | KAJ8546679.1 | 4785 | g20464 | i0 | 50.6 | 23.2058823529412 | 89 | 43 | 98.2 | 1 | 1 | 267 | 951 | 1038 | KAJ8546679.1 hypothetical protein ON010_g11556 [Phytophthora cinnamomi] | diamond | 6312 | 97.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;