contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1074407" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6119490 | 6119490 | PRJNA1074407_P_NODE_136765_length_248_cov_0.868571_g132927_i0 | PRJNA1074407 | 136765 | 248 | 0.868571 | 2.15405608 | Ascomycota | 4890 | Fungi | Fungi | 132 | 8.16e-38 | NR | XP_069267630.1 | 5541 | g132927 | i0 | 86.5 | 11.7701612903226 | 74 | 10 | 89.5 | 0 | 22 | 243 | 45 | 118 | XP_069267630.1 60S ribosomal protein uL24 [Thermomyces lanuginosus] | diamond | 2919 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Thermomyces | Thermomyces lanuginosus | |
| 9116359 | 9116359 | PRJNA1074407_P_NODE_137148_length_248_cov_0.868571_g133310_i0 | PRJNA1074407 | 137148 | 248 | 0.868571 | 2.15405608 | Erysiphe pulchra | 225359 | Fungi | Fungi | 164 | 5.899999999999999e-48 | NR | POS81747.1 | 225359 | g133310 | i0 | 92.7 | 1.98387096774194 | 82 | 6 | 99.2 | 0 | 247 | 2 | 165 | 246 | POS81747.1 hypothetical protein EPUL_005907, partial [Erysiphe pulchra] | diamond | 492 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe pulchra | |
| 12942496 | 12942496 | PRJNA1074407_P_NODE_139391_length_246_cov_0.878613_g135553_i0 | PRJNA1074407 | 139391 | 246 | 0.878613 | 2.16138798 | Verruconis gallopava | 253628 | Fungi | Fungi | 117 | 1.1000000000000002e-28 | NR | XP_016211033.1 | 253628 | g135553 | i0 | 70.4 | 0.98780487804878 | 81 | 23 | 98.8 | 1 | 244 | 2 | 373 | 452 | XP_016211033.1 uncharacterized protein PV09_07449 [Verruconis gallopava] | diamond | 243 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Sympoventuriaceae | Verruconis | Verruconis gallopava | |
| 12942521 | 12942521 | PRJNA1074407_P_NODE_140711_length_245_cov_0.883721_g136873_i0 | PRJNA1074407 | 140711 | 245 | 0.883721 | 2.16511645 | Aureobasidium | 5579 | Fungi | Fungi | 159 | 3.77e-43 | NR | KAG2164553.1 | 5580 | g136873 | i0 | 88.9 | 15.869387755102 | 81 | 9 | 99.2 | 0 | 245 | 3 | 634 | 714 | KAG2164553.1 hypothetical protein JADG_004292 [Aureobasidium pullulans] | diamond | 3888 | 160 | 0.99375 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 18867934 | 18867934 | PRJNA1074407_P_NODE_139435_length_246_cov_0.878613_g135597_i0 | PRJNA1074407 | 139435 | 246 | 0.878613 | 2.16138798 | Stemphylium lycopersici | 183478 | Fungi | Fungi | 154 | 1.73e-45 | NR | KNG48362.1 | 183478 | g135597 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 245 | 3 | 42 | 122 | KNG48362.1 gpi anchored protein [Stemphylium lycopersici] | diamond | 243 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Stemphylium | Stemphylium lycopersici | |
| 20142738 | 20142738 | PRJNA1074407_P_NODE_142696_length_243_cov_0.894118_g138858_i0 | PRJNA1074407 | 142696 | 243 | 0.894118 | 2.17270674 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 107 | 6.6999999999999985e-25 | NR | XP_033667981.1 | 1080233 | g138858 | i0 | 68.9 | 0.91358024691358 | 74 | 18 | 91.4 | 2 | 222 | 1 | 402 | 470 | XP_033667981.1 uncharacterized protein M409DRAFT_54298 [Zasmidium cellare ATCC 36951] | diamond | 222 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 20589305 | 20589305 | PRJNA1074407_P_NODE_114637_length_302_cov_1.165939_g110799_i0 | PRJNA1074407 | 114637 | 302 | 1.165939 | 3.52113578 | Zasmidium cellare | 395010 | Fungi | Fungi | 151 | 2.02e-43 | NR | KAK4495549.1 | 395010 | g110799 | i0 | 91.6 | 0.824503311258278 | 83 | 7 | 82.5 | 0 | 54 | 302 | 1 | 83 | KAK4495549.1 hypothetical protein PRZ48_013881 [Zasmidium cellare] | diamond | 249 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 26647198 | 26647198 | PRJNA1074407_P_NODE_129721_length_262_cov_1.206349_g125883_i0 | PRJNA1074407 | 129721 | 262 | 1.206349 | 3.16063438 | Zasmidium | 395590 | Fungi | Fungi | 116 | 4.75e-28 | NR | KAK4504116.1 | 395010 | g125883 | i0 | 83.1 | 1.48854961832061 | 65 | 11 | 74.4 | 0 | 196 | 2 | 1 | 65 | KAK4504116.1 hypothetical protein PRZ48_005031 [Zasmidium cellare] | diamond | 390 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 27383582 | 27383582 | PRJNA1074407_P_NODE_146363_length_240_cov_0.910180_g142525_i0 | PRJNA1074407 | 146363 | 240 | 0.91018 | 2.184432 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 76.3 | 4.96e-14 | NR | XP_023632321.1 | 112498 | g142525 | i0 | 75 | 0.65 | 52 | 13 | 65 | 0 | 29 | 184 | 1 | 52 | XP_023632321.1 uncharacterized protein RCC_11332 [Ramularia collo-cygni] | diamond | 156 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 28227232 | 28227232 | PRJNA1074407_P_NODE_133966_length_251_cov_1.724719_g130128_i0 | PRJNA1074407 | 133966 | 251 | 1.724719 | 4.32904469 | Fungi | 4751 | Fungi | Fungi | 84.3 | 9.41e-17 | NR | KAK3678457.1 | 574656 | g130128 | i0 | 44.6 | 6.9203187250996 | 83 | 46 | 99.2 | 0 | 250 | 2 | 440 | 522 | KAK3678457.1 Coatomer subunit beta' [Recurvomyces mirabilis] | diamond | 1737 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 28772671 | 28772671 | PRJNA1074407_P_NODE_136527_length_248_cov_0.868571_g132689_i0 | PRJNA1074407 | 136527 | 248 | 0.868571 | 2.15405608 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 129 | 2.66e-34 | NR | XP_033670248.1 | 1080233 | g132689 | i0 | 69.5 | 0.991935483870968 | 82 | 25 | 99.2 | 0 | 247 | 2 | 179 | 260 | XP_033670248.1 uncharacterized protein M409DRAFT_52608 [Zasmidium cellare ATCC 36951] | diamond | 246 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 29088573 | 29088573 | PRJNA1074407_P_NODE_142588_length_243_cov_0.894118_g138750_i0 | PRJNA1074407 | 142588 | 243 | 0.894118 | 2.17270674 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 127 | 3.7199999999999997e-32 | NR | XP_033673219.1 | 1080233 | g138750 | i0 | 90.1 | 1 | 81 | 8 | 100 | 0 | 1 | 243 | 490 | 570 | XP_033673219.1 uncharacterized protein M409DRAFT_17566 [Zasmidium cellare ATCC 36951] | diamond | 243 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 29530589 | 29530589 | PRJNA1074407_P_NODE_116530_length_297_cov_1.000000_g112692_i0 | PRJNA1074407 | 116530 | 297 | 1 | 2.97 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 169 | 1.0799999999999999e-47 | NR | XP_033673458.1 | 1080233 | g112692 | i0 | 81.6 | 0.98989898989899 | 98 | 18 | 99 | 0 | 3 | 296 | 246 | 343 | XP_033673458.1 uncharacterized protein M409DRAFT_50243 [Zasmidium cellare ATCC 36951] | diamond | 294 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 29909612 | 29909612 | PRJNA1074407_P_NODE_144671_length_241_cov_1.095238_g140833_i0 | PRJNA1074407 | 144671 | 241 | 1.095238 | 2.63952358 | Trichomonascus ciferrii | 44093 | Fungi | Fungi | 43.5 | 0.019 | NR | KAA8917773.1 | 44093 | g140833 | i0 | 36.7 | 0.746887966804979 | 60 | 38 | 74.7 | 0 | 185 | 6 | 563 | 622 | KAA8917773.1 hypothetical protein TRICI_000081 [Trichomonascus ciferrii] | diamond | 180 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Trichomonascus | Trichomonascus ciferrii | |
| 30067349 | 30067349 | PRJNA1074407_P_NODE_143612_length_242_cov_0.899408_g139774_i0 | PRJNA1074407 | 143612 | 242 | 0.899408 | 2.17656736 | Zygotorulaspora mrakii | 42260 | Fungi | Fungi | 43.5 | 0.0201 | NR | XP_037146595.1 | 42260 | g139774 | i0 | 40 | 0.681818181818182 | 55 | 28 | 64.5 | 2 | 184 | 29 | 416 | 468 | XP_037146595.1 mRNA-binding protein RRP12 [Zygotorulaspora mrakii] | diamond | 165 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Zygotorulaspora | Zygotorulaspora mrakii | |
| 30098898 | 30098898 | PRJNA1074407_P_NODE_95152_length_366_cov_1.037543_g91315_i0 | PRJNA1074407 | 95152 | 366 | 1.037543 | 3.79740738 | Zasmidium cellare | 395010 | Fungi | Fungi | 142 | 4.1199999999999997e-38 | NR | KAK4496751.1 | 395010 | g91315 | i0 | 96.1 | 0.622950819672131 | 76 | 3 | 62.3 | 0 | 364 | 137 | 331 | 406 | KAK4496751.1 hypothetical protein PRZ48_012734 [Zasmidium cellare] | diamond | 228 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 30920689 | 30920689 | PRJNA1074407_P_NODE_143334_length_242_cov_1.349112_g139496_i0 | PRJNA1074407 | 143334 | 242 | 1.349112 | 3.26485104 | Friedmanniomyces endolithicus | 329885 | Fungi | Fungi | 43.9 | 0.014 | NR | TKA42203.1 | 329885 | g139496 | i0 | 41 | 2.26859504132231 | 61 | 34 | 73.1 | 2 | 191 | 15 | 225 | 285 | TKA42203.1 hypothetical protein B0A54_07291 [Friedmanniomyces endolithicus] | diamond | 549 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus | |
| 31047202 | 31047202 | PRJNA1074407_P_NODE_93895_length_371_cov_0.889262_g90058_i0 | PRJNA1074407 | 93895 | 371 | 0.889262 | 3.29916202 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 112 | 1.49e-26 | NR | XP_033674198.1 | 1080233 | g90058 | i0 | 79.5 | 1.34231805929919 | 83 | 16 | 66.3 | 1 | 247 | 2 | 1 | 83 | XP_033674198.1 uncharacterized protein M409DRAFT_49770 [Zasmidium cellare ATCC 36951] | diamond | 498 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 32090583 | 32090583 | PRJNA1074407_P_NODE_146358_length_240_cov_0.910180_g142520_i0 | PRJNA1074407 | 146358 | 240 | 0.91018 | 2.184432 | Tothia fuscella | 1048955 | Fungi | Fungi | 90.9 | 1.34e-19 | NR | KAF2434755.1 | 1048955 | g142520 | i0 | 55.7 | 0.9875 | 79 | 26 | 98.8 | 1 | 3 | 239 | 38 | 107 | KAF2434755.1 endo-beta-1,4-glucanase [Tothia fuscella] | diamond | 237 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Cylindrosympodiaceae | Tothia | Tothia fuscella | |
| 32185579 | 32185579 | PRJNA1074407_P_NODE_139178_length_246_cov_0.878613_g135340_i0 | PRJNA1074407 | 139178 | 246 | 0.878613 | 2.16138798 | Watsoniomyces obsoletus | 2796175 | Fungi | Fungi | 88.6 | 2.87e-18 | NR | KAI9882290.1 | 2796175 | g135340 | i0 | 75.8 | 0.804878048780488 | 66 | 14 | 78 | 1 | 244 | 53 | 1360 | 1425 | KAI9882290.1 MAG: putative cell survival pathways protein [Watsoniomyces obsoletus] | diamond | 198 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lichinomycetes | Lichinales | Porocyphaceae | Watsoniomyces | Watsoniomyces obsoletus | |
| 32848518 | 32848518 | PRJNA1074407_P_NODE_145320_length_241_cov_0.904762_g141482_i0 | PRJNA1074407 | 145320 | 241 | 0.904762 | 2.18047642 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 75.9 | 7.64e-14 | NR | XP_033675045.1 | 1080233 | g141482 | i0 | 89.7 | 0.721991701244813 | 58 | 6 | 72.2 | 0 | 176 | 3 | 238 | 295 | XP_033675045.1 uncharacterized protein M409DRAFT_49023 [Zasmidium cellare ATCC 36951] | diamond | 174 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare |
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);;