contig_metadata
18 rows where bioproject = "PRJNA784979", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2488888 | 2488888 | PRJNA784979_S_NODE_4402_length_225_cov_3.369318_g4360_i0 | PRJNA784979 | 4402 | 225 | 3.369318 | 7.5809655 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.76e-92 | NTclustered | gi|338798067|gb|HQ665128.1| | 82934 | g4360 | i0 | 95.872 | 96.4177777777778 | 218 | 8 | 97 | 1 | 8 | 225 | 772 | 556 | Pythium coloratum isolate CBS 154.64 28S large subunit ribosomal RNA gene, partial sequence | blastn | 21694 | 351 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium coloratum | ||
| 5869027 | 5869027 | PRJNA784979_S_NODE_11505_length_164_cov_4.513043_g11463_i0 | PRJNA784979 | 11505 | 164 | 4.513043 | 7.40139052 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 9.65e-69 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g11463 | i0 | 97.5 | 34.6768292682927 | 160 | 3 | 98 | 1 | 1 | 160 | 553 | 711 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 5687 | 272 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 6317367 | 6317367 | PRJNA784979_S_NODE_13665_length_158_cov_3.844037_g13623_i0 | PRJNA784979 | 13665 | 158 | 3.844037 | 6.07357846 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 5.54e-66 | NTclustered | gi|531037395|gb|AY598672.2| | 4798 | g13623 | i0 | 98.026 | 96.1962025316456 | 152 | 2 | 96 | 1 | 2 | 153 | 1633 | 1483 | Pythium hydnosporum strain CBS 253.60 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 | 15199 | 263 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium hydnosporum | ||
| 7144016 | 7144016 | PRJNA784979_S_NODE_2046_length_325_cov_1.568841_g2004_i0 | PRJNA784979 | 2046 | 325 | 1.568841 | 5.09873325 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 547 | 3.199999999999999e-151 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g2004 | i0 | 97.792 | 92.2769230769231 | 317 | 7 | 98 | 0 | 3 | 319 | 433 | 117 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 29990 | 547 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 7144051 | 7144051 | PRJNA784979_S_NODE_8046_length_181_cov_3.727273_g8004_i0 | PRJNA784979 | 8046 | 181 | 3.727273 | 6.74636413 | Pythium sp. AP | 378252 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 3.04e-64 | NTclustered | gi|90855438|dbj|AB254193.1| | 378252 | g8004 | i0 | 93.678 | 31.4088397790055 | 174 | 7 | 95 | 3 | 10 | 181 | 77 | 248 | Pythium sp. AP genes for 28S rRNA, IGS, 5S rRNA, partial and complete sequence, strain: AP-1, AP-2 and AP-3 | blastn | 5685 | 257 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium sp. AP | ||
| 12693060 | 12693060 | PRJNA784979_S_NODE_1850_length_346_cov_3.074074_g1808_i0 | PRJNA784979 | 1850 | 346 | 3.074074 | 10.63629604 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 617 | 2.5699999999999998e-172 | NTclustered | gi|505574769|gb|AY598634.2| | 82936 | g1808 | i0 | 99.412 | 99.9537572254335 | 340 | 2 | 98 | 0 | 6 | 345 | 933 | 594 | Pythium dissotocum strain CBS 166.68 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 | 34584 | 621 | 0.993558776167472 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium dissotocum | ||
| 13967307 | 13967307 | PRJNA784979_S_NODE_2371_length_299_cov_1.924000_g2329_i0 | PRJNA784979 | 2371 | 299 | 1.924 | 5.75276 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.81e-123 | NTclustered | gi|292680097|dbj|AB468703.1| | 82936 | g2329 | i0 | 100 | 82.2775919732441 | 246 | 0 | 82 | 0 | 49 | 294 | 32 | 277 | Pythium dissotocum gene for large subunit ribosomal RNA, partial sequence, strain: UZ159 | blastn | 24601 | 455 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium dissotocum | ||
| 15241859 | 15241859 | PRJNA784979_S_NODE_9992_length_168_cov_1.378151_g9950_i0 | PRJNA784979 | 9992 | 168 | 1.378151 | 2.31529368 | Globisporangium | 1448052 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 9.81e-79 | NTclustered | gi|505574786|gb|AY598655.2| | 82926 | g9950 | i0 | 100 | 98.1964285714286 | 165 | 0 | 98 | 0 | 4 | 168 | 3867 | 4031 | Globisporangium splendens strain CBS 462.48 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 | 16497 | 305 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 17791116 | 17791116 | PRJNA784979_S_NODE_9294_length_172_cov_2.089431_g9252_i0 | PRJNA784979 | 9294 | 172 | 2.089431 | 3.59382132 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 3.68e-63 | NTclustered | gi|2661426469|ref|XR_009934769.1| | 403677 | g9252 | i0 | 93.529 | 96.8430232558139 | 170 | 11 | 99 | 0 | 3 | 172 | 1625 | 1794 | Phytophthora infestans T30-4 28S ribosomal RNA (PITG_33375), rRNA | blastn | 16657 | 254 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 20339798 | 20339798 | PRJNA784979_S_NODE_6576_length_195_cov_1.280822_g6534_i0 | PRJNA784979 | 6576 | 195 | 1.280822 | 2.4976029 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.15e-88 | NTclustered | gi|338798216|gb|HQ665277.1| | 135481 | g6534 | i0 | 98.947 | 97.451282051282 | 190 | 1 | 97 | 1 | 5 | 194 | 827 | 1015 | Lagenidium caudatum isolate CBS 584.85 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19003 | 339 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium caudatum | ||
| 23718394 | 23718394 | PRJNA784979_S_NODE_6079_length_200_cov_2.231788_g6037_i0 | PRJNA784979 | 6079 | 200 | 2.231788 | 4.463576 | Leptolegnia sp. CBS 177.86 | 170620 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.24e-58 | NTclustered | gi|17224985|gb|AF320588.1| | 170620 | g6037 | i0 | 94.231 | 79.71 | 156 | 9 | 78 | 0 | 13 | 168 | 856 | 701 | Leptolegnia sp. CBS177.86 28S ribosomal RNA gene, partial sequence | blastn | 15942 | 239 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Leptolegnia | Leptolegnia sp. CBS 177.86 | ||
| 26832176 | 26832176 | PRJNA784979_S_NODE_5821_length_204_cov_1.077419_g5779_i0 | PRJNA784979 | 5821 | 204 | 1.077419 | 2.19793476 | Phytophthora lilii | 2077276 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 6.71e-12 | NR | GMF31033.1 | 2077276 | g5779 | i0 | 56.1 | 0.838235294117647 | 57 | 25 | 83.8 | 0 | 199 | 29 | 113 | 169 | GMF31033.1 unnamed protein product [Phytophthora lilii] | diamond | 171 | 69.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lilii | ||
| 27116641 | 27116641 | PRJNA784979_S_NODE_9382_length_172_cov_1.130081_g9340_i0 | PRJNA784979 | 9382 | 172 | 1.130081 | 1.94373932 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 6.12e-14 | NR | KAF4128241.1 | 4787 | g9340 | i0 | 60.7 | 0.976744186046512 | 56 | 21 | 97.7 | 1 | 170 | 3 | 27 | 81 | KAF4128241.1 hypothetical protein GN958_ATG22563 [Phytophthora infestans] | diamond | 168 | 73.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 27464609 | 27464609 | PRJNA784979_S_NODE_8223_length_180_cov_1.877863_g8181_i0 | PRJNA784979 | 8223 | 180 | 1.877863 | 3.3801534 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 4.14e-8 | NR | KAE9302619.1 | 53985 | g8181 | i0 | 77.1 | 0.8 | 48 | 10 | 78.3 | 1 | 148 | 8 | 34 | 81 | KAE9302619.1 hypothetical protein PF008_g22450 [Phytophthora fragariae] | diamond | 144 | 58.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 30189257 | 30189257 | PRJNA784979_S_NODE_10592_length_166_cov_1.811966_g10550_i0 | PRJNA784979 | 10592 | 166 | 1.811966 | 3.00786356 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 4.1e-10 | NR | KAF4128246.1 | 4787 | g10550 | i0 | 60.7 | 6.05421686746988 | 56 | 19 | 97.6 | 2 | 3 | 164 | 67 | 121 | KAF4128246.1 hypothetical protein GN958_ATG22568 [Phytophthora infestans] | diamond | 1005 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 30852784 | 30852784 | PRJNA784979_S_NODE_6494_length_196_cov_1.034014_g6452_i0 | PRJNA784979 | 6494 | 196 | 1.034014 | 2.02666744 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 7.12e-11 | NR | KAF4128243.1 | 4787 | g6452 | i0 | 40.3 | 2.05102040816327 | 67 | 38 | 99.5 | 1 | 195 | 1 | 57 | 123 | KAF4128243.1 hypothetical protein GN958_ATG22565 [Phytophthora infestans] | diamond | 402 | 63.9 | 0.993740219092332 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31064965 | 31064965 | PRJNA784979_S_NODE_5335_length_210_cov_1.136646_g5293_i0 | PRJNA784979 | 5335 | 210 | 1.136646 | 2.3869566 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 2.02e-14 | NR | KAF0714686.1 | 120398 | g5293 | i0 | 53.8 | 0.928571428571429 | 65 | 28 | 90 | 1 | 199 | 11 | 283 | 347 | KAF0714686.1 hypothetical protein As57867_003739 [Aphanomyces stellatus] | diamond | 195 | 76.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 32424874 | 32424874 | PRJNA784979_S_NODE_5059_length_214_cov_1.539394_g5017_i0 | PRJNA784979 | 5059 | 214 | 1.539394 | 3.29430316 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 8.93e-5 | NR | GMF22350.1 | 1490495 | g5017 | i0 | 56.9 | 0.714953271028037 | 51 | 21 | 70.1 | 1 | 152 | 3 | 184 | 234 | GMF22350.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 153 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia |
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);;