contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA832865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4650547 | 4650547 | PRJNA832865_S_NODE_109044_length_242_cov_0.911243_g103958_i0 | PRJNA832865 | 109044 | 242 | 0.911243 | 2.20520806 | Wickerhamomyces ciferrii | 1041607 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|754409294|ref|XM_011275748.1| | 1041607 | g103958 | i0 | 100 | 0.12396694214876 | 30 | 0 | 12 | 0 | 148 | 177 | 286 | 257 | Wickerhamomyces ciferrii uncharacterized protein (BN7_3667), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces ciferrii | |
| 4652153 | 4652153 | PRJNA832865_S_NODE_83164_length_269_cov_0.780612_g78078_i0 | PRJNA832865 | 83164 | 269 | 0.780612 | 2.09984628 | Wickerhamomyces ciferrii | 1041607 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|754409294|ref|XM_011275748.1| | 1041607 | g78078 | i0 | 100 | 0.107806691449814 | 29 | 0 | 11 | 0 | 130 | 158 | 286 | 258 | Wickerhamomyces ciferrii uncharacterized protein (BN7_3667), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces ciferrii | |
| 7200267 | 7200267 | PRJNA832865_S_NODE_101106_length_247_cov_0.885057_g96020_i0 | PRJNA832865 | 101106 | 247 | 0.885057 | 2.18609079 | Candida albicans | 5476 | Fungi | Fungi | 457 | 4.05e-124 | NTclustered | gi|2530258991|gb|CP115803.1| | 5476 | g96020 | i0 | 100 | 1.66396761133603 | 247 | 0 | 100 | 0 | 1 | 247 | 738662 | 738908 | Candida albicans strain Fungi-01 chromosome 6 | blastn | 411 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida albicans | |
| 8476394 | 8476394 | PRJNA832865_S_NODE_65127_length_307_cov_1.076923_g60041_i0 | PRJNA832865 | 65127 | 307 | 1.076923 | 3.30615361 | Pyricularia oryzae | 318829 | Fungi | Fungi | 52.8 | 0.029 | NTclustered | gi|2263452720|gb|CP099697.1| | 318829 | g60041 | i0 | 100 | 0.0912052117263844 | 28 | 0 | 9 | 0 | 263 | 290 | 3531094 | 3531121 | Pyricularia oryzae strain ZM2-1 chromosome 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Pyriculariaceae | Pyricularia | Pyricularia oryzae | |
| 11025859 | 11025859 | PRJNA832865_S_NODE_104369_length_245_cov_0.895349_g99283_i0 | PRJNA832865 | 104369 | 245 | 0.895349 | 2.19360505 | Candida albicans | 5476 | Fungi | Fungi | 453 | 5.1900000000000006e-123 | NTclustered | gi|68480986|ref|XM_710442.1| | 237561 | g99283 | i0 | 100 | 1.99183673469388 | 245 | 0 | 100 | 0 | 1 | 245 | 1247 | 1003 | Candida albicans SC5314 Iff5p (IFF5), partial mRNA | blastn | 488 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida albicans | |
| 11026434 | 11026434 | PRJNA832865_S_NODE_23589_length_668_cov_1.537815_g18690_i0 | PRJNA832865 | 23589 | 668 | 1.537815 | 10.2726042 | Cadophora gregata | 51156 | Fungi | Fungi | 54.7 | 0.019 | NTclustered | gi|2553626693|ref|XM_058505527.1| | 51156 | g18690 | i0 | 100 | 0.0434131736526946 | 29 | 0 | 4 | 0 | 229 | 257 | 5676 | 5648 | Cadophora gregata uncharacterized protein (ONS95_011926), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Ploettnerulaceae | Cadophora | Cadophora gregata | |
| 13575862 | 13575862 | PRJNA832865_S_NODE_13951_length_1120_cov_4.874881_g10288_i0 | PRJNA832865 | 13951 | 1120 | 4.874881 | 54.5986672 | Exserohilum turcicum | 93612 | Fungi | Fungi | 56.5 | 0.009 | NTclustered | gi|636588052|ref|XM_008027174.1| | 671987 | g10288 | i0 | 100 | 0.0267857142857143 | 30 | 0 | 3 | 0 | 76 | 105 | 2535 | 2506 | Exserohilum turcica Et28A uncharacterized protein (SETTUDRAFT_162935), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Exserohilum | Exserohilum turcicum | |
| 18673454 | 18673454 | PRJNA832865_S_NODE_104055_length_245_cov_0.895349_g98969_i0 | PRJNA832865 | 104055 | 245 | 0.895349 | 2.19360505 | Cladosporium cladosporioides | 29917 | Fungi | Fungi | 448 | 2.41e-121 | NTclustered | gi|1841183609|gb|MN661341.1| | 29917 | g98969 | i0 | 99.592 | 9.73469387755102 | 245 | 1 | 100 | 0 | 1 | 245 | 10828 | 11072 | Cladosporium cladosporioides strain YFCC 8621 mitochondrion, complete genome | blastn | 2385 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 19949100 | 19949100 | PRJNA832865_S_NODE_19596_length_806_cov_4.073670_g14999_i0 | PRJNA832865 | 19596 | 806 | 4.07367 | 32.8337802 | Saccharomyces eubayanus | 1080349 | Fungi | Fungi | 54.7 | 0.023 | NTclustered | gi|1069854048|ref|XM_018366870.1| | 1080349 | g14999 | i0 | 100 | 0.0359801488833747 | 29 | 0 | 4 | 0 | 451 | 479 | 1152 | 1124 | Saccharomyces eubayanus IMH1-like protein (DI49_3815), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces eubayanus | |
| 19950327 | 19950327 | PRJNA832865_S_NODE_86936_length_262_cov_1.343915_g81850_i0 | PRJNA832865 | 86936 | 262 | 1.343915 | 3.5210573 | Nakaseomyces glabratus | 5478 | Fungi | Fungi | 52.8 | 0.024 | NTclustered | gi|50293120|ref|XM_448979.1| | 5478 | g81850 | i0 | 100 | 0.106870229007634 | 28 | 0 | 11 | 0 | 204 | 231 | 803 | 830 | Nakaseomyces glabratus carboxylic ester hydrolase (GVI51_L04521), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Nakaseomyces | Nakaseomyces glabratus | |
| 22906179 | 22906179 | PRJNA832865_S_NODE_104778_length_244_cov_1.801170_g99692_i0 | PRJNA832865 | 104778 | 244 | 1.80117 | 4.3948548 | Candida | 5475 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2530258974|gb|CP115799.1| | 5476 | g99692 | i0 | 92.5 | 0.327868852459016 | 40 | 2 | 16 | 1 | 206 | 244 | 395499 | 395460 | Candida albicans strain Fungi-01 chromosome 2 | blastn | 80 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida albicans | |
| 22906182 | 22906182 | PRJNA832865_S_NODE_110998_length_241_cov_0.916667_g105912_i0 | PRJNA832865 | 110998 | 241 | 0.916667 | 2.20916747 | Aspergillus | 5052 | Fungi | Fungi | 126 | 1.26e-24 | NTclustered | gi|2028140832|ref|XM_040812086.1| | 1036611 | g105912 | i0 | 100 | 4.69294605809129 | 68 | 0 | 53 | 0 | 1 | 68 | 560 | 627 | Aspergillus versicolor CBS 583.65 uncharacterized protein (ASPVEDRAFT_40212), mRNA | blastn | 1131 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus versicolor | |
| 25049469 | 25049469 | PRJNA832865_S_NODE_45060_length_384_cov_1.980707_g39974_i0 | PRJNA832865 | 45060 | 384 | 1.980707 | 7.60591488 | Talaromyces marneffei | 37727 | Fungi | Fungi | 52.8 | 0.037 | NTclustered | gi|2459765569|ref|XM_054260602.1| | 37727 | g39974 | i0 | 100 | 0.0729166666666667 | 28 | 0 | 7 | 0 | 197 | 224 | 646 | 673 | Talaromyces marneffei uncharacterized protein (EYB26_001291), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei |
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);;