contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA937226" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17490181 | 17490181 | PRJNA937226_S_NODE_18214_length_193_cov_1.083333_g18087_i0 | PRJNA937226 | 18214 | 193 | 1.083333 | 2.09083269 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 114 | 6.21e-29 | NR | XP_043140199.1 | 182096 | g18087 | i0 | 84.1 | 0.979274611398964 | 63 | 10 | 97.9 | 0 | 4 | 192 | 228 | 290 | XP_043140199.1 uncharacterized protein ACHE_70520S [Aspergillus chevalieri] | diamond | 189 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 26771804 | 26771804 | PRJNA937226_S_NODE_6941_length_275_cov_3.637168_g6814_i0 | PRJNA937226 | 6941 | 275 | 3.637168 | 10.002212 | Xylariales sp. PMI_5 | 1756188 | Fungi | Fungi | 59.3 | 2.5e-8 | NR | KAH8664623.1 | 1940296 | g6814 | i0 | 90 | 0.654545454545455 | 30 | 3 | 32.7 | 0 | 273 | 184 | 160 | 189 | KAH8664623.1 2Fe-2S ferredoxin-type domain-containing protein [Xylariales sp. PMI_506] | diamond | 180 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariales sp. PMI_506 | |||
| 27119524 | 27119524 | PRJNA937226_S_NODE_11242_length_233_cov_1.706522_g11115_i0 | PRJNA937226 | 11242 | 233 | 1.706522 | 3.97619626 | Pleomassaria siparia CBS 279.74 | 1314801 | Fungi | Fungi | 53.1 | 7.21e-6 | NR | KAF2702907.1 | 1314801 | g11115 | i0 | 37 | 0.939914163090129 | 73 | 35 | 79.8 | 2 | 214 | 29 | 1282 | 1354 | KAF2702907.1 putative polyketide synthase [Pleomassaria siparia CBS 279.74] | diamond | 219 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleomassariaceae | Pleomassaria | Pleomassaria siparia | |
| 27150965 | 27150965 | PRJNA937226_S_NODE_18422_length_192_cov_1.454545_g18295_i0 | PRJNA937226 | 18422 | 192 | 1.454545 | 2.7927264 | Xylaria intraflava | 492091 | Fungi | Fungi | 42.4 | 0.0275 | NR | KAI1826832.1 | 492091 | g18295 | i0 | 42.4 | 1.03125 | 66 | 35 | 98.4 | 2 | 4 | 192 | 1552 | 1617 | KAI1826832.1 hypothetical protein F4861DRAFT_495363 [Xylaria intraflava] | diamond | 198 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria intraflava | |
| 27284848 | 27284848 | PRJNA937226_S_NODE_13923_length_214_cov_4.787879_g13796_i0 | PRJNA937226 | 13923 | 214 | 4.787879 | 10.24606106 | Bipolaris | 33194 | Fungi | Fungi | 42 | 0.0486 | NR | KAF5847637.1 | 45130 | g13796 | i0 | 59.3 | 0.757009345794392 | 27 | 11 | 37.9 | 0 | 112 | 32 | 275 | 301 | KAF5847637.1 hypothetical protein GGP41_000363 [Bipolaris sorokiniana] | diamond | 162 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Bipolaris | Bipolaris sorokiniana | |
| 27379893 | 27379893 | PRJNA937226_S_NODE_10703_length_237_cov_2.936170_g10576_i0 | PRJNA937226 | 10703 | 237 | 2.93617 | 6.9587229 | Aspergillaceae | 1131492 | Fungi | Fungi | 45.4 | 0.00167 | NR | XP_038931924.1 | 5082 | g10576 | i0 | 64.3 | 3.18987341772152 | 28 | 10 | 35.4 | 0 | 2 | 85 | 122 | 149 | XP_038931924.1 uncharacterized protein LCP9604111_1797 [Penicillium roqueforti] | diamond | 756 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 28193394 | 28193394 | PRJNA937226_S_NODE_14646_length_210_cov_2.453416_g14519_i0 | PRJNA937226 | 14646 | 210 | 2.453416 | 5.1521736 | Aspergillus calidoustus | 454130 | Fungi | Fungi | 120 | 4.06e-32 | NR | CEN62200.1 | 454130 | g14519 | i0 | 87.1 | 2.98571428571429 | 70 | 9 | 100 | 0 | 210 | 1 | 138 | 207 | CEN62200.1 Putative Ankyrin repeat protein [Aspergillus calidoustus] | diamond | 627 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus calidoustus | |
| 28200403 | 28200403 | PRJNA937226_S_NODE_18346_length_192_cov_3.069930_g18219_i0 | PRJNA937226 | 18346 | 192 | 3.06993 | 5.8942656 | Aspergillus | 5052 | Fungi | Fungi | 88.2 | 1.32e-18 | NR | GES57532.1 | 33178 | g18219 | i0 | 95.6 | 19.6875 | 45 | 2 | 70.3 | 0 | 1 | 135 | 370 | 414 | GES57532.1 hypothetical protein ATETN484_0001074100 [Aspergillus terreus] | diamond | 3780 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus terreus | |
| 28288144 | 28288144 | PRJNA937226_S_NODE_6946_length_275_cov_3.048673_g6819_i0 | PRJNA937226 | 6946 | 275 | 3.048673 | 8.38385075 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 109 | 1.39e-25 | NR | XP_069229726.1 | 1052096 | g6819 | i0 | 85.2 | 0.665454545454545 | 61 | 9 | 66.5 | 0 | 2 | 184 | 450 | 510 | XP_069229726.1 uncharacterized protein WHR41_04562 [Cladosporium halotolerans] | diamond | 183 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 28319863 | 28319863 | PRJNA937226_S_NODE_13486_length_217_cov_1.642857_g13359_i0 | PRJNA937226 | 13486 | 217 | 1.642857 | 3.56499969 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 85.5 | 2.24e-17 | NR | KAH1462757.1 | 746128 | g13359 | i0 | 76 | 2.75115207373272 | 50 | 12 | 69.1 | 0 | 3 | 152 | 554 | 603 | KAH1462757.1 hypothetical protein KXX58_007440 [Aspergillus fumigatus] | diamond | 597 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 28863585 | 28863585 | PRJNA937226_S_NODE_24968_length_169_cov_3.466667_g24841_i0 | PRJNA937226 | 24968 | 169 | 3.466667 | 5.85866723 | Aspergillaceae | 1131492 | Fungi | Fungi | 73.6 | 7.08e-14 | NR | KAJ6168208.1 | 5076 | g24841 | i0 | 57.1 | 4.97041420118343 | 56 | 24 | 99.4 | 0 | 1 | 168 | 58 | 113 | KAJ6168208.1 hypothetical protein N7497_001051 [Penicillium chrysogenum] | diamond | 840 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chrysogenum | |
| 29330225 | 29330225 | PRJNA937226_S_NODE_19069_length_189_cov_2.557143_g18942_i0 | PRJNA937226 | 19069 | 189 | 2.557143 | 4.83300027 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 53.5 | 2.73e-6 | NR | XP_069229357.1 | 1052096 | g18942 | i0 | 83.3 | 0.476190476190476 | 30 | 5 | 47.6 | 0 | 3 | 92 | 370 | 399 | XP_069229357.1 uncharacterized protein WHR41_05480 [Cladosporium halotolerans] | diamond | 90 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29772125 | 29772125 | PRJNA937226_S_NODE_5891_length_291_cov_2.950413_g5764_i0 | PRJNA937226 | 5891 | 291 | 2.950413 | 8.58570183 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 68.2 | 7.79e-11 | NR | XP_069230746.1 | 1052096 | g5764 | i0 | 96.8 | 0.319587628865979 | 31 | 1 | 32 | 0 | 1 | 93 | 705 | 735 | XP_069230746.1 uncharacterized protein WHR41_03611 [Cladosporium halotolerans] | diamond | 93 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29937312 | 29937312 | PRJNA937226_S_NODE_12851_length_221_cov_1.813953_g12724_i0 | PRJNA937226 | 12851 | 221 | 1.813953 | 4.00883613 | Eurotiomycetes | 147545 | Fungi | Fungi | 87.8 | 9.96e-21 | NR | XP_031900895.1 | 209559 | g12724 | i0 | 70.3 | 5.2262443438914 | 64 | 19 | 86.9 | 0 | 219 | 28 | 23 | 86 | XP_031900895.1 heat shock protein 9/12-domain-containing protein [Aspergillus alliaceus] | diamond | 1155 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus alliaceus | |
| 29993504 | 29993504 | PRJNA937226_S_NODE_30531_length_155_cov_2.141509_g30404_i0 | PRJNA937226 | 30531 | 155 | 2.141509 | 3.31933895 | Penicillium chermesinum | 63820 | Fungi | Fungi | 65.5 | 1.06e-10 | NR | XP_058332577.1 | 63820 | g30404 | i0 | 78 | 0.793548387096774 | 41 | 9 | 79.4 | 0 | 154 | 32 | 500 | 540 | XP_058332577.1 uncharacterized protein N7468_004277 [Penicillium chermesinum] | diamond | 123 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chermesinum | |
| 30341479 | 30341479 | PRJNA937226_S_NODE_20432_length_184_cov_1.540741_g20305_i0 | PRJNA937226 | 20432 | 184 | 1.540741 | 2.83496344 | Talaromyces islandicus | 28573 | Fungi | Fungi | 51.2 | 1.64e-6 | NR | CRG83147.1 | 28573 | g20305 | i0 | 78.6 | 0.456521739130435 | 28 | 6 | 45.7 | 0 | 106 | 23 | 54 | 81 | CRG83147.1 hypothetical protein PISL3812_00495 [Talaromyces islandicus] | diamond | 84 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces islandicus | |
| 30404562 | 30404562 | PRJNA937226_S_NODE_8053_length_262_cov_1.953052_g7926_i0 | PRJNA937226 | 8053 | 262 | 1.953052 | 5.11699624 | Clohesyomyces aquaticus | 1231657 | Fungi | Fungi | 82.4 | 3.14e-18 | NR | ORY00373.1 | 1231657 | g7926 | i0 | 67.2 | 0.732824427480916 | 64 | 21 | 73.3 | 0 | 261 | 70 | 34 | 97 | ORY00373.1 heat shock protein 9/12-domain-containing protein [Clohesyomyces aquaticus] | diamond | 192 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lindgomycetaceae | Clohesyomyces | Clohesyomyces aquaticus | |
| 30909792 | 30909792 | PRJNA937226_S_NODE_11254_length_233_cov_1.413043_g11127_i0 | PRJNA937226 | 11254 | 233 | 1.413043 | 3.29239019 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 113 | 1.34e-27 | NR | XP_022405394.1 | 1160497 | g11127 | i0 | 73.6 | 0.927038626609442 | 72 | 19 | 92.7 | 0 | 232 | 17 | 344 | 415 | XP_022405394.1 uncharacterized protein ASPGLDRAFT_31833 [Aspergillus glaucus CBS 516.65] | diamond | 216 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 30972971 | 30972971 | PRJNA937226_S_NODE_11794_length_229_cov_1.155556_g11667_i0 | PRJNA937226 | 11794 | 229 | 1.155556 | 2.64622324 | Colletotrichum tanaceti | 1306861 | Fungi | Fungi | 43.1 | 0.0228 | NR | KAJ0166374.1 | 1306861 | g11667 | i0 | 37.7 | 0.694323144104803 | 53 | 33 | 69.4 | 0 | 224 | 66 | 433 | 485 | KAJ0166374.1 hypothetical protein CTA2_7524 [Colletotrichum tanaceti] | diamond | 159 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum tanaceti | |
| 31043393 | 31043393 | PRJNA937226_S_NODE_16875_length_199_cov_1.386667_g16748_i0 | PRJNA937226 | 16875 | 199 | 1.386667 | 2.75946733 | Aspergillaceae | 1131492 | Fungi | Fungi | 68.6 | 1.68e-11 | NR | XP_058331933.1 | 63820 | g16748 | i0 | 61.4 | 1.74874371859296 | 57 | 22 | 85.9 | 0 | 11 | 181 | 1051 | 1107 | XP_058331933.1 uncharacterized protein N7468_003633 [Penicillium chermesinum] | diamond | 348 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chermesinum | |
| 31953072 | 31953072 | PRJNA937226_S_NODE_21577_length_180_cov_1.190840_g21450_i0 | PRJNA937226 | 21577 | 180 | 1.19084 | 2.143512 | Monascus purpureus | 5098 | Fungi | Fungi | 73.9 | 3.13e-15 | NR | TQB76965.1 | 5098 | g21450 | i0 | 67.3 | 0.816666666666667 | 49 | 16 | 81.7 | 0 | 1 | 147 | 62 | 110 | TQB76965.1 thioredoxin trx1 [Monascus purpureus] | diamond | 147 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Monascus | Monascus purpureus | |
| 32459531 | 32459531 | PRJNA937226_S_NODE_10019_length_243_cov_1.340206_g9892_i0 | PRJNA937226 | 10019 | 243 | 1.340206 | 3.25670058 | Cryoendolithus antarcticus | 1507870 | Fungi | Fungi | 58.5 | 1e-7 | NR | OQO07572.1 | 1507870 | g9892 | i0 | 69.4 | 0.604938271604938 | 49 | 10 | 58 | 2 | 242 | 102 | 880 | 925 | OQO07572.1 hypothetical protein B0A48_07269 [Cryoendolithus antarcticus] | diamond | 147 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cryoendolithus | Cryoendolithus antarcticus | |
| 32522981 | 32522981 | PRJNA937226_S_NODE_2979_length_368_cov_3.260188_g2852_i0 | PRJNA937226 | 2979 | 368 | 3.260188 | 11.99749184 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 211 | 1.45e-64 | NR | XP_069231468.1 | 1052096 | g2852 | i0 | 85.1 | 0.929347826086957 | 114 | 17 | 92.9 | 0 | 3 | 344 | 283 | 396 | XP_069231468.1 uncharacterized protein WHR41_03064 [Cladosporium halotolerans] | diamond | 342 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 32624224 | 32624224 | PRJNA937226_S_NODE_12300_length_225_cov_2.068182_g12173_i0 | PRJNA937226 | 12300 | 225 | 2.068182 | 4.6534095 | Ascomycota | 4890 | Fungi | Fungi | 97.8 | 1.01e-22 | NR | KAI0454656.1 | 114808 | g12173 | i0 | 81.8 | 21.08 | 55 | 10 | 73.3 | 0 | 2 | 166 | 99 | 153 | KAI0454656.1 putative short-chain dehydrogenase [Xylaria acuta] | diamond | 4743 | 98.6 | 0.991886409736308 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria acuta |
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);;