contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27374344 | 27374344 | PRJNA983848_P_NODE_147923_length_248_cov_0.891429_g142040_i0 | PRJNA983848 | 147923 | 248 | 0.891429 | 2.21074392 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 135 | 3.5999999999999997e-35 | NR | XP_023621073.1 | 112498 | g142040 | i0 | 89.2 | 0.895161290322581 | 74 | 8 | 89.5 | 0 | 26 | 247 | 222 | 295 | XP_023621073.1 related to MFS peptide transporter Ptr2 [Ramularia collo-cygni] | diamond | 222 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 27500452 | 27500452 | PRJNA983848_P_NODE_145563_length_249_cov_0.886364_g139680_i0 | PRJNA983848 | 145563 | 249 | 0.886364 | 2.20704636 | Penicillium angulare | 116970 | Fungi | Fungi | 57 | 3.72e-7 | NR | XP_056781423.1 | 116970 | g139680 | i0 | 46.8 | 1.49397590361446 | 62 | 25 | 65.1 | 1 | 235 | 74 | 214 | 275 | XP_056781423.1 uncharacterized protein N7478_007172 [Penicillium angulare] | diamond | 372 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium angulare | |
| 27563199 | 27563199 | PRJNA983848_P_NODE_40104_length_599_cov_4.923954_g34278_i0 | PRJNA983848 | 40104 | 599 | 4.923954 | 29.49448446 | Apiospora kogelbergensis | 1337665 | Fungi | Fungi | 118 | 2.1000000000000002e-30 | NR | XP_066734544.1 | 1337665 | g34278 | i0 | 49.5 | 1.62270450751252 | 107 | 54 | 53.6 | 0 | 98 | 418 | 1 | 107 | XP_066734544.1 Thioredoxin [Apiospora kogelbergensis] | diamond | 972 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora kogelbergensis | |
| 27753120 | 27753120 | PRJNA983848_P_NODE_136804_length_254_cov_0.850829_g130921_i0 | PRJNA983848 | 136804 | 254 | 0.850829 | 2.16110566 | Thermoascus thermophilus | 1131473 | Fungi | Fungi | 42.4 | 0.0147 | NR | KAL2002437.1 | 1131473 | g130921 | i0 | 23.8 | 0.74409448818897606 | 63 | 38 | 74.4 | 1 | 20 | 208 | 9 | 61 | KAL2002437.1 hypothetical protein VTN02DRAFT_6778 [Thermoascus thermophilus] | diamond | 189 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Thermoascaceae | Thermoascus | Thermoascus thermophilus | |
| 27942483 | 27942483 | PRJNA983848_P_NODE_140445_length_252_cov_0.871508_g134562_i0 | PRJNA983848 | 140445 | 252 | 0.871508 | 2.19620016 | Diaporthe ampelina | 1214573 | Fungi | Fungi | 106 | 5.23e-25 | NR | KKY37888.1 | 1214573 | g134562 | i0 | 73.5 | 0.988095238095238 | 83 | 22 | 98.8 | 0 | 3 | 251 | 118 | 200 | KKY37888.1 hypothetical protein UCDDA912_g02105 [Diaporthe ampelina] | diamond | 249 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe ampelina | |
| 28163487 | 28163487 | PRJNA983848_P_NODE_144185_length_250_cov_0.881356_g138302_i0 | PRJNA983848 | 144185 | 250 | 0.881356 | 2.20339 | Clavispora lusitaniae | 36911 | Fungi | Fungi | 89 | 6.94e-19 | NR | QFZ25681.1 | 36911 | g138302 | i0 | 65 | 1.488 | 60 | 21 | 72 | 0 | 69 | 248 | 5 | 64 | QFZ25681.1 putative geranylgeranyl transferase type-2 subunit beta [Clavispora lusitaniae] | diamond | 372 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Clavispora | Clavispora lusitaniae | |
| 28573751 | 28573751 | PRJNA983848_P_NODE_114627_length_280_cov_2.260870_g108744_i0 | PRJNA983848 | 114627 | 280 | 2.26087 | 6.330436 | Byssothecium circinans | 147558 | Fungi | Fungi | 42 | 0.0257 | NR | KAF1955246.1 | 147558 | g108744 | i0 | 37 | 0.492857142857143 | 46 | 26 | 49.3 | 1 | 248 | 111 | 4 | 46 | KAF1955246.1 hypothetical protein CC80DRAFT_90873 [Byssothecium circinans] | diamond | 138 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Massarinaceae | Byssothecium | Byssothecium circinans | |
| 28637226 | 28637226 | PRJNA983848_P_NODE_157487_length_243_cov_1.294118_g151604_i0 | PRJNA983848 | 157487 | 243 | 1.294118 | 3.14470674 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 75.9 | 7.83e-14 | NR | XP_022395717.1 | 1160497 | g151604 | i0 | 73.2 | 0.506172839506173 | 41 | 11 | 50.6 | 0 | 18 | 140 | 25 | 65 | XP_022395717.1 uncharacterized protein ASPGLDRAFT_70378 [Aspergillus glaucus CBS 516.65] | diamond | 123 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 28889543 | 28889543 | PRJNA983848_P_NODE_65948_length_394_cov_1.196262_g60065_i0 | PRJNA983848 | 65948 | 394 | 1.196262 | 4.71327228 | Starmerella bacillaris | 1247836 | Fungi | Fungi | 45.8 | 0.0141 | NR | GMM49612.1 | 1247836 | g60065 | i0 | 33.3 | 1.10406091370558 | 72 | 48 | 54.8 | 0 | 221 | 6 | 269 | 340 | GMM49612.1 UDP-galactose transporter [Starmerella bacillaris] | diamond | 435 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Starmerella | Starmerella bacillaris | |
| 28921010 | 28921010 | PRJNA983848_P_NODE_157708_length_243_cov_0.917647_g151825_i0 | PRJNA983848 | 157708 | 243 | 0.917647 | 2.22988221 | Aspergillus heteromorphus CBS 117.55 | 1448321 | Fungi | Fungi | 58.2 | 1.45e-7 | NR | XP_025399173.1 | 1448321 | g151825 | i0 | 48.1 | 1 | 81 | 29 | 100 | 2 | 243 | 1 | 1414 | 1481 | XP_025399173.1 uncharacterized protein BO70DRAFT_41926 [Aspergillus heteromorphus CBS 117.55] | diamond | 243 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus heteromorphus | |
| 29142427 | 29142427 | PRJNA983848_P_NODE_151749_length_246_cov_0.901734_g145866_i0 | PRJNA983848 | 151749 | 246 | 0.901734 | 2.21826564 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 45.4 | 0.00438 | NR | XP_043137829.1 | 182096 | g145866 | i0 | 53.8 | 0.634146341463415 | 52 | 4 | 63.4 | 1 | 156 | 1 | 1 | 32 | XP_043137829.1 uncharacterized protein ACHE_50505S [Aspergillus chevalieri] | diamond | 156 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 29463499 | 29463499 | PRJNA983848_P_NODE_156110_length_244_cov_0.912281_g150227_i0 | PRJNA983848 | 156110 | 244 | 0.912281 | 2.22596564 | Aspergillus | 5052 | Fungi | Fungi | 154 | 6.29e-44 | NR | KAL4893605.1 | 176160 | g150227 | i0 | 87.5 | 6.88524590163934 | 80 | 10 | 98.4 | 0 | 3 | 242 | 150 | 229 | KAL4893605.1 Intradiol ring-cleavage dioxygenase [Aspergillus ambiguus] | diamond | 1680 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus ambiguus | |
| 29489338 | 29489338 | PRJNA983848_P_NODE_155530_length_244_cov_0.912281_g149647_i0 | PRJNA983848 | 155530 | 244 | 0.912281 | 2.22596564 | Vermiconidia calcicola | 1690605 | Fungi | Fungi | 90.9 | 4.35e-19 | NR | KAK3723583.1 | 1690605 | g149647 | i0 | 63.1 | 1.0327868852459 | 84 | 28 | 99.6 | 2 | 2 | 244 | 98 | 181 | KAK3723583.1 hypothetical protein LTR37_001835 [Vermiconidia calcicola] | diamond | 252 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Vermiconidia | Vermiconidia calcicola | |
| 29521039 | 29521039 | PRJNA983848_P_NODE_147990_length_248_cov_0.891429_g142107_i0 | PRJNA983848 | 147990 | 248 | 0.891429 | 2.21074392 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 109 | 1.49e-25 | NR | XP_069225820.1 | 1052096 | g142107 | i0 | 79.7 | 2.70967741935484 | 79 | 16 | 95.6 | 0 | 246 | 10 | 112 | 190 | XP_069225820.1 uncharacterized protein WHR41_08582 [Cladosporium halotolerans] | diamond | 672 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29969128 | 29969128 | PRJNA983848_P_NODE_152871_length_245_cov_1.802326_g146988_i0 | PRJNA983848 | 152871 | 245 | 1.802326 | 4.4156987 | Fusarium | 5506 | Fungi | Fungi | 92 | 1.34e-19 | NR | KAK6707130.1 | 5518 | g146988 | i0 | 60.8 | 3.7469387755102 | 74 | 29 | 90.6 | 0 | 226 | 5 | 149 | 222 | KAK6707130.1 T-complex protein 1 subunit theta [Fusarium graminearum] | diamond | 918 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium graminearum | |
| 30374335 | 30374335 | PRJNA983848_P_NODE_63112_length_406_cov_2.594595_g57230_i0 | PRJNA983848 | 63112 | 406 | 2.594595 | 10.5340557 | Diplocarpon mali | 946123 | Fungi | Fungi | 45.1 | 0.0179 | NR | KAI6714177.1 | 946123 | g57230 | i0 | 32.6 | 0.679802955665025 | 92 | 58 | 68 | 2 | 131 | 406 | 18 | 105 | KAI6714177.1 hypothetical protein JHW43_003298 [Diplocarpon mali] | diamond | 276 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Drepanopezizaceae | Diplocarpon | Diplocarpon mali | |
| 30500323 | 30500323 | PRJNA983848_P_NODE_76633_length_356_cov_1.102473_g70750_i0 | PRJNA983848 | 76633 | 356 | 1.102473 | 3.92480388 | Aspergillus cristatus | 573508 | Fungi | Fungi | 165 | 3.3699999999999998e-46 | NR | ODM20157.1 | 573508 | g70750 | i0 | 78.2 | 0.926966292134832 | 110 | 21 | 91 | 2 | 1 | 324 | 234 | 342 | ODM20157.1 hypothetical protein SI65_05145 [Aspergillus cristatus] | diamond | 330 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus cristatus | |
| 30563156 | 30563156 | PRJNA983848_P_NODE_154633_length_244_cov_2.403509_g148750_i0 | PRJNA983848 | 154633 | 244 | 2.403509 | 5.86456196 | Hanseniaspora valbyensis NRRL Y-1626 | 766949 | Fungi | Fungi | 56.2 | 6.64e-7 | NR | OBA27354.1 | 766949 | g148750 | i0 | 60 | 0.430327868852459 | 35 | 14 | 43 | 0 | 111 | 7 | 83 | 117 | OBA27354.1 hypothetical protein HANVADRAFT_48328 [Hanseniaspora valbyensis NRRL Y-1626] | diamond | 105 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Hanseniaspora | Hanseniaspora valbyensis | |
| 30853786 | 30853786 | PRJNA983848_P_NODE_154334_length_245_cov_0.906977_g148451_i0 | PRJNA983848 | 154334 | 245 | 0.906977 | 2.22209365 | Aspergillus | 5052 | Fungi | Fungi | 113 | 2.09e-29 | NR | XP_045944091.1 | 138277 | g148451 | i0 | 75 | 1.86122448979592 | 76 | 19 | 93.1 | 0 | 236 | 9 | 91 | 166 | XP_045944091.1 uncharacterized protein LDX57_006419 [Aspergillus melleus] | diamond | 456 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus melleus | |
| 32460891 | 32460891 | PRJNA983848_P_NODE_153539_length_245_cov_0.906977_g147656_i0 | PRJNA983848 | 153539 | 245 | 0.906977 | 2.22209365 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 138 | 3.4699999999999995e-37 | NR | XP_043136535.1 | 182096 | g147656 | i0 | 85.2 | 0.991836734693878 | 81 | 12 | 99.2 | 0 | 243 | 1 | 269 | 349 | XP_043136535.1 uncharacterized protein ACHE_40577A [Aspergillus chevalieri] | diamond | 243 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 32587408 | 32587408 | PRJNA983848_P_NODE_148179_length_248_cov_0.891429_g142296_i0 | PRJNA983848 | 148179 | 248 | 0.891429 | 2.21074392 | Verruconis gallopava | 253628 | Fungi | Fungi | 155 | 1.28e-41 | NR | XP_016217624.1 | 253628 | g142296 | i0 | 92.7 | 0.991935483870968 | 82 | 6 | 99.2 | 0 | 3 | 248 | 216 | 297 | XP_016217624.1 aspartate-tRNA(Asn) ligase [Verruconis gallopava] | diamond | 246 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Sympoventuriaceae | Verruconis | Verruconis gallopava | |
| 32618690 | 32618690 | PRJNA983848_P_NODE_165740_length_228_cov_2.012903_g159857_i0 | PRJNA983848 | 165740 | 228 | 2.012903 | 4.5894188400000004 | Exophiala mesophila | 212818 | Fungi | Fungi | 91.7 | 1.84e-19 | NR | XP_016223737.1 | 212818 | g159857 | i0 | 85.7 | 0.736842105263158 | 56 | 7 | 73.7 | 1 | 59 | 226 | 1200 | 1254 | XP_016223737.1 uncharacterized protein PV10_06624 [Exophiala mesophila] | diamond | 168 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala mesophila | |
| 32901952 | 32901952 | PRJNA983848_P_NODE_149500_length_247_cov_0.896552_g143617_i0 | PRJNA983848 | 149500 | 247 | 0.896552 | 2.21448344 | Aspergillus oleicola | 1250372 | Fungi | Fungi | 59.7 | 3.99e-8 | NR | KAL4935276.1 | 1250372 | g143617 | i0 | 64.3 | 0.510121457489879 | 42 | 15 | 51 | 0 | 161 | 36 | 29 | 70 | KAL4935276.1 hypothetical protein BDV06DRAFT_207346 [Aspergillus oleicola] | diamond | 126 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus oleicola |
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);;