contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA345071" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6173267 | 6173267 | PRJNA345071_P_NODE_10805_length_242_cov_0.923077_g10765_i0 | PRJNA345071 | 10805 | 242 | 0.923077 | 2.23384634 | Aspergillaceae | 1131492 | Fungi | Fungi | 76.6 | 2.18e-14 | NR | ODM21730.1 | 573508 | g10765 | i0 | 92.3 | 2.88842975206612 | 39 | 3 | 48.3 | 0 | 240 | 124 | 104 | 142 | ODM21730.1 hypothetical protein SI65_02574 [Aspergillus cristatus] | diamond | 699 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus cristatus | |
| 9321423 | 9321423 | PRJNA345071_P_NODE_7388_length_255_cov_1.675824_g7348_i0 | PRJNA345071 | 7388 | 255 | 1.675824 | 4.2733512 | Erysiphe neolycopersici | 212602 | Fungi | Fungi | 132 | 1.46e-34 | NR | RKF64258.1 | 212602 | g7348 | i0 | 82.7 | 0.952941176470588 | 81 | 14 | 95.3 | 0 | 254 | 12 | 338 | 418 | RKF64258.1 Ubiquitin domain-containing protein DSK2 [Erysiphe neolycopersici] | diamond | 243 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe neolycopersici | |
| 14422193 | 14422193 | PRJNA345071_P_NODE_8452_length_250_cov_0.881356_g8412_i0 | PRJNA345071 | 8452 | 250 | 0.881356 | 2.20339 | Ascomycota | 4890 | Fungi | Fungi | 125 | 1.48e-33 | NR | KAA8908802.1 | 44093 | g8412 | i0 | 76.5 | 17.4 | 81 | 19 | 97.2 | 0 | 248 | 6 | 44 | 124 | KAA8908802.1 hypothetical protein TRICI_004730 [Trichomonascus ciferrii] | diamond | 4350 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Trichomonascus | Trichomonascus ciferrii | |
| 26885079 | 26885079 | PRJNA345071_P_NODE_4301_length_305_cov_1.189655_g4261_i0 | PRJNA345071 | 4301 | 305 | 1.189655 | 3.62844775 | Ambrosiozyma monospora | 43982 | Fungi | Fungi | 75.1 | 3.26e-13 | NR | GMG21562.1 | 43982 | g4261 | i0 | 44.9 | 2.77377049180328 | 69 | 38 | 67.9 | 0 | 98 | 304 | 242 | 310 | GMG21562.1 unnamed protein product [Ambrosiozyma monospora] | diamond | 846 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ambrosiozyma | Ambrosiozyma monospora | |
| 27232775 | 27232775 | PRJNA345071_P_NODE_9603_length_246_cov_0.901734_g9563_i0 | PRJNA345071 | 9603 | 246 | 0.901734 | 2.21826564 | Sarocladium strictum | 5046 | Fungi | Fungi | 99.8 | 1.5699999999999994e-23 | NR | KAK0384253.1 | 5046 | g9563 | i0 | 73.2 | 0.865853658536585 | 71 | 17 | 86.6 | 2 | 213 | 1 | 1 | 69 | KAK0384253.1 hypothetical protein NLU13_8341 [Sarocladium strictum] | diamond | 213 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 27327714 | 27327714 | PRJNA345071_P_NODE_8943_length_248_cov_0.891429_g8903_i0 | PRJNA345071 | 8943 | 248 | 0.891429 | 2.21074392 | Verruconis gallopava | 253628 | Fungi | Fungi | 152 | 1.13e-40 | NR | XP_016211089.1 | 253628 | g8903 | i0 | 87.8 | 0.991935483870968 | 82 | 10 | 99.2 | 0 | 2 | 247 | 209 | 290 | XP_016211089.1 uncharacterized protein PV09_07264 [Verruconis gallopava] | diamond | 246 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Sympoventuriaceae | Verruconis | Verruconis gallopava | |
| 27359404 | 27359404 | PRJNA345071_P_NODE_5223_length_287_cov_1.098131_g5183_i0 | PRJNA345071 | 5223 | 287 | 1.098131 | 3.15163597 | Stemphylium lycopersici | 183478 | Fungi | Fungi | 79.3 | 8.9e-15 | NR | KNG49363.1 | 183478 | g5183 | i0 | 51.4 | 2.24738675958188 | 72 | 35 | 75.3 | 0 | 70 | 285 | 350 | 421 | KNG49363.1 nad(P)-binding protein [Stemphylium lycopersici] | diamond | 645 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Stemphylium | Stemphylium lycopersici | |
| 28432835 | 28432835 | PRJNA345071_P_NODE_5626_length_280_cov_1.753623_g5586_i0 | PRJNA345071 | 5626 | 280 | 1.753623 | 4.9101444 | Dendryphion nanum | 256645 | Fungi | Fungi | 84.3 | 1.09e-18 | NR | KAH7138046.1 | 256645 | g5586 | i0 | 58.3 | 0.771428571428571 | 72 | 30 | 77.1 | 0 | 220 | 5 | 4 | 75 | KAH7138046.1 ribosomal protein S10 domain-containing protein [Dendryphion nanum] | diamond | 216 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Torulaceae | Dendryphion | Dendryphion nanum | |
| 28797059 | 28797059 | PRJNA345071_P_NODE_8127_length_251_cov_0.876404_g8087_i0 | PRJNA345071 | 8127 | 251 | 0.876404 | 2.19977404 | Sordariomycetes | 147550 | Fungi | Fungi | 67.4 | 8.59e-11 | NR | KAJ6786059.1 | 12942 | g8087 | i0 | 84.4 | 15.6812749003984 | 32 | 5 | 38.2 | 0 | 155 | 250 | 115 | 146 | KAJ6786059.1 hypothetical protein PWT90_02753 [Aphanocladium album] | diamond | 3936 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Aphanocladium | Aphanocladium album | ||
| 28955385 | 28955385 | PRJNA345071_P_NODE_10448_length_243_cov_0.917647_g10408_i0 | PRJNA345071 | 10448 | 243 | 0.917647 | 2.22988221 | Xylographa | 223428 | Fungi | Fungi | 44.7 | 0.00723 | NR | MCJ1289476.1 | 1590122 | g10408 | i0 | 52.3 | 1.62962962962963 | 44 | 21 | 54.3 | 0 | 233 | 102 | 95 | 138 | MCJ1289476.1 hypothetical protein [Xylographa carneopallida] | diamond | 396 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Xylographa | Xylographa carneopallida | |
| 29144922 | 29144922 | PRJNA345071_P_NODE_7549_length_253_cov_1.700000_g7509_i0 | PRJNA345071 | 7549 | 253 | 1.7 | 4.301 | Fungi | 4751 | Fungi | Fungi | 82 | 6.3e-16 | NR | RFU71957.1 | 490622 | g7509 | i0 | 57.3 | 3.68774703557312 | 82 | 35 | 97.2 | 0 | 1 | 246 | 293 | 374 | RFU71957.1 nadp transhydrogenase, partial [Trichoderma arundinaceum] | diamond | 933 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma arundinaceum | |
| 29379959 | 29379959 | PRJNA345071_P_NODE_10169_length_244_cov_0.912281_g10129_i0 | PRJNA345071 | 10169 | 244 | 0.912281 | 2.22596564 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 136 | 2.4699999999999997e-37 | NR | XP_023625005.1 | 112498 | g10129 | i0 | 87.7 | 0.995901639344262 | 81 | 10 | 99.6 | 0 | 243 | 1 | 122 | 202 | XP_023625005.1 related to Y.lipolytica GPR1 protein and Fun34p [Ramularia collo-cygni] | diamond | 243 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 29491868 | 29491868 | PRJNA345071_P_NODE_5370_length_284_cov_1.578199_g5330_i0 | PRJNA345071 | 5370 | 284 | 1.578199 | 4.48208516 | Debaryomycetaceae | 766764 | Fungi | Fungi | 95.9 | 1.25e-20 | NR | CAK7906258.1 | 148631 | g5330 | i0 | 46.6 | 3.66549295774648 | 88 | 47 | 93 | 0 | 2 | 265 | 172 | 259 | CAK7906258.1 eukaryotic translation initiation factor 2A [[Candida] anglica] | diamond | 1041 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Kurtzmaniella | [Candida] anglica | |
| 30043101 | 30043101 | PRJNA345071_P_NODE_6531_length_266_cov_1.606218_g6491_i0 | PRJNA345071 | 6531 | 266 | 1.606218 | 4.27253988 | Cladophialophora immunda | 569365 | Fungi | Fungi | 44.7 | 0.01 | NR | OQU98288.1 | 569365 | g6491 | i0 | 37.7 | 1.37593984962406 | 61 | 32 | 66.5 | 2 | 89 | 265 | 111 | 167 | OQU98288.1 hypothetical protein CLAIMM_04094 isoform 1 [Cladophialophora immunda] | diamond | 366 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora immunda | |
| 31528605 | 31528605 | PRJNA345071_P_NODE_7976_length_252_cov_0.871508_g7936_i0 | PRJNA345071 | 7976 | 252 | 0.871508 | 2.19620016 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 96.7 | 3.89e-21 | NR | XP_069230394.1 | 1052096 | g7936 | i0 | 69.5 | 0.702380952380952 | 59 | 18 | 70.2 | 0 | 250 | 74 | 470 | 528 | XP_069230394.1 uncharacterized protein WHR41_04432 [Cladosporium halotolerans] | diamond | 177 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans |
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);;