contig_metadata
25 rows where bioproject = "PRJNA816047", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25601505 | 25601505 | PRJNA816047d_S_NODE_127913_length_233_cov_2.555556_g126078_i0 | PRJNA816047 | 127913 | 233 | 2.555556 | 5.95444548 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.66e-11 | NTclustered | gi|669162729|ref|XM_008618705.1| | 1156394 | g126078 | i0 | 80.18 | 1.56223175965665 | 111 | 20 | 47 | 2 | 124 | 233 | 366 | 257 | Saprolegnia diclina VS20 60S ribosomal protein L44 mRNA | blastn | 364 | 82.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 25742566 | 25742566 | PRJNA816047d_S_NODE_85202_length_259_cov_1.291262_g83367_i0 | PRJNA816047 | 85202 | 259 | 1.291262 | 3.34436858 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 8.02e-42 | NTclustered | gi|695382201|ref|XM_009519030.1| | 67593 | g83367 | i0 | 82.843 | 16.992277992278 | 204 | 35 | 79 | 0 | 6 | 209 | 86 | 289 | Phytophthora sojae hypothetical protein mRNA | blastn | 4401 | 183 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 26005354 | 26005354 | PRJNA816047b_S_NODE_13388_length_423_cov_12635.017143_g11082_i0 | PRJNA816047 | 13388 | 423 | 12635.017143 | 53446.12251489 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 2.02e-36 | NR | RHY33137.1 | 157072 | g11082 | i0 | 82.9 | 1.16312056737589 | 82 | 14 | 58.2 | 0 | 71 | 316 | 120 | 201 | RHY33137.1 hypothetical protein DYB32_001820, partial [Aphanomyces invadans] | diamond | 492 | 134 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 26179490 | 26179490 | PRJNA816047d_S_NODE_110789_length_245_cov_1.171875_g108954_i0 | PRJNA816047 | 110789 | 245 | 1.171875 | 2.87109375 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 7.57e-25 | NR | TMW56879.1 | 41045 | g108954 | i0 | 60 | 2.93877551020408 | 80 | 32 | 98 | 0 | 242 | 3 | 197 | 276 | TMW56879.1 hypothetical protein Poli38472_006889 [Pythium oligandrum] | diamond | 720 | 108 | 0.990740740740741 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 26283834 | 26283834 | PRJNA816047d_S_NODE_28486_length_399_cov_3.973988_g26654_i0 | PRJNA816047 | 28486 | 399 | 3.973988 | 15.85621212 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.31e-36 | NTclustered | gi|2795048880|ref|XM_067943659.1| | 4785 | g26654 | i0 | 77.431 | 4.98245614035088 | 288 | 60 | 71 | 4 | 24 | 307 | 153 | 439 | Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA | blastn | 1988 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 26421399 | 26421399 | PRJNA816047d_S_NODE_58191_length_294_cov_4.651452_g56356_i0 | PRJNA816047 | 58191 | 294 | 4.651452 | 13.67526888 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 2.4e-21 | NR | GMF45944.1 | 1490495 | g56356 | i0 | 47.2 | 1.81632653061224 | 89 | 47 | 90.8 | 0 | 286 | 20 | 168 | 256 | GMF45944.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 534 | 95.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia | ||
| 26551815 | 26551815 | PRJNA816047b_S_NODE_41856_length_264_cov_3.277487_g39544_i0 | PRJNA816047 | 41856 | 264 | 3.277487 | 8.65256568 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.26e-47 | NTclustered | gi|698783094|ref|XM_009826289.1| | 112090 | g39544 | i0 | 91.216 | 43.844696969697 | 148 | 13 | 56 | 0 | 117 | 264 | 498 | 351 | Aphanomyces astaci 40S ribosomal protein S23 mRNA | blastn | 11575 | 202 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 26559028 | 26559028 | PRJNA816047d_S_NODE_94848_length_253_cov_1.810000_g93013_i0 | PRJNA816047 | 94848 | 253 | 1.81 | 4.5793 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.31e-39 | NTclustered | gi|59894163|gb|AY729864.1| | 74557 | g93013 | i0 | 80.342 | 52.4110671936759 | 234 | 44 | 92 | 2 | 1 | 233 | 1277 | 1045 | Thraustotheca clavata heat shock protein 90 gene, partial cds | blastn | 13260 | 176 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32922187 | 32922187 | PRJNA816047d_S_NODE_92049_length_255_cov_0.960396_g90214_i0 | PRJNA816047 | 92049 | 255 | 0.960396 | 2.4490098 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 3.15e-8 | NR | OQR91227.1 | 74557 | g90214 | i0 | 34.7 | 3.54117647058824 | 75 | 47 | 85.9 | 1 | 251 | 33 | 165 | 239 | OQR91227.1 hypothetical protein THRCLA_22482 [Thraustotheca clavata] | diamond | 903 | 60.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32942241 | 32942241 | PRJNA816047d_S_NODE_45569_length_324_cov_1.387454_g43734_i0 | PRJNA816047 | 45569 | 324 | 1.387454 | 4.49535096 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 4.16e-5 | NR | DAZ95523.1 | 4803 | g43734 | i0 | 39.3 | 2.59259259259259 | 89 | 54 | 82.4 | 0 | 58 | 324 | 937 | 1025 | DAZ95523.1 TPA: hypothetical protein N0F65_001862 [Lagenidium giganteum] | diamond | 840 | 52.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32990283 | 32990283 | PRJNA816047d_S_NODE_114955_length_243_cov_2.247368_g113120_i0 | PRJNA816047 | 114955 | 243 | 2.247368 | 5.46110424 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 2e-4 | NR | KAG9402244.1 | 112091 | g113120 | i0 | 44.4 | 1.17283950617284 | 45 | 25 | 55.6 | 0 | 59 | 193 | 101 | 145 | KAG9402244.1 hypothetical protein AC1031_006867 [Aphanomyces cochlioides] | diamond | 285 | 48.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 32990641 | 32990641 | PRJNA816047d_S_NODE_49211_length_314_cov_2.272031_g47376_i0 | PRJNA816047 | 49211 | 314 | 2.272031 | 7.13417734 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 1.79e-5 | NR | TYZ60679.1 | 1485010 | g47376 | i0 | 33.7 | 1.73885350318471 | 98 | 59 | 91.7 | 2 | 312 | 25 | 217 | 310 | TYZ60679.1 hypothetical protein PybrP1_012107 [[Pythium] brassicae (nom. inval.)] | diamond | 546 | 53.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 32993456 | 32993456 | PRJNA816047d_S_NODE_29283_length_394_cov_1.099707_g27451_i0 | PRJNA816047 | 29283 | 394 | 1.099707 | 4.33284558 | root | 1 | Root_unresolved | Root_unresolved | 70.1 | 3.38e-11 | NR | OWZ08818.1 | 4795 | g27451 | i0 | 44.4 | 2.95431472081218 | 81 | 39 | 61.7 | 1 | 2 | 244 | 241 | 315 | OWZ08818.1 YjeF family domain-containing hypothetical protein [Phytophthora megakarya] | diamond | 1164 | 70.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 33007174 | 33007174 | PRJNA816047d_S_NODE_131067_length_230_cov_2.186441_g129232_i0 | PRJNA816047 | 131067 | 230 | 2.186441 | 5.0288143 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 4.48e-8 | NR | CCI50533.1 | 65357 | g129232 | i0 | 56.3 | 1.25217391304348 | 48 | 21 | 62.6 | 0 | 2 | 145 | 206 | 253 | CCI50533.1 unnamed protein product [Albugo candida] | diamond | 288 | 59.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 33010519 | 33010519 | PRJNA816047d_S_NODE_32323_length_375_cov_3.807453_g30489_i0 | PRJNA816047 | 32323 | 375 | 3.807453 | 14.27794875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 4.609999999999999e-37 | NR | KAF0738771.1 | 100861 | g30489 | i0 | 67.3 | 15.832 | 104 | 34 | 83.2 | 0 | 341 | 30 | 18 | 121 | KAF0738771.1 hypothetical protein Ae201684_005384 [Aphanomyces euteiches] | diamond | 5937 | 133 | 0.992481203007519 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 33024290 | 33024290 | PRJNA816047d_S_NODE_112852_length_244_cov_1.481675_g111017_i0 | PRJNA816047 | 112852 | 244 | 1.481675 | 3.615287 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 4.51e-9 | NR | XP_024581478.1 | 4781 | g111017 | i0 | 62.5 | 2.8155737704918 | 48 | 18 | 59 | 0 | 1 | 144 | 607 | 654 | XP_024581478.1 aspartate aminotransferase [Plasmopara halstedii] | diamond | 687 | 62.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 33024469 | 33024469 | PRJNA816047d_S_NODE_23764_length_442_cov_2.269923_g21937_i0 | PRJNA816047 | 23764 | 442 | 2.269923 | 10.03305966 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 5.73e-16 | NR | KAJ8578277.1 | 4785 | g21937 | i0 | 40 | 1.35746606334842 | 100 | 60 | 67.9 | 0 | 138 | 437 | 172 | 271 | KAJ8578277.1 hypothetical protein ON010_g926 [Phytophthora cinnamomi] | diamond | 600 | 84.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 33027660 | 33027660 | PRJNA816047d_S_NODE_67860_length_278_cov_0.777778_g66025_i0 | PRJNA816047 | 67860 | 278 | 0.777778 | 2.16222284 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 6.6e-11 | NR | KAJ0402934.1 | 114742 | g66025 | i0 | 58.3 | 34.1870503597122 | 72 | 30 | 77.7 | 0 | 2 | 217 | 15 | 86 | KAJ0402934.1 hypothetical protein P43SY_005919 [Pythium insidiosum] | diamond | 9504 | 65.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 33044450 | 33044450 | PRJNA816047a_S_NODE_36404_length_344_cov_2.778598_g33744_i0 | PRJNA816047 | 36404 | 344 | 2.778598 | 9.55837712 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 4.4e-4 | NR | KAE8877845.1 | 53985 | g33744 | i0 | 33.8 | 8.66860465116279 | 71 | 47 | 61.9 | 0 | 343 | 131 | 521 | 591 | KAE8877845.1 hypothetical protein PF003_g37962 [Phytophthora fragariae] | diamond | 2982 | 50.1 | 0.992015968063872 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 33075334 | 33075334 | PRJNA816047d_S_NODE_117829_length_242_cov_1.037037_g115994_i0 | PRJNA816047 | 117829 | 242 | 1.037037 | 2.50962954 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 3.14e-9 | NR | XP_009844354.1 | 112090 | g115994 | i0 | 65.5 | 1.5495867768595 | 58 | 20 | 71.9 | 0 | 66 | 239 | 5 | 62 | XP_009844354.1 hypothetical protein H257_17317 [Aphanomyces astaci] | diamond | 375 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 33095875 | 33095875 | PRJNA816047d_S_NODE_50910_length_310_cov_2.035019_g49075_i0 | PRJNA816047 | 50910 | 310 | 2.035019 | 6.3085589 | root | 1 | Root_unresolved | Root_unresolved | 108 | 4.11e-25 | NR | KUF98307.1 | 4792 | g49075 | i0 | 59.3 | 7.04516129032258 | 91 | 37 | 88.1 | 0 | 3 | 275 | 424 | 514 | KUF98307.1 hypothetical protein AM588_10009698 [Phytophthora nicotianae] | diamond | 2184 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 33109074 | 33109074 | PRJNA816047a_S_NODE_50246_length_296_cov_1.349776_g47586_i0 | PRJNA816047 | 50246 | 296 | 1.349776 | 3.99533696 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 2.7899999999999998e-24 | NR | XP_012209282.1 | 695850 | g47586 | i0 | 60.5 | 0.820945945945946 | 81 | 31 | 82.1 | 1 | 294 | 52 | 243 | 322 | XP_012209282.1 hypothetical protein SPRG_21383 [Saprolegnia parasitica CBS 223.65] | diamond | 243 | 103 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 33112593 | 33112593 | PRJNA816047a_S_NODE_3446_length_1281_cov_6.931291_g1401_i0 | PRJNA816047 | 3446 | 1281 | 6.931291 | 88.78983771 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 0.034 | NR | KAH9095265.1 | 100861 | g1401 | i0 | 52.5 | 0.201405152224824 | 40 | 19 | 9.4 | 0 | 290 | 409 | 10 | 49 | KAH9095265.1 hypothetical protein Ae201684P_013381 [Aphanomyces euteiches] | diamond | 258 | 49.7 | 0.991951710261569 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 33126441 | 33126441 | PRJNA816047b_S_NODE_36383_length_281_cov_1.365385_g34071_i0 | PRJNA816047 | 36383 | 281 | 1.365385 | 3.83673185 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 1.6799999999999999e-40 | NR | KAF0732286.1 | 100861 | g34071 | i0 | 94.6 | 2.37010676156584 | 74 | 4 | 79 | 0 | 279 | 58 | 393 | 466 | KAF0732286.1 hypothetical protein Ae201684_010577 [Aphanomyces euteiches] | diamond | 666 | 149 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 33164033 | 33164033 | PRJNA816047d_S_NODE_88432_length_257_cov_1.176471_g86597_i0 | PRJNA816047 | 88432 | 257 | 1.176471 | 3.02353047 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 8.87e-5 | NR | KUG01027.1 | 4792 | g86597 | i0 | 41.3 | 4.66926070038911 | 63 | 36 | 73.5 | 1 | 257 | 69 | 3678 | 3739 | KUG01027.1 E3 ubiquitin-protein ligase HERC2 [Phytophthora nicotianae] | diamond | 1200 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae |
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);;