contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26680196 | 26680196 | PRJNA312107_P_NODE_19501_length_168_cov_1.025210_g19335_i0 | PRJNA312107 | 19501 | 168 | 1.02521 | 1.7223528 | Ophiocordyceps | 474995 | Fungi | Fungi | 43.5 | 0.00715 | NR | RDA95982.1 | 2039874 | g19335 | i0 | 45.5 | 1.17857142857143 | 33 | 16 | 55.4 | 1 | 38 | 130 | 38 | 70 | RDA95982.1 hypothetical protein CP533_5872 [Ophiocordyceps camponoti-saundersi (nom. inval.)] | diamond | 198 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps camponoti-saundersi (nom. inval.) | |
| 26870662 | 26870662 | PRJNA312107_P_NODE_23701_length_164_cov_0.904348_g23535_i0 | PRJNA312107 | 23701 | 164 | 0.904348 | 1.48313072 | Trichomeriaceae | 1233474 | Fungi | Fungi | 103 | 6.4899999999999996e-24 | NR | XP_064728698.1 | 1635080 | g23535 | i0 | 83.3 | 2.96341463414634 | 54 | 9 | 98.8 | 0 | 162 | 1 | 484 | 537 | XP_064728698.1 uncharacterized protein PMZ80_007025 [Knufia obscura] | diamond | 486 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 27074223 | 27074223 | PRJNA312107_P_NODE_20142_length_168_cov_0.873950_g19976_i0 | PRJNA312107 | 20142 | 168 | 0.87395 | 1.468236 | Malassezia furfur | 55194 | Fungi | Fungi | 63.9 | 4.53e-10 | NR | KAI3626632.1 | 55194 | g19976 | i0 | 55.4 | 2 | 56 | 25 | 100 | 0 | 1 | 168 | 213 | 268 | KAI3626632.1 hypothetical protein CBS14141_000633 [Malassezia furfur] | diamond | 336 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 27232255 | 27232255 | PRJNA312107_P_NODE_23623_length_164_cov_0.904348_g23457_i0 | PRJNA312107 | 23623 | 164 | 0.904348 | 1.48313072 | Alternaria alternata | 5599 | Fungi | Fungi | 103 | 5.02e-26 | NR | KAH6863882.1 | 5599 | g23457 | i0 | 100 | 0.98780487804878 | 54 | 0 | 98.8 | 0 | 163 | 2 | 83 | 136 | KAH6863882.1 hypothetical protein B0T12DRAFT_17280 [Alternaria alternata] | diamond | 162 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 27439773 | 27439773 | PRJNA312107_P_NODE_20503_length_167_cov_0.881356_g20337_i0 | PRJNA312107 | 20503 | 167 | 0.881356 | 1.47186452 | Ascomycota | 4890 | Fungi | Fungi | 102 | 1.5199999999999995e-23 | NR | KAI7618305.1 | 91943 | g20337 | i0 | 94.5 | 45.4491017964072 | 55 | 3 | 98.8 | 0 | 165 | 1 | 231 | 285 | KAI7618305.1 hypothetical protein KC319_g19153, partial [Hortaea werneckii] | diamond | 7590 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 27863825 | 27863825 | PRJNA312107_P_NODE_9245_length_236_cov_0.978610_g9079_i0 | PRJNA312107 | 9245 | 236 | 0.97861 | 2.3095196 | Aspergillus varians | 176181 | Fungi | Fungi | 42 | 0.0237 | NR | KAL4788479.1 | 176181 | g9079 | i0 | 38.6 | 0.724576271186441 | 57 | 31 | 72.5 | 1 | 198 | 28 | 27 | 79 | KAL4788479.1 hypothetical protein BJX76DRAFT_116599 [Aspergillus varians] | diamond | 171 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus varians | |
| 28495566 | 28495566 | PRJNA312107_P_NODE_25787_length_162_cov_0.920354_g25621_i0 | PRJNA312107 | 25787 | 162 | 0.920354 | 1.49097348 | Epicoccum nigrum | 105696 | Fungi | Fungi | 114 | 7.34e-28 | NR | KAG9206674.1 | 105696 | g25621 | i0 | 98.1 | 1 | 54 | 1 | 100 | 0 | 1 | 162 | 52 | 105 | KAG9206674.1 hypothetical protein G6514_003514 [Epicoccum nigrum] | diamond | 162 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum | |
| 28810792 | 28810792 | PRJNA312107_P_NODE_25548_length_162_cov_0.920354_g25382_i0 | PRJNA312107 | 25548 | 162 | 0.920354 | 1.49097348 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 43.1 | 0.00641 | NR | KAH9262945.1 | 1357716 | g25382 | i0 | 83.3 | 0.888888888888889 | 24 | 4 | 44.4 | 0 | 41 | 112 | 54 | 77 | KAH9262945.1 hypothetical protein BASA82_000043 [Batrachochytrium salamandrivorans] | diamond | 144 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28937558 | 28937558 | PRJNA312107_P_NODE_21108_length_167_cov_0.881356_g20942_i0 | PRJNA312107 | 21108 | 167 | 0.881356 | 1.47186452 | Hyaloscypha sp. PMI_1271 | 2614599 | Fungi | Fungi | 85.1 | 1.54e-17 | NR | KAH8755138.1 | 2614599 | g20942 | i0 | 78.2 | 0.988023952095808 | 55 | 12 | 98.8 | 0 | 3 | 167 | 142 | 196 | KAH8755138.1 hypothetical protein F5882DRAFT_367736 [Hyaloscypha sp. PMI_1271] | diamond | 165 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Hyaloscyphaceae | Hyaloscypha | Hyaloscypha sp. PMI_1271 | |
| 29112986 | 29112986 | PRJNA312107_P_NODE_25528_length_162_cov_0.920354_g25362_i0 | PRJNA312107 | 25528 | 162 | 0.920354 | 1.49097348 | Hypocreales | 5125 | Fungi | Fungi | 82.4 | 1.17e-16 | NR | KAL2210795.1 | 5046 | g25362 | i0 | 70 | 8.38888888888889 | 50 | 15 | 92.6 | 0 | 160 | 11 | 398 | 447 | KAL2210795.1 histidine acid phosphatase [Sarocladium strictum] | diamond | 1359 | 82.8 | 0.995169082125604 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 29365555 | 29365555 | PRJNA312107_P_NODE_23769_length_164_cov_0.904348_g23603_i0 | PRJNA312107 | 23769 | 164 | 0.904348 | 1.48313072 | Pleosporales | 92860 | Fungi | Fungi | 89.7 | 3.5e-19 | NR | KAI4949194.1 | 1187941 | g23603 | i0 | 74.1 | 2.96341463414634 | 54 | 12 | 98.8 | 1 | 1 | 162 | 503 | 554 | KAI4949194.1 hypothetical protein J4E91_005658 [Alternaria rosae] | diamond | 486 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria rosae | |
| 29442395 | 29442395 | PRJNA312107_P_NODE_13930_length_196_cov_0.843537_g13764_i0 | PRJNA312107 | 13930 | 196 | 0.843537 | 1.65333252 | Coemansia javaensis | 2761396 | Fungi | Fungi | 42 | 0.039 | NR | KAJ2782999.1 | 2761396 | g13764 | i0 | 45 | 0.612244897959184 | 40 | 22 | 61.2 | 0 | 14 | 133 | 173 | 212 | KAJ2782999.1 hypothetical protein H4R18_001962 [Coemansia javaensis] | diamond | 120 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia javaensis | |
| 29631785 | 29631785 | PRJNA312107_P_NODE_23230_length_165_cov_0.896552_g23064_i0 | PRJNA312107 | 23230 | 165 | 0.896552 | 1.4793108 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 102 | 1.6299999999999994e-23 | NR | KAK3191042.1 | 1964301 | g23064 | i0 | 90.6 | 0.963636363636364 | 53 | 5 | 96.4 | 0 | 160 | 2 | 560 | 612 | KAK3191042.1 hypothetical protein K4F52_002992 [Lecanicillium sp. MT-2017a] | diamond | 159 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 29631786 | 29631786 | PRJNA312107_P_NODE_24410_length_163_cov_1.359649_g24244_i0 | PRJNA312107 | 24410 | 163 | 1.359649 | 2.21622787 | Podospora australis | 1536484 | Fungi | Fungi | 41.2 | 0.0438 | NR | KAK4186062.1 | 1536484 | g24244 | i0 | 41.7 | 0.662576687116564 | 36 | 21 | 66.3 | 0 | 42 | 149 | 609 | 644 | KAK4186062.1 hypothetical protein QBC35DRAFT_453660 [Podospora australis] | diamond | 108 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Podospora | Podospora australis | |
| 30264131 | 30264131 | PRJNA312107_P_NODE_19172_length_169_cov_0.866667_g19006_i0 | PRJNA312107 | 19172 | 169 | 0.866667 | 1.46466723 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 65.5 | 1.23e-10 | NR | KAI8900394.1 | 382532 | g19006 | i0 | 54.5 | 0.976331360946746 | 55 | 25 | 97.6 | 0 | 169 | 5 | 230 | 284 | KAI8900394.1 actin family [Globomyces pollinis-pini] | diamond | 165 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 30579524 | 30579524 | PRJNA312107_P_NODE_21573_length_166_cov_0.888889_g21407_i0 | PRJNA312107 | 21573 | 166 | 0.888889 | 1.47555574 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 92.4 | 4.17e-20 | NR | KAK3191859.1 | 1964301 | g21407 | i0 | 77.8 | 1.95180722891566 | 54 | 12 | 97.6 | 0 | 1 | 162 | 645 | 698 | KAK3191859.1 hypothetical protein K4F52_001902 [Lecanicillium sp. MT-2017a] | diamond | 324 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 30769437 | 30769437 | PRJNA312107_P_NODE_23614_length_164_cov_0.904348_g23448_i0 | PRJNA312107 | 23614 | 164 | 0.904348 | 1.48313072 | Tilletia indica | 43049 | Fungi | Fungi | 52.8 | 3.66e-6 | NR | KAE8239739.1 | 43049 | g23448 | i0 | 60 | 5.72560975609756 | 35 | 14 | 64 | 0 | 164 | 60 | 326 | 360 | KAE8239739.1 hypothetical protein A4X13_0g8091 [Tilletia indica] | diamond | 939 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia indica | |
| 32034178 | 32034178 | PRJNA312107_P_NODE_25958_length_162_cov_0.920354_g25792_i0 | PRJNA312107 | 25958 | 162 | 0.920354 | 1.49097348 | Hortaea werneckii | 91943 | Fungi | Fungi | 41.6 | 0.00917 | NR | RMZ14196.1 | 91943 | g25792 | i0 | 69 | 2.14814814814815 | 29 | 9 | 53.7 | 0 | 63 | 149 | 53 | 81 | RMZ14196.1 hypothetical protein D0864_00250 [Hortaea werneckii] | diamond | 348 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 32097360 | 32097360 | PRJNA312107_P_NODE_20158_length_168_cov_0.873950_g19992_i0 | PRJNA312107 | 20158 | 168 | 0.87395 | 1.468236 | Sphaerobolus stellatus SS14 | 990650 | Fungi | Fungi | 73.2 | 1.09e-14 | NR | KIJ29806.1 | 990650 | g19992 | i0 | 70.9 | 1.89285714285714 | 55 | 16 | 98.2 | 0 | 167 | 3 | 41 | 95 | KIJ29806.1 hypothetical protein M422DRAFT_128484, partial [Sphaerobolus stellatus SS14] | diamond | 318 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Geastrales | Sphaerobolaceae | Sphaerobolus | Sphaerobolus stellatus | |
| 32666394 | 32666394 | PRJNA312107_P_NODE_19780_length_168_cov_0.873950_g19614_i0 | PRJNA312107 | 19780 | 168 | 0.87395 | 1.468236 | Malassezia vespertilionis | 2020962 | Fungi | Fungi | 65.5 | 1.37e-11 | NR | PKI83286.1 | 2020962 | g19614 | i0 | 68.5 | 0.964285714285714 | 54 | 17 | 96.4 | 0 | 167 | 6 | 78 | 131 | PKI83286.1 hypothetical protein MVES_003040 [Malassezia vespertilionis] | diamond | 162 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia vespertilionis | |
| 32886673 | 32886673 | PRJNA312107_P_NODE_18900_length_169_cov_0.866667_g18734_i0 | PRJNA312107 | 18900 | 169 | 0.866667 | 1.46466723 | Valsa sordida | 252740 | Fungi | Fungi | 53.5 | 2.07e-6 | NR | ROV89038.1 | 252740 | g18734 | i0 | 49.1 | 0.976331360946746 | 55 | 28 | 97.6 | 0 | 167 | 3 | 308 | 362 | ROV89038.1 hypothetical protein VSDG_08717 [Cytospora chrysosperma] | diamond | 165 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora chrysosperma |
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);;