contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA864829" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21249456 | 21249456 | PRJNA864829_S_NODE_6557_length_238_cov_2.455026_g6471_i0 | PRJNA864829 | 6557 | 238 | 2.455026 | 5.84296188 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 129 | 2.4999999999999997e-36 | NR | KAI9006966.1 | 82268 | g6471 | i0 | 74.7 | 3.97058823529412 | 79 | 20 | 99.6 | 0 | 237 | 1 | 55 | 133 | KAI9006966.1 L30e-like protein [Hyaloraphidium curvatum] | diamond | 945 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 27308168 | 27308168 | PRJNA864829_S_NODE_10663_length_194_cov_1.489655_g10577_i0 | PRJNA864829 | 10663 | 194 | 1.489655 | 2.8899307 | Schizosaccharomyces pombe | 4896 | Fungi | Fungi | 75.9 | 6.59e-16 | NR | NP_588143.1 | 4896 | g10577 | i0 | 62.5 | 1.7319587628866 | 56 | 21 | 86.6 | 0 | 179 | 12 | 48 | 103 | NP_588143.1 60S ribosomal protein L34 [Schizosaccharomyces pombe] | diamond | 336 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 27537253 | 27537253 | PRJNA864829_S_NODE_15303_length_167_cov_0.889831_g15217_i0 | PRJNA864829 | 15303 | 167 | 0.889831 | 1.48601777 | Chaetomiaceae | 35718 | Fungi | Fungi | 65.5 | 6.04e-12 | NR | KAL1835581.1 | 85995 | g15217 | i0 | 55.6 | 2.91017964071856 | 54 | 9 | 97 | 2 | 6 | 167 | 52 | 90 | KAL1835581.1 hypothetical protein VTJ49DRAFT_6440 [Mycothermus thermophilus] | diamond | 486 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Mycothermus | Mycothermus thermophilus | |
| 28634400 | 28634400 | PRJNA864829_S_NODE_3667_length_295_cov_1.621951_g3581_i0 | PRJNA864829 | 3667 | 295 | 1.621951 | 4.78475545 | Mortierella sp. AD | 1715235 | Fungi | Fungi | 64.7 | 7.11e-10 | NR | KAF9157771.1 | 1896179 | g3581 | i0 | 33 | 3.11186440677966 | 100 | 65 | 99.7 | 1 | 2 | 295 | 106 | 205 | KAF9157771.1 hypothetical protein BGX20_003730 [Mortierella sp. AD010] | diamond | 918 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella sp. AD010 | |
| 28926406 | 28926406 | PRJNA864829_S_NODE_14548_length_170_cov_0.876033_g14462_i0 | PRJNA864829 | 14548 | 170 | 0.876033 | 1.4892561 | Eukaryota | 2759 | Fungi | Fungi | 79.7 | 1.27e-15 | NR | EMG46868.1 | 1245528 | g14462 | i0 | 78.7 | 12.7411764705882 | 47 | 10 | 82.9 | 0 | 3 | 143 | 372 | 418 | EMG46868.1 Polyadenylate-binding protein, cytoplasmic and nuclear [Candida maltosa Xu316] | diamond | 2166 | 80.1 | 0.995006242197254 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida maltosa | |
| 28950119 | 28950119 | PRJNA864829_S_NODE_6688_length_236_cov_3.096257_g6602_i0 | PRJNA864829 | 6688 | 236 | 3.096257 | 7.30716652 | Xylaria scruposa | 743287 | Fungi | Fungi | 46.6 | 3.57e-4 | NR | KAI1733355.1 | 743287 | g6602 | i0 | 69 | 1.19491525423729 | 29 | 9 | 36.9 | 0 | 234 | 148 | 15 | 43 | KAI1733355.1 hypothetical protein F4680DRAFT_463211 [Xylaria scruposa] | diamond | 282 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria scruposa | |
| 29392049 | 29392049 | PRJNA864829_S_NODE_2209_length_353_cov_3.407895_g2123_i0 | PRJNA864829 | 2209 | 353 | 3.407895 | 12.02986935 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 88.6 | 5.46e-19 | NR | PVU85138.1 | 61424 | g2123 | i0 | 63.4 | 2.39660056657224 | 71 | 26 | 60.3 | 0 | 2 | 214 | 117 | 187 | PVU85138.1 hypothetical protein BB559_007195 [Furculomyces boomerangus] | diamond | 846 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 30189560 | 30189560 | PRJNA864829_S_NODE_7712_length_222_cov_2.924855_g7626_i0 | PRJNA864829 | 7712 | 222 | 2.924855 | 6.4931781 | Opisthokonta | 33154 | Fungi | Fungi | 132 | 6.529999999999999e-37 | NR | KAK0436538.1 | 47425 | g7626 | i0 | 84.9 | 22.6891891891892 | 73 | 11 | 98.6 | 0 | 220 | 2 | 87 | 159 | KAK0436538.1 thioredoxin-like protein [Armillaria borealis] | diamond | 5037 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Armillaria | Armillaria borealis | |
| 30371510 | 30371510 | PRJNA864829_S_NODE_4092_length_284_cov_1.876596_g4006_i0 | PRJNA864829 | 4092 | 284 | 1.876596 | 5.32953264 | [Candida] subhashii | 561895 | Fungi | Fungi | 50.1 | 1.63e-4 | NR | XP_049261443.1 | 561895 | g4006 | i0 | 40 | 0.845070422535211 | 80 | 36 | 83.5 | 3 | 37 | 273 | 526 | 594 | XP_049261443.1 uncharacterized protein J8A68_005278, partial [[Candida] subhashii] | diamond | 240 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Spathaspora | [Candida] subhashii | |
| 30403109 | 30403109 | PRJNA864829_S_NODE_4693_length_271_cov_2.072072_g4607_i0 | PRJNA864829 | 4693 | 271 | 2.072072 | 5.61531512 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 108 | 1.44e-27 | NR | KAH9257010.1 | 1357716 | g4607 | i0 | 80.3 | 0.675276752767528 | 61 | 12 | 67.5 | 0 | 270 | 88 | 104 | 164 | KAH9257010.1 hypothetical protein BASA81_004831 [Batrachochytrium salamandrivorans] | diamond | 183 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30434615 | 30434615 | PRJNA864829_S_NODE_7493_length_225_cov_2.130682_g7407_i0 | PRJNA864829 | 7493 | 225 | 2.130682 | 4.7940345 | Neoconidiobolus thromboides FSU 785 | 1314799 | Fungi | Fungi | 81.6 | 5.63e-16 | NR | KAI9290818.1 | 1314799 | g7407 | i0 | 54.7 | 5.73333333333333 | 75 | 32 | 98.7 | 2 | 223 | 2 | 238 | 311 | KAI9290818.1 hypothetical protein K502DRAFT_310092 [Neoconidiobolus thromboides FSU 785] | diamond | 1290 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 30686909 | 30686909 | PRJNA864829_S_NODE_12313_length_182_cov_2.563910_g12227_i0 | PRJNA864829 | 12313 | 182 | 2.56391 | 4.6663162 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 58.2 | 5.97e-8 | NR | WFD15251.1 | 1514897 | g12227 | i0 | 64.9 | 2.48901098901099 | 37 | 13 | 61 | 0 | 6 | 116 | 622 | 658 | WFD15251.1 hypothetical protein MARU1_001267 [Malassezia arunalokei] | diamond | 453 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 30876601 | 30876601 | PRJNA864829_S_NODE_8614_length_212_cov_2.858896_g8528_i0 | PRJNA864829 | 8614 | 212 | 2.858896 | 6.06085952 | Mycena floridula | 1033242 | Fungi | Fungi | 42.4 | 0.0329 | NR | KAJ7594971.1 | 1033242 | g8528 | i0 | 40.4 | 0.665094339622642 | 47 | 24 | 66.5 | 1 | 147 | 7 | 105 | 147 | KAJ7594971.1 hypothetical protein C8J56DRAFT_928118 [Mycena floridula] | diamond | 141 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena floridula | |
| 31983231 | 31983231 | PRJNA864829_S_NODE_8978_length_209_cov_1.168750_g8892_i0 | PRJNA864829 | 8978 | 209 | 1.16875 | 2.4426875 | Tothia fuscella | 1048955 | Fungi | Fungi | 40.8 | 0.0144 | NR | KAF2413444.1 | 1048955 | g8892 | i0 | 56.8 | 0.5311004784689 | 37 | 16 | 53.1 | 0 | 99 | 209 | 13 | 49 | KAF2413444.1 hypothetical protein EJ08DRAFT_601403, partial [Tothia fuscella] | diamond | 111 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Cylindrosympodiaceae | Tothia | Tothia fuscella | |
| 32109898 | 32109898 | PRJNA864829_S_NODE_11218_length_190_cov_1.645390_g11132_i0 | PRJNA864829 | 11218 | 190 | 1.64539 | 3.126241 | Onygenales sp. PD_12 | 2135916 | Fungi | Fungi | 51.6 | 1.39e-5 | NR | KAK2789604.1 | 2135916 | g11132 | i0 | 42.9 | 4.98947368421053 | 63 | 35 | 97.9 | 1 | 187 | 2 | 222 | 284 | KAK2789604.1 heme peroxidase [Onygenales sp. PD_12] | diamond | 948 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Onygenales sp. PD_12 | |||
| 32236827 | 32236827 | PRJNA864829_S_NODE_16938_length_155_cov_2.311321_g16852_i0 | PRJNA864829 | 16938 | 155 | 2.311321 | 3.58254755 | Cunninghamella echinulata | 76405 | Fungi | Fungi | 68.9 | 2.11e-13 | NR | KAI9304767.1 | 76405 | g16852 | i0 | 72.9 | 1.83870967741935 | 48 | 13 | 92.9 | 0 | 8 | 151 | 64 | 111 | KAI9304767.1 60S ribosomal protein L34-B [Cunninghamella echinulata] | diamond | 285 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Cunninghamella | Cunninghamella echinulata | |
| 32561264 | 32561264 | PRJNA864829_S_NODE_10759_length_193_cov_2.590278_g10673_i0 | PRJNA864829 | 10759 | 193 | 2.590278 | 4.99923654 | root | 1 | Root_unresolved | Root_unresolved | 60.1 | 1.49e-8 | NR | YP_010119226.1 | 36044 | g10673 | i0 | 42.6 | 2.82901554404145 | 61 | 35 | 94.8 | 0 | 192 | 10 | 620 | 680 | YP_010119226.1 reverse transcriptase domain-containing protein, partial [Erysiphe pisi] | diamond | 546 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe pisi |
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);;