contig_metadata
18 rows where bioproject = "PRJNA556842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1124150 | 1124150 | PRJNA556842_P_NODE_12721_length_197_cov_2.493750_g12216_i0 | PRJNA556842 | 12721 | 197 | 2.49375 | 4.9126875 | Didymellaceae | 683158 | Fungi | Fungi | 340 | 3.2499999999999995e-89 | NTclustered | gi|785740128|gb|KP161043.1| | 1200837 | g12216 | i0 | 97.959 | 87.3248730964467 | 196 | 4 | 99 | 0 | 1 | 196 | 2 | 197 | Stagonosporopsis chrysanthemi strain CBS 500.63 28S ribosomal RNA gene and 28S-18S ribosomal RNA intergenic spacer, partial sequence | blastn | 17203 | 340 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Stagonosporopsis | Stagonosporopsis chrysanthemi | |
| 1797400 | 1797400 | PRJNA556842_P_NODE_16602_length_159_cov_1.918033_g16097_i0 | PRJNA556842 | 16602 | 159 | 1.918033 | 3.04967247 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 222 | 9.479999999999999e-54 | NTclustered | gi|1701893707|ref|XM_029904023.1| | 1043002 | g16097 | i0 | 100 | 5.83647798742138 | 120 | 0 | 75 | 0 | 40 | 159 | 1 | 120 | Aureobasidium pullulans EXF-150 DUF1761-domain-containing protein (M438DRAFT_337668), partial mRNA | blastn | 928 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 2399569 | 2399569 | PRJNA556842_P_NODE_12262_length_203_cov_4.891566_g11757_i0 | PRJNA556842 | 12262 | 203 | 4.891566 | 9.92987898 | Cladosporium | 5498 | Fungi | Fungi | 375 | 9.24e-100 | NTclustered | gi|284158823|gb|GU214410.1| | 29918 | g11757 | i0 | 100 | 65.5467980295567 | 203 | 0 | 100 | 0 | 1 | 203 | 3236 | 3034 | Cladosporium herbarum strain CBS 723.79 28S large subunit ribosomal RNA gene, partial sequence | blastn | 13306 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium herbarum | |
| 3072724 | 3072724 | PRJNA556842_P_NODE_16563_length_159_cov_20.573770_g16058_i0 | PRJNA556842 | 16563 | 159 | 20.57377 | 32.7122943 | Monocillium sp. | 2077188 | Fungi | Fungi | 235 | 1.22e-57 | NTclustered | gi|1486697866|gb|MK018452.1| | 2077188 | g16058 | i0 | 94.702 | 95.2955974842767 | 151 | 8 | 95 | 0 | 1 | 151 | 153 | 3 | Monocillium sp. isolate OTU346 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15152 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Niessliaceae | Monocillium | Monocillium sp. | |
| 4952324 | 4952324 | PRJNA556842_P_NODE_7864_length_295_cov_7.193798_g7360_i0 | PRJNA556842 | 7864 | 295 | 7.193798 | 21.2217041 | Aureobasidium | 5579 | Fungi | Fungi | 407 | 5.069999999999999e-109 | NTclustered | gi|563427618|gb|JX188100.1| | 5580 | g7360 | i0 | 94.382 | 90.2406779661017 | 267 | 11 | 89 | 4 | 1 | 264 | 817 | 552 | Aureobasidium pullulans strain RGA001 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26621 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 6899705 | 6899705 | PRJNA556842_P_NODE_15486_length_168_cov_2.938931_g14981_i0 | PRJNA556842 | 15486 | 168 | 2.938931 | 4.93740408 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 305 | 9.81e-79 | NTclustered | gi|670734114|gb|KJ443114.1| | 33203 | g14981 | i0 | 99.405 | 99.7380952380952 | 168 | 1 | 100 | 0 | 1 | 168 | 2019 | 1852 | Purpureocillium lilacinum strain G406 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16756 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 7502296 | 7502296 | PRJNA556842_P_NODE_13286_length_190_cov_1.620915_g12781_i0 | PRJNA556842 | 13286 | 190 | 1.620915 | 3.0797385 | Hormonema | 46635 | Fungi | Fungi | 311 | 2.44e-80 | NTclustered | gi|1407920319|gb|MF611880.1| | 284138 | g12781 | i0 | 96.316 | 104.315789473684 | 190 | 6 | 100 | 1 | 1 | 190 | 3584 | 3396 | Hormonema carpetanum culture ATCC:74360 28S ribosomal RNA gene, complete sequence | blastn | 19820 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothioraceae | Hormonema | Hormonema carpetanum | |
| 8174565 | 8174565 | PRJNA556842_P_NODE_15807_length_165_cov_3.343750_g15302_i0 | PRJNA556842 | 15807 | 165 | 3.34375 | 5.5171875 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 302 | 1.24e-77 | NTclustered | gi|1209454411|ref|NG_055393.1| | 4952 | g15302 | i0 | 99.394 | 2 | 165 | 1 | 100 | 0 | 1 | 165 | 3055 | 2891 | Yarrowia lipolytica NRRL YB-423 28S rRNA, partial sequence; from TYPE material | blastn | 330 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 8174572 | 8174572 | PRJNA556842_P_NODE_6947_length_325_cov_2.145833_g6444_i0 | PRJNA556842 | 6947 | 325 | 2.145833 | 6.97395725 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 601 | 2.4199999999999993e-167 | NTclustered | gi|1209454411|ref|NG_055393.1| | 4952 | g6444 | i0 | 100 | 84.5753846153846 | 325 | 0 | 100 | 0 | 1 | 325 | 1356 | 1680 | Yarrowia lipolytica NRRL YB-423 28S rRNA, partial sequence; from TYPE material | blastn | 27487 | 601 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 15152224 | 15152224 | PRJNA556842_P_NODE_5352_length_390_cov_6.830028_g4853_i0 | PRJNA556842 | 5352 | 390 | 6.830028 | 26.6371092 | Hypocreales | 5125 | Fungi | Fungi | 665 | 0 | NTclustered | gi|255709244|gb|FJ609314.1| | 5530 | g4853 | i0 | 97.449 | 100.015384615385 | 392 | 7 | 100 | 3 | 1 | 390 | 2 | 392 | Metarhizium anisopliae strain 40B1ii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 39006 | 665 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Metarhizium | Metarhizium anisopliae | |
| 15824545 | 15824545 | PRJNA556842_P_NODE_15793_length_165_cov_9.484375_g15288_i0 | PRJNA556842 | 15793 | 165 | 9.484375 | 15.64921875 | Lecanosticta acicola | 111012 | Fungi | Fungi | 289 | 9.66e-74 | NTclustered | gi|284159076|gb|GU214663.1| | 111012 | g15288 | i0 | 98.182 | 100 | 165 | 3 | 100 | 0 | 1 | 165 | 4075 | 3911 | Lecanosticta acicola culture CBS:871.95 strain CBS 871.95 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16500 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Lecanosticta | Lecanosticta acicola | |
| 17702098 | 17702098 | PRJNA556842_P_NODE_6694_length_334_cov_1.427609_g6191_i0 | PRJNA556842 | 6694 | 334 | 1.427609 | 4.76821406 | Ophiocordycipitaceae | 474942 | Fungi | Fungi | 540 | 5.51e-149 | NTclustered | gi|670734114|gb|KJ443114.1| | 33203 | g6191 | i0 | 95.808 | 100.161676646707 | 334 | 14 | 100 | 0 | 1 | 334 | 1692 | 1359 | Purpureocillium lilacinum strain G406 28S large subunit ribosomal RNA gene, partial sequence | blastn | 33454 | 540 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 20923932 | 20923932 | PRJNA556842_P_NODE_15277_length_170_cov_1.759398_g14772_i0 | PRJNA556842 | 15277 | 170 | 1.759398 | 2.9909766 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 309 | 7.64e-80 | NTclustered | gi|2086743560|ref|XR_006253225.1| | 182096 | g14772 | i0 | 99.412 | 106.011764705882 | 170 | 1 | 100 | 0 | 1 | 170 | 2435 | 2266 | Aspergillus chevalieri 28S ribosomal RNA (ACHE_r70002S), rRNA | blastn | 18022 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 21526200 | 21526200 | PRJNA556842_P_NODE_10537_length_232_cov_2.856410_g10032_i0 | PRJNA556842 | 10537 | 232 | 2.85641 | 6.6268712 | Eukaryota | 2759 | Fungi | Fungi | 398 | 2.3099999999999995e-106 | NTclustered | gi|1523644887|gb|MK225554.1| | 135283 | g10032 | i0 | 97.826 | 99.1508620689655 | 230 | 5 | 99 | 0 | 1 | 230 | 1445 | 1674 | Podosphaera xanthii isolate 2086 large subunit ribosomal RNA gene, partial sequence | blastn | 23003 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Podosphaera | Podosphaera xanthii | |
| 22801335 | 22801335 | PRJNA556842_P_NODE_16318_length_161_cov_3.370968_g15813_i0 | PRJNA556842 | 16318 | 161 | 3.370968 | 5.42725848 | Yarrowia | 4951 | Fungi | Fungi | 298 | 1.56e-76 | NTclustered | gi|90658119|gb|DQ438182.1| | 4952 | g15813 | i0 | 100 | 94.2360248447205 | 161 | 0 | 100 | 0 | 1 | 161 | 577 | 737 | Yarrowia lipolytica 18S ribosomal RNA gene, partial sequence | blastn | 15172 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 23474222 | 23474222 | PRJNA556842_P_NODE_16539_length_160_cov_1.235772_g16034_i0 | PRJNA556842 | 16539 | 160 | 1.235772 | 1.9772352 | Scheffersomyces spartinae | 45513 | Fungi | Fungi | 117 | 4.64e-22 | NTclustered | gi|2083595464|ref|XM_043191105.1| | 45513 | g16034 | i0 | 86.239 | 41.64375 | 109 | 13 | 68 | 2 | 2 | 109 | 49 | 156 | Scheffersomyces spartinae 60S ribosomal protein L39 (RPL39), partial mRNA | blastn | 6663 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces spartinae | |
| 27078266 | 27078266 | PRJNA556842_P_NODE_11802_length_210_cov_2.236994_g11297_i0 | PRJNA556842 | 11802 | 210 | 2.236994 | 4.6976874 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 75.9 | 5.54e-16 | NR | KAG9514618.1 | 46634 | g11297 | i0 | 68.6 | 0.728571428571429 | 51 | 16 | 72.9 | 0 | 58 | 210 | 1 | 51 | KAG9514618.1 hypothetical protein KCV07_g7983, partial [Aureobasidium melanogenum] | diamond | 153 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 32859328 | 32859328 | PRJNA556842_P_NODE_10880_length_226_cov_1.359788_g10375_i0 | PRJNA556842 | 10880 | 226 | 1.359788 | 3.07312088 | Cladophialophora bantiana CBS 173.52 | 1442370 | Fungi | Fungi | 42.4 | 0.0422 | NR | XP_016621673.1 | 1442370 | g10375 | i0 | 38.2 | 1.00884955752212 | 76 | 33 | 83.6 | 4 | 2 | 190 | 815 | 889 | XP_016621673.1 uncharacterized protein Z519_04984 [Cladophialophora bantiana CBS 173.52] | diamond | 228 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora bantiana |
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);;