contig_metadata
13 rows where bioproject = "PRJNA846486" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13586890 | 13586890 | PRJNA846486_P_NODE_44171_length_207_cov_2.215190_g44075_i0 | PRJNA846486 | 44171 | 207 | 2.21519 | 4.5854433 | Hyaloperonospora arabidopsidis | 272952 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 6.38e-17 | NTclustered | gi|2248512796|ref|NC_063789.1| | 272952 | g44075 | i0 | 79.73 | 46.1449275362319 | 148 | 22 | 70 | 6 | 1 | 145 | 1013 | 1155 | Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome | blastn | 9552 | 100 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora arabidopsidis | ||
| 14861250 | 14861250 | PRJNA846486_P_NODE_7632_length_442_cov_2.941476_g7538_i0 | PRJNA846486 | 7632 | 442 | 2.941476 | 13.00132392 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 3.08e-53 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g7538 | i0 | 79.027 | 17.8144796380091 | 329 | 65 | 74 | 4 | 99 | 425 | 482 | 156 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 7874 | 222 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 23785593 | 23785593 | PRJNA846486_P_NODE_65159_length_179_cov_1.430769_g65063_i0 | PRJNA846486 | 65159 | 179 | 1.430769 | 2.56107651 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.35e-82 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g65063 | i0 | 98.876 | 134.899441340782 | 178 | 2 | 99 | 0 | 1 | 178 | 2063 | 2240 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 24147 | 318 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 26746280 | 26746280 | PRJNA846486_P_NODE_19461_length_289_cov_2.166667_g19365_i0 | PRJNA846486 | 19461 | 289 | 2.166667 | 6.26166763 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 4.81e-15 | NR | TMW55519.1 | 41045 | g19365 | i0 | 45.7 | 3.92387543252595 | 94 | 44 | 97.6 | 1 | 8 | 289 | 204 | 290 | TMW55519.1 hypothetical protein Poli38472_010401 [Pythium oligandrum] | diamond | 1134 | 80.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28697155 | 28697155 | PRJNA846486_P_NODE_86707_length_165_cov_0.896552_g86611_i0 | PRJNA846486 | 86707 | 165 | 0.896552 | 1.4793108 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0174 | NR | KAE8905549.1 | 53985 | g86611 | i0 | 48.6 | 1.25454545454545 | 37 | 19 | 67.3 | 0 | 136 | 26 | 110 | 146 | KAE8905549.1 hypothetical protein PF003_g10350 [Phytophthora fragariae] | diamond | 207 | 42.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 29170703 | 29170703 | PRJNA846486_P_NODE_93249_length_162_cov_0.920354_g93153_i0 | PRJNA846486 | 93249 | 162 | 0.920354 | 1.49097348 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 2.1e-7 | NR | GLE06712.1 | 114742 | g93153 | i0 | 59.6 | 1.74074074074074 | 47 | 19 | 87 | 0 | 14 | 154 | 375 | 421 | GLE06712.1 hypothetical protein PINS_up016195 [Pythium insidiosum] | diamond | 282 | 56.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30348021 | 30348021 | PRJNA846486_P_NODE_78592_length_168_cov_1.025210_g78496_i0 | PRJNA846486 | 78592 | 168 | 1.02521 | 1.7223528 | root | 1 | Root_unresolved | Root_unresolved | 88.2 | 6.41e-20 | NR | DBA03562.1 | 4803 | g78496 | i0 | 73.1 | 5.57142857142857 | 52 | 14 | 92.9 | 0 | 12 | 167 | 1 | 52 | DBA03562.1 TPA: hypothetical protein N0F65_011463 [Lagenidium giganteum] | diamond | 936 | 89 | 0.991011235955056 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31445235 | 31445235 | PRJNA846486_P_NODE_8416_length_423_cov_3.681818_g8321_i0 | PRJNA846486 | 8416 | 423 | 3.681818 | 15.57409014 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.45e-30 | NR | GLD98056.1 | 114742 | g8321 | i0 | 65.2 | 1.26241134751773 | 89 | 30 | 62.4 | 1 | 2 | 265 | 96 | 184 | GLD98056.1 hypothetical protein PINS_up006753 [Pythium insidiosum] | diamond | 534 | 118 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31611844 | 31611844 | PRJNA846486_P_NODE_26936_length_252_cov_2.216749_g26840_i0 | PRJNA846486 | 26936 | 252 | 2.216749 | 5.58620748 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 3.039999999999999e-23 | NR | KAF0700380.1 | 120398 | g26840 | i0 | 59 | 6.88095238095238 | 83 | 33 | 98.8 | 1 | 250 | 2 | 42 | 123 | KAF0700380.1 hypothetical protein As57867_009049 [Aphanomyces stellatus] | diamond | 1734 | 100 | 0.99 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 31792905 | 31792905 | PRJNA846486_P_NODE_65417_length_179_cov_1.200000_g65321_i0 | PRJNA846486 | 65417 | 179 | 1.2 | 2.148 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.0024 | NR | OWZ04956.1 | 4795 | g65321 | i0 | 51.1 | 5.83240223463687 | 45 | 21 | 73.7 | 1 | 9 | 140 | 286 | 330 | OWZ04956.1 hypothetical protein PHMEG_00023046 [Phytophthora megakarya] | diamond | 1044 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 31824618 | 31824618 | PRJNA846486_P_NODE_89997_length_163_cov_1.438596_g89901_i0 | PRJNA846486 | 89997 | 163 | 1.438596 | 2.34491148 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 3.039999999999999e-23 | NR | KUF91244.1 | 4792 | g89901 | i0 | 75.9 | 4.96932515337423 | 54 | 13 | 99.4 | 0 | 163 | 2 | 50 | 103 | KUF91244.1 hypothetical protein AM588_10004817 [Phytophthora nicotianae] | diamond | 810 | 94 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 32584247 | 32584247 | PRJNA846486_P_NODE_61419_length_183_cov_1.552239_g61323_i0 | PRJNA846486 | 61419 | 183 | 1.552239 | 2.84059737 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00339 | NR | KAI9911742.1 | 230839 | g61323 | i0 | 60.5 | 1.26229508196721 | 38 | 15 | 62.3 | 0 | 181 | 68 | 54 | 91 | KAI9911742.1 hypothetical protein PsorP6_008793 [Peronosclerospora sorghi] | diamond | 231 | 44.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 32875764 | 32875764 | PRJNA846486_P_NODE_29460_length_243_cov_1.309278_g29364_i0 | PRJNA846486 | 29460 | 243 | 1.309278 | 3.18154554 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 2.3e-6 | NR | OQS05018.1 | 74557 | g29364 | i0 | 47.4 | 5.37037037037037 | 78 | 35 | 95.1 | 2 | 2 | 232 | 1229 | 1301 | OQS05018.1 hypothetical protein THRCLA_02800, partial [Thraustotheca clavata] | diamond | 1305 | 55.1 | 0.992740471869329 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata |
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);;