contig_metadata
22 rows where bioproject = "PRJEB673", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134878 | 134878 | PRJEB673_P_NODE_10961_length_166_cov_2.511450_g10612_i0 | PRJEB673 | 10961 | 166 | 2.51145 | 4.169007 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 1.64e-66 | NTclustered | gi|256009645|gb|GQ374534.1| | 112090 | g10612 | i0 | 95.732 | 59.433734939759 | 164 | 7 | 99 | 0 | 3 | 166 | 264 | 427 | Aphanomyces astaci strain Gb04 28S ribosomal RNA gene, partial sequence | blastn | 9866 | 265 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 134942 | 134942 | PRJEB673_P_NODE_5721_length_369_cov_3.844311_g5372_i0 | PRJEB673 | 5721 | 369 | 3.844311 | 14.18550759 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.92e-64 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g5372 | i0 | 79.89 | 91.6178861788618 | 363 | 65 | 96 | 4 | 1 | 356 | 429 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33807 | 259 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 5237449 | 5237449 | PRJEB673_P_NODE_3365_length_544_cov_2.504912_g3047_i0 | PRJEB673 | 3365 | 544 | 2.504912 | 13.62672128 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 2.96e-59 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g3047 | i0 | 79.05 | 14.5680147058824 | 358 | 71 | 65 | 4 | 84 | 439 | 127 | 482 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 7925 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 6098472 | 6098472 | PRJEB673_P_NODE_12645_length_152_cov_1.478632_g12296_i0 | PRJEB673 | 12645 | 152 | 1.478632 | 2.24752064 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 1.51e-46 | NTclustered | gi|698791719|ref|XM_009830590.1| | 112090 | g12296 | i0 | 90.132 | 4.82236842105263 | 152 | 15 | 100 | 0 | 1 | 152 | 865 | 714 | Aphanomyces astaci hypothetical protein partial mRNA | blastn | 733 | 198 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 6512971 | 6512971 | PRJEB673_P_NODE_10646_length_170_cov_3.851852_g10297_i0 | PRJEB673 | 10646 | 170 | 3.851852 | 6.5481484 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 1.64e-81 | NTclustered | gi|1578815423|gb|MK546600.1| | 1982524 | g10297 | i0 | 100 | 100.041176470588 | 170 | 0 | 100 | 0 | 1 | 170 | 834 | 665 | Aphanomyces sp. voucher CPZ14 large subunit ribosomal RNA gene, partial sequence | blastn | 17007 | 315 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 6513073 | 6513073 | PRJEB673_P_NODE_9706_length_189_cov_1.818182_g9357_i0 | PRJEB673 | 9706 | 189 | 1.818182 | 3.43636398 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 4.14e-63 | NTclustered | gi|166035705|emb|CU351918.1| | 100861 | g9357 | i0 | 90.957 | 15.9153439153439 | 188 | 17 | 99 | 0 | 1 | 188 | 538 | 725 | Aphanomyces euteiches cDNA | blastn | 3008 | 254 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9923347 | 9923347 | PRJEB673_P_NODE_11908_length_157_cov_1.967213_g11559_i0 | PRJEB673 | 11908 | 157 | 1.967213 | 3.08852441 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 5.66e-46 | NTclustered | gi|301107178|ref|XM_002902626.1| | 403677 | g11559 | i0 | 89.308 | 3.01273885350318 | 159 | 13 | 100 | 2 | 1 | 157 | 872 | 716 | Phytophthora infestans T30-4 40S ribosomal protein S2 (PITG_10146), mRNA | blastn | 473 | 196 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 10337967 | 10337967 | PRJEB673_P_NODE_4289_length_464_cov_4.897436_g3946_i0 | PRJEB673 | 4289 | 464 | 4.897436 | 22.72410304 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|695382888|ref|XM_009519246.1| | 67593 | g3946 | i0 | 92.5 | 0.271551724137931 | 40 | 3 | 9 | 0 | 230 | 269 | 398 | 359 | Phytophthora sojae hypothetical protein mRNA | blastn | 126 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 10337976 | 10337976 | PRJEB673_P_NODE_5289_length_389_cov_1.748588_g4940_i0 | PRJEB673 | 5289 | 389 | 1.748588 | 6.80200732 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 4.61e-31 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g4940 | i0 | 79.904 | 10.866323907455 | 209 | 36 | 53 | 6 | 15 | 220 | 997 | 1202 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 4227 | 148 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 17986541 | 17986541 | PRJEB673_P_NODE_8255_length_290_cov_1.458824_g7906_i0 | PRJEB673 | 8255 | 290 | 1.458824 | 4.2305896 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 8.2e-40 | NR | TMW62875.1 | 41045 | g7906 | i0 | 71.6 | 1.97586206896552 | 95 | 25 | 98.3 | 1 | 290 | 6 | 49 | 141 | TMW62875.1 hypothetical protein Poli38472_005493 [Pythium oligandrum] | diamond | 573 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 20535774 | 20535774 | PRJEB673_P_NODE_12377_length_154_cov_1.344538_g12028_i0 | PRJEB673 | 12377 | 154 | 1.344538 | 2.07058852 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.2200000000000002e-27 | NTclustered | gi|2794921676|ref|XM_067881069.1| | 164328 | g12028 | i0 | 84.559 | 2.97402597402597 | 136 | 21 | 88 | 0 | 15 | 150 | 353 | 218 | Phytophthora ramorum 40S ribosomal protein S8 (KRP23_10601), partial mRNA | blastn | 458 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 24360729 | 24360729 | PRJEB673_P_NODE_5720_length_369_cov_4.284431_g5371_i0 | PRJEB673 | 5720 | 369 | 4.284431 | 15.80955039 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 532 | 1.03e-146 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g5371 | i0 | 92.722 | 76.6314363143631 | 371 | 23 | 100 | 4 | 1 | 369 | 1319 | 1687 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 28277 | 532 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 27286957 | 27286957 | PRJEB673_P_NODE_10623_length_171_cov_1.176471_g10274_i0 | PRJEB673 | 10623 | 171 | 1.176471 | 2.01176541 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 1.7e-25 | NR | KAF1322632.1 | 82926 | g10274 | i0 | 91.2 | 1 | 57 | 5 | 100 | 0 | 171 | 1 | 258 | 314 | KAF1322632.1 Adp/atp translocase 1, partial [Globisporangium splendens] | diamond | 171 | 105 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 27785290 | 27785290 | PRJEB673_P_NODE_10944_length_167_cov_1.189394_g10595_i0 | PRJEB673 | 10944 | 167 | 1.189394 | 1.98628798 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 2.48e-16 | NR | DBA05130.1 | 4803 | g10595 | i0 | 66.7 | 4.77844311377245 | 54 | 18 | 97 | 0 | 164 | 3 | 141 | 194 | DBA05130.1 TPA: hypothetical protein N0F65_004980 [Lagenidium giganteum] | diamond | 798 | 80.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28171114 | 28171114 | PRJEB673_P_NODE_10946_length_167_cov_1.174242_g10597_i0 | PRJEB673 | 10946 | 167 | 1.174242 | 1.96098414 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 1.68e-16 | NR | KAE9192436.1 | 53985 | g10597 | i0 | 72.7 | 7.90419161676647 | 55 | 14 | 98.8 | 1 | 166 | 2 | 45 | 98 | KAE9192436.1 hypothetical protein PF005_g18457 [Phytophthora fragariae] | diamond | 1320 | 77.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 29749550 | 29749550 | PRJEB673_P_NODE_12831_length_151_cov_1.379310_g12482_i0 | PRJEB673 | 12831 | 151 | 1.37931 | 2.0827581 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 4.14e-12 | NR | TMW55385.1 | 41045 | g12482 | i0 | 86.1 | 0.71523178807947 | 36 | 5 | 71.5 | 0 | 2 | 109 | 72 | 107 | TMW55385.1 hypothetical protein Poli38472_013276 [Pythium oligandrum] | diamond | 108 | 65.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29781394 | 29781394 | PRJEB673_P_NODE_10711_length_170_cov_1.185185_g10362_i0 | PRJEB673 | 10711 | 170 | 1.185185 | 2.0148145 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.00992 | NR | DAZ98250.1 | 4803 | g10362 | i0 | 90 | 0.352941176470588 | 20 | 2 | 35.3 | 0 | 159 | 100 | 260 | 279 | DAZ98250.1 TPA: hypothetical protein N0F65_008935 [Lagenidium giganteum] | diamond | 60 | 43.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30760899 | 30760899 | PRJEB673_P_NODE_11414_length_161_cov_1.904762_g11065_i0 | PRJEB673 | 11414 | 161 | 1.904762 | 3.06666682 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 9.309999999999999e-28 | NR | KAL0585048.1 | 65357 | g11065 | i0 | 96.2 | 4.93788819875776 | 53 | 2 | 98.8 | 0 | 160 | 2 | 142 | 194 | KAL0585048.1 hypothetical protein ABG067_005185 [Albugo candida] | diamond | 795 | 109 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 30918982 | 30918982 | PRJEB673_P_NODE_11294_length_162_cov_2.291339_g10945_i0 | PRJEB673 | 11294 | 162 | 2.291339 | 3.71196918 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 9.449999999999999e-25 | NR | KAG6952591.1 | 29920 | g10945 | i0 | 83 | 0.981481481481482 | 53 | 9 | 98.1 | 0 | 3 | 161 | 22 | 74 | KAG6952591.1 hypothetical protein JG687_00012914, partial [Phytophthora cactorum] | diamond | 159 | 101 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 31322387 | 31322387 | PRJEB673_P_NODE_1355_length_814_cov_2.216945_g1135_i0 | PRJEB673 | 1355 | 814 | 2.216945 | 18.0459323 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 6.439999999999999e-67 | NR | KAG7400572.1 | 109152 | g1135 | i0 | 57.3 | 5.7051597051597 | 220 | 83 | 77.4 | 3 | 179 | 808 | 47 | 265 | KAG7400572.1 60S ribosomal protein L7A [Phytophthora boehmeriae] | diamond | 4644 | 219 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 31993917 | 31993917 | PRJEB673_P_NODE_10758_length_169_cov_1.470149_g10409_i0 | PRJEB673 | 10758 | 169 | 1.470149 | 2.48455181 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 3.58e-8 | NR | RHY34871.1 | 157072 | g10409 | i0 | 39.3 | 2.89349112426035 | 56 | 34 | 99.4 | 0 | 169 | 2 | 221 | 276 | RHY34871.1 hypothetical protein DYB32_002399 [Aphanomyces invadans] | diamond | 489 | 58.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 32025630 | 32025630 | PRJEB673_P_NODE_10218_length_178_cov_1.853147_g9869_i0 | PRJEB673 | 10218 | 178 | 1.853147 | 3.29860166 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 2.03e-21 | NR | TMW64158.1 | 41045 | g9869 | i0 | 90.6 | 0.893258426966292 | 53 | 5 | 89.3 | 0 | 3 | 161 | 402 | 454 | TMW64158.1 hypothetical protein Poli38472_014275 [Pythium oligandrum] | diamond | 159 | 95.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum |
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);;