contig_metadata
21 rows where bioproject = "PRJNA682774", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 664633 | 664633 | PRJNA682774_P_NODE_2121_length_310_cov_1.147679_g2092_i0 | PRJNA682774 | 2121 | 310 | 1.147679 | 3.5578049 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 8.919999999999999e-45 | NR | KAG2789316.1 | 29920 | g2092 | i0 | 78.4 | 61.1806451612903 | 102 | 22 | 98.7 | 0 | 3 | 308 | 228 | 329 | KAG2789316.1 Heat shock protein A [Phytophthora cactorum] | diamond | 18966 | 164 | 0.99390243902439 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 664637 | 664637 | PRJNA682774_P_NODE_2741_length_279_cov_1.509709_g2712_i0 | PRJNA682774 | 2741 | 279 | 1.509709 | 4.21208811 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 2.8099999999999997e-35 | NR | KAF1317690.1 | 82926 | g2712 | i0 | 82.1 | 5.25806451612903 | 78 | 14 | 83.9 | 0 | 45 | 278 | 4 | 81 | KAF1317690.1 Isocitrate dehydrogenase [nadp], mitochondrial, partial [Globisporangium splendens] | diamond | 1467 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 4492575 | 4492575 | PRJNA682774_P_NODE_2504_length_289_cov_2.166667_g2475_i0 | PRJNA682774 | 2504 | 289 | 2.166667 | 6.26166763 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.18e-40 | NTclustered | gi|669159439|ref|XM_008617060.1| | 1156394 | g2475 | i0 | 78.246 | 48.9031141868512 | 285 | 58 | 98 | 4 | 4 | 286 | 451 | 169 | Saprolegnia diclina VS20 60S ribosomal protein mRNA | blastn | 14133 | 180 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 14693623 | 14693623 | PRJNA682774_P_NODE_4792_length_245_cov_0.906977_g4763_i0 | PRJNA682774 | 4792 | 245 | 0.906977 | 2.22209365 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.22e-26 | NR | TMW69363.1 | 41045 | g4763 | i0 | 75 | 0.930612244897959 | 76 | 19 | 93.1 | 0 | 228 | 1 | 10 | 85 | TMW69363.1 hypothetical protein Poli38472_001519 [Pythium oligandrum] | diamond | 228 | 106 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 17242555 | 17242555 | PRJNA682774_P_NODE_1294_length_382_cov_2.012945_g1265_i0 | PRJNA682774 | 1294 | 382 | 2.012945 | 7.6894499 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 194 | 2.66e-57 | NR | KAJ8576152.1 | 4785 | g1265 | i0 | 73.2 | 7.97905759162304 | 127 | 34 | 99.7 | 0 | 382 | 2 | 209 | 335 | KAJ8576152.1 hypothetical protein ON010_g3057 [Phytophthora cinnamomi] | diamond | 3048 | 194 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 17242615 | 17242615 | PRJNA682774_P_NODE_5154_length_243_cov_0.917647_g5125_i0 | PRJNA682774 | 5154 | 243 | 0.917647 | 2.22988221 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 9.36e-61 | NTclustered | gi|813170664|ref|XM_012348698.1| | 695850 | g5125 | i0 | 85.062 | 96.8395061728395 | 241 | 36 | 99 | 0 | 2 | 242 | 410 | 170 | Saprolegnia parasitica CBS 223.65 tubulin alpha chain mRNA | blastn | 23532 | 246 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 19026450 | 19026450 | PRJNA682774_P_NODE_4355_length_248_cov_0.891429_g4326_i0 | PRJNA682774 | 4355 | 248 | 0.891429 | 2.21074392 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 2.24e-29 | NR | DAZ92625.1 | 4803 | g4326 | i0 | 62.2 | 12.8951612903226 | 82 | 31 | 99.2 | 0 | 248 | 3 | 82 | 163 | DAZ92625.1 TPA: hypothetical protein N0F65_011891 [Lagenidium giganteum] | diamond | 3198 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 22852163 | 22852163 | PRJNA682774_P_NODE_5178_length_243_cov_0.917647_g5149_i0 | PRJNA682774 | 5178 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 9.49e-51 | NTclustered | gi|156986897|gb|EU080062.1| | 4788 | g5149 | i0 | 83.122 | 97.0452674897119 | 237 | 36 | 97 | 2 | 9 | 243 | 1707 | 1473 | Phytophthora megasperma isolate PD_00017(P3136) heat shock protein 90 (HSP90) gene, partial cds | blastn | 23582 | 213 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 23617551 | 23617551 | PRJNA682774_P_NODE_3819_length_251_cov_0.876404_g3790_i0 | PRJNA682774 | 3819 | 251 | 0.876404 | 2.19977404 | Phytophthora lilii | 2077276 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 2.97e-30 | NR | GMF20109.1 | 2077276 | g3790 | i0 | 62.7 | 1.9840637450199201 | 83 | 30 | 99.2 | 1 | 249 | 1 | 9 | 90 | GMF20109.1 unnamed protein product [Phytophthora lilii] | diamond | 498 | 112 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lilii | ||
| 26702111 | 26702111 | PRJNA682774_P_NODE_1841_length_330_cov_1.509728_g1812_i0 | PRJNA682774 | 1841 | 330 | 1.509728 | 4.9821024 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.027 | NR | XP_009825362.1 | 112090 | g1812 | i0 | 44.9 | 1.4 | 49 | 26 | 43.6 | 1 | 308 | 165 | 371 | 419 | XP_009825362.1 hypothetical protein H257_03107 [Aphanomyces astaci] | diamond | 462 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 26777472 | 26777472 | PRJNA682774_P_NODE_4401_length_247_cov_1.793103_g4372_i0 | PRJNA682774 | 4401 | 247 | 1.793103 | 4.42896441 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 1.31e-4 | NR | KAF0739569.1 | 100861 | g4372 | i0 | 44.7 | 0.923076923076923 | 38 | 21 | 46.2 | 0 | 247 | 134 | 64 | 101 | KAF0739569.1 hypothetical protein Ae201684_004750 [Aphanomyces euteiches] | diamond | 228 | 48.1 | 0.993762993762994 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27271774 | 27271774 | PRJNA682774_P_NODE_4463_length_247_cov_0.896552_g4434_i0 | PRJNA682774 | 4463 | 247 | 0.896552 | 2.21448344 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 4.03e-8 | NR | KAF0716620.1 | 120398 | g4434 | i0 | 38.9 | 1.09311740890688 | 90 | 36 | 86.2 | 2 | 214 | 2 | 1 | 90 | KAF0716620.1 hypothetical protein As57867_002742 [Aphanomyces stellatus] | diamond | 270 | 59.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27966470 | 27966470 | PRJNA682774_P_NODE_4885_length_245_cov_0.906977_g4856_i0 | PRJNA682774 | 4885 | 245 | 0.906977 | 2.22209365 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 1.33e-16 | NR | OQS02292.1 | 74557 | g4856 | i0 | 46.8 | 4.8 | 79 | 42 | 96.7 | 0 | 4 | 240 | 276 | 354 | OQS02292.1 vacuolar proton translocating ATPase A subunit, partial [Thraustotheca clavata] | diamond | 1176 | 83.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 28913503 | 28913503 | PRJNA682774_P_NODE_1988_length_319_cov_0.955285_g1959_i0 | PRJNA682774 | 1988 | 319 | 0.955285 | 3.04735915 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 1.32e-4 | NR | DBA00340.1 | 4803 | g1959 | i0 | 41.4 | 1.22257053291536 | 70 | 32 | 58.3 | 2 | 1 | 186 | 332 | 400 | DBA00340.1 TPA: hypothetical protein N0F65_000525 [Lagenidium giganteum] | diamond | 390 | 50.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29229717 | 29229717 | PRJNA682774_P_NODE_3289_length_257_cov_1.695652_g3260_i0 | PRJNA682774 | 3289 | 257 | 1.695652 | 4.35782564 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 2.74e-6 | NR | DBA00492.1 | 4803 | g3260 | i0 | 38.4 | 1.89105058365759 | 73 | 45 | 85.2 | 0 | 13 | 231 | 51 | 123 | DBA00492.1 TPA: hypothetical protein N0F65_002735 [Lagenidium giganteum] | diamond | 486 | 54.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30271990 | 30271990 | PRJNA682774_P_NODE_5032_length_244_cov_0.912281_g5003_i0 | PRJNA682774 | 5032 | 244 | 0.912281 | 2.22596564 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 3.94e-8 | NR | KAH9089433.1 | 100861 | g5003 | i0 | 67.6 | 2.27459016393443 | 37 | 11 | 45.5 | 1 | 2 | 112 | 71 | 106 | KAH9089433.1 hypothetical protein LEN26_019153 [Aphanomyces euteiches] | diamond | 555 | 58.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30504604 | 30504604 | PRJNA682774_P_NODE_4713_length_246_cov_0.901734_g4684_i0 | PRJNA682774 | 4713 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 9.04e-25 | NR | TMW56563.1 | 41045 | g4684 | i0 | 74.3 | 8.03658536585366 | 74 | 19 | 90.2 | 0 | 24 | 245 | 567 | 640 | TMW56563.1 hypothetical protein Poli38472_006573 [Pythium oligandrum] | diamond | 1977 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31346206 | 31346206 | PRJNA682774_P_NODE_2716_length_280_cov_1.507246_g2687_i0 | PRJNA682774 | 2716 | 280 | 1.507246 | 4.2202888 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00457 | NR | TYZ65373.1 | 1485010 | g2687 | i0 | 38.2 | 1.43571428571429 | 68 | 40 | 72.9 | 2 | 206 | 3 | 410 | 475 | TYZ65373.1 hypothetical protein PybrP1_012697 [[Pythium] brassicae (nom. inval.)] | diamond | 402 | 45.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 32105261 | 32105261 | PRJNA682774_P_NODE_5358_length_242_cov_0.923077_g5329_i0 | PRJNA682774 | 5358 | 242 | 0.923077 | 2.23384634 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 1.55e-45 | NR | KAG9413282.1 | 112091 | g5329 | i0 | 95 | 0.991735537190083 | 80 | 4 | 99.2 | 0 | 2 | 241 | 210 | 289 | KAG9413282.1 hypothetical protein AC1031_012498 [Aphanomyces cochlioides] | diamond | 240 | 157 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 32654111 | 32654111 | PRJNA682774_P_NODE_5280_length_243_cov_0.917647_g5251_i0 | PRJNA682774 | 5280 | 243 | 0.917647 | 2.22988221 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 4.52e-22 | NR | DAZ99860.1 | 4803 | g5251 | i0 | 64.9 | 4.75308641975309 | 77 | 27 | 95.1 | 0 | 241 | 11 | 2050 | 2126 | DAZ99860.1 TPA: hypothetical protein N0F65_008603 [Lagenidium giganteum] | diamond | 1155 | 100 | 0.994 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32748855 | 32748855 | PRJNA682774_P_NODE_2840_length_275_cov_1.544554_g2811_i0 | PRJNA682774 | 2840 | 275 | 1.544554 | 4.2475235 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 2.15e-31 | NR | DAZ94790.1 | 4803 | g2811 | i0 | 71.4 | 10.8109090909091 | 77 | 22 | 84 | 0 | 3 | 233 | 294 | 370 | DAZ94790.1 TPA: hypothetical protein N0F65_002403, partial [Lagenidium giganteum] | diamond | 2973 | 124 | 0.991935483870968 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum |
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);;