contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3795837 | 3795837 | PRJNA896758_P_NODE_19263_length_265_cov_1.348958_g18873_i0 | PRJNA896758 | 19263 | 265 | 1.348958 | 3.5747387 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 1.11e-27 | NR | OQR95961.1 | 74557 | g18873 | i0 | 60 | 0.962264150943396 | 85 | 34 | 96.2 | 0 | 11 | 265 | 195 | 279 | OQR95961.1 hypothetical protein THRCLA_22037 [Thraustotheca clavata] | diamond | 255 | 112 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 11076291 | 11076291 | PRJNA896758_P_NODE_11449_length_339_cov_3.184211_g11059_i0 | PRJNA896758 | 11449 | 339 | 3.184211 | 10.79447529 | Nothophytophthora sp. Chile5 | 2483409 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 5.07e-41 | NR | RLN20103.1 | 2483409 | g11059 | i0 | 88.8 | 7.7787610619469 | 80 | 9 | 70.8 | 0 | 337 | 98 | 25 | 104 | RLN20103.1 hypothetical protein BBJ28_00024748 [Nothophytophthora sp. Chile5] | diamond | 2637 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. Chile5 | ||
| 20370241 | 20370241 | PRJNA896758_P_NODE_11076_length_345_cov_1.132353_g10686_i0 | PRJNA896758 | 11076 | 345 | 1.132353 | 3.90661785 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.11e-26 | NR | KAG1708806.1 | 4784 | g10686 | i0 | 58.2 | 13.1913043478261 | 98 | 37 | 81.7 | 1 | 283 | 2 | 48 | 145 | KAG1708806.1 hypothetical protein DVH05_022428 [Phytophthora capsici] | diamond | 4551 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 26778690 | 26778690 | PRJNA896758_P_NODE_22321_length_249_cov_0.875000_g21931_i0 | PRJNA896758 | 22321 | 249 | 0.875 | 2.17875 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 9.05e-22 | NR | OQR89707.1 | 74557 | g21931 | i0 | 61.4 | 7 | 83 | 32 | 100 | 0 | 249 | 1 | 166 | 248 | OQR89707.1 60S acidic ribosomal protein P0, partial [Thraustotheca clavata] | diamond | 1743 | 98.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 26999946 | 26999946 | PRJNA896758_P_NODE_22342_length_249_cov_0.875000_g21952_i0 | PRJNA896758 | 22342 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 2.91e-33 | NR | KAF4143879.1 | 4787 | g21952 | i0 | 76.1 | 131.686746987952 | 71 | 17 | 85.5 | 0 | 1 | 213 | 100 | 170 | KAF4143879.1 Ubiquitin-conjugating enzyme, partial [Phytophthora infestans] | diamond | 32790 | 123 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 27118665 | 27118665 | PRJNA896758_P_NODE_16782_length_282_cov_1.263158_g16392_i0 | PRJNA896758 | 16782 | 282 | 1.263158 | 3.56210556 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 2.26e-17 | NR | XP_067820777.1 | 4779 | g16392 | i0 | 45.2 | 5.72340425531915 | 93 | 51 | 98.9 | 0 | 1 | 279 | 288 | 380 | XP_067820777.1 hypothetical protein CCR75_006601 [Bremia lactucae] | diamond | 1614 | 86.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 27213534 | 27213534 | PRJNA896758_P_NODE_20142_length_258_cov_2.037838_g19752_i0 | PRJNA896758 | 20142 | 258 | 2.037838 | 5.25762204 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 2.18e-4 | NR | OQR96439.1 | 74557 | g19752 | i0 | 56.3 | 1.11627906976744 | 48 | 21 | 55.8 | 0 | 258 | 115 | 344 | 391 | OQR96439.1 60S ribosomal protein L24, partial [Thraustotheca clavata] | diamond | 288 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 27221176 | 27221176 | PRJNA896758_P_NODE_24562_length_245_cov_0.895349_g24172_i0 | PRJNA896758 | 24562 | 245 | 0.895349 | 2.19360505 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 3.94e-24 | NR | TMW66833.1 | 41045 | g24172 | i0 | 65.3 | 8.16734693877551 | 75 | 26 | 91.8 | 0 | 3 | 227 | 367 | 441 | TMW66833.1 hypothetical protein Poli38472_011949 [Pythium oligandrum] | diamond | 2001 | 105 | 0.990476190476191 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27379712 | 27379712 | PRJNA896758_P_NODE_1783_length_864_cov_1.230088_g1450_i0 | PRJNA896758 | 1783 | 864 | 1.230088 | 10.62796032 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 1.0399999999999999e-60 | NR | XP_012209436.1 | 695850 | g1450 | i0 | 45.1 | 1.89583333333333 | 273 | 91 | 91 | 8 | 3 | 788 | 80 | 304 | XP_012209436.1 hypothetical protein SPRG_14910 [Saprolegnia parasitica CBS 223.65] | diamond | 1638 | 209 | 0.990430622009569 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 27537411 | 27537411 | PRJNA896758_P_NODE_23683_length_247_cov_0.885057_g23293_i0 | PRJNA896758 | 23683 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 4.81e-20 | NR | CAI5728785.1 | 162125 | g23293 | i0 | 63.4 | 3.69230769230769 | 82 | 29 | 98.4 | 1 | 245 | 3 | 3 | 84 | CAI5728785.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 912 | 88.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 27687909 | 27687909 | PRJNA896758_P_NODE_22564_length_249_cov_0.875000_g22174_i0 | PRJNA896758 | 22564 | 249 | 0.875 | 2.17875 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 9.64e-10 | NR | XP_008615106.1 | 1156394 | g22174 | i0 | 50.8 | 1.42168674698795 | 59 | 29 | 71.1 | 0 | 3 | 179 | 213 | 271 | XP_008615106.1 hypothetical protein SDRG_10870 [Saprolegnia diclina VS20] | diamond | 354 | 64.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 28003480 | 28003480 | PRJNA896758_P_NODE_21805_length_250_cov_0.870056_g21415_i0 | PRJNA896758 | 21805 | 250 | 0.870056 | 2.17514 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.6e-9 | NR | DBA04060.1 | 4803 | g21415 | i0 | 53.7 | 3.876 | 54 | 24 | 64.8 | 1 | 244 | 83 | 553 | 605 | DBA04060.1 TPA: hypothetical protein N0F65_009407 [Lagenidium giganteum] | diamond | 969 | 63.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28042596 | 28042596 | PRJNA896758_P_NODE_20885_length_252_cov_2.178771_g20495_i0 | PRJNA896758 | 20885 | 252 | 2.178771 | 5.49050292 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 8.17e-5 | NR | XP_067814794.1 | 4779 | g20495 | i0 | 32.1 | 1.86904761904762 | 84 | 55 | 97.6 | 1 | 7 | 252 | 185 | 268 | XP_067814794.1 hypothetical protein CCR75_001807 [Bremia lactucae] | diamond | 471 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 28547954 | 28547954 | PRJNA896758_P_NODE_14947_length_296_cov_1.004484_g14557_i0 | PRJNA896758 | 14947 | 296 | 1.004484 | 2.97327264 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.03e-26 | NR | XP_067789141.1 | 4785 | g14557 | i0 | 73.4 | 4.42905405405405 | 64 | 17 | 64.9 | 0 | 295 | 104 | 31 | 94 | XP_067789141.1 40S ribosomal protein S10 [Phytophthora cinnamomi] | diamond | 1311 | 105 | 0.990476190476191 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29487032 | 29487032 | PRJNA896758_P_NODE_18610_length_270_cov_0.964467_g18220_i0 | PRJNA896758 | 18610 | 270 | 0.964467 | 2.6040609 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 9.45e-4 | NR | OQR89904.1 | 74557 | g18220 | i0 | 41.2 | 1.45555555555556 | 68 | 37 | 72.2 | 2 | 22 | 216 | 605 | 672 | OQR89904.1 transmembrane protein, partial [Thraustotheca clavata] | diamond | 393 | 47.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 29779071 | 29779071 | PRJNA896758_P_NODE_15851_length_288_cov_1.432558_g15461_i0 | PRJNA896758 | 15851 | 288 | 1.432558 | 4.12576704 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 3.5200000000000003e-29 | NR | KAF1783236.1 | 29920 | g15461 | i0 | 70.5 | 6.42708333333333 | 88 | 22 | 91.7 | 1 | 285 | 22 | 541 | 624 | KAF1783236.1 Heat shock protein Hsp90, N-terminal [Phytophthora cactorum] | diamond | 1851 | 120 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 29937106 | 29937106 | PRJNA896758_P_NODE_22691_length_248_cov_1.674286_g22301_i0 | PRJNA896758 | 22691 | 248 | 1.674286 | 4.15222928 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 9.37e-20 | NR | RLN46345.1 | 325452 | g22301 | i0 | 57.1 | 7.05241935483871 | 84 | 34 | 99.2 | 2 | 246 | 1 | 104 | 187 | RLN46345.1 hypothetical protein BBJ29_006599 [Phytophthora kernoviae] | diamond | 1749 | 90.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 30000356 | 30000356 | PRJNA896758_P_NODE_23231_length_247_cov_1.672414_g22841_i0 | PRJNA896758 | 23231 | 247 | 1.672414 | 4.13086258 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 94.7 | 2.74e-23 | NR | DAZ97608.1 | 4803 | g22841 | i0 | 56.3 | 1.95546558704453 | 80 | 28 | 94.7 | 3 | 11 | 244 | 4 | 78 | DAZ97608.1 TPA: hypothetical protein N0F65_002227 [Lagenidium giganteum] | diamond | 483 | 94.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30213528 | 30213528 | PRJNA896758_P_NODE_7192_length_422_cov_1.415473_g6802_i0 | PRJNA896758 | 7192 | 422 | 1.415473 | 5.97329606 | Phytophthora boehmeriae | 109152 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 8.07e-28 | NR | KAG7399314.1 | 109152 | g6802 | i0 | 43.7 | 0.895734597156398 | 126 | 70 | 88.9 | 1 | 1 | 375 | 301 | 426 | KAG7399314.1 hypothetical protein PHYBOEH_009116 [Phytophthora boehmeriae] | diamond | 378 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 30529536 | 30529536 | PRJNA896758_P_NODE_19553_length_263_cov_1.284211_g19163_i0 | PRJNA896758 | 19553 | 263 | 1.284211 | 3.37747493 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.2500000000000001e-22 | NR | TYZ51215.1 | 1485010 | g19163 | i0 | 54.7 | 1.96197718631179 | 86 | 38 | 98.1 | 1 | 2 | 259 | 789 | 873 | TYZ51215.1 hypothetical protein PybrP1_012702 [[Pythium] brassicae (nom. inval.)] | diamond | 516 | 101 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31549021 | 31549021 | PRJNA896758_P_NODE_25076_length_244_cov_0.900585_g24686_i0 | PRJNA896758 | 25076 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 0.00117 | NR | GLD98269.1 | 114742 | g24686 | i0 | 37.2 | 5.97540983606557 | 78 | 48 | 95.9 | 1 | 9 | 242 | 390 | 466 | GLD98269.1 hypothetical protein PINS_up006966 [Pythium insidiosum] | diamond | 1458 | 47.4 | 0.991561181434599 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32181568 | 32181568 | PRJNA896758_P_NODE_22358_length_249_cov_0.875000_g21968_i0 | PRJNA896758 | 22358 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 4.6699999999999995e-30 | NR | RAW26519.1 | 29920 | g21968 | i0 | 67.5 | 8 | 83 | 22 | 100 | 1 | 249 | 1 | 186 | 263 | RAW26519.1 60S ribosomal protein [Phytophthora cactorum] | diamond | 1992 | 120 | 0.991666666666667 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 32363807 | 32363807 | PRJNA896758_P_NODE_13519_length_313_cov_1.141667_g13129_i0 | PRJNA896758 | 13519 | 313 | 1.141667 | 3.57341771 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 5.24e-13 | NR | GMF18554.1 | 1490495 | g13129 | i0 | 38.8 | 0.987220447284345 | 103 | 60 | 97.8 | 3 | 307 | 2 | 848 | 948 | GMF18554.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 309 | 74.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia | ||
| 32371479 | 32371479 | PRJNA896758_P_NODE_2379_length_746_cov_1.442793_g2022_i0 | PRJNA896758 | 2379 | 746 | 1.442793 | 10.76323578 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 5.37e-5 | NR | ETL83427.1 | 4792 | g2022 | i0 | 38.8 | 1.61662198391421 | 67 | 37 | 26.1 | 3 | 744 | 550 | 591 | 655 | ETL83427.1 hypothetical protein L917_16625 [Phytophthora nicotianae] | diamond | 1206 | 56.2 | 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);;