contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA796975" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26705457 | 26705457 | PRJNA796975_S_NODE_11681_length_165_cov_0.879310_g11604_i0 | PRJNA796975 | 11681 | 165 | 0.87931 | 1.4508615 | Malassezia cuniculi | 948313 | Fungi | Fungi | 98.2 | 3.9e-22 | NR | WFD36249.1 | 948313 | g11604 | i0 | 85.5 | 2 | 55 | 8 | 100 | 0 | 1 | 165 | 505 | 559 | WFD36249.1 methionine--tRNA ligase [Malassezia cuniculi] | diamond | 330 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 26895908 | 26895908 | PRJNA796975_S_NODE_15441_length_161_cov_0.910714_g15364_i0 | PRJNA796975 | 15441 | 161 | 0.910714 | 1.46624954 | Sparassis crispa | 139825 | Fungi | Fungi | 48.1 | 3.05e-5 | NR | XP_027617778.1 | 139825 | g15364 | i0 | 48 | 0.93167701863354 | 50 | 18 | 93.2 | 1 | 155 | 6 | 56 | 97 | XP_027617778.1 hypothetical protein SCP_1001070 [Sparassis crispa] | diamond | 150 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Sparassidaceae | Sparassis | Sparassis crispa | |
| 27148281 | 27148281 | PRJNA796975_S_NODE_11142_length_165_cov_0.879310_g11065_i0 | PRJNA796975 | 11142 | 165 | 0.87931 | 1.4508615 | Paramarasmius palmivorus | 297713 | Fungi | Fungi | 42.7 | 0.00522 | NR | KAK7019365.1 | 297713 | g11065 | i0 | 55.2 | 1.58181818181818 | 29 | 13 | 52.7 | 0 | 91 | 5 | 22 | 50 | KAK7019365.1 hypothetical protein VNI00_018109 [Paramarasmius palmivorus] | diamond | 261 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Paramarasmius | Paramarasmius palmivorus | |
| 27568418 | 27568418 | PRJNA796975_S_NODE_9704_length_167_cov_0.864407_g9627_i0 | PRJNA796975 | 9704 | 167 | 0.864407 | 1.44355969 | Basidiomycota | 5204 | Fungi | Fungi | 75.5 | 3.46e-14 | NR | XP_016290266.2 | 1365824 | g9627 | i0 | 85.4 | 3.70059880239521 | 41 | 6 | 73.7 | 0 | 44 | 166 | 193 | 233 | XP_016290266.2 MT-A70-like protein [Kalmanozyma brasiliensis GHG001] | diamond | 618 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Kalmanozyma | Kalmanozyma brasiliensis | |
| 27686056 | 27686056 | PRJNA796975_S_NODE_10624_length_166_cov_0.871795_g10547_i0 | PRJNA796975 | 10624 | 166 | 0.871795 | 1.4471797 | Exobasidium rhododendri | 63378 | Fungi | Fungi | 43.1 | 0.00929 | NR | UZJ55362.1 | 63378 | g10547 | i0 | 76.9 | 0.469879518072289 | 26 | 6 | 47 | 0 | 3 | 80 | 52 | 77 | UZJ55362.1 hypothetical protein CBS101457_004682 [Exobasidium rhododendri] | diamond | 78 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Exobasidiaceae | Exobasidium | Exobasidium rhododendri | |
| 27875095 | 27875095 | PRJNA796975_S_NODE_12285_length_164_cov_0.886957_g12208_i0 | PRJNA796975 | 12285 | 164 | 0.886957 | 1.45460948 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 67.8 | 1.86e-11 | NR | XP_066820444.1 | 1397322 | g12208 | i0 | 90.3 | 0.567073170731707 | 31 | 3 | 56.7 | 0 | 163 | 71 | 823 | 853 | XP_066820444.1 ubiquitinyl hydrolase [Cystobasidium minutum MCA 4210] | diamond | 93 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 28253994 | 28253994 | PRJNA796975_S_NODE_9546_length_167_cov_0.864407_g9469_i0 | PRJNA796975 | 9546 | 167 | 0.864407 | 1.44355969 | Puccinia triticina | 208348 | Fungi | Fungi | 43.9 | 0.00324 | NR | XP_053019290.1 | 208348 | g9469 | i0 | 58.3 | 1.18562874251497 | 36 | 15 | 64.7 | 0 | 108 | 1 | 94 | 129 | XP_053019290.1 uncharacterized protein PtA15_4A183 [Puccinia triticina] | diamond | 198 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 28380326 | 28380326 | PRJNA796975_S_NODE_10086_length_167_cov_0.864407_g10009_i0 | PRJNA796975 | 10086 | 167 | 0.864407 | 1.44355969 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 101 | 2.3399999999999994e-23 | NR | XP_014657287.1 | 84753 | g10009 | i0 | 90.9 | 0.988023952095808 | 55 | 5 | 98.8 | 0 | 1 | 165 | 419 | 473 | XP_014657287.1 MFS polyamine transporter [Moesziomyces antarcticus] | diamond | 165 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 29453533 | 29453533 | PRJNA796975_S_NODE_12490_length_164_cov_0.886957_g12413_i0 | PRJNA796975 | 12490 | 164 | 0.886957 | 1.45460948 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 66.6 | 4.74e-11 | NR | XP_017992233.1 | 77020 | g12413 | i0 | 75.9 | 0.98780487804878 | 54 | 12 | 98.8 | 1 | 162 | 1 | 412 | 464 | XP_017992233.1 rna-binding protein [Malassezia pachydermatis] | diamond | 162 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 29706026 | 29706026 | PRJNA796975_S_NODE_14570_length_162_cov_0.902655_g14493_i0 | PRJNA796975 | 14570 | 162 | 0.902655 | 1.4623011 | Pterula gracilis | 1884261 | Fungi | Fungi | 73.9 | 1.19e-13 | NR | TFK99248.1 | 1884261 | g14493 | i0 | 72 | 0.925925925925926 | 50 | 14 | 92.6 | 0 | 3 | 152 | 354 | 403 | TFK99248.1 major facilitator superfamily domain-containing protein [Pterula gracilis] | diamond | 150 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pterulaceae | Pterulicium | Pterulicium gracile | |
| 30717273 | 30717273 | PRJNA796975_S_NODE_15334_length_161_cov_0.910714_g15257_i0 | PRJNA796975 | 15334 | 161 | 0.910714 | 1.46624954 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 96.7 | 1.24e-21 | NR | CAD6577539.1 | 2778381 | g15257 | i0 | 77.4 | 0.987577639751553 | 53 | 12 | 98.8 | 0 | 2 | 160 | 478 | 530 | CAD6577539.1 MAG: hypothetical protein CYPHOPRED_000267 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 159 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 31349580 | 31349580 | PRJNA796975_S_NODE_10556_length_166_cov_0.871795_g10479_i0 | PRJNA796975 | 10556 | 166 | 0.871795 | 1.4471797 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 63.5 | 6.03e-10 | NR | SHO76919.1 | 1230383 | g10479 | i0 | 55.1 | 2.6566265060241 | 49 | 22 | 88.6 | 0 | 165 | 19 | 422 | 470 | SHO76919.1 Uncharacterized protein MSYG_1258 [Malassezia sympodialis ATCC 42132] | diamond | 441 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 32140368 | 32140368 | PRJNA796975_S_NODE_11318_length_165_cov_0.879310_g11241_i0 | PRJNA796975 | 11318 | 165 | 0.87931 | 1.4508615 | Phellopilus nigrolimitatus | 127956 | Fungi | Fungi | 97.8 | 3.59e-22 | NR | KAH8118392.1 | 127956 | g11241 | i0 | 73.6 | 0.963636363636364 | 53 | 14 | 96.4 | 0 | 4 | 162 | 378 | 430 | KAH8118392.1 hypothetical protein DFH11DRAFT_1839035 [Phellopilus nigrolimitatus] | diamond | 159 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Phellopilus | Phellopilus nigrolimitatus | |
| 32203615 | 32203615 | PRJNA796975_S_NODE_11078_length_165_cov_1.241379_g11001_i0 | PRJNA796975 | 11078 | 165 | 1.241379 | 2.04827535 | Lentinus tigrinus ALCF2SS1-7 | 1328758 | Fungi | Fungi | 97.4 | 5.48e-22 | NR | XP_067533030.1 | 1328758 | g11001 | i0 | 90.7 | 1.98181818181818 | 54 | 5 | 98.2 | 0 | 3 | 164 | 302 | 355 | XP_067533030.1 TMS membrane protein/tumor differentially expressed protein [Lentinus tigrinus ALCF2SS1-7] | diamond | 327 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus | |
| 32267068 | 32267068 | PRJNA796975_S_NODE_12978_length_163_cov_0.894737_g12901_i0 | PRJNA796975 | 12978 | 163 | 0.894737 | 1.45842131 | Jaminaea rosea | 1569628 | Fungi | Fungi | 46.2 | 7.35e-4 | NR | XP_025364284.1 | 1569628 | g12901 | i0 | 53.7 | 0.993865030674847 | 54 | 24 | 97.5 | 1 | 3 | 161 | 300 | 353 | XP_025364284.1 ARM repeat-containing protein [Jaminaea rosea] | diamond | 162 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Jaminaea | Jaminaea rosea | ||
| 32298878 | 32298878 | PRJNA796975_S_NODE_12339_length_164_cov_0.886957_g12262_i0 | PRJNA796975 | 12339 | 164 | 0.886957 | 1.45460948 | Sanghuangporus baumii | 108892 | Fungi | Fungi | 45.1 | 0.00196 | NR | OCB91887.1 | 108892 | g12262 | i0 | 49.1 | 0.969512195121951 | 53 | 26 | 95.1 | 1 | 7 | 162 | 183 | 235 | OCB91887.1 hypothetical protein A7U60_g822 [Sanghuangporus baumii] | diamond | 159 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Sanghuangporus | Sanghuangporus baumii |
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);;