contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1103784" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6590227 | 6590227 | PRJNA1103784_P_NODE_5226_length_258_cov_1.594595_g5171_i0 | PRJNA1103784 | 5226 | 258 | 1.594595 | 4.1140551 | Hypocreales | 5125 | Fungi | Fungi | 130 | 1.98e-34 | NR | XP_018145649.1 | 1380566 | g5171 | i0 | 80.2 | 4.95348837209302 | 86 | 16 | 98.8 | 1 | 4 | 258 | 258 | 343 | XP_018145649.1 Sas10/Utp3/C1D-like protein [Pochonia chlamydosporia 170] | diamond | 1278 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Pochonia | Pochonia chlamydosporia | |
| 10415607 | 10415607 | PRJNA1103784_P_NODE_7769_length_241_cov_0.916667_g7714_i0 | PRJNA1103784 | 7769 | 241 | 0.916667 | 2.20916747 | Fungi | 4751 | Fungi | Fungi | 135 | 9.48e-36 | NR | XP_066789786.1 | 44089 | g7714 | i0 | 74.7 | 14.7136929460581 | 79 | 20 | 98.3 | 0 | 237 | 1 | 208 | 286 | XP_066789786.1 pyridoxal phosphate-dependent transferase [Dipodascopsis tothii] | diamond | 3546 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Dipodascopsis | Dipodascopsis tothii | |
| 14240971 | 14240971 | PRJNA1103784_P_NODE_7012_length_244_cov_2.514620_g6957_i0 | PRJNA1103784 | 7012 | 244 | 2.51462 | 6.1356728 | Magnusiomyces paraingens | 2606893 | Fungi | Fungi | 141 | 1.5699999999999999e-40 | NR | XP_031851618.1 | 2606893 | g6957 | i0 | 80.2 | 3.98360655737705 | 81 | 15 | 98.4 | 1 | 243 | 4 | 108 | 188 | XP_031851618.1 uncharacterized protein SAPINGB_P001004 [Magnusiomyces paraingens] | diamond | 972 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Magnusiomyces | Magnusiomyces paraingens | |
| 15514765 | 15514765 | PRJNA1103784_P_NODE_3673_length_290_cov_1.253456_g3618_i0 | PRJNA1103784 | 3673 | 290 | 1.253456 | 3.6350224 | Septoria linicola | 215465 | Fungi | Fungi | 152 | 5.269999999999999e-42 | NR | USW57563.1 | 215465 | g3618 | i0 | 76.3 | 2.88620689655172 | 93 | 22 | 96.2 | 0 | 280 | 2 | 36 | 128 | USW57563.1 Putative major facilitator superfamily, MFS transporter superfamily [Septoria linicola] | diamond | 837 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Septoria | Septoria linicola | |
| 16322671 | 16322671 | PRJNA1103784_P_NODE_3973_length_283_cov_1.404762_g3918_i0 | PRJNA1103784 | 3973 | 283 | 1.404762 | 3.97547646 | Thelonectria olida | 1576542 | Fungi | Fungi | 65.1 | 7.8e-10 | NR | KAH6898524.1 | 1576542 | g3918 | i0 | 54.2 | 0.879858657243816 | 83 | 25 | 74.2 | 3 | 278 | 69 | 377 | 459 | KAH6898524.1 hypothetical protein B0T10DRAFT_578321 [Thelonectria olida] | diamond | 249 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Thelonectria | Thelonectria olida | |
| 19337899 | 19337899 | PRJNA1103784_P_NODE_2556_length_337_cov_1.662879_g2501_i0 | PRJNA1103784 | 2556 | 337 | 1.662879 | 5.60390223 | Trichophyton interdigitale H6 | 1215336 | Fungi | Fungi | 159 | 3.38e-45 | NR | EZF29569.1 | 1215336 | g2501 | i0 | 75 | 16.406528189911 | 92 | 23 | 81.9 | 0 | 336 | 61 | 238 | 329 | EZF29569.1 phenylalanine-tRNA ligase, alpha subunit [Trichophyton interdigitale H6] | diamond | 5529 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton interdigitale | |
| 27121884 | 27121884 | PRJNA1103784_P_NODE_5442_length_254_cov_1.530387_g5387_i0 | PRJNA1103784 | 5442 | 254 | 1.530387 | 3.88718298 | Fungi | 4751 | Fungi | Fungi | 64.3 | 1.1e-9 | NR | TQB75469.1 | 5098 | g5387 | i0 | 47.3 | 6.81496062992126 | 74 | 37 | 85 | 1 | 252 | 37 | 235 | 308 | TQB75469.1 Transcriptional regulatory protein sin3 [Monascus purpureus] | diamond | 1731 | 64.7 | 0.993817619783617 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Monascus | Monascus purpureus | |
| 27447166 | 27447166 | PRJNA1103784_P_NODE_2283_length_353_cov_1.853571_g2228_i0 | PRJNA1103784 | 2283 | 353 | 1.853571 | 6.54310563 | Penicillium oxalicum 114-2 | 933388 | Fungi | Fungi | 48.5 | 4.16e-4 | NR | EPS26071.1 | 933388 | g2228 | i0 | 32.2 | 1.0028328611898 | 118 | 79 | 99.4 | 1 | 1 | 351 | 19 | 136 | EPS26071.1 hypothetical protein PDE_01007 [Penicillium oxalicum 114-2] | diamond | 354 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium oxalicum | |
| 28615239 | 28615239 | PRJNA1103784_P_NODE_6727_length_246_cov_0.890173_g6672_i0 | PRJNA1103784 | 6727 | 246 | 0.890173 | 2.18982558 | Fusarium austroafricanum | 2364996 | Fungi | Fungi | 124 | 3.56e-34 | NR | KAF4453252.1 | 2364996 | g6672 | i0 | 88 | 1.01219512195122 | 83 | 9 | 100 | 1 | 1 | 246 | 47 | 129 | KAF4453252.1 hypothetical protein F53441_4059, partial [Fusarium austroafricanum] | diamond | 249 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium austroafricanum | |
| 28795694 | 28795694 | PRJNA1103784_P_NODE_6287_length_248_cov_0.880000_g6232_i0 | PRJNA1103784 | 6287 | 248 | 0.88 | 2.1824 | Fungi | 4751 | Fungi | Fungi | 114 | 5.89e-29 | NR | OWB67705.1 | 5477 | g6232 | i0 | 67.9 | 11.758064516129 | 81 | 26 | 98 | 0 | 246 | 4 | 146 | 226 | OWB67705.1 hypothetical protein B5S30_g3068 [[Candida] boidinii] | diamond | 2916 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | [Candida] boidinii | |
| 29025939 | 29025939 | PRJNA1103784_P_NODE_6428_length_247_cov_1.218391_g6373_i0 | PRJNA1103784 | 6428 | 247 | 1.218391 | 3.00942577 | Aspergillus heteromorphus CBS 117.55 | 1448321 | Fungi | Fungi | 117 | 2.16e-28 | NR | XP_025402092.1 | 1448321 | g6373 | i0 | 65.9 | 5.82995951417004 | 82 | 26 | 99.6 | 1 | 246 | 1 | 568 | 647 | XP_025402092.1 40S ribosomal RACK1 domain-containing protein [Aspergillus heteromorphus CBS 117.55] | diamond | 1440 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus heteromorphus | |
| 29332689 | 29332689 | PRJNA1103784_P_NODE_6589_length_247_cov_0.816092_g6534_i0 | PRJNA1103784 | 6589 | 247 | 0.816092 | 2.01574724 | Saccotheciaceae | 1570301 | Fungi | Fungi | 53.1 | 7.32e-7 | NR | KAG9817087.1 | 46634 | g6534 | i0 | 72.7 | 1.88259109311741 | 33 | 9 | 40.1 | 0 | 3 | 101 | 35 | 67 | KAG9817087.1 hypothetical protein KCU68_g18613, partial [Aureobasidium melanogenum] | diamond | 465 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 29499146 | 29499146 | PRJNA1103784_P_NODE_6570_length_247_cov_0.885057_g6515_i0 | PRJNA1103784 | 6570 | 247 | 0.885057 | 2.18609079 | Fusarium decemcellulare | 57161 | Fungi | Fungi | 52 | 2.2e-5 | NR | KAJ3530490.1 | 57161 | g6515 | i0 | 47.6 | 1.9919028340081 | 82 | 40 | 96 | 3 | 11 | 247 | 787 | 868 | KAJ3530490.1 hypothetical protein NM208_g9307 [Fusarium decemcellulare] | diamond | 492 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium decemcellulare | |
| 29711178 | 29711178 | PRJNA1103784_P_NODE_7870_length_241_cov_0.916667_g7815_i0 | PRJNA1103784 | 7870 | 241 | 0.916667 | 2.20916747 | Nectriaceae | 110618 | Fungi | Fungi | 102 | 1.6000000000000002e-23 | NR | KAH6964270.1 | 40199 | g7815 | i0 | 81.3 | 8.68879668049792 | 64 | 12 | 79.7 | 0 | 192 | 1 | 64 | 127 | KAH6964270.1 hypothetical protein DER45DRAFT_535475 [Fusarium avenaceum] | diamond | 2094 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium avenaceum | |
| 29878280 | 29878280 | PRJNA1103784_P_NODE_6471_length_247_cov_0.885057_g6416_i0 | PRJNA1103784 | 6471 | 247 | 0.885057 | 2.18609079 | Neonectria magnoliae | 2732573 | Fungi | Fungi | 129 | 1.84e-34 | NR | KAK7425022.1 | 2732573 | g6416 | i0 | 90.8 | 3.582995951417 | 76 | 7 | 92.3 | 0 | 230 | 3 | 183 | 258 | KAK7425022.1 hypothetical protein QQZ08_008418 [Neonectria magnoliae] | diamond | 885 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Neonectria | Neonectria magnoliae | |
| 31892260 | 31892260 | PRJNA1103784_P_NODE_1997_length_372_cov_1.006689_g1942_i0 | PRJNA1103784 | 1997 | 372 | 1.006689 | 3.74488308 | Fusarium | 5506 | Fungi | Fungi | 235 | 2.6000000000000007e-71 | NR | CAF3483075.1 | 5518 | g1942 | i0 | 90.3 | 4 | 124 | 12 | 100 | 0 | 372 | 1 | 258 | 381 | CAF3483075.1 unnamed protein product, partial [Fusarium graminearum] | diamond | 1488 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium graminearum | |
| 31987068 | 31987068 | PRJNA1103784_P_NODE_5998_length_249_cov_1.511364_g5943_i0 | PRJNA1103784 | 5998 | 249 | 1.511364 | 3.76329636 | Fungi | 4751 | Fungi | Fungi | 102 | 9.66e-26 | NR | NP_593900.1 | 4896 | g5943 | i0 | 72.7 | 16.6987951807229 | 66 | 18 | 79.5 | 0 | 247 | 50 | 86 | 151 | NP_593900.1 40S ribosomal protein uS15 [Schizosaccharomyces pombe] | diamond | 4158 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 32534004 | 32534004 | PRJNA1103784_P_NODE_6759_length_246_cov_0.890173_g6704_i0 | PRJNA1103784 | 6759 | 246 | 0.890173 | 2.18982558 | Alternaria atra | 119953 | Fungi | Fungi | 120 | 6.15e-32 | NR | XP_043168564.1 | 119953 | g6704 | i0 | 85.4 | 1 | 82 | 11 | 98.8 | 1 | 245 | 3 | 15 | 96 | XP_043168564.1 uncharacterized protein ALTATR162_LOCUS5013 [Alternaria atra] | diamond | 246 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria atra |
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);;