contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA1192965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11799084 | 11799084 | PRJNA1192965_P_NODE_4010_length_247_cov_0.885057_g3991_i0 | PRJNA1192965 | 4010 | 247 | 0.885057 | 2.18609079 | Paraphaeosphaeria minitans | 565426 | Fungi | Fungi | 167 | 8.01e-49 | NR | KAF9737903.1 | 565426 | g3991 | i0 | 96.3 | 1.9919028340081 | 82 | 3 | 99.6 | 0 | 246 | 1 | 249 | 330 | KAF9737903.1 alcohol dehydrogenase [Paraphaeosphaeria minitans] | diamond | 492 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymosphaeriaceae | Paraphaeosphaeria | Paraphaeosphaeria minitans | |
| 21997232 | 21997232 | PRJNA1192965_P_NODE_3398_length_251_cov_0.865169_g3379_i0 | PRJNA1192965 | 3398 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | Fungi | Fungi | 103 | 4.31e-25 | NR | KAL1953049.1 | 5041 | g3379 | i0 | 56.6 | 30.5498007968128 | 83 | 36 | 99.2 | 0 | 250 | 2 | 119 | 201 | KAL1953049.1 hypothetical protein VTO42DRAFT_3721 [Malbranchea cinnamomea] | diamond | 7668 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Malbrancheaceae | Malbranchea | Malbranchea cinnamomea | |
| 21997249 | 21997249 | PRJNA1192965_P_NODE_798_length_423_cov_4.628571_g779_i0 | PRJNA1192965 | 798 | 423 | 4.628571 | 19.57885533 | Eukaryota | 2759 | Fungi | Fungi | 216 | 3.2e-68 | NR | ROW01840.1 | 448051 | g779 | i0 | 71.7 | 18.7021276595745 | 138 | 39 | 97.9 | 0 | 423 | 10 | 99 | 236 | ROW01840.1 hypothetical protein VMCG_05647 [Cytospora schulzeri] | diamond | 7911 | 218 | 0.990825688073395 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora schulzeri | |
| 26755657 | 26755657 | PRJNA1192965_P_NODE_3301_length_251_cov_0.865169_g3282_i0 | PRJNA1192965 | 3301 | 251 | 0.865169 | 2.17157419 | Xylaria hypoxylon | 37992 | Fungi | Fungi | 43.1 | 0.0293 | NR | TGJ83346.1 | 37992 | g3282 | i0 | 39.2 | 0.609561752988048 | 51 | 28 | 61 | 1 | 181 | 29 | 65 | 112 | TGJ83346.1 hypothetical protein E0Z10_g5423 [Xylaria hypoxylon] | diamond | 153 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria hypoxylon | |
| 26933246 | 26933246 | PRJNA1192965_P_NODE_2182_length_290_cov_1.769585_g2163_i0 | PRJNA1192965 | 2182 | 290 | 1.769585 | 5.1317965 | Eukaryota | 2759 | Fungi | Fungi | 103 | 2.4199999999999998e-23 | NR | KAL3960658.1 | 33203 | g2163 | i0 | 53.5 | 8.86551724137931 | 86 | 38 | 86.9 | 1 | 38 | 289 | 57 | 142 | KAL3960658.1 hypothetical protein ACCO45_005775 [Purpureocillium lilacinum] | diamond | 2571 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 26964791 | 26964791 | PRJNA1192965_P_NODE_3722_length_249_cov_0.875000_g3703_i0 | PRJNA1192965 | 3722 | 249 | 0.875 | 2.17875 | Aspergillaceae | 1131492 | Fungi | Fungi | 101 | 2.9e-23 | NR | OOO07167.1 | 5062 | g3703 | i0 | 57.3 | 28.4819277108434 | 82 | 35 | 98.8 | 0 | 2 | 247 | 271 | 352 | OOO07167.1 50S ribosomal protein L30e [Aspergillus oryzae] | diamond | 7092 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus oryzae | |
| 27198569 | 27198569 | PRJNA1192965_P_NODE_4662_length_244_cov_0.900585_g4643_i0 | PRJNA1192965 | 4662 | 244 | 0.900585 | 2.1974274 | Venturia effusa | 50376 | Fungi | Fungi | 55.1 | 1.61e-6 | NR | QDS72945.1 | 50376 | g4643 | i0 | 38.7 | 1.84426229508197 | 75 | 40 | 87.3 | 3 | 214 | 2 | 173 | 245 | QDS72945.1 hypothetical protein FKW77_008330 [Venturia effusa] | diamond | 450 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Venturiaceae | Venturia | Venturia effusa | |
| 27230357 | 27230357 | PRJNA1192965_P_NODE_1123_length_373_cov_1.540000_g1104_i0 | PRJNA1192965 | 1123 | 373 | 1.54 | 5.7442 | Xylariaceae sp. AK1471 | 2723393 | Fungi | Fungi | 59.3 | 1.05e-7 | NR | KAI3332066.1 | 2723393 | g1104 | i0 | 45.6 | 0.546916890080429 | 68 | 36 | 53.9 | 1 | 341 | 141 | 142 | 209 | KAI3332066.1 glutathione S-transferase [Xylariaceae sp. AK1471] | diamond | 204 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylariaceae sp. AK1471 | ||
| 27376179 | 27376179 | PRJNA1192965_P_NODE_423_length_558_cov_3.255670_g405_i0 | PRJNA1192965 | 423 | 558 | 3.25567 | 18.1666386 | Ascomycota | 4890 | Fungi | Fungi | 86.7 | 1.45e-17 | NR | KAI2732586.1 | 5082 | g405 | i0 | 30.7 | 9.05913978494624 | 153 | 97 | 77.4 | 1 | 39 | 470 | 27 | 179 | KAI2732586.1 hypothetical protein CBS147332_1725 [Penicillium roqueforti] | diamond | 5055 | 87 | 0.996551724137931 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 27597082 | 27597082 | PRJNA1192965_P_NODE_3044_length_258_cov_0.913514_g3025_i0 | PRJNA1192965 | 3044 | 258 | 0.913514 | 2.35686612 | Colletotrichum | 5455 | Fungi | Fungi | 50.8 | 6.13e-5 | NR | XP_049148845.1 | 145971 | g3025 | i0 | 36.6 | 3.80232558139535 | 82 | 51 | 94.2 | 1 | 244 | 2 | 176 | 257 | XP_049148845.1 vacuolar protein sorting-associated protein 4 [Colletotrichum lupini] | diamond | 981 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum lupini | |
| 27704537 | 27704537 | PRJNA1192965_P_NODE_4344_length_245_cov_0.895349_g4325_i0 | PRJNA1192965 | 4344 | 245 | 0.895349 | 2.19360505 | Aspergillus nanangensis | 2582783 | Fungi | Fungi | 43.9 | 0.0148 | NR | KAF9894478.1 | 2582783 | g4325 | i0 | 38.7 | 0.759183673469388 | 62 | 36 | 75.9 | 1 | 43 | 228 | 78 | 137 | KAF9894478.1 hypothetical protein FE257_006361 [Aspergillus nanangensis] | diamond | 186 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus nanangensis | |
| 27975756 | 27975756 | PRJNA1192965_P_NODE_1805_length_311_cov_4.714286_g1786_i0 | PRJNA1192965 | 1805 | 311 | 4.714286 | 14.66142946 | Sordariomycetes | 147550 | Fungi | Fungi | 82 | 5.87e-18 | NR | XP_008097613.1 | 645133 | g1786 | i0 | 46.1 | 6.84887459807074 | 76 | 41 | 73.3 | 0 | 266 | 39 | 3 | 78 | XP_008097613.1 ribosomal protein S21e [Colletotrichum graminicola M1.001] | diamond | 2130 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum graminicola | |
| 28196674 | 28196674 | PRJNA1192965_P_NODE_1046_length_382_cov_2.592233_g1027_i0 | PRJNA1192965 | 1046 | 382 | 2.592233 | 9.90233006 | Ascomycota | 4890 | Fungi | Fungi | 50.8 | 7.86e-5 | NR | RFU25673.1 | 5539 | g1027 | i0 | 35.8 | 2.11256544502618 | 67 | 39 | 49.5 | 1 | 5 | 193 | 7 | 73 | RFU25673.1 hypothetical protein B7463_g10657, partial [Scytalidium lignicola] | diamond | 807 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Scytalidium | Scytalidium lignicola | |||
| 28480990 | 28480990 | PRJNA1192965_P_NODE_3246_length_251_cov_1.730337_g3227_i0 | PRJNA1192965 | 3246 | 251 | 1.730337 | 4.34314587 | Fungi | 4751 | Fungi | Fungi | 92.4 | 8.26e-22 | NR | RKP30329.1 | 27322 | g3227 | i0 | 51.2 | 15.6932270916335 | 82 | 40 | 98 | 0 | 248 | 3 | 1 | 82 | RKP30329.1 hypothetical protein METBISCDRAFT_16598 [Metschnikowia bicuspidata] | diamond | 3939 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia bicuspidata | |
| 29207351 | 29207351 | PRJNA1192965_P_NODE_5309_length_228_cov_3.651613_g5290_i0 | PRJNA1192965 | 5309 | 228 | 3.651613 | 8.32567764 | Ascomycota | 4890 | Fungi | Fungi | 95.9 | 1.27e-22 | NR | XP_045973380.1 | 1174673 | g5290 | i0 | 63.5 | 33.0789473684211 | 74 | 26 | 96.1 | 1 | 9 | 227 | 44 | 117 | XP_045973380.1 uncharacterized protein LAJ45_04070 [Morchella importuna] | diamond | 7542 | 96.3 | 0.995846313603323 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Morchellaceae | Morchella | Morchella importuna | |
| 29914588 | 29914588 | PRJNA1192965_P_NODE_2411_length_281_cov_5.168269_g2392_i0 | PRJNA1192965 | 2411 | 281 | 5.168269 | 14.52283589 | Arxiozyma heterogenica | 278026 | Fungi | Fungi | 127 | 6.41e-36 | NR | XP_064713664.1 | 278026 | g2392 | i0 | 69 | 1.79359430604982 | 84 | 25 | 89.7 | 1 | 269 | 18 | 2 | 84 | XP_064713664.1 uncharacterized protein PWA37_002870 [Arxiozyma heterogenica] | diamond | 504 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Arxiozyma | Arxiozyma heterogenica | |
| 30704199 | 30704199 | PRJNA1192965_P_NODE_1614_length_324_cov_3.035857_g1595_i0 | PRJNA1192965 | 1614 | 324 | 3.035857 | 9.83617668 | Penicillium nalgiovense | 60175 | Fungi | Fungi | 63.9 | 7.73e-10 | NR | CAG8889586.1 | 60175 | g1595 | i0 | 43.4 | 5.25 | 99 | 48 | 85.2 | 4 | 304 | 29 | 19 | 116 | CAG8889586.1 unnamed protein product [Penicillium nalgiovense] | diamond | 1701 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium nalgiovense | |
| 30818086 | 30818086 | PRJNA1192965_P_NODE_4114_length_246_cov_1.566474_g4095_i0 | PRJNA1192965 | 4114 | 246 | 1.566474 | 3.85352604 | Fungi | 4751 | Fungi | Fungi | 54.3 | 3.3e-7 | NR | KAF1348163.1 | 147560 | g4095 | i0 | 64.9 | 9.90243902439024 | 37 | 13 | 45.1 | 0 | 134 | 244 | 25 | 61 | KAF1348163.1 Non-histone chromosomal protein 6 [Delphinella strobiligena] | diamond | 2436 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothioraceae | Delphinella | Delphinella strobiligena | |
| 31133765 | 31133765 | PRJNA1192965_P_NODE_2155_length_291_cov_4.197248_g2136_i0 | PRJNA1192965 | 2155 | 291 | 4.197248 | 12.21399168 | Saccharomycetes | 4891 | Fungi | Fungi | 91.3 | 5.8e-19 | NR | CAI7483938.1 | 4932 | g2136 | i0 | 47.2 | 13.2268041237113 | 89 | 46 | 91.8 | 1 | 269 | 3 | 562 | 649 | CAI7483938.1 BAD_collapsed_G0055650.mRNA.1.CDS.1 [Saccharomyces cerevisiae] | diamond | 3849 | 92 | 0.992391304347826 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 31196837 | 31196837 | PRJNA1192965_P_NODE_3855_length_248_cov_0.880000_g3836_i0 | PRJNA1192965 | 3855 | 248 | 0.88 | 2.1824 | Ascomycota | 4890 | Fungi | Fungi | 53.1 | 7.36e-6 | NR | KAI9695930.1 | 460848 | g3836 | i0 | 62.7 | 2.02016129032258 | 59 | 17 | 70.2 | 2 | 247 | 74 | 187 | 241 | KAI9695930.1 MAG: hypothetical protein M1812_008491, partial [Candelaria pacifica] | diamond | 501 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Candelariomycetes | Candelariales | Candelariaceae | Candelaria | Candelaria pacifica | |
| 31482178 | 31482178 | PRJNA1192965_P_NODE_2696_length_270_cov_1.563452_g2677_i0 | PRJNA1192965 | 2696 | 270 | 1.563452 | 4.2213204 | Helotiales | 5178 | Fungi | Fungi | 68.9 | 3.1e-11 | NR | KAK0110691.1 | 85999 | g2677 | i0 | 45.9 | 6.67777777777778 | 85 | 45 | 94.4 | 1 | 257 | 3 | 289 | 372 | KAK0110691.1 plasma membrane calcium [Cadophora gregata f. sp. sojae] | diamond | 1803 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Ploettnerulaceae | Cadophora | Cadophora gregata | |
| 31747405 | 31747405 | PRJNA1192965_P_NODE_3837_length_248_cov_0.880000_g3818_i0 | PRJNA1192965 | 3837 | 248 | 0.88 | 2.1824 | Beauveria bassiana | 176275 | Fungi | Fungi | 45.8 | 0.00317 | NR | KAF1733592.1 | 176275 | g3818 | i0 | 69 | 1.88709677419355 | 29 | 8 | 35.1 | 1 | 246 | 160 | 448 | 475 | KAF1733592.1 Histone-lysine N-methyltransferase setd3 [Beauveria bassiana] | diamond | 468 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Beauveria | Beauveria bassiana | |
| 31861292 | 31861292 | PRJNA1192965_P_NODE_1977_length_302_cov_1.344978_g1958_i0 | PRJNA1192965 | 1977 | 302 | 1.344978 | 4.06183356 | Opisthokonta | 33154 | Fungi | Fungi | 192 | 3.58e-58 | NR | XP_066782060.1 | 56871 | g1958 | i0 | 87 | 218.543046357616 | 100 | 13 | 99.3 | 0 | 1 | 300 | 109 | 208 | XP_066782060.1 Serine/threonine-protein phosphatase PP2A catalytic subunit [Lipomyces japonicus] | diamond | 66000 | 193 | 0.994818652849741 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces japonicus | |
| 31956233 | 31956233 | PRJNA1192965_P_NODE_1337_length_351_cov_1.136691_g1318_i0 | PRJNA1192965 | 1337 | 351 | 1.136691 | 3.98978541 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 0.00116 | NR | KAK0634862.1 | 252184 | g1318 | i0 | 36.2 | 4.03418803418803 | 94 | 53 | 76.1 | 4 | 80 | 346 | 51 | 142 | KAK0634862.1 P-loop containing nucleoside triphosphate hydrolase protein [Bombardia bombarda] | diamond | 1416 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Bombardia | Bombardia bombarda | |
| 32840831 | 32840831 | PRJNA1192965_P_NODE_4260_length_246_cov_0.890173_g4241_i0 | PRJNA1192965 | 4260 | 246 | 0.890173 | 2.18982558 | Fungi | 4751 | Fungi | Fungi | 69.7 | 1.14e-11 | NR | RKF78075.1 | 62708 | g4241 | i0 | 46.2 | 2.96341463414634 | 91 | 36 | 96.3 | 3 | 9 | 245 | 5 | 94 | RKF78075.1 Protein phosphatase 2C-like protein 3 [Golovinomyces cichoracearum] | diamond | 729 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Golovinomyces | Golovinomyces cichoracearum |
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);;