contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1123686" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26658511 | 26658511 | PRJNA1123686_S_NODE_18501_length_157_cov_45.851562_g18469_i0 | PRJNA1123686 | 18501 | 157 | 45.851562 | 71.98695234 | Diaporthe vaccinii | 105482 | Fungi | Fungi | 56.2 | 1.94e-7 | NR | KAL2285990.1 | 105482 | g18469 | i0 | 59.6 | 0.993630573248408 | 52 | 21 | 99.4 | 0 | 2 | 157 | 69 | 120 | KAL2285990.1 hypothetical protein FJTKL_07240 [Diaporthe vaccinii] | diamond | 156 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe vaccinii | |
| 26721655 | 26721655 | PRJNA1123686_S_NODE_11501_length_181_cov_71.835526_g11469_i0 | PRJNA1123686 | 11501 | 181 | 71.835526 | 130.02230206 | Sungouiella intermedia | 45354 | Fungi | Fungi | 45.4 | 0.00103 | NR | SGZ51696.1 | 45354 | g11469 | i0 | 53.3 | 0.74585635359116 | 45 | 21 | 74.6 | 0 | 149 | 15 | 44 | 88 | SGZ51696.1 CIC11C00000003486 [Sungouiella intermedia] | diamond | 135 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Sungouiella | Sungouiella intermedia | |
| 26838058 | 26838058 | PRJNA1123686_S_NODE_3901_length_244_cov_8.776744_g3869_i0 | PRJNA1123686 | 3901 | 244 | 8.776744 | 21.41525536 | Dothideomycetes | 147541 | Fungi | Fungi | 97.4 | 1.67e-24 | NR | XP_033586513.1 | 245834 | g3869 | i0 | 67.2 | 4.80737704918033 | 67 | 22 | 82.4 | 0 | 244 | 44 | 12 | 78 | XP_033586513.1 heavy-metal-associated domain-containing protein [Neohortaea acidophila] | diamond | 1173 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Neohortaea | Neohortaea acidophila | |
| 26911985 | 26911985 | PRJNA1123686_S_NODE_13602_length_173_cov_3.673611_g13570_i0 | PRJNA1123686 | 13602 | 173 | 3.673611 | 6.35534703 | Bogoriella megaspora | 2939406 | Fungi | Fungi | 74.3 | 2.05e-14 | NR | KAI9708957.1 | 2939406 | g13570 | i0 | 62.7 | 0.884393063583815 | 51 | 19 | 88.4 | 0 | 6 | 158 | 165 | 215 | KAI9708957.1 MAG: hypothetical protein M1820_003651 [Bogoriella megaspora] | diamond | 153 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Trypetheliales | Trypetheliaceae | Bogoriella | Bogoriella megaspora | |
| 27196480 | 27196480 | PRJNA1123686_S_NODE_9362_length_193_cov_2.926829_g9330_i0 | PRJNA1123686 | 9362 | 193 | 2.926829 | 5.64877997 | Colletotrichum spaethianum | 700344 | Fungi | Fungi | 45.8 | 0.00154 | NR | XP_049127919.1 | 700344 | g9330 | i0 | 54 | 3.10880829015544 | 50 | 21 | 77.7 | 1 | 30 | 179 | 541 | 588 | XP_049127919.1 uncharacterized protein ColSpa_05750 [Colletotrichum spaethianum] | diamond | 600 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum spaethianum | |
| 27481039 | 27481039 | PRJNA1123686_S_NODE_1483_length_306_cov_117.061372_g1451_i0 | PRJNA1123686 | 1483 | 306 | 117.061372 | 358.20779832 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 50.8 | 4.12e-5 | NR | VBB83060.1 | 4952 | g1451 | i0 | 43.5 | 0.676470588235294 | 69 | 39 | 67.6 | 0 | 30 | 236 | 80 | 148 | VBB83060.1 Ribosomal 40S subunit protein S13, putative [Yarrowia lipolytica] | diamond | 207 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 27723225 | 27723225 | PRJNA1123686_S_NODE_14164_length_171_cov_2.429577_g14132_i0 | PRJNA1123686 | 14164 | 171 | 2.429577 | 4.15457667 | Physciaceae | 50934 | Fungi | Fungi | 68.2 | 7.17e-12 | NR | CAF9904024.1 | 116794 | g14132 | i0 | 66.7 | 2.36842105263158 | 45 | 15 | 78.9 | 0 | 2 | 136 | 218 | 262 | CAF9904024.1 MAG: hypothetical protein HETSPECPRED_003321 [Heterodermia speciosa] | diamond | 405 | 68.6 | 0.994169096209913 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Heterodermia | Heterodermia speciosa | |
| 28164893 | 28164893 | PRJNA1123686_S_NODE_17745_length_160_cov_1.221374_g17713_i0 | PRJNA1123686 | 17745 | 160 | 1.221374 | 1.9541984 | Ascomycota | 4890 | Fungi | Fungi | 44.3 | 0.00196 | NR | XP_047755827.1 | 5499 | g17713 | i0 | 95.2 | 5.90625 | 21 | 1 | 39.4 | 0 | 158 | 96 | 142 | 162 | XP_047755827.1 40S ribosomal protein S11-B [Fulvia fulva] | diamond | 945 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 28586347 | 28586347 | PRJNA1123686_S_NODE_1487_length_306_cov_95.794224_g1455_i0 | PRJNA1123686 | 1487 | 306 | 95.794224 | 293.13032544 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 46.6 | 0.0016 | NR | VBB83060.1 | 4952 | g1455 | i0 | 44.9 | 0.676470588235294 | 69 | 38 | 67.6 | 0 | 30 | 236 | 80 | 148 | VBB83060.1 Ribosomal 40S subunit protein S13, putative [Yarrowia lipolytica] | diamond | 207 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 28870236 | 28870236 | PRJNA1123686_S_NODE_10228_length_187_cov_84.506329_g10196_i0 | PRJNA1123686 | 10228 | 187 | 84.506329 | 158.02683523 | Ogataea philodendri | 1378263 | Fungi | Fungi | 44.3 | 0.00341 | NR | XP_046063442.1 | 1378263 | g10196 | i0 | 42.1 | 1.90909090909091 | 57 | 33 | 91.4 | 0 | 186 | 16 | 50 | 106 | XP_046063442.1 uncharacterized protein OGAPHI_001655 [Ogataea philodendri] | diamond | 357 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | Ogataea philodendri | |
| 29722505 | 29722505 | PRJNA1123686_S_NODE_14710_length_169_cov_3.835714_g14678_i0 | PRJNA1123686 | 14710 | 169 | 3.835714 | 6.48235666 | Saccharomyces cerevisiae | 4932 | Fungi | Fungi | 40.4 | 0.0224 | NR | CAI4596813.1 | 4932 | g14678 | i0 | 41.7 | 4.47337278106509 | 36 | 21 | 63.9 | 0 | 139 | 32 | 19 | 54 | CAI4596813.1 AMP_1a_G0034570.mRNA.1.CDS.1 [Saccharomyces cerevisiae] | diamond | 756 | 40.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 30217306 | 30217306 | PRJNA1123686_S_NODE_6312_length_215_cov_47.102151_g6280_i0 | PRJNA1123686 | 6312 | 215 | 47.102151 | 101.26962465 | Clavispora | 36910 | Fungi | Fungi | 56.6 | 2.69e-7 | NR | QFZ28931.1 | 36911 | g6280 | i0 | 53.6 | 1.92558139534884 | 69 | 32 | 96.3 | 0 | 209 | 3 | 74 | 142 | QFZ28931.1 hypothetical protein EJF14_50149 [Clavispora lusitaniae] | diamond | 414 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Clavispora | Clavispora lusitaniae | |
| 30512549 | 30512549 | PRJNA1123686_S_NODE_18993_length_156_cov_18.440945_g18961_i0 | PRJNA1123686 | 18993 | 156 | 18.440945 | 28.7678742 | Alternaria alternata | 5599 | Fungi | Fungi | 41.2 | 0.0266 | NR | KAH8643886.1 | 5599 | g18961 | i0 | 51.4 | 0.673076923076923 | 35 | 16 | 67.3 | 1 | 126 | 22 | 106 | 139 | KAH8643886.1 hypothetical protein IG631_01350 [Alternaria alternata] | diamond | 105 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 31302563 | 31302563 | PRJNA1123686_S_NODE_20095_length_154_cov_3.944000_g20063_i0 | PRJNA1123686 | 20095 | 154 | 3.944 | 6.07376 | Acrodontium crateriforme | 150365 | Fungi | Fungi | 63.5 | 8.81e-11 | NR | WPH02944.1 | 150365 | g20063 | i0 | 59.3 | 2.02597402597403 | 54 | 19 | 99.4 | 3 | 154 | 2 | 104 | 157 | WPH02944.1 Hypothetical protein R9X50_00581400 [Acrodontium crateriforme] | diamond | 312 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme | |
| 31650282 | 31650282 | PRJNA1123686_S_NODE_13917_length_172_cov_1.307692_g13885_i0 | PRJNA1123686 | 13917 | 172 | 1.307692 | 2.24923024 | Viridothelium virens | 1048519 | Fungi | Fungi | 45.8 | 0.00118 | NR | KAF2236383.1 | 1048519 | g13885 | i0 | 41.3 | 0.802325581395349 | 46 | 27 | 80.2 | 0 | 2 | 139 | 335 | 380 | KAF2236383.1 iron reductase domain protein [Viridothelium virens] | diamond | 138 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Trypetheliales | Trypetheliaceae | Viridothelium | Viridothelium virens | |
| 32441756 | 32441756 | PRJNA1123686_S_NODE_1839_length_292_cov_45.574144_g1807_i0 | PRJNA1123686 | 1839 | 292 | 45.574144 | 133.07650048 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 49.3 | 1.34e-4 | NR | VBB83060.1 | 4952 | g1807 | i0 | 37.2 | 0.883561643835616 | 86 | 52 | 88.4 | 1 | 30 | 287 | 80 | 163 | VBB83060.1 Ribosomal 40S subunit protein S13, putative [Yarrowia lipolytica] | diamond | 258 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 32536581 | 32536581 | PRJNA1123686_S_NODE_8319_length_199_cov_7.800000_g8287_i0 | PRJNA1123686 | 8319 | 199 | 7.8 | 15.522 | Bimuria novae-zelandiae CBS 1 | 147497 | Fungi | Fungi | 72 | 6.69e-13 | NR | KAF1970305.1 | 1447943 | g8287 | i0 | 88.1 | 0.633165829145729 | 42 | 5 | 63.3 | 0 | 2 | 127 | 282 | 323 | KAF1970305.1 hypothetical protein BU23DRAFT_650307 [Bimuria novae-zelandiae CBS 107.79] | diamond | 126 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymosphaeriaceae | Bimuria | Bimuria novae-zelandiae |
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);;