contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26668216 | 26668216 | PRJNA603943_P_NODE_67921_length_242_cov_0.911243_g67729_i0 | PRJNA603943 | 67921 | 242 | 0.911243 | 2.20520806 | Thielaviopsis punctulata | 72032 | Fungi | Fungi | 129 | 3.27e-36 | NR | KKA29692.1 | 72032 | g67729 | i0 | 77.5 | 0.991735537190083 | 80 | 18 | 99.2 | 0 | 3 | 242 | 23 | 102 | KKA29692.1 hypothetical protein TD95_001359 [Thielaviopsis punctulata] | diamond | 240 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Ceratocystidaceae | Thielaviopsis | Thielaviopsis punctulata | |
| 26998146 | 26998146 | PRJNA603943_P_NODE_56602_length_249_cov_0.875000_g56410_i0 | PRJNA603943 | 56602 | 249 | 0.875 | 2.17875 | Fungi | 4751 | Fungi | Fungi | 113 | 1.2200000000000002e-27 | NR | RPA87569.1 | 1160509 | g56410 | i0 | 59.8 | 7.90361445783132 | 82 | 33 | 98.8 | 0 | 2 | 247 | 324 | 405 | RPA87569.1 PLP-dependent transferase [Ascobolus immersus RN42] | diamond | 1968 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Ascobolaceae | Ascobolus | Ascobolus immersus | |
| 27079972 | 27079972 | PRJNA603943_P_NODE_54482_length_250_cov_0.870056_g54290_i0 | PRJNA603943 | 54482 | 250 | 0.870056 | 2.17514 | Dissoconium aciculare CBS 342.82 | 1314786 | Fungi | Fungi | 73.9 | 4.29e-13 | NR | XP_033457652.1 | 1314786 | g54290 | i0 | 56.3 | 5.268 | 64 | 28 | 76.8 | 0 | 244 | 53 | 1022 | 1085 | XP_033457652.1 NAD-dependent glutamate dehydrogenase [Dissoconium aciculare CBS 342.82] | diamond | 1317 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Dissoconiaceae | Dissoconium | Dissoconium aciculare | |
| 27301295 | 27301295 | PRJNA603943_P_NODE_42943_length_282_cov_1.349282_g42751_i0 | PRJNA603943 | 42943 | 282 | 1.349282 | 3.80497524 | Xylaria venustula | 743302 | Fungi | Fungi | 43.1 | 0.0436 | NR | KAI1295183.1 | 743302 | g42751 | i0 | 38.6 | 0.468085106382979 | 44 | 27 | 46.8 | 0 | 151 | 282 | 300 | 343 | KAI1295183.1 hypothetical protein F5Y03DRAFT_410642 [Xylaria venustula] | diamond | 132 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria venustula | |
| 27712219 | 27712219 | PRJNA603943_P_NODE_60584_length_247_cov_0.885057_g60392_i0 | PRJNA603943 | 60584 | 247 | 0.885057 | 2.18609079 | Neoarthrinium moseri | 1658444 | Fungi | Fungi | 51.2 | 4.05e-5 | NR | KAI1842089.1 | 1658444 | g60392 | i0 | 43.9 | 1.38461538461538 | 57 | 32 | 69.2 | 0 | 2 | 172 | 361 | 417 | KAI1842089.1 hypothetical protein JX266_011740 [Neoarthrinium moseri] | diamond | 342 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Neoarthrinium | Neoarthrinium moseri | |
| 28816584 | 28816584 | PRJNA603943_P_NODE_54148_length_250_cov_1.451977_g53956_i0 | PRJNA603943 | 54148 | 250 | 1.451977 | 3.6299425 | Schizosaccharomyces octosporus yFS286 | 483514 | Fungi | Fungi | 58.5 | 1.04e-7 | NR | XP_013020710.1 | 483514 | g53956 | i0 | 39.4 | 2.592 | 71 | 41 | 85.2 | 1 | 225 | 13 | 183 | 251 | XP_013020710.1 protein disulfide isomerase [Schizosaccharomyces octosporus yFS286] | diamond | 648 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces octosporus | |
| 28879905 | 28879905 | PRJNA603943_P_NODE_25268_length_351_cov_1.104317_g25076_i0 | PRJNA603943 | 25268 | 351 | 1.104317 | 3.87615267 | Xylographa soralifera | 1590126 | Fungi | Fungi | 45.8 | 0.0101 | NR | MCJ1378384.1 | 1590126 | g25076 | i0 | 35.7 | 0.717948717948718 | 84 | 48 | 66.7 | 2 | 245 | 12 | 24 | 107 | MCJ1378384.1 hypothetical protein [Xylographa soralifera] | diamond | 252 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Xylographa | Xylographa soralifera | |
| 29479618 | 29479618 | PRJNA603943_P_NODE_58070_length_248_cov_0.880000_g57878_i0 | PRJNA603943 | 58070 | 248 | 0.88 | 2.1824 | Immersiella caudata | 314043 | Fungi | Fungi | 67.8 | 8.79e-12 | NR | KAK0614243.1 | 314043 | g57878 | i0 | 49.4 | 2.43145161290323 | 83 | 29 | 84.7 | 2 | 210 | 1 | 16 | 98 | KAK0614243.1 transcriptional Coactivator p15-domain-containing protein [Immersiella caudata] | diamond | 603 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Immersiella | Immersiella caudata | |
| 30553750 | 30553750 | PRJNA603943_P_NODE_66593_length_243_cov_0.905882_g66401_i0 | PRJNA603943 | 66593 | 243 | 0.905882 | 2.20129326 | Stictis urceolata | 2704026 | Fungi | Fungi | 45.1 | 0.00537 | NR | MCJ1444846.1 | 2704026 | g66401 | i0 | 40.7 | 1.97530864197531 | 81 | 41 | 97.5 | 2 | 2 | 238 | 156 | 231 | MCJ1444846.1 Arginase, catabolizes arginine to ornithine and urea [Stictis urceolata] | diamond | 480 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Stictidaceae | Stictis | Stictis urceolata | |
| 30901540 | 30901540 | PRJNA603943_P_NODE_70654_length_239_cov_2.361446_g70462_i0 | PRJNA603943 | 70654 | 239 | 2.361446 | 5.64385594 | Ascodesmis nigricans | 341454 | Fungi | Fungi | 98.2 | 1.87e-24 | NR | TGZ83211.1 | 341454 | g70462 | i0 | 72.1 | 0.853556485355649 | 68 | 19 | 85.4 | 0 | 35 | 238 | 1 | 68 | TGZ83211.1 ribosomal protein 60S [Ascodesmis nigricans] | diamond | 204 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Ascodesmidaceae | Ascodesmis | Ascodesmis nigricans | |
| 31881492 | 31881492 | PRJNA603943_P_NODE_2957_length_841_cov_2.598958_g2798_i0 | PRJNA603943 | 2957 | 841 | 2.598958 | 21.85723678 | Zymoseptoria brevis | 1047168 | Fungi | Fungi | 90.5 | 3.58e-18 | NR | KJX98998.1 | 1047168 | g2798 | i0 | 47.5 | 0.495838287752675 | 139 | 53 | 48.9 | 6 | 664 | 254 | 47 | 167 | KJX98998.1 40S ribosomal protein S10 [Zymoseptoria brevis] | diamond | 417 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zymoseptoria | Zymoseptoria brevis | |
| 32261657 | 32261657 | PRJNA603943_P_NODE_54938_length_250_cov_0.870056_g54746_i0 | PRJNA603943 | 54938 | 250 | 0.870056 | 2.17514 | Starmerella bacillaris | 1247836 | Fungi | Fungi | 47 | 9.99e-4 | NR | GMM49428.1 | 1247836 | g54746 | i0 | 39.6 | 1.068 | 53 | 32 | 63.6 | 0 | 219 | 61 | 159 | 211 | GMM49428.1 proteasome core particle subunit beta 6 [Starmerella bacillaris] | diamond | 267 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Starmerella | Starmerella bacillaris | |
| 32464603 | 32464603 | PRJNA603943_P_NODE_52699_length_251_cov_0.865169_g52507_i0 | PRJNA603943 | 52699 | 251 | 0.865169 | 2.17157419 | Ascomycota | 4890 | Fungi | Fungi | 53.5 | 6.54e-6 | NR | KAI8935986.1 | 301713 | g52507 | i0 | 37.9 | 5.04382470119522 | 66 | 37 | 78.9 | 2 | 33 | 230 | 679 | 740 | KAI8935986.1 hypothetical protein NX059_007489 [Plenodomus lindquistii] | diamond | 1266 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus lindquistii | |
| 32811272 | 32811272 | PRJNA603943_P_NODE_5820_length_633_cov_2.212500_g5635_i0 | PRJNA603943 | 5820 | 633 | 2.2125 | 14.005125 | Opisthokonta | 33154 | Fungi | Fungi | 119 | 1.05e-28 | NR | XP_024666392.1 | 45607 | g5635 | i0 | 43.5 | 1.93364928909953 | 131 | 72 | 62.1 | 1 | 2 | 394 | 181 | 309 | XP_024666392.1 hypothetical protein B9G98_04067 [Wickerhamiella sorbophila] | diamond | 1224 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella sorbophila |
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);;