contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA675331" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1923815 | 1923815 | PRJNA675331_P_NODE_13722_length_277_cov_2.176471_g13550_i0 | PRJNA675331 | 13722 | 277 | 2.176471 | 6.02882467 | Brettanomyces bruxellensis | 5007 | Fungi | Fungi | 135 | 2.46e-27 | NTclustered | gi|2033704597|ref|XM_041283357.1| | 5007 | g13550 | i0 | 94.318 | 24.1696750902527 | 88 | 5 | 32 | 0 | 190 | 277 | 4 | 91 | Brettanomyces bruxellensis actin (ACT1), partial mRNA | blastn | 6695 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Brettanomyces | Brettanomyces bruxellensis | |
| 2443887 | 2443887 | PRJNA675331_P_NODE_5522_length_408_cov_1.149254_g5350_i0 | PRJNA675331 | 5522 | 408 | 1.149254 | 4.68895632 | Trichoderma | 5543 | Fungi | Fungi | 219 | 3.649999999999999e-52 | NTclustered | gi|2749670612|ref|XM_014083725.2| | 63577 | g5350 | i0 | 79.027 | 80.2205882352941 | 329 | 61 | 80 | 8 | 59 | 383 | 714 | 390 | Trichoderma atroviride 40S ribosomal protein uS7 (TrAtP1_004094), mRNA | blastn | 32730 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 3198669 | 3198669 | PRJNA675331_P_NODE_21383_length_245_cov_1.343023_g21211_i0 | PRJNA675331 | 21383 | 245 | 1.343023 | 3.29040635 | Apiospora phragmitis | 2905665 | Fungi | Fungi | 145 | 3.5499999999999996e-30 | NTclustered | gi|2781373544|ref|XM_066854220.1| | 2905665 | g21211 | i0 | 81.421 | 9.06530612244898 | 183 | 29 | 73 | 3 | 66 | 244 | 1106 | 925 | Apiospora phragmitis adenosylhomocysteinase (PG994_002811), partial mRNA | blastn | 2221 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora phragmitis | |
| 4475765 | 4475765 | PRJNA675331_P_NODE_21804_length_245_cov_0.895349_g21632_i0 | PRJNA675331 | 21804 | 245 | 0.895349 | 2.19360505 | Penicillium citrinum | 5077 | Fungi | Fungi | 58.4 | 4.75e-4 | NTclustered | gi|2513264109|ref|XM_056646852.1| | 5077 | g21632 | i0 | 100 | 0.6 | 31 | 0 | 13 | 0 | 5 | 35 | 641 | 611 | Penicillium citrinum uncharacterized protein (N7469_007934), partial mRNA | blastn | 147 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium citrinum | |
| 7546434 | 7546434 | PRJNA675331_P_NODE_2966_length_540_cov_3.528908_g2798_i0 | PRJNA675331 | 2966 | 540 | 3.528908 | 19.0561032 | Aspergillus | 5052 | Fungi | Fungi | 294 | 7.99e-75 | NTclustered | gi|1799801859|ref|XM_032071244.1| | 61420 | g2798 | i0 | 83.082 | 57.6407407407407 | 331 | 49 | 61 | 5 | 202 | 530 | 326 | 1 | Aspergillus caelatus ubiquitin-related domain-containing protein (BDV27DRAFT_150612), partial mRNA | blastn | 31126 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus caelatus | |
| 8821534 | 8821534 | PRJNA675331_P_NODE_12467_length_288_cov_1.288372_g12295_i0 | PRJNA675331 | 12467 | 288 | 1.288372 | 3.71051136 | Penicillium | 5073 | Fungi | Fungi | 182 | 3.26e-41 | NTclustered | gi|2554113666|ref|XM_058509721.1| | 5083 | g12295 | i0 | 84.211 | 66.2013888888889 | 190 | 26 | 65 | 4 | 60 | 247 | 443 | 256 | Penicillium canescens uncharacterized protein (N7446_000954), partial mRNA | blastn | 19066 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium canescens | |
| 10097205 | 10097205 | PRJNA675331_P_NODE_18428_length_251_cov_0.865169_g18256_i0 | PRJNA675331 | 18428 | 251 | 0.865169 | 2.17157419 | Bipolaris | 33194 | Fungi | Fungi | 152 | 2.18e-32 | NTclustered | gi|628236149|ref|XM_007719019.1| | 930089 | g18256 | i0 | 84.076 | 3.86852589641434 | 157 | 25 | 63 | 0 | 59 | 215 | 488 | 644 | Bipolaris zeicola 26-R-13 uncharacterized protein (COCCADRAFT_109038), partial mRNA | blastn | 971 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Bipolaris | Bipolaris zeicola | |
| 18499969 | 18499969 | PRJNA675331_P_NODE_10675_length_307_cov_0.970085_g10503_i0 | PRJNA675331 | 10675 | 307 | 0.970085 | 2.97816095 | Candida dubliniensis | 42374 | Fungi | Fungi | 263 | 1.22e-65 | NTclustered | gi|241955061|ref|XM_002420207.1| | 573826 | g10503 | i0 | 82.372 | 8.92182410423453 | 312 | 45 | 100 | 9 | 1 | 307 | 1224 | 918 | Candida dubliniensis CD36 flavoprotein subunit of succinate dehydrogenase, putative (CD36_46090), partial mRNA | blastn | 2739 | 263 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida dubliniensis | |
| 18500034 | 18500034 | PRJNA675331_P_NODE_21175_length_246_cov_0.890173_g21003_i0 | PRJNA675331 | 21175 | 246 | 0.890173 | 2.18982558 | Debaryomyces hansenii | 4959 | Fungi | Fungi | 394 | 3.2e-105 | NTclustered | gi|294655681|ref|XM_457855.2| | 284592 | g21003 | i0 | 95.528 | 2 | 246 | 11 | 100 | 0 | 1 | 246 | 1008 | 1253 | Debaryomyces hansenii CBS767 DEHA2C03938p (DEHA2C03938g), partial mRNA | blastn | 492 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 19020247 | 19020247 | PRJNA675331_P_NODE_10775_length_306_cov_0.991416_g10603_i0 | PRJNA675331 | 10775 | 306 | 0.991416 | 3.03373296 | Candida | 5475 | Fungi | Fungi | 361 | 4.17e-95 | NTclustered | gi|1143187|gb|U32627.1|CAU32627 | 5476 | g10603 | i0 | 87.908 | 220.346405228758 | 306 | 37 | 100 | 0 | 1 | 306 | 663 | 358 | Candida albicans ubiquitin precursor (CaUBI1) mRNA, complete cds | blastn | 67426 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida albicans | |
| 19774578 | 19774578 | PRJNA675331_P_NODE_13956_length_276_cov_1.137931_g13784_i0 | PRJNA675331 | 13956 | 276 | 1.137931 | 3.14068956 | Colletotrichum spaethianum | 700344 | Fungi | Fungi | 180 | 1.1199999999999999e-40 | NTclustered | gi|2272183197|ref|XM_049266292.1| | 700344 | g13784 | i0 | 78.889 | 11.6884057971014 | 270 | 53 | 97 | 4 | 1 | 268 | 620 | 887 | Colletotrichum spaethianum aconitate hydratase, mitochondrial (ColSpa_00080), partial mRNA | blastn | 3226 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum spaethianum | |
| 21050320 | 21050320 | PRJNA675331_P_NODE_3317_length_513_cov_1.768182_g3147_i0 | PRJNA675331 | 3317 | 513 | 1.768182 | 9.07077366 | Debaryomyces fabryi | 58627 | Fungi | Fungi | 278 | 7.610000000000001e-70 | NTclustered | gi|998531938|ref|XM_015610877.1| | 58627 | g3147 | i0 | 80.376 | 45.8654970760234 | 372 | 67 | 72 | 6 | 11 | 379 | 412 | 44 | Debaryomyces fabryi 40S ribosomal protein S14-A (AC631_02047), partial mRNA | blastn | 23529 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces fabryi | |
| 22845923 | 22845923 | PRJNA675331_P_NODE_10218_length_312_cov_1.288703_g10046_i0 | PRJNA675331 | 10218 | 312 | 1.288703 | 4.02075336 | Fungi | 4751 | Fungi | Fungi | 52.8 | 0.029 | NTclustered | gi|2185479718|ref|XM_046187174.1| | 48865 | g10046 | i0 | 96.774 | 0.378205128205128 | 31 | 1 | 10 | 0 | 181 | 211 | 2141 | 2171 | Fusarium redolens fungal-specific transcription factor domain-containing protein (BKA55DRAFT_505303), partial mRNA | blastn | 118 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium redolens | |
| 23600508 | 23600508 | PRJNA675331_P_NODE_11259_length_300_cov_1.352423_g11087_i0 | PRJNA675331 | 11259 | 300 | 1.352423 | 4.057269 | Huiozyma naganishii | 588726 | Fungi | Fungi | 158 | 5.75e-34 | NTclustered | gi|1247057376|ref|XM_022611070.1| | 1071383 | g11087 | i0 | 77.113 | 43.1466666666667 | 284 | 57 | 93 | 8 | 6 | 285 | 886 | 607 | Huiozyma naganishii CBS 8797 uncharacterized protein (KNAG0M02060), partial mRNA | blastn | 12944 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Huiozyma | Huiozyma naganishii | |
| 24120443 | 24120443 | PRJNA675331_P_NODE_10039_length_314_cov_1.614108_g9867_i0 | PRJNA675331 | 10039 | 314 | 1.614108 | 5.06829912 | Candida | 5475 | Fungi | Fungi | 377 | 4.27e-100 | NTclustered | gi|5823596|emb|AJ236897.1| | 42374 | g9867 | i0 | 88.889 | 98.7579617834395 | 306 | 34 | 97 | 0 | 9 | 314 | 1117 | 812 | Candida dubliniensis ACT1 gene, exons 1-2 | blastn | 31010 | 377 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida dubliniensis |
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);;