contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1242190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 350786 | 350786 | PRJNA1242190_S_NODE_5221_length_359_cov_4.024476_g5214_i0 | PRJNA1242190 | 5221 | 359 | 4.024476 | 14.44786884 | Sphaerosporella brunnea | 1250544 | Fungi | Fungi | 104 | 4.88e-25 | NR | KAA8914655.1 | 1250544 | g5214 | i0 | 49 | 0.802228412256267 | 96 | 46 | 77.7 | 1 | 3 | 281 | 7 | 102 | KAA8914655.1 thioredoxin-like protein [Sphaerosporella brunnea] | diamond | 288 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Sphaerosporella | Sphaerosporella brunnea | |
| 1625660 | 1625660 | PRJNA1242190_S_NODE_8262_length_297_cov_3.508929_g8255_i0 | PRJNA1242190 | 8262 | 297 | 3.508929 | 10.42151913 | Fungi | 4751 | Fungi | Fungi | 134 | 9.39e-38 | NR | NP_593900.1 | 4896 | g8255 | i0 | 71.1 | 56.3434343434343 | 90 | 26 | 90.9 | 0 | 295 | 26 | 62 | 151 | NP_593900.1 40S ribosomal protein uS15 [Schizosaccharomyces pombe] | diamond | 16734 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 5454399 | 5454399 | PRJNA1242190_S_NODE_6485_length_329_cov_3.585938_g6478_i0 | PRJNA1242190 | 6485 | 329 | 3.585938 | 11.79773602 | Eukaryota | 2759 | Fungi | Fungi | 147 | 1.04e-38 | NR | RAL66112.1 | 38457 | g6478 | i0 | 89.7 | 193.449848024316 | 78 | 8 | 71.1 | 0 | 20 | 253 | 592 | 669 | RAL66112.1 hypothetical protein DID88_005783 [Monilinia fructigena] | diamond | 63645 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Monilinia | Monilinia fructigena | |
| 26852324 | 26852324 | PRJNA1242190_S_NODE_9001_length_286_cov_1.582160_g8994_i0 | PRJNA1242190 | 9001 | 286 | 1.58216 | 4.5249776 | Drechmeria coniospora | 98403 | Fungi | Fungi | 43.5 | 0.0209 | NR | XP_040658901.1 | 98403 | g8994 | i0 | 32.4 | 1.06993006993007 | 102 | 57 | 96.5 | 3 | 2 | 277 | 70 | 169 | XP_040658901.1 phosphatidylinositol/phosphatidylglycerol transfer protein [Drechmeria coniospora] | diamond | 306 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Drechmeria | Drechmeria coniospora | |
| 27534049 | 27534049 | PRJNA1242190_S_NODE_3743_length_412_cov_3.333333_g3736_i0 | PRJNA1242190 | 3743 | 412 | 3.333333 | 13.73333196 | Dothideomycetes | 147541 | Fungi | Fungi | 169 | 1.38e-50 | NR | XP_035362743.1 | 45133 | g3736 | i0 | 68.5 | 14.1626213592233 | 108 | 34 | 78.6 | 0 | 3 | 326 | 80 | 187 | XP_035362743.1 Nucleoside diphosphate kinase protein [Lasiodiplodia theobromae] | diamond | 5835 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Botryosphaeriaceae | Lasiodiplodia | Lasiodiplodia theobromae | |
| 28368331 | 28368331 | PRJNA1242190_S_NODE_2346_length_482_cov_2.026895_g2339_i0 | PRJNA1242190 | 2346 | 482 | 2.026895 | 9.7696339 | Chaetomium strumarium | 1170767 | Fungi | Fungi | 88.6 | 2.49e-18 | NR | XP_062718949.1 | 1170767 | g2339 | i0 | 48.5 | 1.58091286307054 | 130 | 52 | 71.6 | 4 | 391 | 47 | 82 | 211 | XP_062718949.1 60S ribosomal protein L13 [Chaetomium strumarium] | diamond | 762 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Chaetomium | Chaetomium strumarium | |
| 28481289 | 28481289 | PRJNA1242190_S_NODE_12226_length_250_cov_2.548023_g12219_i0 | PRJNA1242190 | 12226 | 250 | 2.548023 | 6.3700575 | Ascomycota | 4890 | Fungi | Fungi | 56.2 | 2.9e-7 | NR | KAK9313955.1 | 29829 | g12219 | i0 | 62 | 5.568 | 50 | 18 | 58.8 | 1 | 182 | 36 | 147 | 196 | KAK9313955.1 ribosomal protein L6e-domain-containing protein [Lipomyces starkeyi] | diamond | 1392 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces starkeyi | |
| 28481290 | 28481290 | PRJNA1242190_S_NODE_5086_length_363_cov_3.451724_g5079_i0 | PRJNA1242190 | 5086 | 363 | 3.451724 | 12.52975812 | Sordariomycetes | 147550 | Fungi | Fungi | 81.6 | 1.52e-17 | NR | XP_008097613.1 | 645133 | g5079 | i0 | 46.1 | 5.98347107438016 | 76 | 41 | 62.8 | 0 | 78 | 305 | 3 | 78 | XP_008097613.1 ribosomal protein S21e [Colletotrichum graminicola M1.001] | diamond | 2172 | 82.4 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum graminicola | |
| 28923166 | 28923166 | PRJNA1242190_S_NODE_7608_length_308_cov_1.472340_g7601_i0 | PRJNA1242190 | 7608 | 308 | 1.47234 | 4.5348072 | Eukaryota | 2759 | Fungi | Fungi | 134 | 8e-38 | NR | XP_034009856.1 | 5481 | g7601 | i0 | 63.4 | 47.25 | 93 | 34 | 90.6 | 0 | 307 | 29 | 56 | 148 | XP_034009856.1 uncharacterized protein DIURU_005232 [Diutina rugosa] | diamond | 14553 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Diutina | Diutina rugosa | |
| 29094786 | 29094786 | PRJNA1242190_S_NODE_5188_length_360_cov_6.944251_g5181_i0 | PRJNA1242190 | 5188 | 360 | 6.944251 | 24.9993036 | Arxiozyma heterogenica | 278026 | Fungi | Fungi | 126 | 2.6299999999999997e-35 | NR | XP_064713664.1 | 278026 | g5181 | i0 | 69 | 2.93333333333333 | 84 | 25 | 70 | 1 | 345 | 94 | 2 | 84 | XP_064713664.1 uncharacterized protein PWA37_002870 [Arxiozyma heterogenica] | diamond | 1056 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Arxiozyma | Arxiozyma heterogenica | |
| 29554591 | 29554591 | PRJNA1242190_S_NODE_1410_length_554_cov_2.424116_g1403_i0 | PRJNA1242190 | 1410 | 554 | 2.424116 | 13.42960264 | Ascomycota | 4890 | Fungi | Fungi | 87 | 1e-17 | NR | KAI2732586.1 | 5082 | g1403 | i0 | 30.7 | 9.12454873646209 | 153 | 97 | 78 | 1 | 518 | 87 | 27 | 179 | KAI2732586.1 hypothetical protein CBS147332_1725 [Penicillium roqueforti] | diamond | 5055 | 87.4 | 0.995423340961098 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 29997039 | 29997039 | PRJNA1242190_S_NODE_5451_length_353_cov_6.714286_g5444_i0 | PRJNA1242190 | 5451 | 353 | 6.714286 | 23.70142958 | Ascomycota | 4890 | Fungi | Fungi | 75.9 | 2.56e-15 | NR | TID13282.1 | 52247 | g5444 | i0 | 46.1 | 7.75070821529745 | 76 | 41 | 64.6 | 0 | 302 | 75 | 3 | 78 | TID13282.1 hypothetical protein CANINC_004968 [Pichia inconspicua] | diamond | 2736 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia inconspicua | |
| 30926879 | 30926879 | PRJNA1242190_S_NODE_13794_length_240_cov_2.425150_g13787_i0 | PRJNA1242190 | 13794 | 240 | 2.42515 | 5.82036 | Scytalidium lignicola | 5539 | Fungi | Fungi | 53.9 | 1.17e-6 | NR | RFU25673.1 | 5539 | g13787 | i0 | 34.3 | 0.8375 | 67 | 44 | 83.8 | 0 | 232 | 32 | 7 | 73 | RFU25673.1 hypothetical protein B7463_g10657, partial [Scytalidium lignicola] | diamond | 201 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Scytalidium | Scytalidium lignicola | |||
| 32033474 | 32033474 | PRJNA1242190_S_NODE_4718_length_375_cov_1.986755_g4711_i0 | PRJNA1242190 | 4718 | 375 | 1.986755 | 7.45033125 | Candidozyma auris | 498019 | Fungi | Fungi | 86.3 | 2.04e-18 | NR | XP_028888046.1 | 498019 | g4711 | i0 | 54.9 | 2.448 | 102 | 38 | 80.8 | 3 | 2 | 304 | 71 | 165 | XP_028888046.1 60S ribosomal protein eL6 [Candidozyma auris] | diamond | 918 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Candidozyma | Candidozyma auris | |
| 32191750 | 32191750 | PRJNA1242190_S_NODE_2558_length_470_cov_3.848866_g2551_i0 | PRJNA1242190 | 2558 | 470 | 3.848866 | 18.0896702 | Hypoxylon crocopeplum | 326657 | Fungi | Fungi | 54.3 | 7.87e-6 | NR | KAI1378271.1 | 326657 | g2551 | i0 | 30.8 | 1.67234042553191 | 130 | 87 | 81.1 | 2 | 433 | 53 | 13 | 142 | KAI1378271.1 60S ribosomal protein L28 [Hypoxylon crocopeplum] | diamond | 786 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Hypoxylon | Hypoxylon crocopeplum |
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);;