contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJDB14274" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8540 | 8540 | PRJDB14274_S_NODE_10461_length_193_cov_5.340909_g10383_i0 | PRJDB14274 | 10461 | 193 | 5.340909 | 10.30795437 | Aplosporella prunicola | 462254 | Fungi | Fungi | 174 | 3.4e-39 | NTclustered | gi|1832928858|ref|XM_033541314.1| | 1176127 | g10383 | i0 | 86.624 | 48.4766839378238 | 157 | 21 | 81 | 0 | 1 | 157 | 892 | 736 | Aplosporella prunicola CBS 121167 uncharacterized protein (K452DRAFT_292161), mRNA | blastn | 9356 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Aplosporellaceae | Aplosporella | Aplosporella prunicola | |
| 2558411 | 2558411 | PRJDB14274_S_NODE_3383_length_333_cov_6.794118_g3305_i0 | PRJDB14274 | 3383 | 333 | 6.794118 | 22.62441294 | Talaromyces atroroseus | 1441469 | Fungi | Fungi | 52.8 | 0.031 | NTclustered | gi|1147823063|ref|XM_020267415.1| | 1441469 | g3305 | i0 | 100 | 0.0840840840840841 | 28 | 0 | 8 | 0 | 169 | 196 | 2038 | 2065 | Talaromyces atroroseus hypothetical protein (UA08_05127), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces atroroseus | |
| 3531593 | 3531593 | PRJDB14274_S_NODE_4223_length_300_cov_2.832636_g4145_i0 | PRJDB14274 | 4223 | 300 | 2.832636 | 8.497908 | Ascomycota | 4890 | Fungi | Fungi | 254 | 7.13e-63 | NTclustered | gi|2741349244|ref|XM_018318905.2| | 33203 | g4145 | i0 | 83.456 | 80.28 | 272 | 45 | 91 | 0 | 1 | 272 | 727 | 998 | Purpureocillium lilacinum 26S proteasome regulatory subunit 6B (PLICBS_005243), partial mRNA | blastn | 24084 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 3834728 | 3834728 | PRJDB14274_S_NODE_4284_length_298_cov_1.894515_g4206_i0 | PRJDB14274 | 4284 | 298 | 1.894515 | 5.6456547 | Debaryomyces hansenii | 4959 | Fungi | Fungi | 182 | 3.39e-41 | NTclustered | gi|294655715|ref|XM_457899.2| | 284592 | g4206 | i0 | 87.821 | 14.255033557047 | 156 | 18 | 52 | 1 | 5 | 159 | 247 | 402 | Debaryomyces hansenii CBS767 60S ribosomal protein L23 (DEHA2C04884g), partial mRNA | blastn | 4248 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 4808880 | 4808880 | PRJDB14274_S_NODE_2284_length_404_cov_1.670554_g2206_i0 | PRJDB14274 | 2284 | 404 | 1.670554 | 6.74903816 | Opisthokonta | 33154 | Fungi | Fungi | 52.8 | 0.039 | NTclustered | gi|2623289206|ref|XM_001523305.2| | 36914 | g2206 | i0 | 100 | 0.207920792079208 | 28 | 0 | 7 | 0 | 68 | 95 | 212 | 239 | Lodderomyces elongisporus uncharacterized protein (PVL30_005107), partial mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Lodderomyces | Lodderomyces elongisporus | |
| 5110967 | 5110967 | PRJDB14274_S_NODE_2665_length_375_cov_1.649682_g2587_i0 | PRJDB14274 | 2665 | 375 | 1.649682 | 6.1863075 | Scheffersomyces coipomensis | 1788519 | Fungi | Fungi | 87.9 | 9.78e-13 | NTclustered | gi|2725183374|ref|XM_064904753.1| | 1788519 | g2587 | i0 | 73.991 | 1.064 | 223 | 54 | 59 | 4 | 20 | 240 | 269 | 49 | Scheffersomyces coipomensis ras family-domain-containing protein (DFJ63DRAFT_283952), partial mRNA | blastn | 399 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces coipomensis | |
| 6386846 | 6386846 | PRJDB14274_S_NODE_4606_length_289_cov_1.078947_g4528_i0 | PRJDB14274 | 4606 | 289 | 1.078947 | 3.11815683 | Aplosporella prunicola | 462254 | Fungi | Fungi | 58.4 | 5.75e-4 | NTclustered | gi|1832874043|ref|XM_033542794.1| | 1176127 | g4528 | i0 | 94.595 | 4.37024221453287 | 37 | 2 | 13 | 0 | 94 | 130 | 2147 | 2183 | Aplosporella prunicola CBS 121167 uncharacterized protein (K452DRAFT_304184), partial mRNA | blastn | 1263 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Aplosporellaceae | Aplosporella | Aplosporella prunicola | |
| 7660875 | 7660875 | PRJDB14274_S_NODE_8647_length_216_cov_1.206452_g8569_i0 | PRJDB14274 | 8647 | 216 | 1.206452 | 2.60593632 | Parathielavia appendiculata | 2587402 | Fungi | Fungi | 52.8 | 0.019 | NTclustered | gi|2669754473|ref|XM_062796346.1| | 2587402 | g8569 | i0 | 100 | 0.12962962962963 | 28 | 0 | 13 | 0 | 59 | 86 | 3944 | 3971 | Parathielavia appendiculata uncharacterized protein (N657DRAFT_681062), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Parathielavia | Parathielavia appendiculata | |
| 8935542 | 8935542 | PRJDB14274_S_NODE_6488_length_248_cov_1.005348_g6410_i0 | PRJDB14274 | 6488 | 248 | 1.005348 | 2.49326304 | Wickerhamiella sorbophila | 45607 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1383773519|ref|XM_024808067.1| | 45607 | g6410 | i0 | 100 | 0.120967741935484 | 30 | 0 | 12 | 0 | 181 | 210 | 955 | 984 | [Candida] sorbophila hypothetical protein (B9G98_01509), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella sorbophila | |
| 10211402 | 10211402 | PRJDB14274_S_NODE_1869_length_444_cov_1.765013_g1791_i0 | PRJDB14274 | 1869 | 444 | 1.765013 | 7.83665772 | Saccharomyces paradoxus | 27291 | Fungi | Fungi | 267 | 1.4099999999999998e-66 | NTclustered | gi|2087953814|gb|CP081976.1| | 27291 | g1791 | i0 | 81.571 | 67.1261261261261 | 331 | 53 | 74 | 8 | 21 | 347 | 58098 | 58424 | Mutant Saccharomyces paradoxus strain 337 chromosome X genomic sequence | blastn | 29804 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces paradoxus | |
| 11486449 | 11486449 | PRJDB14274_S_NODE_2650_length_376_cov_1.904762_g2572_i0 | PRJDB14274 | 2650 | 376 | 1.904762 | 7.16190512 | Aspergillus aculeatinus | 487661 | Fungi | Fungi | 65.8 | 4.6e-6 | NTclustered | gi|1419179680|ref|XM_025645514.1| | 1448322 | g2572 | i0 | 90 | 9.39095744680851 | 50 | 5 | 13 | 0 | 293 | 342 | 860 | 811 | Aspergillus aculeatinus CBS 121060 putative DEAH-box RNA helicase (BO66DRAFT_372839), partial mRNA | blastn | 3531 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus aculeatinus | |
| 12460140 | 12460140 | PRJDB14274_S_NODE_3690_length_319_cov_2.368217_g3612_i0 | PRJDB14274 | 3690 | 319 | 2.368217 | 7.55461223 | Debaryomycetaceae | 766764 | Fungi | Fungi | 113 | 1.35e-20 | NTclustered | gi|2083595464|ref|XM_043191105.1| | 45513 | g3612 | i0 | 85.981 | 17.1724137931034 | 107 | 13 | 33 | 2 | 61 | 166 | 51 | 156 | Scheffersomyces spartinae 60S ribosomal protein L39 (RPL39), partial mRNA | blastn | 5478 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces spartinae | |
| 12460143 | 12460143 | PRJDB14274_S_NODE_5630_length_264_cov_1.261084_g5552_i0 | PRJDB14274 | 5630 | 264 | 1.261084 | 3.32926176 | Emericellopsis | 45244 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|2185272212|ref|XM_046264273.1| | 2614577 | g5552 | i0 | 100 | 0.553030303030303 | 29 | 0 | 11 | 0 | 54 | 82 | 793 | 765 | Emericellopsis atlantica surfeit locus protein 6-domain-containing protein (F5Z01DRAFT_667204), mRNA | blastn | 146 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Emericellopsis | Emericellopsis atlantica | |
| 15310645 | 15310645 | PRJDB14274_S_NODE_4993_length_278_cov_5.165899_g4915_i0 | PRJDB14274 | 4993 | 278 | 5.165899 | 14.36119922 | Exophiala mesophila | 212818 | Fungi | Fungi | 108 | 5.38e-19 | NTclustered | gi|1022628013|ref|XM_016367627.1| | 212818 | g4915 | i0 | 88.043 | 2.37410071942446 | 92 | 9 | 33 | 2 | 188 | 278 | 886 | 796 | Exophiala mesophila polyubiquitin (PV10_03207), mRNA | blastn | 660 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala mesophila | |
| 16585385 | 16585385 | PRJDB14274_S_NODE_7794_length_227_cov_1.909639_g7716_i0 | PRJDB14274 | 7794 | 227 | 1.909639 | 4.33488053 | Penicillium atrosanguineum | 1132637 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2514940631|ref|XM_056880616.1| | 1132637 | g7716 | i0 | 100 | 0.13215859030837 | 30 | 0 | 13 | 0 | 78 | 107 | 1803 | 1774 | Penicillium atrosanguineum alpha/beta hydrolase fold domain-containing protein (N7443_000560), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium atrosanguineum | |
| 16585387 | 16585387 | PRJDB14274_S_NODE_8334_length_220_cov_1.213836_g8256_i0 | PRJDB14274 | 8334 | 220 | 1.213836 | 2.6704392 | Kluyveromyces marxianus | 4911 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1255181638|ref|XM_022818103.1| | 1003335 | g8256 | i0 | 97.059 | 1.04545454545455 | 34 | 0 | 15 | 1 | 97 | 129 | 514 | 481 | Kluyveromyces marxianus DMKU3-1042 RFX-like DNA-binding protein RFX1 (KLMA_20481), partial mRNA | blastn | 230 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kluyveromyces | Kluyveromyces marxianus | |
| 17558870 | 17558870 | PRJDB14274_S_NODE_5554_length_265_cov_2.544118_g5476_i0 | PRJDB14274 | 5554 | 265 | 2.544118 | 6.7419127 | Eukaryota | 2759 | Fungi | Fungi | 490 | 4.3299999999999986e-134 | NTclustered | gi|514829572|gb|KC771883.1| | 4929 | g5476 | i0 | 100 | 82.8981132075472 | 265 | 0 | 100 | 0 | 1 | 265 | 35 | 299 | Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence | blastn | 21968 | 490 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 17860379 | 17860379 | PRJDB14274_S_NODE_2415_length_393_cov_2.051205_g2337_i0 | PRJDB14274 | 2415 | 393 | 2.051205 | 8.06123565 | Cordyceps fumosorosea | 114497 | Fungi | Fungi | 52.8 | 0.038 | NTclustered | gi|1089717561|ref|XM_018844909.1| | 1081104 | g2337 | i0 | 100 | 0.0712468193384224 | 28 | 0 | 7 | 0 | 209 | 236 | 431 | 458 | Isaria fumosorosea ARSEF 2679 hypothetical protein (ISF_01302), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Cordyceps | Cordyceps fumosorosea | |
| 20107486 | 20107486 | PRJDB14274_S_NODE_256_length_1115_cov_40.163188_g222_i0 | PRJDB14274 | 256 | 1115 | 40.163188 | 447.8195462 | Opisthokonta | 33154 | Fungi | Fungi | 58.4 | 0.002 | NTclustered | gi|366987818|ref|XM_003673628.1| | 27288 | g222 | i0 | 100 | 0.573991031390135 | 31 | 0 | 3 | 0 | 796 | 826 | 1199 | 1229 | Naumovozyma castellii uncharacterized protein (NCAS0A07370), partial mRNA | blastn | 640 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Naumovozyma | Naumovozyma castellii | |
| 24234404 | 24234404 | PRJDB14274_S_NODE_2300_length_403_cov_1.894737_g2222_i0 | PRJDB14274 | 2300 | 403 | 1.894737 | 7.63579011 | Pseudocercospora fijiensis | 1873960 | Fungi | Fungi | 60.2 | 2.31e-4 | NTclustered | gi|631388285|ref|XM_007930332.1| | 383855 | g2222 | i0 | 94.737 | 0.0942928039702233 | 38 | 2 | 9 | 0 | 217 | 254 | 592 | 629 | Pseudocercospora fijiensis CIRAD86 uncharacterized protein (MYCFIDRAFT_166063), mRNA | blastn | 38 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fijiensis |
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);;