contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4334364 | 4334364 | PRJNA534016_P_NODE_12924_length_256_cov_1.677596_g12834_i0 | PRJNA534016 | 12924 | 256 | 1.677596 | 4.29464576 | Candida verbasci | 1227364 | Fungi | Fungi | 108 | 9.07e-29 | NR | CAI5760403.1 | 1227364 | g12834 | i0 | 69.4 | 5.0859375 | 72 | 22 | 84.4 | 0 | 252 | 37 | 15 | 86 | CAI5760403.1 unnamed protein product [Candida verbasci] | diamond | 1302 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida verbasci | |
| 11986230 | 11986230 | PRJNA534016_P_NODE_17110_length_244_cov_0.859649_g17020_i0 | PRJNA534016 | 17110 | 244 | 0.859649 | 2.09754356 | Eukaryota | 2759 | Fungi | Fungi | 100 | 2.15e-22 | NR | KAI5293593.1 | 51565 | g17020 | i0 | 57.1 | 6.57786885245902 | 77 | 32 | 93.4 | 1 | 234 | 7 | 332 | 408 | KAI5293593.1 hypothetical protein KEM52_005396 [Ascosphaera acerosa] | diamond | 1605 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ascosphaeraceae | Ascosphaera | Ascosphaera acerosa | |
| 18358945 | 18358945 | PRJNA534016_P_NODE_12715_length_258_cov_1.400000_g12625_i0 | PRJNA534016 | 12715 | 258 | 1.4 | 3.612 | Ascobolus immersus RN42 | 1160509 | Fungi | Fungi | 142 | 2.7199999999999997e-37 | NR | RPA82171.1 | 1160509 | g12625 | i0 | 80 | 0.988372093023256 | 85 | 17 | 98.8 | 0 | 3 | 257 | 583 | 667 | RPA82171.1 aconitase [Ascobolus immersus RN42] | diamond | 255 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Ascobolaceae | Ascobolus | Ascobolus immersus | |
| 19633514 | 19633514 | PRJNA534016_P_NODE_10236_length_277_cov_1.509804_g10146_i0 | PRJNA534016 | 10236 | 277 | 1.509804 | 4.18215708 | Eukaryota | 2759 | Fungi | Fungi | 156 | 4.7799999999999986e-43 | NR | KAK3615690.1 | 574655 | g10146 | i0 | 81.3 | 92.6425992779783 | 91 | 17 | 98.6 | 0 | 3 | 275 | 253 | 343 | KAK3615690.1 RuvB ATP-dependent DNA helicase pontin [Elasticomyces elasticus] | diamond | 25662 | 157 | 0.993630573248408 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Elasticomyces | Elasticomyces elasticus | |
| 26634555 | 26634555 | PRJNA534016_P_NODE_13761_length_251_cov_0.865169_g13671_i0 | PRJNA534016 | 13761 | 251 | 0.865169 | 2.17157419 | Lipomyces arxii | 56418 | Fungi | Fungi | 43.9 | 0.0161 | NR | XP_066770316.1 | 56418 | g13671 | i0 | 52.2 | 0.549800796812749 | 46 | 22 | 55 | 0 | 73 | 210 | 421 | 466 | XP_066770316.1 nucleolar complex-associated protein-domain-containing protein [Lipomyces arxii] | diamond | 138 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces arxii | |
| 26729183 | 26729183 | PRJNA534016_P_NODE_17941_length_242_cov_0.911243_g17851_i0 | PRJNA534016 | 17941 | 242 | 0.911243 | 2.20520806 | Podospora appendiculata | 314037 | Fungi | Fungi | 62.8 | 7.07e-10 | NR | KAK3693545.1 | 314037 | g17851 | i0 | 49.2 | 1.66115702479339 | 65 | 33 | 80.6 | 0 | 197 | 3 | 28 | 92 | KAK3693545.1 ubiquitin-conjugating enzyme/RWD-like protein [Podospora appendiculata] | diamond | 402 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Podospora | Podospora appendiculata | |
| 26951077 | 26951077 | PRJNA534016_P_NODE_7022_length_319_cov_1.113821_g6932_i0 | PRJNA534016 | 7022 | 319 | 1.113821 | 3.55308899 | Scedosporium apiospermum | 563466 | Fungi | Fungi | 66.6 | 1.33e-11 | NR | XP_016642949.1 | 563466 | g6932 | i0 | 61.3 | 1.09090909090909 | 62 | 21 | 58.3 | 1 | 2 | 187 | 16 | 74 | XP_016642949.1 DNA-(apurinic or apyrimidinic site) lyase [Scedosporium apiospermum] | diamond | 348 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Scedosporium | Scedosporium apiospermum | |
| 27520143 | 27520143 | PRJNA534016_P_NODE_11003_length_271_cov_1.555556_g10913_i0 | PRJNA534016 | 11003 | 271 | 1.555556 | 4.21555676 | Sphaerosporella brunnea | 1250544 | Fungi | Fungi | 93.6 | 1.59e-22 | NR | KAA8892592.1 | 1250544 | g10913 | i0 | 56.6 | 2.60147601476015 | 76 | 32 | 84.1 | 1 | 40 | 267 | 11 | 85 | KAA8892592.1 hypothetical protein FN846DRAFT_896715 [Sphaerosporella brunnea] | diamond | 705 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Sphaerosporella | Sphaerosporella brunnea | |
| 27898878 | 27898878 | PRJNA534016_P_NODE_16005_length_246_cov_0.890173_g15915_i0 | PRJNA534016 | 16005 | 246 | 0.890173 | 2.18982558 | Dothistroma septosporum NZE1 | 64363 | Fungi | Fungi | 42.7 | 0.0377 | NR | EME43200.1 | 675120 | g15915 | i0 | 37.1 | 0.75609756097561 | 62 | 39 | 75.6 | 0 | 234 | 49 | 156 | 217 | EME43200.1 hypothetical protein DOTSEDRAFT_72548 [Dothistroma septosporum NZE10] | diamond | 186 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Dothistroma | Dothistroma septosporum | |
| 28640369 | 28640369 | PRJNA534016_P_NODE_13427_length_252_cov_1.620112_g13337_i0 | PRJNA534016 | 13427 | 252 | 1.620112 | 4.08268224 | Talaromyces | 5094 | Fungi | Fungi | 150 | 4.07e-40 | NR | KAL3702653.1 | 37727 | g13337 | i0 | 78.7 | 4.47619047619048 | 94 | 2 | 90.5 | 1 | 229 | 2 | 118 | 211 | KAL3702653.1 hypothetical protein TMatcc_011232 [Talaromyces marneffei] | diamond | 1128 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei | |
| 28829525 | 28829525 | PRJNA534016_P_NODE_17928_length_242_cov_0.911243_g17838_i0 | PRJNA534016 | 17928 | 242 | 0.911243 | 2.20520806 | Hypocreales | 5125 | Fungi | Fungi | 107 | 3.41e-26 | NR | KAF5690028.1 | 48490 | g17838 | i0 | 60.5 | 9.60743801652893 | 76 | 30 | 94.2 | 0 | 238 | 11 | 172 | 247 | KAF5690028.1 members of the aldo keto reductase family [Fusarium circinatum] | diamond | 2325 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium circinatum | |
| 28846093 | 28846093 | PRJNA534016_P_NODE_14888_length_248_cov_2.348571_g14798_i0 | PRJNA534016 | 14888 | 248 | 2.348571 | 5.82445608 | Aspergillus steynii IBT 23 | 306088 | Fungi | Fungi | 62 | 9.69e-10 | NR | XP_024698185.1 | 1392250 | g14798 | i0 | 46.5 | 0.858870967741935 | 71 | 37 | 84.7 | 1 | 34 | 243 | 58 | 128 | XP_024698185.1 uncharacterized protein P170DRAFT_419945 [Aspergillus steynii IBT 23096] | diamond | 213 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus steynii | |
| 29650115 | 29650115 | PRJNA534016_P_NODE_12870_length_256_cov_2.644809_g12780_i0 | PRJNA534016 | 12870 | 256 | 2.644809 | 6.77071104 | Fungi | 4751 | Fungi | Fungi | 43.9 | 0.0139 | NR | XP_022630293.1 | 1245769 | g12780 | i0 | 44.8 | 1.20703125 | 58 | 30 | 66.8 | 2 | 187 | 17 | 31 | 87 | XP_022630293.1 histone H1 [Lachancea lanzarotensis] | diamond | 309 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Lachancea | Lachancea lanzarotensis | |
| 29666855 | 29666855 | PRJNA534016_P_NODE_16390_length_245_cov_0.895349_g16300_i0 | PRJNA534016 | 16390 | 245 | 0.895349 | 2.19360505 | Oidiodendron maius Zn | 913774 | Fungi | Fungi | 43.1 | 0.0288 | NR | KIN07530.1 | 913774 | g16300 | i0 | 41.2 | 0.83265306122449 | 68 | 26 | 74.7 | 4 | 242 | 60 | 559 | 619 | KIN07530.1 hypothetical protein OIDMADRAFT_151137 [Oidiodendron maius Zn] | diamond | 204 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Myxotrichaceae | Oidiodendron | Oidiodendron maius | ||
| 30661437 | 30661437 | PRJNA534016_P_NODE_7373_length_311_cov_11.563025_g7283_i0 | PRJNA534016 | 7373 | 311 | 11.563025 | 35.96100775 | Saccharomycetaceae | 4893 | Fungi | Fungi | 63.2 | 6.9e-10 | NR | KAF4001137.1 | 4932 | g7283 | i0 | 54.5 | 3.16398713826367 | 66 | 20 | 63.7 | 1 | 2 | 199 | 51 | 106 | KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] | diamond | 984 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 32147606 | 32147606 | PRJNA534016_P_NODE_14398_length_250_cov_0.870056_g14308_i0 | PRJNA534016 | 14398 | 250 | 0.870056 | 2.17514 | Fungi | 4751 | Fungi | Fungi | 90.5 | 6.19e-19 | NR | KAG0128210.1 | 55307 | g14308 | i0 | 57.8 | 6.972 | 83 | 35 | 99.6 | 0 | 1 | 249 | 38 | 120 | KAG0128210.1 phosphate transporter [Tuber indicum] | diamond | 1743 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tuberaceae | Tuber | Tuber indicum | |
| 32810787 | 32810787 | PRJNA534016_P_NODE_9460_length_283_cov_1.833333_g9370_i0 | PRJNA534016 | 9460 | 283 | 1.833333 | 5.18833239 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.00537 | NR | VBB79485.1 | 48703 | g9370 | i0 | 35.2 | 2.45936395759717 | 71 | 46 | 75.3 | 0 | 19 | 231 | 10 | 80 | VBB79485.1 Putative protein of unknown function [Podospora comata] | diamond | 696 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Podospora | Podospora comata |
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);;