contig_metadata
22 rows where bioproject = "PRJEB29441", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 988145 | 988145 | PRJEB29441_P_NODE_10621_length_345_cov_9.060811_g10180_i0 | PRJEB29441 | 10621 | 345 | 9.060811 | 31.25979795 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 632 | 9.17e-177 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g10180 | i0 | 99.71 | 99.8608695652174 | 345 | 1 | 100 | 0 | 1 | 345 | 721 | 377 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 34452 | 638 | 0.990595611285266 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 2576460 | 2576460 | PRJEB29441_P_NODE_31423_length_187_cov_1.108696_g30982_i0 | PRJEB29441 | 31423 | 187 | 1.108696 | 2.07326152 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 5.56e-27 | NTclustered | gi|59894163|gb|AY729864.1| | 74557 | g30982 | i0 | 79.679 | 2.39572192513369 | 187 | 36 | 99 | 2 | 1 | 186 | 1203 | 1018 | Thraustotheca clavata heat shock protein 90 gene, partial cds | blastn | 448 | 134 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 6404792 | 6404792 | PRJEB29441_P_NODE_31906_length_185_cov_1.875000_g31465_i0 | PRJEB29441 | 31906 | 185 | 1.875 | 3.46875 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.23e-24 | NR | TMW64892.1 | 41045 | g31465 | i0 | 78.7 | 7.91351351351351 | 61 | 13 | 98.9 | 0 | 183 | 1 | 88 | 148 | TMW64892.1 hypothetical protein Poli38472_009059 [Pythium oligandrum] | diamond | 1464 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 8953617 | 8953617 | PRJEB29441_P_NODE_35988_length_174_cov_1.328000_g35547_i0 | PRJEB29441 | 35988 | 174 | 1.328 | 2.31072 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.87e-11 | NTclustered | gi|325194684|emb|FR825494.1| | 890382 | g35547 | i0 | 76.19 | 1.93103448275862 | 168 | 33 | 95 | 6 | 10 | 174 | 202 | 39 | Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 | blastn | 336 | 82.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 11504265 | 11504265 | PRJEB29441_P_NODE_10730_length_343_cov_3.017007_g10289_i0 | PRJEB29441 | 10730 | 343 | 3.017007 | 10.34833401 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 617 | 2.55e-172 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g10289 | i0 | 99.125 | 101.68804664723 | 343 | 3 | 100 | 0 | 1 | 343 | 2156 | 2498 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 34879 | 617 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11504888 | 11504888 | PRJEB29441_P_NODE_45610_length_162_cov_0.902655_g45169_i0 | PRJEB29441 | 45610 | 162 | 0.902655 | 1.4623011 | uncultured Oomycota | 179533 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 2.88e-9 | NTclustered | gi|307939675|gb|HM441352.1| | 179533 | g45169 | i0 | 83.75 | 13.0802469135802 | 80 | 11 | 49 | 2 | 35 | 114 | 291 | 368 | Uncultured oomycete clone o8-Alf-22 large subunit ribosomal RNA gene, partial sequence | blastn | 2119 | 75 | 1 | Eukaryota | Sar | Oomycota | uncultured Oomycota | ||||||
| 12467363 | 12467363 | PRJEB29441_P_NODE_28790_length_195_cov_1.917808_g28349_i0 | PRJEB29441 | 28790 | 195 | 1.917808 | 3.7397256 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.1799999999999998e-73 | NTclustered | gi|1812102600|ref|NC_045922.1| | 143451 | g28349 | i0 | 93.333 | 101.066666666667 | 195 | 13 | 100 | 0 | 1 | 195 | 2284 | 2090 | Plasmopara viticola mitochondrion, complete genome | blastn | 19708 | 289 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara viticola | ||
| 14054669 | 14054669 | PRJEB29441_P_NODE_27692_length_199_cov_2.033333_g27251_i0 | PRJEB29441 | 27692 | 199 | 2.033333 | 4.04633267 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.51e-97 | NTclustered | gi|1578815424|gb|MK546601.1| | 1982524 | g27251 | i0 | 100 | 99.929648241206 | 199 | 0 | 100 | 0 | 1 | 199 | 601 | 799 | Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence | blastn | 19886 | 368 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 17877893 | 17877893 | PRJEB29441_P_NODE_13395_length_301_cov_2.107143_g12954_i0 | PRJEB29441 | 13395 | 301 | 2.107143 | 6.34250043 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 1.12e-44 | NR | KAG1694345.1 | 4784 | g12954 | i0 | 77.8 | 2.96013289036545 | 99 | 22 | 98.7 | 0 | 1 | 297 | 36 | 134 | KAG1694345.1 40S ribosomal protein S4 [Phytophthora capsici] | diamond | 891 | 154 | 0.993506493506494 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 26589785 | 26589785 | PRJEB29441_P_NODE_31921_length_185_cov_1.750000_g31480_i0 | PRJEB29441 | 31921 | 185 | 1.75 | 3.2375 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 7.27e-18 | NR | KAJ0410394.1 | 114742 | g31480 | i0 | 67.9 | 1.81621621621622 | 56 | 18 | 90.8 | 0 | 6 | 173 | 79 | 134 | KAJ0410394.1 hypothetical protein P43SY_002726 [Pythium insidiosum] | diamond | 336 | 82 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 27311461 | 27311461 | PRJEB29441_P_NODE_43623_length_163_cov_2.605263_g43182_i0 | PRJEB29441 | 43623 | 163 | 2.605263 | 4.24657869 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.71e-26 | NR | CCI50303.1 | 65357 | g43182 | i0 | 96.2 | 10.7300613496933 | 53 | 2 | 97.5 | 0 | 3 | 161 | 366 | 418 | CCI50303.1 unnamed protein product [Albugo candida] | diamond | 1749 | 110 | 0.990909090909091 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 27690544 | 27690544 | PRJEB29441_P_NODE_20904_length_232_cov_1.010929_g20463_i0 | PRJEB29441 | 20904 | 232 | 1.010929 | 2.34535528 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.09e-26 | NR | KAG1703166.1 | 4784 | g20463 | i0 | 70.7 | 4.84913793103448 | 75 | 21 | 95.7 | 1 | 224 | 3 | 1 | 75 | KAG1703166.1 hypothetical protein DVH05_008077 [Phytophthora capsici] | diamond | 1125 | 104 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 28069028 | 28069028 | PRJEB29441_P_NODE_18685_length_248_cov_1.537688_g18244_i0 | PRJEB29441 | 18685 | 248 | 1.537688 | 3.81346624 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 2.16e-21 | NR | XP_024582431.1 | 4781 | g18244 | i0 | 58.1 | 3.58064516129032 | 74 | 31 | 89.5 | 0 | 26 | 247 | 1 | 74 | XP_024582431.1 rok family protein [Plasmopara halstedii] | diamond | 888 | 95.9 | 0.995828988529718 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 28138968 | 28138968 | PRJEB29441_P_NODE_36805_length_172_cov_1.211382_g36364_i0 | PRJEB29441 | 36805 | 172 | 1.211382 | 2.08357704 | Phytophthora palmivora | 4796 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 2.5e-18 | NR | POM80711.1 | 4796 | g36364 | i0 | 71.7 | 8.42441860465116 | 53 | 15 | 92.4 | 0 | 170 | 12 | 535 | 587 | POM80711.1 ABC Superfamily [Phytophthora palmivora] | diamond | 1449 | 87.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 28479605 | 28479605 | PRJEB29441_P_NODE_28646_length_196_cov_1.040816_g28205_i0 | PRJEB29441 | 28646 | 196 | 1.040816 | 2.03999936 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 4.15e-29 | NR | TMW60322.1 | 41045 | g28205 | i0 | 84.6 | 9.94897959183673 | 65 | 10 | 99.5 | 0 | 1 | 195 | 209 | 273 | TMW60322.1 hypothetical protein Poli38472_000364 [Pythium oligandrum] | diamond | 1950 | 119 | 0.991596638655462 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28928046 | 28928046 | PRJEB29441_P_NODE_31708_length_186_cov_1.291971_g31267_i0 | PRJEB29441 | 31708 | 186 | 1.291971 | 2.40306606 | Phytophthora idaei | 53986 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0341 | NR | KAG3171441.1 | 53986 | g31267 | i0 | 60 | 0.483870967741935 | 30 | 11 | 48.4 | 1 | 68 | 157 | 81 | 109 | KAG3171441.1 hypothetical protein PI126_g1913 [Phytophthora idaei] | diamond | 90 | 41.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora idaei | ||
| 29205950 | 29205950 | PRJEB29441_P_NODE_34869_length_177_cov_1.195312_g34428_i0 | PRJEB29441 | 34869 | 177 | 1.195312 | 2.11570224 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0279 | NR | KAF0710815.1 | 120398 | g34428 | i0 | 48.1 | 1.61016949152542 | 54 | 27 | 91.5 | 1 | 2 | 163 | 30 | 82 | KAF0710815.1 hypothetical protein As57867_005451, partial [Aphanomyces stellatus] | diamond | 285 | 42 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 29306884 | 29306884 | PRJEB29441_P_NODE_14789_length_284_cov_1.953191_g14348_i0 | PRJEB29441 | 14789 | 284 | 1.953191 | 5.54706244 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 4.32e-38 | NR | KAG9404282.1 | 112091 | g14348 | i0 | 72 | 5.8943661971831 | 93 | 26 | 98.2 | 0 | 1 | 279 | 231 | 323 | KAG9404282.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Aphanomyces cochlioides] | diamond | 1674 | 139 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 29370177 | 29370177 | PRJEB29441_P_NODE_47049_length_161_cov_0.910714_g46608_i0 | PRJEB29441 | 47049 | 161 | 0.910714 | 1.46624954 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.02e-9 | NR | DAZ93968.1 | 4803 | g46608 | i0 | 51.9 | 3.8944099378882 | 52 | 25 | 96.9 | 0 | 157 | 2 | 219 | 270 | DAZ93968.1 TPA: hypothetical protein N0F65_008697 [Lagenidium giganteum] | diamond | 627 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29805546 | 29805546 | PRJEB29441_P_NODE_20711_length_233_cov_1.505435_g20270_i0 | PRJEB29441 | 20711 | 233 | 1.505435 | 3.50766355 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 9.59e-19 | NR | KAL0584202.1 | 65357 | g20270 | i0 | 66.2 | 3.97854077253219 | 65 | 22 | 83.7 | 0 | 39 | 233 | 2818 | 2882 | KAL0584202.1 hypothetical protein ABG067_005976 [Albugo candida] | diamond | 927 | 90.1 | 0.995560488346282 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 30538765 | 30538765 | PRJEB29441_P_NODE_8493_length_393_cov_2.287791_g8054_i0 | PRJEB29441 | 8493 | 393 | 2.287791 | 8.99101863 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 2.06e-21 | NR | KAE8911393.1 | 53985 | g8054 | i0 | 53.3 | 2.73282442748092 | 92 | 32 | 63.4 | 3 | 392 | 144 | 50 | 139 | KAE8911393.1 hypothetical protein PF003_g4481 [Phytophthora fragariae] | diamond | 1074 | 93.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 31138763 | 31138763 | PRJEB29441_P_NODE_25615_length_208_cov_1.232704_g25174_i0 | PRJEB29441 | 25615 | 208 | 1.232704 | 2.56402432 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00147 | NR | KAJ0401079.1 | 114742 | g25174 | i0 | 42.2 | 4.52884615384615 | 45 | 26 | 64.9 | 0 | 135 | 1 | 2099 | 2143 | KAJ0401079.1 hypothetical protein ATCC90586_000763 [Pythium insidiosum] | diamond | 942 | 46.2 | 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);;