contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA801875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 801080 | 801080 | PRJNA801875_P_NODE_81_length_1481_cov_6.591286_g51_i0 | PRJNA801875 | 81 | 1481 | 6.591286 | 97.61694566 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 6.13e-46 | NR | CAH0474084.1 | 622444 | g51 | i0 | 39.5 | 5.97771775827144 | 294 | 161 | 58.9 | 7 | 1365 | 493 | 60 | 339 | CAH0474084.1 unnamed protein product [Peronospora belbahrii] | diamond | 8853 | 176 | 0.994318181818182 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 6325723 | 6325723 | PRJNA801875_P_NODE_1105_length_385_cov_1.637143_g1002_i0 | PRJNA801875 | 1105 | 385 | 1.637143 | 6.30300055 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 7.02e-64 | NR | DAZ95461.1 | 4803 | g1002 | i0 | 79.7 | 38.8987012987013 | 128 | 26 | 99.7 | 0 | 1 | 384 | 239 | 366 | DAZ95461.1 TPA: hypothetical protein N0F65_002146 [Lagenidium giganteum] | diamond | 14976 | 214 | 0.995327102803738 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 7179387 | 7179387 | PRJNA801875_P_NODE_1786_length_280_cov_2.355102_g1683_i0 | PRJNA801875 | 1786 | 280 | 2.355102 | 6.5942856 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.65e-40 | NR | TMW60420.1 | 41045 | g1683 | i0 | 78.9 | 5.51785714285714 | 90 | 19 | 96.4 | 0 | 279 | 10 | 52 | 141 | TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] | diamond | 1545 | 147 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 18652535 | 18652535 | PRJNA801875_P_NODE_2355_length_227_cov_3.062500_g2252_i0 | PRJNA801875 | 2355 | 227 | 3.0625 | 6.951875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 1.54e-20 | NR | KAJ8561724.1 | 4785 | g2252 | i0 | 64.8 | 10.3876651982379 | 71 | 25 | 93.8 | 0 | 4 | 216 | 18 | 88 | KAJ8561724.1 hypothetical protein ON010_g7958 [Phytophthora cinnamomi] | diamond | 2358 | 88.2 | 0.99546485260771 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 26705710 | 26705710 | PRJNA801875_P_NODE_1241_length_361_cov_2.674847_g1138_i0 | PRJNA801875 | 1241 | 361 | 2.674847 | 9.65619767 | Phytophthora lilii | 2077276 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 4.48e-4 | NR | GMF15501.1 | 2077276 | g1138 | i0 | 40.4 | 0.947368421052632 | 114 | 44 | 94.7 | 4 | 342 | 1 | 36 | 125 | GMF15501.1 unnamed protein product [Phytophthora lilii] | diamond | 342 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lilii | ||
| 26705711 | 26705711 | PRJNA801875_P_NODE_1841_length_274_cov_3.020921_g1738_i0 | PRJNA801875 | 1841 | 274 | 3.020921 | 8.27732354 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 5.4e-32 | NR | KAI9905651.1 | 230839 | g1738 | i0 | 62.5 | 1.91605839416058 | 88 | 33 | 96.4 | 0 | 271 | 8 | 154 | 241 | KAI9905651.1 hypothetical protein PsorP6_013937 [Peronosclerospora sorghi] | diamond | 525 | 125 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 26968041 | 26968041 | PRJNA801875_P_NODE_122_length_1242_cov_7.042254_g77_i0 | PRJNA801875 | 122 | 1242 | 7.042254 | 87.46479468 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 447 | 9.77e-153 | NR | TMW57229.1 | 41045 | g77 | i0 | 58.8 | 9.67391304347826 | 364 | 148 | 87.4 | 2 | 1242 | 157 | 10 | 373 | TMW57229.1 hypothetical protein Poli38472_003154 [Pythium oligandrum] | diamond | 12015 | 447 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27528065 | 27528065 | PRJNA801875_P_NODE_3183_length_185_cov_2.266667_g3080_i0 | PRJNA801875 | 3183 | 185 | 2.266667 | 4.19333395 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 2.46e-16 | NR | XP_024572435.1 | 4781 | g3080 | i0 | 65.6 | 4.94594594594595 | 61 | 21 | 98.9 | 0 | 3 | 185 | 542 | 602 | XP_024572435.1 atp-binding cassette superfamily [Plasmopara halstedii] | diamond | 915 | 82 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 27852653 | 27852653 | PRJNA801875_P_NODE_3284_length_182_cov_1.455782_g3181_i0 | PRJNA801875 | 3284 | 182 | 1.455782 | 2.64952324 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 6.58e-24 | NR | KAF0742836.1 | 100861 | g3181 | i0 | 85.7 | 8.57142857142857 | 56 | 8 | 92.3 | 0 | 177 | 10 | 368 | 423 | KAF0742836.1 hypothetical protein Ae201684_002234 [Aphanomyces euteiches] | diamond | 1560 | 104 | 0.990384615384615 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27938678 | 27938678 | PRJNA801875_P_NODE_4425_length_155_cov_1.925000_g4322_i0 | PRJNA801875 | 4425 | 155 | 1.925 | 2.98375 | Phytophthora citrophthora | 4793 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 1.13e-8 | NR | KAK1940843.1 | 4793 | g4322 | i0 | 51 | 4.52903225806452 | 51 | 25 | 98.7 | 0 | 153 | 1 | 271 | 321 | KAK1940843.1 N-ethylmaleimide reductase [Phytophthora citrophthora] | diamond | 702 | 59.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 28799720 | 28799720 | PRJNA801875_P_NODE_2567_length_213_cov_1.707865_g2464_i0 | PRJNA801875 | 2567 | 213 | 1.707865 | 3.63775245 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 4.93e-16 | NR | RHY36540.1 | 112090 | g2464 | i0 | 84.4 | 3.80281690140845 | 45 | 7 | 63.4 | 0 | 212 | 78 | 1490 | 1534 | RHY36540.1 hypothetical protein DYB38_010883, partial [Aphanomyces astaci] | diamond | 810 | 82 | 0.995121951219512 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 29588957 | 29588957 | PRJNA801875_P_NODE_3270_length_182_cov_2.700680_g3167_i0 | PRJNA801875 | 3270 | 182 | 2.70068 | 4.9152376 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 2.12e-23 | NR | TMW54960.1 | 41045 | g3167 | i0 | 79.3 | 1.91208791208791 | 58 | 12 | 95.6 | 0 | 179 | 6 | 40 | 97 | TMW54960.1 hypothetical protein Poli38472_014731 [Pythium oligandrum] | diamond | 348 | 100 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29778704 | 29778704 | PRJNA801875_P_NODE_2131_length_244_cov_1.789474_g2028_i0 | PRJNA801875 | 2131 | 244 | 1.789474 | 4.36631656 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 3.6e-20 | NR | KAG1689501.1 | 4784 | g2028 | i0 | 59.4 | 4.00819672131148 | 64 | 26 | 78.7 | 0 | 232 | 41 | 332 | 395 | KAG1689501.1 hypothetical protein DVH05_002170 [Phytophthora capsici] | diamond | 978 | 94 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 30442310 | 30442310 | PRJNA801875_P_NODE_793_length_472_cov_8.757437_g691_i0 | PRJNA801875 | 793 | 472 | 8.757437 | 41.33510264 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 4.749999999999999e-43 | NR | XP_024573476.1 | 4781 | g691 | i0 | 64.7 | 8.6885593220339 | 116 | 41 | 73.7 | 0 | 54 | 401 | 533 | 648 | XP_024573476.1 dead deah box helicase [Plasmopara halstedii] | diamond | 4101 | 162 | 0.993827160493827 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 30473931 | 30473931 | PRJNA801875_P_NODE_2073_length_249_cov_2.598131_g1970_i0 | PRJNA801875 | 2073 | 249 | 2.598131 | 6.46934619 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 2.49e-15 | NR | KAJ8578052.1 | 4785 | g1970 | i0 | 56.3 | 2.83132530120482 | 80 | 25 | 89.2 | 3 | 2 | 223 | 175 | 250 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 705 | 78.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30600024 | 30600024 | PRJNA801875_P_NODE_313_length_819_cov_3.891582_g228_i0 | PRJNA801875 | 313 | 819 | 3.891582 | 31.87205658 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 7.09e-28 | NR | TMW55519.1 | 41045 | g228 | i0 | 49.6 | 1.35531135531136 | 123 | 60 | 45.1 | 2 | 5 | 373 | 201 | 321 | TMW55519.1 hypothetical protein Poli38472_010401 [Pythium oligandrum] | diamond | 1110 | 125 | 0.992 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30749268 | 30749268 | PRJNA801875_P_NODE_54_length_1706_cov_16.640335_g29_i0 | PRJNA801875 | 54 | 1706 | 16.640335 | 283.8841151 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 642 | 4.599999999999998e-225 | NR | OQS07615.1 | 74557 | g29 | i0 | 63.8 | 4.48769050410317 | 506 | 178 | 88.3 | 5 | 1594 | 89 | 3 | 507 | OQS07615.1 thioredoxin reductase [Thraustotheca clavata] | diamond | 7656 | 642 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 30938996 | 30938996 | PRJNA801875_P_NODE_2734_length_204_cov_2.284024_g2631_i0 | PRJNA801875 | 2734 | 204 | 2.284024 | 4.65940896 | Phytophthora nicotianae P1569 | 1317065 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 1.15e-7 | NR | ETI32568.1 | 1317065 | g2631 | i0 | 50.9 | 5.07352941176471 | 57 | 28 | 83.8 | 0 | 198 | 28 | 884 | 940 | ETI32568.1 hypothetical protein F443_20651 [Phytophthora nicotianae P1569] | diamond | 1035 | 57.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 31222992 | 31222992 | PRJNA801875_P_NODE_3475_length_176_cov_1.560284_g3372_i0 | PRJNA801875 | 3475 | 176 | 1.560284 | 2.74609984 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 5.03e-10 | NR | OQR84167.1 | 1202772 | g3372 | i0 | 51.2 | 0.698863636363636 | 41 | 20 | 69.9 | 0 | 125 | 3 | 445 | 485 | OQR84167.1 lysine-specific demethylase PHF2 [Achlya hypogyna] | diamond | 123 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 31665905 | 31665905 | PRJNA801875_P_NODE_1497_length_315_cov_1.457143_g1394_i0 | PRJNA801875 | 1497 | 315 | 1.457143 | 4.59000045 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 2.19e-5 | NR | KAH9118556.1 | 100861 | g1394 | i0 | 46.5 | 3.28571428571429 | 43 | 23 | 41 | 0 | 162 | 290 | 22 | 64 | KAH9118556.1 hypothetical protein AeMF1_008354, partial [Aphanomyces euteiches] | diamond | 1035 | 52 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32741021 | 32741021 | PRJNA801875_P_NODE_3300_length_181_cov_2.739726_g3197_i0 | PRJNA801875 | 3300 | 181 | 2.739726 | 4.95890406 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 2.54e-6 | NR | CCA15819.1 | 890382 | g3197 | i0 | 44.6 | 7.04419889502762 | 56 | 31 | 92.8 | 0 | 174 | 7 | 267 | 322 | CCA15819.1 protein kinase putative [Albugo laibachii Nc14] | diamond | 1275 | 53.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii |
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);;