contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA415636" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2969827 | 2969827 | PRJNA415636_S_NODE_6023_length_211_cov_2.487805_g5976_i0 | PRJNA415636 | 6023 | 211 | 2.487805 | 5.24926855 | Boeremia exigua | 749465 | Fungi | Fungi | 52.8 | 0.019 | NTclustered | gi|2185331991|ref|XM_046135256.1| | 749465 | g5976 | i0 | 92.308 | 0.184834123222749 | 39 | 0 | 18 | 2 | 58 | 96 | 902 | 937 | Boeremia exigua uncharacterized protein (C7974DRAFT_125998), mRNA | blastn | 39 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Boeremia | Boeremia exigua | |
| 10011368 | 10011368 | PRJNA415636_S_NODE_1608_length_349_cov_8.609272_g1561_i0 | PRJNA415636 | 1608 | 349 | 8.609272 | 30.04635928 | Eremothecium | 33170 | Fungi | Fungi | 265 | 3.89e-66 | NTclustered | gi|1063853000|ref|XM_018131964.1| | 45286 | g1561 | i0 | 81.25 | 49.3667621776504 | 336 | 55 | 95 | 8 | 1 | 332 | 61 | 392 | Eremothecium sinecaudum 60S ribosomal protein uL14 (AW171_hschr42355), partial mRNA | blastn | 17229 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Eremothecium | Eremothecium sinecaudum | |
| 21485003 | 21485003 | PRJNA415636_S_NODE_6457_length_204_cov_3.050955_g6410_i0 | PRJNA415636 | 6457 | 204 | 3.050955 | 6.2239482 | Saccharomyces | 4930 | Fungi | Fungi | 372 | 1.2e-98 | NTclustered | gi|559925|emb|Z46255.1| | 4932 | g6410 | i0 | 99.51 | 13.5539215686275 | 204 | 1 | 100 | 0 | 1 | 204 | 10231 | 10434 | S.cerevisiae chromosome VI lambda clone | blastn | 2765 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 22095532 | 22095532 | PRJNA415636_S_NODE_4478_length_238_cov_1.434555_g4431_i0 | PRJNA415636 | 4478 | 238 | 1.434555 | 3.4142409 | Plenodomus lingam | 5022 | Fungi | Fungi | 148 | 2.6499999999999996e-31 | NTclustered | gi|702073659|emb|FO906006.1| | 225343 | g4431 | i0 | 88.618 | 23.2689075630252 | 123 | 12 | 51 | 2 | 10 | 131 | 176740 | 176861 | Leptosphaeria maculans lepidii ibcn84_scaffold00018 complete sequence | blastn | 5538 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus lingam | |
| 22095534 | 22095534 | PRJNA415636_S_NODE_5758_length_215_cov_2.678571_g5711_i0 | PRJNA415636 | 5758 | 215 | 2.678571 | 5.75892765 | Emericellopsis atlantica | 2614577 | Fungi | Fungi | 159 | 1.09e-34 | NTclustered | gi|2185252749|ref|XM_046257805.1| | 2614577 | g5711 | i0 | 84.242 | 73.0139534883721 | 165 | 24 | 76 | 2 | 1 | 164 | 156 | 319 | Emericellopsis atlantica ribosomal protein L37ae (F5Z01DRAFT_161246), mRNA | blastn | 15698 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Emericellopsis | Emericellopsis atlantica | |
| 24645512 | 24645512 | PRJNA415636_S_NODE_3000_length_278_cov_1.545455_g2953_i0 | PRJNA415636 | 3000 | 278 | 1.545455 | 4.2963649 | Didymella exigua | 100019 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|1832879865|ref|XM_033591691.1| | 1150837 | g2953 | i0 | 85.455 | 0.701438848920863 | 55 | 4 | 19 | 4 | 60 | 111 | 560 | 507 | Didymella exigua CBS 183.55 TIM44 subunit of mitochondria import inner membrane translocase (M421DRAFT_418155), mRNA | blastn | 195 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella exigua | |
| 24645513 | 24645513 | PRJNA415636_S_NODE_3400_length_265_cov_1.610092_g3353_i0 | PRJNA415636 | 3400 | 265 | 1.610092 | 4.2667438 | Lipomyces arxii | 56418 | Fungi | Fungi | 52.8 | 0.024 | NTclustered | gi|2781515019|ref|XM_066915134.1| | 56418 | g3353 | i0 | 100 | 0.105660377358491 | 28 | 0 | 11 | 0 | 139 | 166 | 335 | 362 | Lipomyces arxii heat shock protein 70 family (V1512DRAFT_256956), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces arxii | |
| 24645514 | 24645514 | PRJNA415636_S_NODE_4120_length_246_cov_1.643216_g4073_i0 | PRJNA415636 | 4120 | 246 | 1.643216 | 4.04231136 | Aspergillus campestris | 41068 | Fungi | Fungi | 147 | 9.909999999999998e-31 | NTclustered | gi|1383835682|ref|XM_024838843.1| | 1392248 | g4073 | i0 | 89.167 | 48.0731707317073 | 120 | 9 | 48 | 2 | 124 | 242 | 327 | 211 | Aspergillus campestris IBT 28561 ribosomal protein P1 (P168DRAFT_304422), partial mRNA | blastn | 11826 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus campestris |
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);;