contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA169559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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);;