contig_metadata
22 rows where bioproject = "PRJNA358490" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1073206 | 1073206 | PRJNA358490_P_NODE_12321_length_240_cov_1.621891_g11977_i0 | PRJNA358490 | 12321 | 240 | 1.621891 | 3.8925384 | root | 1 | Root_unresolved | Root_unresolved | 444 | 3.05e-120 | NTclustered | gi|166044661|emb|CU367570.1| | 100861 | g11977 | i0 | 100 | 99.6083333333333 | 240 | 0 | 100 | 0 | 1 | 240 | 348 | 587 | Aphanomyces euteiches cDNA | blastn | 23906 | 444 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 2348533 | 2348533 | PRJNA358490_P_NODE_10982_length_288_cov_1.670683_g10640_i0 | PRJNA358490 | 10982 | 288 | 1.670683 | 4.81156704 | root | 1 | Root_unresolved | Root_unresolved | 307 | 5.15e-79 | NTclustered | gi|166044469|emb|CU367378.1| | 100861 | g10640 | i0 | 100 | 46.6423611111111 | 166 | 0 | 58 | 0 | 123 | 288 | 69 | 234 | Aphanomyces euteiches cDNA | blastn | 13433 | 307 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 2348562 | 2348562 | PRJNA358490_P_NODE_17842_length_154_cov_1.373913_g17498_i0 | PRJNA358490 | 17842 | 154 | 1.373913 | 2.11582602 | root | 1 | Root_unresolved | Root_unresolved | 233 | 4.2099999999999994e-57 | NTclustered | gi|166046493|emb|CU367610.1| | 100861 | g17498 | i0 | 100 | 81.4090909090909 | 126 | 0 | 100 | 0 | 1 | 126 | 458 | 583 | Aphanomyces euteiches cDNA | blastn | 12537 | 233 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3623894 | 3623894 | PRJNA358490_P_NODE_16723_length_163_cov_1.629032_g16379_i0 | PRJNA358490 | 16723 | 163 | 1.629032 | 2.65532216 | root | 1 | Root_unresolved | Root_unresolved | 292 | 7.35e-75 | NTclustered | gi|166046728|emb|CU367838.1| | 100861 | g16379 | i0 | 100 | 98.4846625766871 | 158 | 0 | 97 | 0 | 6 | 163 | 534 | 691 | Aphanomyces euteiches cDNA | blastn | 16053 | 292 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 8725854 | 8725854 | PRJNA358490_P_NODE_14807_length_185_cov_1.623288_g14463_i0 | PRJNA358490 | 14807 | 185 | 1.623288 | 3.0030828 | root | 1 | Root_unresolved | Root_unresolved | 342 | 8.369999999999999e-90 | NTclustered | gi|166046493|emb|CU367610.1| | 100861 | g14463 | i0 | 100 | 99.9837837837838 | 185 | 0 | 100 | 0 | 1 | 185 | 177 | 361 | Aphanomyces euteiches cDNA | blastn | 18497 | 342 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 8725904 | 8725904 | PRJNA358490_P_NODE_8567_length_409_cov_1.191892_g8226_i0 | PRJNA358490 | 8567 | 409 | 1.191892 | 4.87483828 | root | 1 | Root_unresolved | Root_unresolved | 239 | 2.81e-58 | NTclustered | gi|166046625|emb|CU367742.1| | 100861 | g8226 | i0 | 100 | 32.919315403423 | 129 | 0 | 32 | 0 | 1 | 129 | 249 | 121 | Aphanomyces euteiches cDNA | blastn | 13464 | 239 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 10001340 | 10001340 | PRJNA358490_P_NODE_15148_length_180_cov_2.531915_g14804_i0 | PRJNA358490 | 15148 | 180 | 2.531915 | 4.557447 | root | 1 | Root_unresolved | Root_unresolved | 300 | 4.94e-77 | NTclustered | gi|166044558|emb|CU367467.1| | 100861 | g14804 | i0 | 97.714 | 96.8055555555556 | 175 | 3 | 97 | 1 | 1 | 175 | 310 | 137 | Aphanomyces euteiches cDNA | blastn | 17425 | 300 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 11276458 | 11276458 | PRJNA358490_P_NODE_4409_length_667_cov_1.511146_g4156_i0 | PRJNA358490 | 4409 | 667 | 1.511146 | 10.07934382 | root | 1 | Root_unresolved | Root_unresolved | 894 | 0 | NTclustered | gi|166046677|emb|CU367787.1| | 100861 | g4156 | i0 | 99.592 | 82.3868065967016 | 490 | 2 | 73 | 0 | 170 | 659 | 798 | 309 | Aphanomyces euteiches cDNA | blastn | 54952 | 894 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13152833 | 13152833 | PRJNA358490_P_NODE_6271_length_529_cov_1.848980_g5948_i0 | PRJNA358490 | 6271 | 529 | 1.84898 | 9.7811042 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 4.38e-122 | NTclustered | gi|166046664|emb|CU367774.1| | 100861 | g5948 | i0 | 100 | 82.3724007561437 | 244 | 0 | 46 | 0 | 267 | 510 | 31 | 274 | Aphanomyces euteiches cDNA | blastn | 43575 | 451 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13826641 | 13826641 | PRJNA358490_P_NODE_7211_length_474_cov_1.025287_g6877_i0 | PRJNA358490 | 7211 | 474 | 1.025287 | 4.85986038 | root | 1 | Root_unresolved | Root_unresolved | 309 | 2.48e-79 | NTclustered | gi|166046702|emb|CU367812.1| | 100861 | g6877 | i0 | 100 | 17.5801687763713 | 167 | 0 | 65 | 0 | 308 | 474 | 550 | 384 | Aphanomyces euteiches cDNA | blastn | 8333 | 309 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16375683 | 16375683 | PRJNA358490_P_NODE_15933_length_171_cov_1.227273_g15589_i0 | PRJNA358490 | 15933 | 171 | 1.227273 | 2.09863683 | root | 1 | Root_unresolved | Root_unresolved | 316 | 4.6e-82 | NTclustered | gi|166046651|emb|CU367768.1| | 100861 | g15589 | i0 | 100 | 4 | 171 | 0 | 100 | 0 | 1 | 171 | 247 | 417 | Aphanomyces euteiches cDNA | blastn | 684 | 316 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16375695 | 16375695 | PRJNA358490_P_NODE_18533_length_150_cov_1.081081_g18189_i0 | PRJNA358490 | 18533 | 150 | 1.081081 | 1.6216215 | root | 1 | Root_unresolved | Root_unresolved | 278 | 1.85e-70 | NTclustered | gi|166046503|emb|CU367620.1| | 100861 | g18189 | i0 | 100 | 16.92 | 150 | 0 | 100 | 0 | 1 | 150 | 414 | 563 | Aphanomyces euteiches cDNA | blastn | 2538 | 278 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16976321 | 16976321 | PRJNA358490_P_NODE_11474_length_269_cov_2.569565_g11130_i0 | PRJNA358490 | 11474 | 269 | 2.569565 | 6.91212985 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.0499999999999994e-132 | NTclustered | gi|166046639|emb|CU367756.1| | 100861 | g11130 | i0 | 100 | 96.5650557620818 | 262 | 0 | 97 | 0 | 8 | 269 | 421 | 160 | Aphanomyces euteiches cDNA | blastn | 25976 | 484 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18924676 | 18924676 | PRJNA358490_P_NODE_16415_length_166_cov_1.283465_g16071_i0 | PRJNA358490 | 16415 | 166 | 1.283465 | 2.1305519 | root | 1 | Root_unresolved | Root_unresolved | 307 | 2.69e-79 | NTclustered | gi|166046589|emb|CU367706.1| | 100861 | g16071 | i0 | 100 | 123.126506024096 | 166 | 0 | 100 | 0 | 1 | 166 | 372 | 537 | Aphanomyces euteiches cDNA | blastn | 20439 | 307 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20800514 | 20800514 | PRJNA358490_P_NODE_18517_length_150_cov_1.099099_g18173_i0 | PRJNA358490 | 18517 | 150 | 1.099099 | 1.6486485 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 1.85e-70 | NTclustered | gi|166044497|emb|CU367406.1| | 100861 | g18173 | i0 | 100 | 71.5 | 150 | 0 | 100 | 0 | 1 | 150 | 664 | 515 | Aphanomyces euteiches cDNA | blastn | 10725 | 278 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22750048 | 22750048 | PRJNA358490_P_NODE_16878_length_162_cov_0.983740_g16534_i0 | PRJNA358490 | 16878 | 162 | 0.98374 | 1.5936588 | root | 1 | Root_unresolved | Root_unresolved | 289 | 9.44e-74 | NTclustered | gi|166046470|emb|CU367587.1| | 100861 | g16534 | i0 | 98.765 | 94.9012345679012 | 162 | 2 | 100 | 0 | 1 | 162 | 65 | 226 | Aphanomyces euteiches cDNA | blastn | 15374 | 289 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22750063 | 22750063 | PRJNA358490_P_NODE_4958_length_622_cov_1.331046_g4683_i0 | PRJNA358490 | 4958 | 622 | 1.331046 | 8.27910612 | root | 1 | Root_unresolved | Root_unresolved | 544 | 8.35e-150 | NTclustered | gi|166044635|emb|CU367544.1| | 100861 | g4683 | i0 | 92.737 | 49.1382636655949 | 358 | 22 | 58 | 2 | 265 | 622 | 78 | 431 | Aphanomyces euteiches cDNA | blastn | 30564 | 544 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 23351087 | 23351087 | PRJNA358490_P_NODE_8859_length_394_cov_5.509859_g8518_i0 | PRJNA358490 | 8859 | 394 | 5.509859 | 21.70884446 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 667 | 0 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g8518 | i0 | 99.455 | 96.1979695431472 | 367 | 2 | 93 | 0 | 28 | 394 | 9861 | 9495 | Pythium ultimum mitochondrion, complete genome | blastn | 37902 | 667 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 25299388 | 25299388 | PRJNA358490_P_NODE_16820_length_162_cov_1.674797_g16476_i0 | PRJNA358490 | 16820 | 162 | 1.674797 | 2.71317114 | root | 1 | Root_unresolved | Root_unresolved | 294 | 2.03e-75 | NTclustered | gi|166046611|emb|CU367728.1| | 100861 | g16476 | i0 | 99.383 | 95.5246913580247 | 162 | 1 | 100 | 0 | 1 | 162 | 264 | 425 | Aphanomyces euteiches cDNA | blastn | 15475 | 294 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 25299392 | 25299392 | PRJNA358490_P_NODE_17760_length_154_cov_3.426087_g17416_i0 | PRJNA358490 | 17760 | 154 | 3.426087 | 5.27617398 | root | 1 | Root_unresolved | Root_unresolved | 285 | 1.14e-72 | NTclustered | gi|166044558|emb|CU367467.1| | 100861 | g17416 | i0 | 100 | 99.8701298701299 | 154 | 0 | 100 | 0 | 1 | 154 | 308 | 461 | Aphanomyces euteiches cDNA | blastn | 15380 | 285 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 28197268 | 28197268 | PRJNA358490_P_NODE_6846_length_493_cov_11.160793_g6515_i0 | PRJNA358490 | 6846 | 493 | 11.160793 | 55.02270949 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.88e-5 | NR | TMW59321.1 | 41045 | g6515 | i0 | 32.2 | 4.87423935091278 | 115 | 74 | 70 | 2 | 109 | 453 | 624 | 734 | TMW59321.1 hypothetical protein Poli38472_004390 [Pythium oligandrum] | diamond | 2403 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29807575 | 29807575 | PRJNA358490_P_NODE_4971_length_620_cov_3.745267_g4696_i0 | PRJNA358490 | 4971 | 620 | 3.745267 | 23.2206554 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 190 | 1.27e-53 | NR | KAF1787781.1 | 29920 | g4696 | i0 | 56.4 | 14.7241935483871 | 179 | 72 | 85.6 | 2 | 6 | 536 | 379 | 553 | KAF1787781.1 Transglutaminase elicitor [Phytophthora cactorum] | diamond | 9129 | 191 | 0.994764397905759 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum |
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);;