contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1681756 | 1681756 | PRJNA385396_P_NODE_19522_length_243_cov_0.905882_g19430_i0 | PRJNA385396 | 19522 | 243 | 0.905882 | 2.20129326 | Zalaria obscura | 2024903 | Fungi | Fungi | 179 | 2.0099999999999998e-54 | NR | KAK8194375.1 | 2024903 | g19430 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 241 | 2 | 93 | 172 | KAK8194375.1 hypothetical protein M8818_007565 [Zalaria obscura] | diamond | 240 | 179 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Zalariaceae | Zalaria | Zalaria obscura | |
| 8060480 | 8060480 | PRJNA385396_P_NODE_8587_length_302_cov_1.895197_g8495_i0 | PRJNA385396 | 8587 | 302 | 1.895197 | 5.72349494 | Fungi | 4751 | Fungi | Fungi | 112 | 6.45e-28 | NR | XP_019025540.1 | 698492 | g8495 | i0 | 58.3 | 16.3013245033113 | 103 | 38 | 99.3 | 2 | 2 | 301 | 4 | 104 | XP_019025540.1 40s ribosomal protein s3ae-a [Saitoella complicata NRRL Y-17804] | diamond | 4923 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 11885644 | 11885644 | PRJNA385396_P_NODE_19810_length_243_cov_0.905882_g19718_i0 | PRJNA385396 | 19810 | 243 | 0.905882 | 2.20129326 | Ophiocordyceps | 474995 | Fungi | Fungi | 102 | 1.54e-23 | NR | PFH62679.1 | 268505 | g19718 | i0 | 62 | 5.85185185185185 | 79 | 25 | 97.5 | 1 | 238 | 2 | 109 | 182 | PFH62679.1 hypothetical protein XA68_12550 [Ophiocordyceps unilateralis] | diamond | 1422 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps unilateralis | |
| 26948533 | 26948533 | PRJNA385396_P_NODE_18882_length_244_cov_0.900585_g18790_i0 | PRJNA385396 | 18882 | 244 | 0.900585 | 2.1974274 | Cryphonectria parasitica EP155 | 660469 | Fungi | Fungi | 45.1 | 0.00566 | NR | XP_040782064.1 | 660469 | g18790 | i0 | 33.8 | 0.872950819672131 | 71 | 40 | 79.9 | 2 | 50 | 244 | 211 | 280 | XP_040782064.1 uncharacterized protein M406DRAFT_344483 [Cryphonectria parasitica EP155] | diamond | 213 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cryphonectriaceae | Cryphonectria | Cryphonectria parasitica | |
| 27454636 | 27454636 | PRJNA385396_P_NODE_21543_length_241_cov_0.916667_g21451_i0 | PRJNA385396 | 21543 | 241 | 0.916667 | 2.20916747 | Hanseniaspora uvarum | 29833 | Fungi | Fungi | 96.7 | 3.82e-21 | NR | KAF0272477.1 | 29833 | g21451 | i0 | 55.7 | 0.983402489626556 | 79 | 35 | 98.3 | 0 | 240 | 4 | 138 | 216 | KAF0272477.1 hypothetical protein FOG51_02631 [Hanseniaspora uvarum] | diamond | 237 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Hanseniaspora | Hanseniaspora uvarum | |
| 27549080 | 27549080 | PRJNA385396_P_NODE_17524_length_246_cov_0.890173_g17432_i0 | PRJNA385396 | 17524 | 246 | 0.890173 | 2.18982558 | Stereocaulon virgatum | 373712 | Fungi | Fungi | 83.6 | 1.29e-17 | NR | KAL2038914.1 | 373712 | g17432 | i0 | 51.3 | 0.951219512195122 | 78 | 38 | 95.1 | 0 | 245 | 12 | 109 | 186 | KAL2038914.1 hypothetical protein N7G274_008254 [Stereocaulon virgatum] | diamond | 234 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Lecanorales | Stereocaulaceae | Stereocaulon | Stereocaulon virgatum | |
| 27565855 | 27565855 | PRJNA385396_P_NODE_5644_length_349_cov_2.753623_g5552_i0 | PRJNA385396 | 5644 | 349 | 2.753623 | 9.61014427 | Eukaryota | 2759 | Fungi | Fungi | 108 | 1.09e-26 | NR | KAK6515252.1 | 74498 | g5552 | i0 | 55.8 | 32.3467048710602 | 95 | 39 | 79.1 | 1 | 27 | 302 | 103 | 197 | KAK6515252.1 hypothetical protein TWF506_007595 [Arthrobotrys conoides] | diamond | 11289 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Arthrobotrys | Arthrobotrys conoides | |
| 28292067 | 28292067 | PRJNA385396_P_NODE_10326_length_281_cov_1.418269_g10234_i0 | PRJNA385396 | 10326 | 281 | 1.418269 | 3.98533589 | Pleosporales | 92860 | Fungi | Fungi | 143 | 2.79e-39 | NR | XP_033683377.1 | 390896 | g10234 | i0 | 81.5 | 3.44839857651246 | 81 | 15 | 86.5 | 0 | 2 | 244 | 279 | 359 | XP_033683377.1 alcohol dehydrogenase [Trematosphaeria pertusa] | diamond | 969 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Trematosphaeriaceae | Trematosphaeria | Trematosphaeria pertusa | |
| 28780393 | 28780393 | PRJNA385396_P_NODE_21227_length_241_cov_0.916667_g21135_i0 | PRJNA385396 | 21227 | 241 | 0.916667 | 2.20916747 | Cercophora scortea | 314031 | Fungi | Fungi | 52.4 | 1.44e-5 | NR | KAK3328287.1 | 314031 | g21135 | i0 | 56.3 | 1.71784232365145 | 64 | 23 | 73.4 | 1 | 207 | 31 | 213 | 276 | KAK3328287.1 splicing factor, Prp19-binding domain-containing protein [Cercophora scortea] | diamond | 414 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Cercophora | Cercophora scortea | |
| 29443355 | 29443355 | PRJNA385396_P_NODE_19950_length_243_cov_0.905882_g19858_i0 | PRJNA385396 | 19950 | 243 | 0.905882 | 2.20129326 | Dactylellina cionopaga | 47266 | Fungi | Fungi | 147 | 1.7e-39 | NR | KAF3912541.1 | 47266 | g19858 | i0 | 76.5 | 1.8641975308642 | 81 | 19 | 100 | 0 | 243 | 1 | 151 | 231 | KAF3912541.1 hypothetical protein ABW20_dc0109605 [Dactylellina cionopaga] | diamond | 453 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Dactylellina | Dactylellina cionopaga | |
| 29822262 | 29822262 | PRJNA385396_P_NODE_10211_length_282_cov_1.473684_g10119_i0 | PRJNA385396 | 10211 | 282 | 1.473684 | 4.15578888 | Recurvomyces mirabilis | 574656 | Fungi | Fungi | 90.1 | 4.68e-20 | NR | XP_064691539.1 | 574656 | g10119 | i0 | 54.4 | 2.85106382978723 | 90 | 41 | 95.7 | 0 | 271 | 2 | 104 | 193 | XP_064691539.1 60S ribosomal protein L16A [Recurvomyces mirabilis] | diamond | 804 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 29965770 | 29965770 | PRJNA385396_P_NODE_21411_length_241_cov_0.916667_g21319_i0 | PRJNA385396 | 21411 | 241 | 0.916667 | 2.20916747 | Ascomycota | 4890 | Fungi | Fungi | 131 | 3.07e-34 | NR | KAA8916006.1 | 44093 | g21319 | i0 | 75 | 17.9253112033195 | 80 | 20 | 99.6 | 0 | 240 | 1 | 125 | 204 | KAA8916006.1 hypothetical protein TRICI_001821 [Trichomonascus ciferrii] | diamond | 4320 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Trichomonascus | Trichomonascus ciferrii | |
| 30043545 | 30043545 | PRJNA385396_P_NODE_13711_length_251_cov_0.865169_g13619_i0 | PRJNA385396 | 13711 | 251 | 0.865169 | 2.17157419 | Colletotrichum trifolii | 5466 | Fungi | Fungi | 70.5 | 4.1e-12 | NR | TDZ68169.1 | 5466 | g13619 | i0 | 57.5 | 0.872509960159363 | 73 | 25 | 82.5 | 2 | 251 | 45 | 71 | 141 | TDZ68169.1 COP9 signalosome complex subunit 7a [Colletotrichum trifolii] | diamond | 219 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum trifolii | |
| 30265100 | 30265100 | PRJNA385396_P_NODE_18412_length_245_cov_0.895349_g18320_i0 | PRJNA385396 | 18412 | 245 | 0.895349 | 2.19360505 | Thermocarpiscus australiensis | 113626 | Fungi | Fungi | 72.8 | 9.93e-13 | NR | KAL2021895.1 | 113626 | g18320 | i0 | 48.1 | 0.96734693877551 | 79 | 36 | 96.7 | 1 | 2 | 238 | 631 | 704 | KAL2021895.1 hypothetical protein VTK56DRAFT_6490 [Thermocarpiscus australiensis] | diamond | 237 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Thermocarpiscus | Thermocarpiscus australiensis | |
| 30313774 | 30313774 | PRJNA385396_P_NODE_14292_length_250_cov_0.870056_g14200_i0 | PRJNA385396 | 14292 | 250 | 0.870056 | 2.17514 | Sordariomycetes | 147550 | Fungi | Fungi | 42.7 | 0.0396 | NR | KAH7186702.1 | 5507 | g14200 | i0 | 44.9 | 1.764 | 49 | 23 | 58.8 | 1 | 244 | 98 | 8 | 52 | KAH7186702.1 C6 zinc finger protein [Fusarium oxysporum] | diamond | 441 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 31149032 | 31149032 | PRJNA385396_P_NODE_17375_length_246_cov_0.890173_g17283_i0 | PRJNA385396 | 17375 | 246 | 0.890173 | 2.18982558 | Cephalotrichum gorgonifer | 2041049 | Fungi | Fungi | 67 | 1.07e-10 | NR | SPO07362.1 | 2041049 | g17283 | i0 | 47.5 | 0.975609756097561 | 80 | 38 | 93.9 | 2 | 244 | 14 | 227 | 305 | SPO07362.1 related to ankyrin [Cephalotrichum gorgonifer] | diamond | 240 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Cephalotrichum | Cephalotrichum gorgonifer | |
| 31180727 | 31180727 | PRJNA385396_P_NODE_7275_length_321_cov_1.056452_g7183_i0 | PRJNA385396 | 7275 | 321 | 1.056452 | 3.39121092 | Cenococcum geophilum 1.58 | 794803 | Fungi | Fungi | 45.8 | 0.00743 | NR | XP_067504299.1 | 794803 | g7183 | i0 | 75 | 0.598130841121495 | 32 | 8 | 29.9 | 0 | 130 | 225 | 437 | 468 | XP_067504299.1 uncharacterized protein K441DRAFT_659230 [Cenococcum geophilum 1.58] | diamond | 192 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Gloniales | Gloniaceae | Cenococcum | Cenococcum geophilum | |
| 31197501 | 31197501 | PRJNA385396_P_NODE_20695_length_242_cov_0.911243_g20603_i0 | PRJNA385396 | 20695 | 242 | 0.911243 | 2.20520806 | Dothideomycetes | 147541 | Fungi | Fungi | 74.7 | 9.78e-14 | NR | XP_033571110.1 | 574789 | g20603 | i0 | 65.3 | 5.10743801652893 | 49 | 17 | 60.7 | 0 | 25 | 171 | 145 | 193 | XP_033571110.1 uncharacterized protein BDZ99DRAFT_153596 [Mytilinidion resinicola] | diamond | 1236 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mytilinidiales | Mytilinidiaceae | Mytilinidion | Mytilinidion resinicola | |
| 32242107 | 32242107 | PRJNA385396_P_NODE_10098_length_283_cov_1.466667_g10006_i0 | PRJNA385396 | 10098 | 283 | 1.466667 | 4.15066761 | Fungi | 4751 | Fungi | Fungi | 134 | 1.59e-38 | NR | NP_593558.1 | 4896 | g10006 | i0 | 67.4 | 14.6077738515901 | 92 | 30 | 97.5 | 0 | 276 | 1 | 14 | 105 | NP_593558.1 60S ribosomal protein eL30 [Schizosaccharomyces pombe] | diamond | 4134 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 32589925 | 32589925 | PRJNA385396_P_NODE_21339_length_241_cov_0.916667_g21247_i0 | PRJNA385396 | 21339 | 241 | 0.916667 | 2.20916747 | Didymosphaeriaceae | 221678 | Fungi | Fungi | 47 | 0.00116 | NR | TKA62513.1 | 331657 | g21247 | i0 | 35.5 | 6.59751037344398 | 76 | 44 | 94.6 | 1 | 12 | 239 | 829 | 899 | TKA62513.1 hypothetical protein B0A49_09230 [Cryomyces minteri] | diamond | 1590 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cryomyces | Cryomyces minteri | |||
| 32824886 | 32824886 | PRJNA385396_P_NODE_13060_length_253_cov_1.416667_g12968_i0 | PRJNA385396 | 13060 | 253 | 1.416667 | 3.58416751 | Xylaria polymorpha | 77046 | Fungi | Fungi | 43.9 | 0.0166 | NR | KAH8162654.1 | 77046 | g12968 | i0 | 47.6 | 0.49802371541502 | 42 | 20 | 49.8 | 1 | 168 | 43 | 329 | 368 | KAH8162654.1 hypothetical protein CIB48_g5609 [Xylaria polymorpha] | diamond | 126 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria polymorpha |
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);;