contig_metadata
19 rows where bioproject = "PRJNA169559", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 364820 | 364820 | PRJNA169559_P_NODE_13881_length_450_cov_7.273159_g11965_i0 | PRJNA169559 | 13881 | 450 | 7.273159 | 32.7292155 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.8799999999999996e-55 | NTclustered | gi|813133999|ref|XM_012342618.1| | 695850 | g11965 | i0 | 82.222 | 7.79777777777778 | 270 | 44 | 60 | 4 | 73 | 340 | 72 | 339 | Saprolegnia parasitica CBS 223.65 ribonucleoprotein-associated protein mRNA | blastn | 3509 | 230 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 7432711 | 7432711 | PRJNA169559_P_NODE_1686_length_1274_cov_5.467470_g996_i0 | PRJNA169559 | 1686 | 1274 | 5.46747 | 69.6555678 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 523 | 2.6199999999999992e-182 | NR | TMW60420.1 | 41045 | g996 | i0 | 68.4 | 46.9356357927786 | 393 | 111 | 92.3 | 4 | 6 | 1181 | 1 | 381 | TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] | diamond | 59796 | 523 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 9293191 | 9293191 | PRJNA169559_P_NODE_4368_length_807_cov_1.924165_g3133_i0 | PRJNA169559 | 4368 | 807 | 1.924165 | 15.52801155 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 6.26e-35 | NR | GLE03027.1 | 114742 | g3133 | i0 | 46.4 | 8.71375464684015 | 168 | 75 | 62.5 | 3 | 641 | 138 | 59 | 211 | GLE03027.1 hypothetical protein PINS_up011906 [Pythium insidiosum] | diamond | 7032 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 10569064 | 10569064 | PRJNA169559_P_NODE_27709_length_278_cov_1.951807_g25633_i0 | PRJNA169559 | 27709 | 278 | 1.951807 | 5.42602346 | Phytophthora hydrogena | 1286608 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.44e-37 | NTclustered | gi|1233050041|gb|KX252277.1| | 1286608 | g25633 | i0 | 84.524 | 60.2482014388489 | 168 | 26 | 60 | 0 | 1 | 168 | 181 | 14 | Phytophthora hydrogena isolate 44G8(authentic) heat shock protein 90 gene, partial cds | blastn | 16749 | 169 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora hydrogena | ||
| 11843697 | 11843697 | PRJNA169559_P_NODE_45370_length_210_cov_5.149171_g43293_i0 | PRJNA169559 | 45370 | 210 | 5.149171 | 10.8132591 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.8e-17 | NTclustered | gi|669149541|ref|XM_008612111.1| | 1156394 | g43293 | i0 | 81.538 | 16.4761904761905 | 130 | 18 | 60 | 5 | 63 | 189 | 441 | 315 | Saprolegnia diclina VS20 50S ribosomal protein L40e mRNA | blastn | 3460 | 102 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 13118825 | 13118825 | PRJNA169559_P_NODE_33391_length_252_cov_2.026906_g31314_i0 | PRJNA169559 | 33391 | 252 | 2.026906 | 5.10780312 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.33e-20 | NR | XP_012197784.1 | 695850 | g31314 | i0 | 81.6 | 2.30952380952381 | 49 | 9 | 58.3 | 0 | 147 | 1 | 1 | 49 | XP_012197784.1 hypothetical protein SPRG_03794, partial [Saprolegnia parasitica CBS 223.65] | diamond | 582 | 89 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 18216910 | 18216910 | PRJNA169559_P_NODE_9175_length_561_cov_2.494361_g7480_i0 | PRJNA169559 | 9175 | 561 | 2.494361 | 13.99336521 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 3.28e-9 | NTclustered | gi|2794885173|ref|XM_067884476.1| | 164328 | g7480 | i0 | 94 | 1.14081996434938 | 50 | 3 | 9 | 0 | 466 | 515 | 1970 | 2019 | Phytophthora ramorum Senescence-specific cysteine protease SAG12 (KRP23_1382), partial mRNA | blastn | 640 | 76.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 18906268 | 18906268 | PRJNA169559_P_NODE_2375_length_1071_cov_3.341651_g1498_i0 | PRJNA169559 | 2375 | 1071 | 3.341651 | 35.78908221 | root | 1 | Root_unresolved | Root_unresolved | 302 | 3.03e-97 | NR | XP_008605263.1 | 1156394 | g1498 | i0 | 48.7 | 7.55182072829132 | 341 | 165 | 94.1 | 6 | 56 | 1063 | 2 | 337 | XP_008605263.1 hypothetical protein SDRG_01511 [Saprolegnia diclina VS20] | diamond | 8088 | 302 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 18906306 | 18906306 | PRJNA169559_P_NODE_5435_length_728_cov_2.690987_g4058_i0 | PRJNA169559 | 5435 | 728 | 2.690987 | 19.59038536 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 1.04e-109 | NTclustered | gi|2795021761|ref|XM_067936233.1| | 4785 | g4058 | i0 | 81.569 | 64.9478021978022 | 510 | 82 | 69 | 10 | 59 | 562 | 1143 | 640 | Phytophthora cinnamomi proline-tRNA ligase (IUM83_11660), partial mRNA | blastn | 47282 | 411 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 19490921 | 19490921 | PRJNA169559_P_NODE_23516_length_321_cov_1.458904_g21443_i0 | PRJNA169559 | 23516 | 321 | 1.458904 | 4.68308184 | Nothophytophthora sp. Chile5 | 2483409 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 5.12e-39 | NR | RLN79760.1 | 2483409 | g21443 | i0 | 66 | 16.8411214953271 | 106 | 36 | 99.1 | 0 | 2 | 319 | 1077 | 1182 | RLN79760.1 hypothetical protein BBJ28_00005928 [Nothophytophthora sp. Chile5] | diamond | 5406 | 149 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. Chile5 | ||
| 20766633 | 20766633 | PRJNA169559_P_NODE_43697_length_224_cov_2.123077_g41620_i0 | PRJNA169559 | 43697 | 224 | 2.123077 | 4.7556924800000004 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 3.31e-14 | NR | OQS06413.1 | 74557 | g41620 | i0 | 65 | 4.08482142857143 | 60 | 20 | 80.4 | 1 | 215 | 36 | 645 | 703 | OQS06413.1 choline/Carnitine O-acyltransferase [Thraustotheca clavata] | diamond | 915 | 76.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 23316959 | 23316959 | PRJNA169559_P_NODE_13979_length_449_cov_2.757143_g12061_i0 | PRJNA169559 | 13979 | 449 | 2.757143 | 12.37957207 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 3.2e-38 | NTclustered | gi|813117120|ref|XM_012340152.1| | 695850 | g12061 | i0 | 80.603 | 26.9198218262806 | 232 | 38 | 51 | 6 | 59 | 288 | 1703 | 1477 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 12087 | 172 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 23317126 | 23317126 | PRJNA169559_P_NODE_29559_length_267_cov_1.768908_g27483_i0 | PRJNA169559 | 29559 | 267 | 1.768908 | 4.72298436 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 8.49e-24 | NR | RHZ41357.1 | 112090 | g27483 | i0 | 53.5 | 3.86516853932584 | 86 | 40 | 96.6 | 0 | 266 | 9 | 112 | 197 | RHZ41357.1 hypothetical protein DYB31_011106 [Aphanomyces astaci] | diamond | 1032 | 100 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28481345 | 28481345 | PRJNA169559_P_NODE_7206_length_631_cov_3.669435_g2315_i1 | PRJNA169559 | 7206 | 631 | 3.669435 | 23.15413485 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 1.22e-37 | NR | TMW56818.1 | 41045 | g2315 | i1 | 42.6 | 5.61014263074485 | 190 | 103 | 88 | 3 | 630 | 76 | 588 | 776 | TMW56818.1 hypothetical protein Poli38472_006828 [Pythium oligandrum] | diamond | 3540 | 150 | 0.993333333333333 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28842259 | 28842259 | PRJNA169559_P_NODE_4308_length_810_cov_7.300896_g3085_i0 | PRJNA169559 | 4308 | 810 | 7.300896 | 59.1372576 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 1.57e-34 | NR | OQS00341.1 | 74557 | g3085 | i0 | 40.4 | 2.1 | 183 | 107 | 67.4 | 2 | 806 | 261 | 66 | 247 | OQS00341.1 hypothetical protein THRCLA_06000 [Thraustotheca clavata] | diamond | 1701 | 137 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 28968791 | 28968791 | PRJNA169559_P_NODE_9508_length_551_cov_2.281609_g7790_i0 | PRJNA169559 | 9508 | 551 | 2.281609 | 12.57166559 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 1.46e-6 | NR | KAG9412244.1 | 112091 | g7790 | i0 | 29.4 | 0.686025408348457 | 126 | 83 | 67.5 | 4 | 69 | 440 | 117 | 238 | KAG9412244.1 hypothetical protein AC1031_015185 [Aphanomyces cochlioides] | diamond | 378 | 58.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 29965429 | 29965429 | PRJNA169559_P_NODE_34891_length_248_cov_1.223744_g32814_i0 | PRJNA169559 | 34891 | 248 | 1.223744 | 3.03488512 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00592 | NR | XP_024572466.1 | 4781 | g32814 | i0 | 76 | 3.75 | 25 | 6 | 30.2 | 0 | 246 | 172 | 254 | 278 | XP_024572466.1 eukaryotic translation initiation factor 2 subunit 3 [Plasmopara halstedii] | diamond | 930 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 31780548 | 31780548 | PRJNA169559_P_NODE_24717_length_306_cov_1.216606_g22641_i0 | PRJNA169559 | 24717 | 306 | 1.216606 | 3.72281436 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 3.49e-6 | NR | XP_008871755.1 | 157072 | g22641 | i0 | 29.3 | 0.970588235294118 | 99 | 70 | 97.1 | 0 | 304 | 8 | 349 | 447 | XP_008871755.1 AGC protein kinase [Aphanomyces invadans] | diamond | 297 | 55.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 32463046 | 32463046 | PRJNA169559_P_NODE_19739_length_377_cov_5.192529_g17705_i0 | PRJNA169559 | 19739 | 377 | 5.192529 | 19.57583433 | root | 1 | Root_unresolved | Root_unresolved | 77.4 | 1.87e-14 | NR | RHY23617.1 | 157072 | g17705 | i0 | 58.6 | 1.51989389920424 | 58 | 23 | 45.4 | 1 | 78 | 248 | 46 | 103 | RHY23617.1 hypothetical protein DYB32_009114 [Aphanomyces invadans] | diamond | 573 | 77.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans |
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);;