contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA833575" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13577636 | 13577636 | PRJNA833575_P_NODE_15371_length_373_cov_2.536184_g15234_i0 | PRJNA833575 | 15371 | 373 | 2.536184 | 9.45996632 | Colletotrichum | 5455 | Fungi | Fungi | 91.3 | 3.34e-20 | NR | XP_049131659.1 | 700344 | g15234 | i0 | 43.1 | 9.69973190348525 | 109 | 53 | 87.7 | 1 | 15 | 341 | 2 | 101 | XP_049131659.1 protein yop-1 [Colletotrichum spaethianum] | diamond | 3618 | 91.7 | 0.995637949836423 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum spaethianum | |
| 15256856 | 15256856 | PRJNA833575_P_NODE_22272_length_314_cov_1.693878_g22135_i0 | PRJNA833575 | 22272 | 314 | 1.693878 | 5.31877692 | Lipomyces starkeyi | 29829 | Fungi | Fungi | 160 | 3.93e-45 | NR | KAK9315451.1 | 29829 | g22135 | i0 | 70.2 | 2.88535031847134 | 104 | 31 | 99.4 | 0 | 314 | 3 | 178 | 281 | KAK9315451.1 pyridoxal phosphate-dependent transferase [Lipomyces starkeyi] | diamond | 906 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces starkeyi | |
| 18675530 | 18675530 | PRJNA833575_P_NODE_21935_length_316_cov_2.109312_g21798_i0 | PRJNA833575 | 21935 | 316 | 2.109312 | 6.66542592 | Ascomycota | 4890 | Fungi | Fungi | 147 | 1.0499999999999999e-42 | NR | KAK1829162.1 | 261694 | g21798 | i0 | 70.5 | 19.2341772151899 | 95 | 28 | 90.2 | 0 | 285 | 1 | 6 | 100 | KAK1829162.1 translation protein SH3-like domain-containing protein [Podospora conica] | diamond | 6078 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Podospora | Podospora conica | |
| 19950783 | 19950783 | PRJNA833575_P_NODE_30316_length_270_cov_1.218905_g30179_i0 | PRJNA833575 | 30316 | 270 | 1.218905 | 3.2910435 | Tortispora caseinolytica NRRL Y-17796 | 767744 | Fungi | Fungi | 136 | 1.06e-38 | NR | ODV89225.1 | 767744 | g30179 | i0 | 72.2 | 3 | 90 | 25 | 100 | 0 | 270 | 1 | 1 | 90 | ODV89225.1 hypothetical protein CANCADRAFT_58210 [Tortispora caseinolytica NRRL Y-17796] | diamond | 810 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Trigonopsidomycetes | Trigonopsidales | Trigonopsidaceae | Tortispora | Tortispora caseinolytica | |
| 25050921 | 25050921 | PRJNA833575_P_NODE_9320_length_468_cov_5.220551_g9183_i0 | PRJNA833575 | 9320 | 468 | 5.220551 | 24.43217868 | Fusarium coffeatum | 231269 | Fungi | Fungi | 152 | 4.13e-44 | NR | XP_031013529.1 | 231269 | g9183 | i0 | 47.4 | 3.50641025641026 | 137 | 72 | 87.8 | 0 | 458 | 48 | 1 | 137 | XP_031013529.1 uncharacterized protein FIESC28_08236 [Fusarium coffeatum] | diamond | 1641 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium coffeatum | |
| 26801351 | 26801351 | PRJNA833575_P_NODE_38741_length_235_cov_0.867470_g38604_i0 | PRJNA833575 | 38741 | 235 | 0.86747 | 2.0385545 | Dactylella cylindrospora | 1814901 | Fungi | Fungi | 99 | 9.72e-25 | NR | KAF3932690.1 | 1814901 | g38604 | i0 | 67.6 | 3.72765957446809 | 74 | 24 | 94.5 | 0 | 235 | 14 | 33 | 106 | KAF3932690.1 hypothetical protein ABW19_dt0202971 [Dactylella cylindrospora] | diamond | 876 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Dactylella | Dactylella cylindrospora | |
| 27054707 | 27054707 | PRJNA833575_P_NODE_18502_length_342_cov_1.428571_g18365_i0 | PRJNA833575 | 18502 | 342 | 1.428571 | 4.88571282 | Aspergillus oryzae | 5062 | Fungi | Fungi | 43.5 | 0.0387 | NR | GMG32746.1 | 5062 | g18365 | i0 | 44.2 | 0.456140350877193 | 52 | 26 | 44.7 | 2 | 178 | 330 | 63 | 112 | GMG32746.1 unnamed protein product [Aspergillus oryzae] | diamond | 156 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus oryzae | |
| 27054711 | 27054711 | PRJNA833575_P_NODE_37662_length_237_cov_1.452381_g37525_i0 | PRJNA833575 | 37662 | 237 | 1.452381 | 3.44214297 | Aspergillus versicolor CBS 583.65 | 1036611 | Fungi | Fungi | 52.8 | 9.8e-6 | NR | XP_040672371.1 | 1036611 | g37525 | i0 | 42.6 | 0.594936708860759 | 47 | 27 | 59.5 | 0 | 151 | 11 | 71 | 117 | XP_040672371.1 uncharacterized protein ASPVEDRAFT_45960 [Aspergillus versicolor CBS 583.65] | diamond | 141 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus versicolor | |
| 27275955 | 27275955 | PRJNA833575_P_NODE_28803_length_277_cov_1.447115_g28666_i0 | PRJNA833575 | 28803 | 277 | 1.447115 | 4.00850855 | Drechslerella dactyloides | 74499 | Fungi | Fungi | 105 | 1.17e-24 | NR | KAJ6260072.1 | 74499 | g28666 | i0 | 58.4 | 2.90252707581227 | 89 | 29 | 96.4 | 1 | 275 | 9 | 56 | 136 | KAJ6260072.1 hypothetical protein Dda_5718 [Drechslerella dactyloides] | diamond | 804 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Drechslerella | Drechslerella dactyloides | |
| 27591928 | 27591928 | PRJNA833575_P_NODE_42304_length_231_cov_0.888889_g42167_i0 | PRJNA833575 | 42304 | 231 | 0.888889 | 2.05333359 | Aspergillus bertholletiae | 1226010 | Fungi | Fungi | 51.6 | 2.29e-5 | NR | KAE8380684.1 | 1226010 | g42167 | i0 | 42.4 | 0.766233766233766 | 59 | 31 | 76.6 | 1 | 211 | 35 | 140 | 195 | KAE8380684.1 hypothetical protein BDV26DRAFT_256807 [Aspergillus bertholletiae] | diamond | 177 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus bertholletiae | |
| 27852752 | 27852752 | PRJNA833575_P_NODE_17564_length_351_cov_1.007092_g17427_i0 | PRJNA833575 | 17564 | 351 | 1.007092 | 3.53489292 | Fungi | 4751 | Fungi | Fungi | 176 | 5.259999999999998e-54 | NR | KAH7038510.1 | 35725 | g17427 | i0 | 77.5 | 18.0598290598291 | 111 | 25 | 94.9 | 0 | 334 | 2 | 1 | 111 | KAH7038510.1 translation initiation factor eIF-1A [Macrophomina phaseolina] | diamond | 6339 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Botryosphaeriaceae | Macrophomina | Macrophomina phaseolina | |
| 28105302 | 28105302 | PRJNA833575_P_NODE_35905_length_245_cov_1.369318_g35768_i0 | PRJNA833575 | 35905 | 245 | 1.369318 | 3.3548291 | Ascomycota | 4890 | Fungi | Fungi | 99.4 | 1.02e-24 | NR | KAK9317658.1 | 29829 | g35768 | i0 | 64.1 | 3.62448979591837 | 78 | 28 | 95.5 | 0 | 2 | 235 | 31 | 108 | KAK9317658.1 ribosomal protein L34e-domain-containing protein [Lipomyces starkeyi] | diamond | 888 | 99.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces starkeyi | |
| 28642353 | 28642353 | PRJNA833575_P_NODE_7667_length_515_cov_3.062780_g7530_i0 | PRJNA833575 | 7667 | 515 | 3.06278 | 15.773317 | Lachnellula | 47830 | Fungi | Fungi | 122 | 3.1000000000000003e-30 | NR | TVY50122.1 | 215460 | g7530 | i0 | 46.9 | 5.03300970873786 | 179 | 73 | 93.2 | 5 | 490 | 11 | 1 | 176 | TVY50122.1 Elongation factor 1-beta [Lachnellula occidentalis] | diamond | 2592 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Lachnaceae | Lachnellula | Lachnellula occidentalis | |
| 28728416 | 28728416 | PRJNA833575_P_NODE_26247_length_291_cov_0.954955_g26110_i0 | PRJNA833575 | 26247 | 291 | 0.954955 | 2.77891905 | Terfezia claveryi | 139407 | Fungi | Fungi | 43.5 | 0.0363 | NR | KAF8448407.1 | 139407 | g26110 | i0 | 37.7 | 0.711340206185567 | 69 | 40 | 71.1 | 2 | 242 | 36 | 1185 | 1250 | KAF8448407.1 hypothetical protein BGX38DRAFT_1270204 [Terfezia claveryi] | diamond | 207 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pezizaceae | Terfezia | Terfezia claveryi | |
| 29021420 | 29021420 | PRJNA833575_P_NODE_32048_length_262_cov_1.492228_g31911_i0 | PRJNA833575 | 32048 | 262 | 1.492228 | 3.90963736 | Ophiocordycipitaceae | 474942 | Fungi | Fungi | 103 | 1.03e-24 | NR | PWI64479.1 | 33203 | g31911 | i0 | 58.2 | 1.80916030534351 | 79 | 33 | 90.5 | 0 | 18 | 254 | 1 | 79 | PWI64479.1 hypothetical protein PCL_09634 [Purpureocillium lilacinum] | diamond | 474 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 29336855 | 29336855 | PRJNA833575_P_NODE_11589_length_424_cov_2.664789_g11452_i0 | PRJNA833575 | 11589 | 424 | 2.664789 | 11.29870536 | Dothideomycetes | 147541 | Fungi | Fungi | 89.4 | 2.45e-19 | NR | KAF2405019.1 | 703511 | g11452 | i0 | 45.3 | 5.38443396226415 | 128 | 59 | 90.6 | 3 | 422 | 39 | 48 | 164 | KAF2405019.1 hypothetical protein EJ06DRAFT_518084 [Trichodelitschia bisporula] | diamond | 2283 | 90.1 | 0.992230854605993 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Phaeotrichales | Phaeotrichaceae | Trichodelitschia | Trichodelitschia bisporula | |
| 29422782 | 29422782 | PRJNA833575_P_NODE_25929_length_292_cov_1.614350_g25792_i0 | PRJNA833575 | 25929 | 292 | 1.61435 | 4.713902 | Naumovozyma dairenensis CBS 421 | 1071378 | Fungi | Fungi | 130 | 1.6399999999999998e-35 | NR | XP_003669082.1 | 1071378 | g25792 | i0 | 60.6 | 5.82534246575342 | 94 | 36 | 96.6 | 1 | 4 | 285 | 30 | 122 | XP_003669082.1 uncharacterized protein NDAI_0C01780 [Naumovozyma dairenensis CBS 421] | diamond | 1701 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Naumovozyma | Naumovozyma dairenensis | |
| 30252923 | 30252923 | PRJNA833575_P_NODE_18412_length_343_cov_1.051095_g18275_i0 | PRJNA833575 | 18412 | 343 | 1.051095 | 3.60525585 | Ascomycota | 4890 | Fungi | Fungi | 105 | 9.66e-27 | NR | XP_066776298.1 | 45792 | g18275 | i0 | 51.4 | 1.81049562682216 | 105 | 49 | 91 | 2 | 10 | 321 | 20 | 123 | XP_066776298.1 acyl carrier protein-like protein [Lipomyces oligophaga] | diamond | 621 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces oligophaga | |
| 31421968 | 31421968 | PRJNA833575_P_NODE_9116_length_473_cov_3.975248_g8979_i0 | PRJNA833575 | 9116 | 473 | 3.975248 | 18.80292304 | Schizosaccharomycetes | 147554 | Fungi | Fungi | 132 | 4.17e-36 | NR | NP_594328.1 | 4896 | g8979 | i0 | 50.3 | 6.60253699788584 | 147 | 70 | 91.3 | 1 | 435 | 4 | 1 | 147 | NP_594328.1 translationally-controlled tumor protein [Schizosaccharomyces pombe] | diamond | 3123 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 31634759 | 31634759 | PRJNA833575_P_NODE_5016_length_628_cov_1.542039_g4882_i0 | PRJNA833575 | 5016 | 628 | 1.542039 | 9.68400492 | Kluyveromyces lactis | 28985 | Fungi | Fungi | 144 | 6.26e-40 | NR | QEU61064.1 | 28985 | g4882 | i0 | 50.3 | 1.4522292993630601 | 147 | 69 | 68.8 | 3 | 591 | 160 | 1 | 146 | QEU61064.1 Rps31 [Kluyveromyces lactis] | diamond | 912 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kluyveromyces | Kluyveromyces lactis | |
| 31761339 | 31761339 | PRJNA833575_P_NODE_13677_length_394_cov_1.129231_g13540_i0 | PRJNA833575 | 13677 | 394 | 1.129231 | 4.44917014 | Zymoseptoria tritici ST99CH_3D7 | 1276538 | Fungi | Fungi | 43.5 | 0.029 | NR | SMQ56147.1 | 1276538 | g13540 | i0 | 30.8 | 1.56091370558376 | 104 | 49 | 68.5 | 5 | 340 | 71 | 10 | 104 | SMQ56147.1 unnamed protein product [Zymoseptoria tritici ST99CH_3D7] | diamond | 615 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zymoseptoria | Zymoseptoria tritici |
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);;