contig_metadata
17 rows where bioproject = "PRJNA315399", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2932733 | 2932733 | PRJNA315399_P_NODE_249223_length_182_cov_2.427586_g248775_i0 | PRJNA315399 | 249223 | 182 | 2.427586 | 4.41820652 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.21e-29 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g248775 | i0 | 100 | 1.01098901098901 | 76 | 0 | 81 | 0 | 107 | 182 | 1107 | 1182 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 184 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 2933735 | 2933735 | PRJNA315399_P_NODE_414623_length_160_cov_3.235772_g414175_i0 | PRJNA315399 | 414623 | 160 | 3.235772 | 5.1772352 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 9.559999999999999e-54 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g414175 | i0 | 93.377 | 1.29375 | 151 | 9 | 94 | 1 | 9 | 159 | 1082 | 1231 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 207 | 222 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 5487786 | 5487786 | PRJNA315399_S_NODE_105125_length_176_cov_3.359712_g104924_i0 | PRJNA315399 | 105125 | 176 | 3.359712 | 5.91309312 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.98e-80 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g104924 | i0 | 100 | 98.6818181818182 | 167 | 0 | 95 | 0 | 7 | 173 | 9650 | 9484 | Pythium ultimum mitochondrion, complete genome | blastn | 17368 | 309 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 6762877 | 6762877 | PRJNA315399_S_NODE_39866_length_228_cov_12.890052_g39665_i0 | PRJNA315399 | 39866 | 228 | 12.890052 | 29.38931856 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 9.39e-6 | NTclustered | gi|2794915906|ref|XM_067893153.1| | 164328 | g39665 | i0 | 93.023 | 0.18859649122807 | 43 | 3 | 19 | 0 | 174 | 216 | 570 | 528 | Phytophthora ramorum 60S ribosomal protein L18-2 (KRP23_7794), partial mRNA | blastn | 43 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 9309523 | 9309523 | PRJNA315399_P_NODE_154168_length_188_cov_6.450331_g153720_i0 | PRJNA315399 | 154168 | 188 | 6.450331 | 12.12662228 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 9.43e-20 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g153720 | i0 | 92.308 | 33.6755319148936 | 78 | 4 | 70 | 2 | 100 | 175 | 10196 | 10273 | Pythium ultimum mitochondrion, complete genome | blastn | 6331 | 110 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 13820046 | 13820046 | PRJNA315399_S_NODE_144391_length_162_cov_5.528000_g144190_i0 | PRJNA315399 | 144391 | 162 | 5.528 | 8.95536 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.25e-57 | NTclustered | gi|1820797599|gb|MT192342.1| | 4798 | g144190 | i0 | 95.862 | 89.5061728395062 | 145 | 6 | 90 | 0 | 1 | 145 | 260 | 116 | Pythium hydnosporum isolate JZB3410001 large subunit ribosomal RNA gene, partial sequence | blastn | 14500 | 235 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium hydnosporum | ||
| 15687896 | 15687896 | PRJNA315399_S_NODE_41173_length_226_cov_9.269841_g40972_i0 | PRJNA315399 | 41173 | 226 | 9.269841 | 20.94984066 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.7799999999999993e-87 | NTclustered | gi|325195136|emb|FR825930.1| | 890382 | g40972 | i0 | 100 | 15.4778761061947 | 181 | 0 | 80 | 0 | 12 | 192 | 1 | 181 | Albugo laibachii Nc14, genomic contig CONTIG_2990_NC14_v4_499_54 | blastn | 3498 | 335 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 19511156 | 19511156 | PRJNA315399_S_NODE_34456_length_238_cov_5.238806_g34255_i0 | PRJNA315399 | 34456 | 238 | 5.238806 | 12.46835828 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 5.16e-103 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g34255 | i0 | 96.957 | 100.911764705882 | 230 | 7 | 97 | 0 | 1 | 230 | 9172 | 9401 | Pythium ultimum mitochondrion, complete genome | blastn | 24017 | 387 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 20785994 | 20785994 | PRJNA315399_S_NODE_147877_length_161_cov_5.766129_g147676_i0 | PRJNA315399 | 147877 | 161 | 5.766129 | 9.28346769 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 7.72e-30 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g147676 | i0 | 86.331 | 9.50310559006211 | 139 | 10 | 83 | 8 | 1 | 133 | 308 | 173 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 1530 | 143 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 22058919 | 22058919 | PRJNA315399_P_NODE_303538_length_178_cov_7.680851_g303090_i0 | PRJNA315399 | 303538 | 178 | 7.680851 | 13.67191478 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|325196118|emb|FR826908.1| | 890382 | g303090 | i0 | 100 | 0.157303370786517 | 28 | 0 | 16 | 0 | 114 | 141 | 147 | 174 | Albugo laibachii Nc14, genomic contig CONTIG_4075_NC14_v4_276_8 | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 23334356 | 23334356 | PRJNA315399_P_NODE_285299_length_179_cov_6.485915_g284851_i0 | PRJNA315399 | 285299 | 179 | 6.485915 | 11.60978785 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.9300000000000005e-79 | NTclustered | gi|1378166683|ref|XM_024717537.1| | 4781 | g284851 | i0 | 99.412 | 2.89385474860335 | 170 | 0 | 94 | 1 | 6 | 174 | 62 | 231 | Plasmopara halstedii uncharacterized protein (PHALS_03264), partial mRNA | blastn | 518 | 307 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 28291855 | 28291855 | PRJNA315399_S_NODE_160846_length_158_cov_2.760331_g160645_i0 | PRJNA315399 | 160846 | 158 | 2.760331 | 4.36132298 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 6.38e-22 | NR | CAI5714890.1 | 134698 | g160645 | i0 | 94.2 | 9.87341772151899 | 52 | 3 | 98.7 | 0 | 3 | 158 | 371 | 422 | CAI5714890.1 unnamed protein product [Peronospora farinosa] | diamond | 1560 | 97.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 29190377 | 29190377 | PRJNA315399_S_NODE_76029_length_192_cov_1.825806_g75828_i0 | PRJNA315399 | 76029 | 192 | 1.825806 | 3.50554752 | Peronospora effusa | 542832 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 2.77e-20 | NR | RQM17341.1 | 542832 | g75828 | i0 | 96.2 | 3.25 | 52 | 2 | 81.3 | 0 | 187 | 32 | 154 | 205 | RQM17341.1 hypothetical protein DD237_001082 [Peronospora effusa] | diamond | 624 | 93.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 29726714 | 29726714 | PRJNA315399_P_NODE_491810_length_152_cov_2.834783_g491362_i0 | PRJNA315399 | 491810 | 152 | 2.834783 | 4.30887016 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00425 | NR | TMW63265.1 | 41045 | g491362 | i0 | 42.6 | 1.20394736842105 | 61 | 21 | 92.8 | 1 | 10 | 150 | 37 | 97 | TMW63265.1 hypothetical protein Poli38472_002206 [Pythium oligandrum] | diamond | 183 | 43.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30548268 | 30548268 | PRJNA315399_P_NODE_226933_length_183_cov_4.246575_g226485_i0 | PRJNA315399 | 226933 | 183 | 4.246575 | 7.77123225 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 4.49e-11 | NR | KAG1690634.1 | 4784 | g226485 | i0 | 73.9 | 7.54098360655738 | 46 | 8 | 75.4 | 1 | 39 | 176 | 135 | 176 | KAG1690634.1 hypothetical protein DVH05_027985 [Phytophthora capsici] | diamond | 1380 | 67 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 31008170 | 31008170 | PRJNA315399_S_NODE_43114_length_224_cov_1.641711_g42913_i0 | PRJNA315399 | 43114 | 224 | 1.641711 | 3.67743264 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.75e-22 | NR | XP_012198630.1 | 695850 | g42913 | i0 | 60.9 | 1.83482142857143 | 69 | 27 | 92.4 | 0 | 4 | 210 | 316 | 384 | XP_012198630.1 hypothetical protein SPRG_19678 [Saprolegnia parasitica CBS 223.65] | diamond | 411 | 100 | 0.99 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 32414047 | 32414047 | PRJNA315399_P_NODE_241419_length_182_cov_4.786207_g240971_i0 | PRJNA315399 | 241419 | 182 | 4.786207 | 8.71089674 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 39.7 | 0.0388 | NR | GMF59784.1 | 1490495 | g240971 | i0 | 39.6 | 0.791208791208791 | 48 | 26 | 74.2 | 1 | 20 | 154 | 24 | 71 | GMF59784.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 144 | 39.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);;