contig_metadata
23 rows where bioproject = "PRJEB7614" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16299093 | 16299093 | PRJEB7614_P_NODE_1213_length_307_cov_20.309353_g1148_i0 | PRJEB7614 | 1213 | 307 | 20.309353 | 62.34971371 | Dothideomycetes | 147541 | Fungi | Fungi | 429 | 1.13e-115 | NTclustered | gi|284158813|gb|GU214400.1| | 93495 | g1148 | i0 | 93.993 | 92.3061889250814 | 283 | 17 | 92 | 0 | 24 | 306 | 366 | 84 | Capnodium coffeae strain CBS 147.52 28S large subunit ribosomal RNA gene, partial sequence | blastn | 28338 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Capnodiales | Capnodiaceae | Capnodium | Capnodium coffeae | |
| 17574325 | 17574325 | PRJEB7614_P_NODE_2334_length_249_cov_25.963636_g2267_i0 | PRJEB7614 | 2334 | 249 | 25.963636 | 64.64945364 | Ascomycota | 4890 | Fungi | Fungi | 407 | 4.1799999999999994e-109 | NTclustered | gi|2034480785|gb|MZ152208.1| | 61296 | g2267 | i0 | 99.115 | 90.4136546184739 | 226 | 2 | 91 | 0 | 24 | 249 | 301 | 76 | Aureobasidium sp. isolate UFMG-CM-Y6821 large subunit ribosomal RNA gene, partial sequence | blastn | 22513 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium sp. | |
| 20122903 | 20122903 | PRJEB7614_P_NODE_2716_length_236_cov_3.541063_g2649_i0 | PRJEB7614 | 2716 | 236 | 3.541063 | 8.35690868 | Fungi | 4751 | Fungi | Fungi | 422 | 1.3999999999999997e-113 | NTclustered | gi|2217006246|gb|ON155334.1| | 34409 | g2649 | i0 | 100 | 96.5677966101695 | 228 | 0 | 97 | 0 | 9 | 236 | 857 | 630 | Colletotrichum sp. isolate PT2731 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 | 22790 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum sp. | |
| 25616371 | 25616371 | PRJEB7614a_S_NODE_90569_length_198_cov_1.907975_g89365_i0 | PRJEB7614 | 90569 | 198 | 1.907975 | 3.7777905 | Alternaria | 5598 | Fungi | Fungi | 248 | 2.04e-61 | NTclustered | gi|2812967425|gb|PQ210871.1| | 5599 | g89365 | i0 | 97.902 | 18.0757575757576 | 143 | 3 | 72 | 0 | 29 | 171 | 43888 | 43746 | Alternaria alternata isolate Karbala-1 mitochondrion, complete genome | blastn | 3579 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 25752630 | 25752630 | PRJEB7614a_S_NODE_134610_length_154_cov_1.680672_g133406_i0 | PRJEB7614 | 134610 | 154 | 1.680672 | 2.58823488 | Hypocreales | 5125 | Fungi | Fungi | 285 | 1.14e-72 | NTclustered | gi|1473253336|gb|MH866280.1| | 5128 | g133406 | i0 | 100 | 100 | 154 | 0 | 100 | 0 | 1 | 154 | 782 | 629 | Fusarium sambucinum culture CBS:135.24 strain CBS 135.24 large subunit ribosomal RNA gene, partial sequence | blastn | 15400 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium sambucinum | |
| 25752643 | 25752643 | PRJEB7614a_S_NODE_68026_length_232_cov_8.472081_g66822_i0 | PRJEB7614 | 68026 | 232 | 8.472081 | 19.65522792 | Alternaria | 5598 | Fungi | Fungi | 429 | 8.2e-116 | NTclustered | gi|315435167|gb|GU584953.1| | 45303 | g66822 | i0 | 100 | 99.9353448275862 | 232 | 0 | 100 | 0 | 1 | 232 | 658 | 889 | Lewia infectoria strain I458 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 | 23185 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria infectoria | |
| 25888337 | 25888337 | PRJEB7614a_S_NODE_135683_length_153_cov_1.838983_g134479_i0 | PRJEB7614 | 135683 | 153 | 1.838983 | 2.81364399 | Eukaryota | 2759 | Fungi | Fungi | 235 | 1.16e-57 | NTclustered | gi|514829572|gb|KC771883.1| | 4929 | g134479 | i0 | 96.479 | 65.2222222222222 | 142 | 5 | 93 | 0 | 1 | 142 | 136 | 277 | Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence | blastn | 9979 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 26024669 | 26024669 | PRJEB7614a_S_NODE_78052_length_215_cov_7.855556_g76848_i0 | PRJEB7614 | 78052 | 215 | 7.855556 | 16.8894454 | Sordariomycetes | 147550 | Fungi | Fungi | 381 | 2.1299999999999996e-101 | NTclustered | gi|397559781|gb|JX028570.1| | 61273 | g76848 | i0 | 98.605 | 100 | 215 | 3 | 100 | 0 | 1 | 215 | 708 | 922 | Ophiostoma piceae strain 28RJ 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 | 21500 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma piceae | |
| 26024702 | 26024702 | PRJEB7614e_S_NODE_7164_length_179_cov_14.437500_g7156_i0 | PRJEB7614 | 7164 | 179 | 14.4375 | 25.843125 | Ascomycota | 4890 | Fungi | Fungi | 331 | 1.74e-86 | NTclustered | gi|66805490|gb|DQ008146.1| | 29917 | g7156 | i0 | 100 | 100 | 179 | 0 | 100 | 0 | 1 | 179 | 47 | 225 | Cladosporium cladosporioides strain CBS 109501 28S large subunit ribosomal RNA gene, partial sequence | blastn | 17900 | 331 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 26069924 | 26069924 | PRJEB7614a_S_NODE_28149_length_341_cov_49.049020_g26945_i0 | PRJEB7614 | 28149 | 341 | 49.04902 | 167.2571582 | Saccharomyces cerevisiae | 4932 | Fungi | Fungi | 568 | 2.5899999999999993e-157 | NTclustered | gi|2640572120|gb|PP049220.1| | 4932 | g26945 | i0 | 98.447 | 95.7712609970674 | 322 | 5 | 94 | 0 | 20 | 341 | 325 | 4 | Saccharomyces cerevisiae strain LC3 large subunit ribosomal RNA gene, partial sequence | blastn | 32658 | 568 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 26160818 | 26160818 | PRJEB7614a_S_NODE_115285_length_171_cov_12.676471_g114081_i0 | PRJEB7614 | 115285 | 171 | 12.676471 | 21.67676541 | Ascomycota | 4890 | Fungi | Fungi | 311 | 2.14e-80 | NTclustered | gi|2591271980|gb|OR649296.1| | 4959 | g114081 | i0 | 99.415 | 100 | 171 | 1 | 100 | 0 | 1 | 171 | 19 | 189 | Debaryomyces hansenii isolate 3-9 large subunit ribosomal RNA gene, partial sequence | blastn | 17100 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 26160829 | 26160829 | PRJEB7614a_S_NODE_42629_length_290_cov_18.976471_g41425_i0 | PRJEB7614 | 42629 | 290 | 18.976471 | 55.0317659 | Aspergillus | 5052 | Fungi | Fungi | 514 | 2.85e-141 | NTclustered | gi|950805266|gb|KT200312.1| | 246267 | g41425 | i0 | 98.621 | 100.013793103448 | 290 | 4 | 100 | 0 | 1 | 290 | 31 | 320 | Uncultured Aspergillus clone K-203-14-19 28S ribosomal RNA gene, complete sequence | blastn | 29004 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | uncultured Aspergillus | ||
| 26160832 | 26160832 | PRJEB7614a_S_NODE_58869_length_251_cov_1.324074_g57665_i0 | PRJEB7614 | 58869 | 251 | 1.324074 | 3.32342574 | Plenodomus | 118259 | Fungi | Fungi | 111 | 3.7e-20 | NTclustered | gi|702068343|emb|FO906979.1| | 225338 | g57665 | i0 | 85.185 | 10.9402390438247 | 108 | 16 | 43 | 0 | 80 | 187 | 56690 | 56797 | Leptosphaeria maculans brassicae wa74_scaffold00107 complete sequence | blastn | 2746 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus biglobosus | |
| 26160840 | 26160840 | PRJEB7614a_S_NODE_91533_length_196_cov_30.490683_g90329_i0 | PRJEB7614 | 91533 | 196 | 30.490683 | 59.76173868 | Pleosporaceae | 28556 | Fungi | Fungi | 363 | 6.899999999999998e-96 | NTclustered | gi|2089999217|gb|OK036399.1| | 48100 | g90329 | i0 | 100 | 100 | 196 | 0 | 100 | 0 | 1 | 196 | 344 | 149 | Alternaria solani isolate AHaAsL large subunit ribosomal RNA gene, partial sequence | blastn | 19600 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria solani | |
| 26160852 | 26160852 | PRJEB7614d_S_NODE_2621_length_167_cov_3.446970_g2583_i0 | PRJEB7614 | 2621 | 167 | 3.44697 | 5.7564399 | root | 1 | Root_unresolved | Root_unresolved | 309 | 7.53e-80 | NTclustered | gi|358001635|gb|JN938999.1| | 5054 | g2583 | i0 | 100 | 100 | 167 | 0 | 100 | 0 | 1 | 167 | 718 | 552 | Eurotium amstelodami strain DAOM 222011 18S ribosomal RNA (SSU) gene, partial sequence | blastn | 16700 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus amstelodami | |
| 26160853 | 26160853 | PRJEB7614d_S_NODE_3733_length_156_cov_4.933884_g3695_i0 | PRJEB7614 | 3733 | 156 | 4.933884 | 7.69685904 | Eurotiales | 5042 | Fungi | Fungi | 289 | 9e-74 | NTclustered | gi|2043739121|gb|MZ267247.1| | 5059 | g3695 | i0 | 100 | 100 | 156 | 0 | 100 | 0 | 1 | 156 | 873 | 718 | Aspergillus flavus strain 3 small subunit ribosomal RNA gene, partial sequence | blastn | 15600 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus flavus | |
| 26432616 | 26432616 | PRJEB7614a_S_NODE_81239_length_210_cov_48.771429_g80035_i0 | PRJEB7614 | 81239 | 210 | 48.771429 | 102.4200009 | Fungi | 4751 | Fungi | Fungi | 331 | 2.11e-86 | NTclustered | gi|2413839487|gb|OQ048530.1| | 4959 | g80035 | i0 | 100 | 85.2380952380952 | 179 | 0 | 85 | 0 | 1 | 179 | 110 | 288 | Saccharomyces hansenii strain 1_10_31.9 large subunit ribosomal RNA gene, partial sequence | blastn | 17900 | 331 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 26432647 | 26432647 | PRJEB7614e_S_NODE_24159_length_163_cov_20.695312_g24151_i0 | PRJEB7614 | 24159 | 163 | 20.695312 | 33.73335856 | Saccharomyces | 4930 | Fungi | Fungi | 291 | 2.64e-74 | NTclustered | gi|2161760974|gb|OL763550.1| | 4932 | g24151 | i0 | 98.773 | 100 | 163 | 2 | 100 | 0 | 1 | 163 | 277 | 115 | Saccharomyces cerevisiae clone S5-19 large subunit ribosomal RNA gene, partial sequence | blastn | 16300 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 26432654 | 26432654 | PRJEB7614e_S_NODE_8127_length_177_cov_3.105634_g8119_i0 | PRJEB7614 | 8127 | 177 | 3.105634 | 5.49697218 | root | 1 | Root_unresolved | Root_unresolved | 278 | 2.27e-70 | NTclustered | gi|358001635|gb|JN938999.1| | 5054 | g8119 | i0 | 100 | 84.774011299435 | 150 | 0 | 85 | 0 | 1 | 150 | 555 | 704 | Eurotium amstelodami strain DAOM 222011 18S ribosomal RNA (SSU) gene, partial sequence | blastn | 15005 | 279 | 0.996415770609319 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus amstelodami | |
| 26478293 | 26478293 | PRJEB7614a_S_NODE_98592_length_188_cov_3.509804_g97388_i0 | PRJEB7614 | 98592 | 188 | 3.509804 | 6.59843152 | Ophiostoma torulosum | 96403 | Fungi | Fungi | 303 | 4.03e-78 | NTclustered | gi|325513885|gb|HQ343317.1| | 96403 | g97388 | i0 | 100 | 83.8989361702128 | 164 | 0 | 87 | 0 | 25 | 188 | 3298 | 3135 | Ophiostoma torulosum strain CBS 730.71 small subunit ribosomal RNA gene, complete sequence; and reverse transcriptase and double motif LAGLIDADG homing endonuclease genes, complete cds; mitochondrial | blastn | 15773 | 303 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma torulosum | |
| 26568602 | 26568602 | PRJEB7614a_S_NODE_119808_length_167_cov_2.946970_g118604_i0 | PRJEB7614 | 119808 | 167 | 2.94697 | 4.9214399 | Ascomycota | 4890 | Fungi | Fungi | 298 | 1.63e-76 | NTclustered | gi|116267509|dbj|AB278178.1| | 65418 | g118604 | i0 | 99.39 | 98.2035928143713 | 164 | 1 | 98 | 0 | 1 | 164 | 219 | 382 | Phaeoacremonium angustius gene for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: CBS 249.95 | blastn | 16400 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Togniniales | Togniniaceae | Phaeoacremonium | Phaeoacremonium angustius | |
| 26568633 | 26568633 | PRJEB7614b_S_NODE_680_length_242_cov_19.072464_g678_i0 | PRJEB7614 | 680 | 242 | 19.072464 | 46.15536288 | Saccharomyces | 4930 | Fungi | Fungi | 416 | 6.709999999999999e-112 | NTclustered | gi|2161760974|gb|OL763550.1| | 4932 | g678 | i0 | 100 | 92.9752066115702 | 225 | 0 | 93 | 0 | 1 | 225 | 276 | 52 | Saccharomyces cerevisiae clone S5-19 large subunit ribosomal RNA gene, partial sequence | blastn | 22500 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 26568653 | 26568653 | PRJEB7614e_S_NODE_9896_length_174_cov_5.827338_g9888_i0 | PRJEB7614 | 9896 | 174 | 5.827338 | 10.13956812 | Dothideales | 5014 | Fungi | Fungi | 292 | 7.92e-75 | NTclustered | gi|28628121|gb|AY167611.1| | 219285 | g9888 | i0 | 100 | 90.4885057471264 | 158 | 0 | 91 | 0 | 17 | 174 | 24 | 181 | Aureobasidium sp. CECT 11965 28S ribosomal RNA gene, partial sequence | blastn | 15745 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium sp. CECT 11965 |
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);;