contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15683722 | 15683722 | PRJNA315314_S_NODE_8473_length_278_cov_3.746988_g8152_i0 | PRJNA315314 | 8473 | 278 | 3.746988 | 10.41662664 | Fungi | 4751 | Fungi | Fungi | 187 | 4.51e-59 | NR | NP_595283.1 | 4896 | g8152 | i0 | 92.3 | 69.7446043165468 | 91 | 7 | 98.2 | 0 | 273 | 1 | 1 | 91 | NP_595283.1 ubiquitin-conjugating enzyme Ubc4 [Schizosaccharomyces pombe] | diamond | 19389 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 24606891 | 24606891 | PRJNA315314_S_NODE_2140_length_537_cov_7.354331_g1853_i0 | PRJNA315314 | 2140 | 537 | 7.354331 | 39.49275747 | Akanthomyces muscarius | 2231603 | Fungi | Fungi | 187 | 8.499999999999998e-56 | NR | XP_056059216.1 | 2231603 | g1853 | i0 | 81.6 | 5.05027932960894 | 114 | 21 | 63.7 | 0 | 194 | 535 | 45 | 158 | XP_056059216.1 hypothetical protein LMH87_005978 [Akanthomyces muscarius] | diamond | 2712 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Akanthomyces | Akanthomyces muscarius | |
| 24607095 | 24607095 | PRJNA315314_S_NODE_4000_length_399_cov_5.483784_g3679_i0 | PRJNA315314 | 4000 | 399 | 5.483784 | 21.88029816 | Saitoella complicata NRRL Y-178 | 5606 | Fungi | Fungi | 186 | 5.499999999999999e-58 | NR | XP_019025300.1 | 698492 | g3679 | i0 | 66.4 | 2.88721804511278 | 128 | 43 | 96.2 | 0 | 399 | 16 | 24 | 151 | XP_019025300.1 nucleoside diphosphate kinase [Saitoella complicata NRRL Y-17804] | diamond | 1152 | 186 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 27313328 | 27313328 | PRJNA315314_S_NODE_7483_length_295_cov_2.473684_g7162_i0 | PRJNA315314 | 7483 | 295 | 2.473684 | 7.2973678 | Sordariomycetes | 147550 | Fungi | Fungi | 106 | 1.26e-26 | NR | KAJ9157848.1 | 41990 | g7162 | i0 | 60.4 | 7.73898305084746 | 96 | 37 | 97.6 | 1 | 290 | 3 | 13 | 107 | KAJ9157848.1 60S ribosomal protein L18 [Pleurostoma richardsiae] | diamond | 2283 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Calosphaeriales | Pleurostomataceae | Pleurostoma | Pleurostoma richardsiae | |
| 27485196 | 27485196 | PRJNA315314_S_NODE_6923_length_307_cov_4.625899_g6602_i0 | PRJNA315314 | 6923 | 307 | 4.625899 | 14.20150993 | Emericellopsis atlantica | 2614577 | Fungi | Fungi | 60.1 | 4.22e-8 | NR | XP_046113280.1 | 2614577 | g6602 | i0 | 36.2 | 0.9185667752443 | 94 | 53 | 87.9 | 3 | 32 | 301 | 64 | 154 | XP_046113280.1 uncharacterized protein F5Z01DRAFT_669462 [Emericellopsis atlantica] | diamond | 282 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Emericellopsis | Emericellopsis atlantica | |
| 27818588 | 27818588 | PRJNA315314_S_NODE_30544_length_154_cov_1.336000_g30223_i0 | PRJNA315314 | 30544 | 154 | 1.336 | 2.05744 | Ascomycota | 4890 | Fungi | Fungi | 79 | 1.83e-15 | NR | KAI5808910.1 | 61495 | g30223 | i0 | 73.5 | 6.68181818181818 | 49 | 13 | 95.5 | 0 | 6 | 152 | 254 | 302 | KAI5808910.1 putative D-xylulose 5-phosphate/D-fructose 6-phosphate phosphoketolase [Peziza echinospora] | diamond | 1029 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pezizaceae | Peziza | Peziza echinospora | |
| 27990419 | 27990419 | PRJNA315314_S_NODE_14585_length_214_cov_2.470270_g14264_i0 | PRJNA315314 | 14585 | 214 | 2.47027 | 5.2863778 | Bathelium mastoideum | 2939407 | Fungi | Fungi | 96.7 | 2.4e-21 | NR | KAI9675462.1 | 2939407 | g14264 | i0 | 57.7 | 8.84579439252336 | 71 | 30 | 99.5 | 0 | 2 | 214 | 373 | 443 | KAI9675462.1 MAG: hypothetical protein M1822_008940 [Bathelium mastoideum] | diamond | 1893 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Trypetheliales | Trypetheliaceae | Bathelium | Bathelium mastoideum | |
| 28923355 | 28923355 | PRJNA315314_S_NODE_14548_length_214_cov_3.518919_g14227_i0 | PRJNA315314 | 14548 | 214 | 3.518919 | 7.53048666 | Ascomycota | 4890 | Fungi | Fungi | 41.6 | 0.0111 | NR | KOS36149.1 | 229535 | g14227 | i0 | 61.3 | 1.73831775700935 | 31 | 12 | 43.5 | 0 | 121 | 213 | 1 | 31 | KOS36149.1 hypothetical protein ACN38_g13142 [Penicillium nordicum] | diamond | 372 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium nordicum | |
| 29001058 | 29001058 | PRJNA315314_S_NODE_29948_length_155_cov_2.055556_g29627_i0 | PRJNA315314 | 29948 | 155 | 2.055556 | 3.1861118 | Lipomyces doorenjongii | 383834 | Fungi | Fungi | 63.5 | 1.38e-10 | NR | KAK9350384.1 | 383834 | g29627 | i0 | 50 | 0.929032258064516 | 48 | 23 | 92.9 | 1 | 153 | 10 | 132 | 178 | KAK9350384.1 hypothetical protein V1523DRAFT_420004 [Lipomyces doorenjongii] | diamond | 144 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces doorenjongii | |
| 29221887 | 29221887 | PRJNA315314_S_NODE_15089_length_210_cov_10.651934_g14768_i0 | PRJNA315314 | 15089 | 210 | 10.651934 | 22.3690614 | Xylariaceae sp. FL | 1881983 | Fungi | Fungi | 55.5 | 2.05e-7 | NR | KAI0480359.1 | 2663375 | g14768 | i0 | 49.2 | 0.871428571428571 | 61 | 29 | 87.1 | 1 | 189 | 7 | 9 | 67 | KAI0480359.1 60S ribosomal protein L28 [Xylariaceae sp. FL0804] | diamond | 183 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylariaceae sp. FL0804 | ||
| 29523392 | 29523392 | PRJNA315314_S_NODE_5970_length_330_cov_5.803987_g5649_i0 | PRJNA315314 | 5970 | 330 | 5.803987 | 19.1531571 | Clavispora | 36910 | Fungi | Fungi | 53.5 | 1.36e-5 | NR | QFZ28931.1 | 36911 | g5649 | i0 | 47.7 | 1.56363636363636 | 86 | 44 | 78.2 | 1 | 73 | 330 | 39 | 123 | QFZ28931.1 hypothetical protein EJF14_50149 [Clavispora lusitaniae] | diamond | 516 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Clavispora | Clavispora lusitaniae | |
| 29726619 | 29726619 | PRJNA315314_S_NODE_19610_length_186_cov_8.171975_g19289_i0 | PRJNA315314 | 19610 | 186 | 8.171975 | 15.1998735 | Penicillium malachiteum | 1324776 | Fungi | Fungi | 44.3 | 0.00285 | NR | KAJ5710222.1 | 1324776 | g19289 | i0 | 65.5 | 0.903225806451613 | 29 | 10 | 46.8 | 0 | 132 | 46 | 97 | 125 | KAJ5710222.1 hypothetical protein N7493_009389 [Penicillium malachiteum] | diamond | 168 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium malachiteum | |
| 30408107 | 30408107 | PRJNA315314_S_NODE_28733_length_158_cov_1.069767_g28412_i0 | PRJNA315314 | 28733 | 158 | 1.069767 | 1.69023186 | Fungi | 4751 | Fungi | Fungi | 43.9 | 0.00457 | NR | GES65560.1 | 33178 | g28412 | i0 | 48.8 | 3.37974683544304 | 41 | 21 | 77.8 | 0 | 34 | 156 | 140 | 180 | GES65560.1 hypothetical protein ATETN484_0012046500 [Aspergillus terreus] | diamond | 534 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus terreus | |
| 30422276 | 30422276 | PRJNA315314_S_NODE_13533_length_222_cov_1.373057_g13212_i0 | PRJNA315314 | 13533 | 222 | 1.373057 | 3.04818654 | Cylindrodendrum hubeiense | 595255 | Fungi | Fungi | 47.8 | 4.7e-4 | NR | KAF7552319.1 | 595255 | g13212 | i0 | 34.7 | 1.5 | 72 | 46 | 97.3 | 1 | 220 | 5 | 392 | 462 | KAF7552319.1 hypothetical protein G7Z17_g4387 [Cylindrodendrum hubeiense] | diamond | 333 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Cylindrodendrum | Cylindrodendrum hubeiense | |
| 30832600 | 30832600 | PRJNA315314_S_NODE_21214_length_180_cov_1.880795_g20893_i0 | PRJNA315314 | 21214 | 180 | 1.880795 | 3.385431 | Gaeumannomyces tritici R3-111a-1 | 644352 | Fungi | Fungi | 66.2 | 8.14e-11 | NR | XP_009226560.1 | 644352 | g20893 | i0 | 53.4 | 13.45 | 58 | 27 | 96.7 | 0 | 179 | 6 | 2337 | 2394 | XP_009226560.1 hypothetical protein GGTG_10423 [Gaeumannomyces tritici R3-111a-1] | diamond | 2421 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Magnaporthaceae | Gaeumannomyces | Gaeumannomyces tritici | |
| 31054097 | 31054097 | PRJNA315314_S_NODE_26515_length_163_cov_2.940299_g26194_i0 | PRJNA315314 | 26515 | 163 | 2.940299 | 4.79268737 | Ophiostoma torulosum | 96403 | Fungi | Fungi | 61.2 | 3.76e-9 | NR | ADZ23991.1 | 96403 | g26194 | i0 | 58.2 | 1.01226993865031 | 55 | 22 | 99.4 | 1 | 162 | 1 | 312 | 366 | ADZ23991.1 reverse transcriptase [Ophiostoma torulosum] | diamond | 165 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma torulosum | |
| 31054115 | 31054115 | PRJNA315314_S_NODE_7095_length_303_cov_5.291971_g6774_i0 | PRJNA315314 | 7095 | 303 | 5.291971 | 16.03467213 | Fulvia fulva | 5499 | Fungi | Fungi | 78.6 | 1.41e-15 | NR | XP_047766766.1 | 5499 | g6774 | i0 | 45.2 | 2.77227722772277 | 93 | 48 | 90.1 | 2 | 298 | 26 | 93 | 184 | XP_047766766.1 uncharacterized protein CLAFUR5_09156 [Fulvia fulva] | diamond | 840 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 31419021 | 31419021 | PRJNA315314_S_NODE_16036_length_205_cov_1.670455_g15715_i0 | PRJNA315314 | 16036 | 205 | 1.670455 | 3.42443275 | Fungi | 4751 | Fungi | Fungi | 75.5 | 4.53e-15 | NR | KAF8538465.1 | 47213 | g15715 | i0 | 58.8 | 10.9463414634146 | 68 | 22 | 99.5 | 1 | 205 | 2 | 81 | 142 | KAF8538465.1 Rps4ap, partial [Trichophaea hybrida] | diamond | 2244 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Trichophaea | Trichophaea hybrida | |
| 31686117 | 31686117 | PRJNA315314_S_NODE_6337_length_320_cov_11.106529_g6016_i0 | PRJNA315314 | 6337 | 320 | 11.106529 | 35.5408928 | Blastomyces parvus | 2060905 | Fungi | Fungi | 96.7 | 2.1699999999999998e-23 | NR | PGG96254.1 | 2060905 | g6016 | i0 | 66.7 | 0.703125 | 75 | 25 | 70.3 | 0 | 45 | 269 | 1 | 75 | PGG96254.1 60S acidic ribosomal protein P2 [Blastomyces parvus] | diamond | 225 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Blastomyces | Blastomyces parvus | |
| 32115139 | 32115139 | PRJNA315314_S_NODE_16158_length_204_cov_2.297143_g15837_i0 | PRJNA315314 | 16158 | 204 | 2.297143 | 4.68617172 | root | 1 | Root_unresolved | Root_unresolved | 106 | 7.9e-25 | NR | XP_036664676.1 | 5480 | g15837 | i0 | 68.7 | 49.3382352941176 | 67 | 21 | 98.5 | 0 | 3 | 203 | 405 | 471 | XP_036664676.1 uncharacterized protein CPAR2_800530 [Candida parapsilosis] | diamond | 10065 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida parapsilosis | |
| 32129350 | 32129350 | PRJNA315314_S_NODE_6618_length_314_cov_2.242105_g6297_i0 | PRJNA315314 | 6618 | 314 | 2.242105 | 7.0402097 | Monosporascus sp. CRB-9-2 | 2211643 | Fungi | Fungi | 110 | 7.03e-29 | NR | RYP82809.1 | 2211643 | g6297 | i0 | 55.4 | 1.73885350318471 | 92 | 41 | 87.9 | 0 | 310 | 35 | 33 | 124 | RYP82809.1 hypothetical protein DL770_005519 [Monosporascus sp. CRB-9-2] | diamond | 546 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Monosporascus | Monosporascus sp. CRB-9-2 |
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);;