contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA793147" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17356582 | 17356582 | PRJNA793147_P_NODE_58774_length_229_cov_0.900000_g58508_i0 | PRJNA793147 | 58774 | 229 | 0.9 | 2.061 | Dothistroma septosporum NZE1 | 64363 | Fungi | Fungi | 130 | 2.77e-36 | NR | EME50235.1 | 675120 | g58508 | i0 | 84.2 | 0.995633187772926 | 76 | 12 | 99.6 | 0 | 1 | 228 | 6 | 81 | EME50235.1 hypothetical protein DOTSEDRAFT_20609 [Dothistroma septosporum NZE10] | diamond | 228 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Dothistroma | Dothistroma septosporum | |
| 22893485 | 22893485 | PRJNA793147_P_NODE_31318_length_299_cov_1.704348_g31052_i0 | PRJNA793147 | 31318 | 299 | 1.704348 | 5.09600052 | Sphaerosporella brunnea | 1250544 | Fungi | Fungi | 80.1 | 4.57e-15 | NR | KAA8912857.1 | 1250544 | g31052 | i0 | 43.6 | 1.53511705685619 | 78 | 38 | 78.3 | 1 | 5 | 238 | 44 | 115 | KAA8912857.1 hypothetical protein FN846DRAFT_886957 [Sphaerosporella brunnea] | diamond | 459 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Sphaerosporella | Sphaerosporella brunnea | |
| 26714448 | 26714448 | PRJNA793147_P_NODE_19581_length_377_cov_2.564935_g19315_i0 | PRJNA793147 | 19581 | 377 | 2.564935 | 9.66980495 | Chaetomiaceae | 35718 | Fungi | Fungi | 142 | 5.42e-40 | NR | XP_003651487.1 | 578455 | g19315 | i0 | 64.6 | 28.9814323607427 | 99 | 35 | 78.8 | 0 | 301 | 5 | 1 | 99 | XP_003651487.1 uncharacterized protein THITE_2111869 [Thermothielavioides terrestris NRRL 8126] | diamond | 10926 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Thermothielavioides | Thermothielavioides terrestris | |
| 26864249 | 26864249 | PRJNA793147_P_NODE_48061_length_242_cov_1.786127_g47795_i0 | PRJNA793147 | 48061 | 242 | 1.786127 | 4.32242734 | Fusarium graminearum PH-1 | 229533 | Fungi | Fungi | 43.9 | 0.0137 | NR | XP_011326510.1 | 229533 | g47795 | i0 | 44 | 1.74793388429752 | 75 | 32 | 80.6 | 3 | 5 | 199 | 5 | 79 | XP_011326510.1 hypothetical protein FGSG_06855 [Fusarium graminearum PH-1] | diamond | 423 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium graminearum | |
| 26904856 | 26904856 | PRJNA793147_P_NODE_52961_length_233_cov_1.317073_g52695_i0 | PRJNA793147 | 52961 | 233 | 1.317073 | 3.06878009 | Fungi | 4751 | Fungi | Fungi | 75.9 | 5.77e-15 | NR | XP_501834.4 | 4952 | g52695 | i0 | 42.1 | 5.83261802575107 | 76 | 43 | 96.6 | 1 | 4 | 228 | 102 | 177 | XP_501834.4 uncharacterized protein YALI1_C20314g [Yarrowia lipolytica] | diamond | 1359 | 76.3 | 0.99475753604194 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 27062925 | 27062925 | PRJNA793147_P_NODE_26022_length_326_cov_1.976654_g25756_i0 | PRJNA793147 | 26022 | 326 | 1.976654 | 6.44389204 | Eurotiales | 5042 | Fungi | Fungi | 134 | 2.1e-36 | NR | KAB8077545.1 | 41062 | g25756 | i0 | 63 | 79.5092024539877 | 100 | 37 | 92 | 0 | 326 | 27 | 163 | 262 | KAB8077545.1 P-loop containing nucleoside triphosphate hydrolase protein [Aspergillus leporis] | diamond | 25920 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus leporis | |
| 28538358 | 28538358 | PRJNA793147_P_NODE_62367_length_226_cov_0.917197_g62101_i0 | PRJNA793147 | 62367 | 226 | 0.917197 | 2.07286522 | Lachnellula willkommii | 215461 | Fungi | Fungi | 52.8 | 7.11e-6 | NR | TVY89511.1 | 215461 | g62101 | i0 | 47 | 1.10176991150442 | 83 | 36 | 99.6 | 3 | 225 | 1 | 105 | 187 | TVY89511.1 hypothetical protein LAWI1_G002247, partial [Lachnellula willkommii] | diamond | 249 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Lachnaceae | Lachnellula | Lachnellula willkommii | |
| 29012069 | 29012069 | PRJNA793147_P_NODE_46828_length_246_cov_1.310734_g46562_i0 | PRJNA793147 | 46828 | 246 | 1.310734 | 3.22440564 | Cordyceps militaris CM | 73501 | Fungi | Fungi | 60.5 | 2.12e-8 | NR | XP_006670369.1 | 983644 | g46562 | i0 | 39.7 | 4.71951219512195 | 73 | 44 | 89 | 0 | 18 | 236 | 306 | 378 | XP_006670369.1 DUF914 domain membrane protein [Cordyceps militaris CM01] | diamond | 1161 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Cordyceps | Cordyceps militaris | |
| 29494510 | 29494510 | PRJNA793147_P_NODE_56690_length_230_cov_0.931677_g56424_i0 | PRJNA793147 | 56690 | 230 | 0.931677 | 2.1428571 | Eukaryota | 2759 | Fungi | Fungi | 43.1 | 0.0062 | NR | ANZ77599.1 | 4922 | g56424 | i0 | 42.1 | 3.32608695652174 | 57 | 33 | 74.3 | 0 | 230 | 60 | 11 | 67 | ANZ77599.1 BA75_04630T0 [Komagataella pastoris] | diamond | 765 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella pastoris | |
| 29516784 | 29516784 | PRJNA793147_P_NODE_48850_length_240_cov_1.637427_g48584_i0 | PRJNA793147 | 48850 | 240 | 1.637427 | 3.9298248 | Sungouiella intermedia | 45354 | Fungi | Fungi | 70.1 | 5.25e-12 | NR | SGZ58397.1 | 45354 | g48584 | i0 | 53.3 | 0.75 | 60 | 27 | 75 | 1 | 1 | 180 | 243 | 301 | SGZ58397.1 CIC11C00000000080 [Sungouiella intermedia] | diamond | 180 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Sungouiella | Sungouiella intermedia | |
| 29548294 | 29548294 | PRJNA793147_P_NODE_35730_length_281_cov_1.877358_g35464_i0 | PRJNA793147 | 35730 | 281 | 1.877358 | 5.27537598 | Aspergillus violaceofuscus CBS 115571 | 1450538 | Fungi | Fungi | 55.1 | 2.29e-6 | NR | PYI23996.1 | 1450538 | g35464 | i0 | 34.5 | 0.896797153024911 | 84 | 50 | 87.5 | 3 | 253 | 8 | 17 | 97 | PYI23996.1 hypothetical protein BO99DRAFT_457832 [Aspergillus violaceofuscus CBS 115571] | diamond | 252 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus violaceofuscus | |
| 30307077 | 30307077 | PRJNA793147_P_NODE_52092_length_234_cov_0.872727_g51826_i0 | PRJNA793147 | 52092 | 234 | 0.872727 | 2.04218118 | Brettanomyces nanus | 13502 | Fungi | Fungi | 48.5 | 2.71e-4 | NR | XP_038777284.1 | 13502 | g51826 | i0 | 34.3 | 0.858974358974359 | 67 | 44 | 85.9 | 0 | 214 | 14 | 160 | 226 | XP_038777284.1 uncharacterized protein FOA43_001032 [Brettanomyces nanus] | diamond | 201 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Brettanomyces | Brettanomyces nanus | |
| 30884430 | 30884430 | PRJNA793147_P_NODE_58794_length_229_cov_0.881250_g58528_i0 | PRJNA793147 | 58794 | 229 | 0.88125 | 2.0180625 | Phyllosticta | 121621 | Fungi | Fungi | 48.1 | 3.93e-4 | NR | KAK7631069.1 | 55181 | g58528 | i0 | 43.8 | 2.51528384279476 | 48 | 27 | 62.9 | 0 | 80 | 223 | 223 | 270 | KAK7631069.1 anaphase promoting complex subunit 8, partial [Phyllosticta citricarpa] | diamond | 576 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Phyllostictaceae | Phyllosticta | Phyllosticta citricarpa | |
| 31602552 | 31602552 | PRJNA793147_P_NODE_26796_length_322_cov_0.818182_g26530_i0 | PRJNA793147 | 26796 | 322 | 0.818182 | 2.63454604 | Acrodontium crateriforme | 150365 | Fungi | Fungi | 69.3 | 2.6e-11 | NR | WPH00390.1 | 150365 | g26530 | i0 | 71.7 | 0.428571428571429 | 46 | 9 | 42.9 | 1 | 320 | 183 | 101 | 142 | WPH00390.1 Hypothetical protein R9X50_00321700 [Acrodontium crateriforme] | diamond | 138 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme | |
| 32181162 | 32181162 | PRJNA793147_P_NODE_16458_length_415_cov_6.575145_g16192_i0 | PRJNA793147 | 16458 | 415 | 6.575145 | 27.28685175 | Ascomycota | 4890 | Fungi | Fungi | 92.4 | 2.5900000000000003e-21 | NR | XP_001645789.1 | 436907 | g16192 | i0 | 51.3 | 4.91566265060241 | 80 | 39 | 57.8 | 0 | 80 | 319 | 21 | 100 | XP_001645789.1 uncharacterized protein Kpol_1010p47 [Vanderwaltozyma polyspora DSM 70294] | diamond | 2040 | 92.8 | 0.995689655172414 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Vanderwaltozyma | Vanderwaltozyma polyspora | |
| 32402610 | 32402610 | PRJNA793147_P_NODE_44599_length_252_cov_1.573770_g44333_i0 | PRJNA793147 | 44599 | 252 | 1.57377 | 3.9659004 | Saccharomycetaceae | 4893 | Fungi | Fungi | 52.4 | 1.65e-5 | NR | XP_449606.1 | 5478 | g44333 | i0 | 43.9 | 6 | 57 | 29 | 65.5 | 2 | 165 | 1 | 182 | 237 | XP_449606.1 histone chaperone NAP1 [Nakaseomyces glabratus] | diamond | 1512 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Nakaseomyces | Nakaseomyces glabratus |
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);;