contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA554794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3071813 | 3071813 | PRJNA554794_P_NODE_12843_length_263_cov_0.799065_g8914_i0 | PRJNA554794 | 12843 | 263 | 0.799065 | 2.10154095 | Ascomycota | 4890 | Fungi | Fungi | 138 | 3.46e-38 | NR | KAJ4526044.1 | 5970 | g8914 | i0 | 73.6 | 30.8669201520913 | 87 | 23 | 99.2 | 0 | 263 | 3 | 174 | 260 | KAJ4526044.1 60S ribosomal protein L15 [Exophiala dermatitidis] | diamond | 8118 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala dermatitidis | |
| 3071877 | 3071877 | PRJNA554794_P_NODE_23663_length_164_cov_0.869565_g19734_i0 | PRJNA554794 | 23663 | 164 | 0.869565 | 1.4260866 | Lipomyces | 29828 | Fungi | Fungi | 89.7 | 6.490000000000001e-21 | NR | KAK9316014.1 | 29829 | g19734 | i0 | 78.8 | 2.85365853658537 | 52 | 11 | 95.1 | 0 | 157 | 2 | 6 | 57 | KAK9316014.1 hypothetical protein V1524DRAFT_428039 [Lipomyces starkeyi] | diamond | 468 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces starkeyi | |
| 4951667 | 4951667 | PRJNA554794_P_NODE_21524_length_179_cov_1.023077_g17595_i0 | PRJNA554794 | 21524 | 179 | 1.023077 | 1.83130783 | Ascomycota | 4890 | Fungi | Fungi | 69.3 | 1.14e-13 | NR | TQS33502.1 | 62714 | g17595 | i0 | 63.5 | 1.74301675977654 | 52 | 19 | 87.2 | 0 | 1 | 156 | 32 | 83 | TQS33502.1 hypothetical protein Golomagni_06151 [Golovinomyces magnicellulatus] | diamond | 312 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Golovinomyces | Golovinomyces magnicellulatus | |
| 5624769 | 5624769 | PRJNA554794_P_NODE_20705_length_190_cov_1.333333_g16776_i0 | PRJNA554794 | 20705 | 190 | 1.333333 | 2.5333327 | root | 1 | Root_unresolved | Root_unresolved | 102 | 4.45e-25 | NR | WZH46099.1 | 5515 | g16776 | i0 | 79.4 | 83.5578947368421 | 63 | 13 | 99.5 | 0 | 190 | 2 | 119 | 181 | WZH46099.1 40S ribosomal protein S5 [Fusarium acuminatum] | diamond | 15876 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium acuminatum | |
| 11999813 | 11999813 | PRJNA554794_P_NODE_14010_length_230_cov_1.569061_g10081_i0 | PRJNA554794 | 14010 | 230 | 1.569061 | 3.6088403 | Purpureocillium lavendulum | 1247861 | Fungi | Fungi | 61.6 | 6.18e-10 | NR | KAJ6444832.1 | 1247861 | g10081 | i0 | 67.3 | 5.11304347826087 | 49 | 16 | 63.9 | 0 | 229 | 83 | 46 | 94 | KAJ6444832.1 60s acidic ribosomal protein domain-containing protein [Purpureocillium lavendulum] | diamond | 1176 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lavendulum | |
| 19647244 | 19647244 | PRJNA554794_P_NODE_14276_length_224_cov_0.937143_g10347_i0 | PRJNA554794 | 14276 | 224 | 0.937143 | 2.09920032 | Ascomycota | 4890 | Fungi | Fungi | 78.6 | 6.02e-16 | NR | UDD56067.1 | 5059 | g10347 | i0 | 59.5 | 20.7589285714286 | 74 | 29 | 99.1 | 1 | 1 | 222 | 53 | 125 | UDD56067.1 Ubiquitin-40S ribosomal protein S27a [Aspergillus flavus] | diamond | 4650 | 79 | 0.994936708860759 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus flavus | |
| 20923096 | 20923096 | PRJNA554794_P_NODE_21437_length_180_cov_1.030534_g17508_i0 | PRJNA554794 | 21437 | 180 | 1.030534 | 1.8549612 | Torulaspora delbrueckii | 4950 | Fungi | Fungi | 79.7 | 1.36e-15 | NR | XP_003679271.1 | 4950 | g17508 | i0 | 80 | 0.75 | 45 | 9 | 75 | 0 | 138 | 4 | 154 | 198 | XP_003679271.1 uncharacterized protein TDEL_0A07280 [Torulaspora delbrueckii] | diamond | 135 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Torulaspora | Torulaspora delbrueckii | |
| 26634988 | 26634988 | PRJNA554794_P_NODE_23141_length_165_cov_0.879310_g19212_i0 | PRJNA554794 | 23141 | 165 | 0.87931 | 1.4508615 | Meristemomyces frigidus | 1508187 | Fungi | Fungi | 77.8 | 4.83e-15 | NR | KAK5121847.1 | 1508187 | g19212 | i0 | 78.8 | 1.94545454545455 | 52 | 10 | 92.7 | 1 | 3 | 155 | 95 | 146 | KAK5121847.1 hypothetical protein LTR85_004722 [Meristemomyces frigidus] | diamond | 321 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Meristemomyces | Meristemomyces frigidus | |
| 27362981 | 27362981 | PRJNA554794_P_NODE_24743_length_161_cov_0.901786_g20814_i0 | PRJNA554794 | 24743 | 161 | 0.901786 | 1.45187546 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 102 | 8.09e-24 | NR | XP_023621520.1 | 112498 | g20814 | i0 | 90.6 | 0.987577639751553 | 53 | 5 | 98.8 | 0 | 3 | 161 | 168 | 220 | XP_023621520.1 uncharacterized protein RCC_00595 [Ramularia collo-cygni] | diamond | 159 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 28373030 | 28373030 | PRJNA554794_P_NODE_23986_length_163_cov_0.885965_g20057_i0 | PRJNA554794 | 23986 | 163 | 0.885965 | 1.44412295 | Aspergillus carlsbadensis | 1810906 | Fungi | Fungi | 47.8 | 2.06e-4 | NR | KAJ0416452.1 | 1810906 | g20057 | i0 | 46.2 | 0.957055214723926 | 52 | 17 | 88.3 | 2 | 149 | 6 | 13 | 57 | KAJ0416452.1 hypothetical protein BJY00DRAFT_316833 [Aspergillus carlsbadensis] | diamond | 156 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus carlsbadensis | |
| 28436370 | 28436370 | PRJNA554794_P_NODE_9186_length_458_cov_1.053790_g5391_i0 | PRJNA554794 | 9186 | 458 | 1.05379 | 4.8263582 | Aspergillus nidulans var. acristatus | 286159 | Fungi | Fungi | 69.3 | 1.92e-12 | NR | KAL4770795.1 | 286159 | g5391 | i0 | 84.6 | 0.255458515283843 | 39 | 5 | 24.9 | 1 | 91 | 204 | 1 | 39 | KAL4770795.1 hypothetical protein BDW60DRAFT_192094 [Aspergillus nidulans var. acristatus] | diamond | 117 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus nidulans | |
| 28531144 | 28531144 | PRJNA554794_P_NODE_21607_length_178_cov_1.124031_g17678_i0 | PRJNA554794 | 21607 | 178 | 1.124031 | 2.00077518 | Saitoella complicata NRRL Y-178 | 5606 | Fungi | Fungi | 81.6 | 1.68e-16 | NR | XP_019024580.1 | 698492 | g17678 | i0 | 61 | 1.97191011235955 | 59 | 23 | 99.4 | 0 | 178 | 2 | 47 | 105 | XP_019024580.1 fructose-1,6-bisphosphatase [Saitoella complicata NRRL Y-17804] | diamond | 351 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 28594214 | 28594214 | PRJNA554794_P_NODE_24307_length_162_cov_0.893805_g20378_i0 | PRJNA554794 | 24307 | 162 | 0.893805 | 1.4479641 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 111 | 5.8200000000000006e-27 | NR | XP_023626902.1 | 112498 | g20378 | i0 | 96.2 | 0.981481481481482 | 53 | 2 | 98.1 | 0 | 162 | 4 | 270 | 322 | XP_023626902.1 uncharacterized protein RCC_05870 [Ramularia collo-cygni] | diamond | 159 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 28846541 | 28846541 | PRJNA554794_P_NODE_24308_length_162_cov_0.893805_g20379_i0 | PRJNA554794 | 24308 | 162 | 0.893805 | 1.4479641 | Pneumocystis canis | 2698477 | Fungi | Fungi | 67 | 6.4e-12 | NR | KAG4303124.1 | 2698477 | g20379 | i0 | 56.6 | 2.92592592592593 | 53 | 23 | 98.1 | 0 | 2 | 160 | 82 | 134 | KAG4303124.1 hypothetical protein PCK1_000462 [Pneumocystis canis] | diamond | 474 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis canis | |
| 29271540 | 29271540 | PRJNA554794_P_NODE_22809_length_166_cov_0.957265_g18880_i0 | PRJNA554794 | 22809 | 166 | 0.957265 | 1.5890599 | Sordariomycetes | 147550 | Fungi | Fungi | 43.5 | 0.00318 | NR | KAG7148728.1 | 100787 | g18880 | i0 | 58.5 | 2.1144578313253 | 41 | 17 | 74.1 | 0 | 125 | 3 | 1 | 41 | KAG7148728.1 40S ribosomal protein S20 like [Verticillium longisporum] | diamond | 351 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Verticillium | Verticillium longisporum | |
| 29635707 | 29635707 | PRJNA554794_P_NODE_23310_length_165_cov_0.870690_g19381_i0 | PRJNA554794 | 23310 | 165 | 0.87069 | 1.4366385 | Acrodontium crateriforme | 150365 | Fungi | Fungi | 44.7 | 0.00268 | NR | WPG98068.1 | 150365 | g19381 | i0 | 50 | 6.76363636363636 | 46 | 22 | 83.6 | 1 | 26 | 163 | 334 | 378 | WPG98068.1 putative membrane protein [Acrodontium crateriforme] | diamond | 1116 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme | |
| 29650210 | 29650210 | PRJNA554794_P_NODE_22970_length_166_cov_0.863248_g19041_i0 | PRJNA554794 | 22970 | 166 | 0.863248 | 1.43299168 | Aspergillus | 5052 | Fungi | Fungi | 76.6 | 1.48e-14 | NR | KAL2824648.1 | 176166 | g19041 | i0 | 54.7 | 4.53614457831325 | 53 | 24 | 95.8 | 0 | 2 | 160 | 113 | 165 | KAL2824648.1 hypothetical protein BDW59DRAFT_180203 [Aspergillus cavernicola] | diamond | 753 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus cavernicola | |
| 29983472 | 29983472 | PRJNA554794_P_NODE_24651_length_161_cov_0.910714_g20722_i0 | PRJNA554794 | 24651 | 161 | 0.910714 | 1.46624954 | Penicillium angulare | 116970 | Fungi | Fungi | 47.4 | 2.87e-4 | NR | XP_056774998.1 | 116970 | g20722 | i0 | 50 | 0.819875776397516 | 44 | 22 | 82 | 0 | 2 | 133 | 1556 | 1599 | XP_056774998.1 uncharacterized protein N7478_009414 [Penicillium angulare] | diamond | 132 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium angulare | |
| 30346088 | 30346088 | PRJNA554794_P_NODE_20832_length_188_cov_1.115108_g16903_i0 | PRJNA554794 | 20832 | 188 | 1.115108 | 2.09640304 | Eukaryota | 2759 | Fungi | Fungi | 77.8 | 7.27e-15 | NR | KAF3394938.1 | 128442 | g16903 | i0 | 62.7 | 2.76063829787234 | 59 | 21 | 92.6 | 1 | 14 | 187 | 331 | 389 | KAF3394938.1 60S ribosomal protein L44 [Talaromyces pinophilus] | diamond | 519 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces pinophilus | |
| 30977627 | 30977627 | PRJNA554794_P_NODE_20194_length_198_cov_1.563758_g16265_i0 | PRJNA554794 | 20194 | 198 | 1.563758 | 3.09624084 | Opisthokonta | 33154 | Fungi | Fungi | 42 | 0.0321 | NR | KAI3092591.1 | 5082 | g16265 | i0 | 64.9 | 4.78787878787879 | 37 | 12 | 56.1 | 1 | 112 | 2 | 13 | 48 | KAI3092591.1 hypothetical protein CBS147333_10231 [Penicillium roqueforti] | diamond | 948 | 42.4 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 31120539 | 31120539 | PRJNA554794_P_NODE_21855_length_175_cov_1.619048_g17926_i0 | PRJNA554794 | 21855 | 175 | 1.619048 | 2.833334 | Aspergillus tetrazonus | 1883080 | Fungi | Fungi | 124 | 2.96e-34 | NR | KAL3433002.1 | 1883080 | g17926 | i0 | 100 | 0.994285714285714 | 58 | 0 | 99.4 | 0 | 174 | 1 | 2 | 59 | KAL3433002.1 hypothetical protein BDV09DRAFT_172865 [Aspergillus tetrazonus] | diamond | 174 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus tetrazonus | |
| 32306132 | 32306132 | PRJNA554794_P_NODE_20439_length_194_cov_1.234483_g16510_i0 | PRJNA554794 | 20439 | 194 | 1.234483 | 2.39489702 | Opisthokonta | 33154 | Fungi | Fungi | 80.1 | 3.68e-17 | NR | XP_024662748.1 | 45607 | g16510 | i0 | 56.3 | 1.97938144329897 | 64 | 28 | 99 | 0 | 194 | 3 | 57 | 120 | XP_024662748.1 60S ribosomal protein L28 [Wickerhamiella sorbophila] | diamond | 384 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella sorbophila | |
| 32369337 | 32369337 | PRJNA554794_P_NODE_21359_length_181_cov_1.598485_g17430_i0 | PRJNA554794 | 21359 | 181 | 1.598485 | 2.89325785 | Opisthokonta | 33154 | Fungi | Fungi | 97.4 | 1.0099999999999999e-24 | NR | XP_001246626.1 | 246410 | g17430 | i0 | 69.5 | 10.7569060773481 | 59 | 18 | 97.8 | 0 | 178 | 2 | 1 | 59 | XP_001246626.1 60S ribosomal protein L37 [Coccidioides immitis RS] | diamond | 1947 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Onygenaceae | Coccidioides | Coccidioides immitis |
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);;