contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1218816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1608195 | 1608195 | PRJNA1218816_P_NODE_54222_length_251_cov_0.865169_g53789_i0 | PRJNA1218816 | 54222 | 251 | 0.865169 | 2.17157419 | Malassezia | 55193 | Fungi | Fungi | 139 | 1.16e-37 | NR | WFD02123.1 | 76774 | g53789 | i0 | 76.5 | 2.9402390438247 | 81 | 19 | 96.8 | 0 | 3 | 245 | 174 | 254 | WFD02123.1 chitinase [Malassezia obtusa] | diamond | 738 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa | |
| 2884373 | 2884373 | PRJNA1218816_P_NODE_51323_length_259_cov_1.543011_g50890_i0 | PRJNA1218816 | 51323 | 259 | 1.543011 | 3.99639849 | Malassezia cuniculi | 948313 | Fungi | Fungi | 154 | 2.98e-41 | NR | WFD36327.1 | 948313 | g50890 | i0 | 87.1 | 0.984555984555985 | 85 | 11 | 98.5 | 0 | 3 | 257 | 245 | 329 | WFD36327.1 hypothetical protein MCUN1_003206 [Malassezia cuniculi] | diamond | 255 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 3596809 | 3596809 | PRJNA1218816_P_NODE_59363_length_245_cov_0.895349_g58930_i0 | PRJNA1218816 | 59363 | 245 | 0.895349 | 2.19360505 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 107 | 4.87e-25 | NR | AYO44318.1 | 425264 | g58930 | i0 | 68.8 | 0.979591836734694 | 80 | 24 | 96.7 | 1 | 237 | 1 | 34 | 113 | AYO44318.1 Kinesin-like protein KIF21A [Malassezia restricta CBS 7877] | diamond | 240 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6711141 | 6711141 | PRJNA1218816_P_NODE_37826_length_316_cov_2.213992_g37393_i0 | PRJNA1218816 | 37826 | 316 | 2.213992 | 6.99621472 | Rhizoctonia solani | 456999 | Fungi | Fungi | 106 | 2.02e-25 | NR | KAJ1304824.1 | 456999 | g37393 | i0 | 63.4 | 0.958860759493671 | 101 | 32 | 94.9 | 4 | 17 | 316 | 25 | 121 | KAJ1304824.1 hypothetical protein OPQ81_005959 [Rhizoctonia solani] | diamond | 303 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 23285557 | 23285557 | PRJNA1218816_P_NODE_35239_length_331_cov_1.282946_g34806_i0 | PRJNA1218816 | 35239 | 331 | 1.282946 | 4.24655126 | Fungi | 4751 | Fungi | Fungi | 154 | 4.31e-44 | NR | XP_025600826.1 | 58919 | g34806 | i0 | 67 | 27.9969788519637 | 109 | 36 | 98.8 | 0 | 2 | 328 | 66 | 174 | XP_025600826.1 putative ribosomal protein S3aE [Tilletiopsis washingtonensis] | diamond | 9267 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 26724072 | 26724072 | PRJNA1218816_P_NODE_63081_length_241_cov_0.916667_g62648_i0 | PRJNA1218816 | 63081 | 241 | 0.916667 | 2.20916747 | Mycena filopes | 858877 | Fungi | Fungi | 154 | 1.04e-41 | NR | KAJ7186854.1 | 858877 | g62648 | i0 | 88.8 | 1.99170124481328 | 80 | 9 | 99.6 | 0 | 2 | 241 | 237 | 316 | KAJ7186854.1 hypothetical protein C8R46DRAFT_1058231 [Mycena filopes] | diamond | 480 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena filopes | |
| 27041122 | 27041122 | PRJNA1218816_P_NODE_60102_length_244_cov_0.900585_g59669_i0 | PRJNA1218816 | 60102 | 244 | 0.900585 | 2.1974274 | Naganishia cerealis | 610337 | Fungi | Fungi | 79.7 | 3e-15 | NR | KAJ9107013.1 | 610337 | g59669 | i0 | 54.9 | 1.00819672131148 | 82 | 36 | 99.6 | 1 | 243 | 1 | 7 | 88 | KAJ9107013.1 Vacuolar protein 8 [Naganishia cerealis] | diamond | 246 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia cerealis | |
| 27230707 | 27230707 | PRJNA1218816_P_NODE_35823_length_328_cov_1.188235_g35390_i0 | PRJNA1218816 | 35823 | 328 | 1.188235 | 3.8974108 | Peniophora sp. CBMAI 1 | 1756134 | Fungi | Fungi | 53.1 | 9.25e-6 | NR | VDB98145.1 | 718367 | g35390 | i0 | 62.5 | 0.51219512195122 | 56 | 14 | 51.2 | 2 | 291 | 124 | 1 | 49 | VDB98145.1 unnamed protein product [Peniophora sp. CBMAI 1063] | diamond | 168 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CBMAI 1063 | |
| 27830779 | 27830779 | PRJNA1218816_P_NODE_60304_length_244_cov_0.900585_g59871_i0 | PRJNA1218816 | 60304 | 244 | 0.900585 | 2.1974274 | Malassezia globosa CBS 7966 | 425265 | Fungi | Fungi | 106 | 1.22e-24 | NR | XP_001732727.1 | 425265 | g59871 | i0 | 63.3 | 0.971311475409836 | 79 | 27 | 97.1 | 1 | 239 | 3 | 1510 | 1586 | XP_001732727.1 uncharacterized protein MGL_0502 [Malassezia globosa CBS 7966] | diamond | 237 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 29523010 | 29523010 | PRJNA1218816_P_NODE_47030_length_275_cov_1.524752_g46597_i0 | PRJNA1218816 | 47030 | 275 | 1.524752 | 4.193068 | Ustilaginaceae | 5268 | Fungi | Fungi | 58.9 | 8.2e-8 | NR | XP_014654605.1 | 84753 | g46597 | i0 | 47.4 | 1.65818181818182 | 76 | 36 | 82.9 | 1 | 229 | 2 | 9 | 80 | XP_014654605.1 subunit B of the stator stalk of mitochondrial F1F0 ATP synthase, ATP4 [Moesziomyces antarcticus] | diamond | 456 | 59.3 | 0.993254637436762 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 29933709 | 29933709 | PRJNA1218816_P_NODE_52431_length_255_cov_1.692308_g51998_i0 | PRJNA1218816 | 52431 | 255 | 1.692308 | 4.3153854 | Agaricomycetes | 155619 | Fungi | Fungi | 137 | 1.56e-36 | NR | EJD52246.1 | 717982 | g51998 | i0 | 72.6 | 16.7882352941176 | 84 | 23 | 98.8 | 0 | 3 | 254 | 171 | 254 | EJD52246.1 rab GTPase activator [Auricularia subglabra TFB-10046 SS5] | diamond | 4281 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia subglabra | |
| 30041106 | 30041106 | PRJNA1218816_P_NODE_27231_length_394_cov_0.959502_g26798_i0 | PRJNA1218816 | 27231 | 394 | 0.959502 | 3.78043788 | Papiliotrema laurentii | 5418 | Fungi | Fungi | 167 | 4.76e-45 | NR | KAK1925324.1 | 5418 | g26798 | i0 | 58.9 | 0.982233502538071 | 129 | 52 | 98.2 | 1 | 2 | 388 | 504 | 631 | KAK1925324.1 V-type ATPase, V0 complex, 116kDa subunit family [Papiliotrema laurentii] | diamond | 387 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii | |
| 30135555 | 30135555 | PRJNA1218816_P_NODE_45032_length_283_cov_1.466667_g44599_i0 | PRJNA1218816 | 45032 | 283 | 1.466667 | 4.15066761 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 46.6 | 0.00254 | NR | CAD6575820.1 | 2778381 | g44599 | i0 | 38.7 | 0.985865724381625 | 93 | 48 | 98.6 | 3 | 281 | 3 | 92 | 175 | CAD6575820.1 MAG: hypothetical protein CYPHOPRED_005802 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 279 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 30470816 | 30470816 | PRJNA1218816_P_NODE_24873_length_420_cov_1.757925_g24440_i0 | PRJNA1218816 | 24873 | 420 | 1.757925 | 7.383285 | Agaricales | 5338 | Fungi | Fungi | 229 | 1.21e-73 | NR | AFU72288.1 | 67730 | g24440 | i0 | 75.7 | 15 | 140 | 34 | 100 | 0 | 420 | 1 | 43 | 182 | AFU72288.1 40S ribosomal protein S1, partial [Amanita strobiliformis] | diamond | 6300 | 229 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita strobiliformis | |
| 30723324 | 30723324 | PRJNA1218816_P_NODE_54654_length_250_cov_0.870056_g54221_i0 | PRJNA1218816 | 54654 | 250 | 0.870056 | 2.17514 | Puccinia | 5296 | Fungi | Fungi | 42.7 | 0.0399 | NR | KAI7956426.1 | 168172 | g54221 | i0 | 35.1 | 2.052 | 57 | 35 | 66 | 2 | 54 | 218 | 624 | 680 | KAI7956426.1 hypothetical protein MJO29_007825 [Puccinia striiformis f. sp. tritici] | diamond | 513 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 31083798 | 31083798 | PRJNA1218816_P_NODE_58915_length_245_cov_1.360465_g58482_i0 | PRJNA1218816 | 58915 | 245 | 1.360465 | 3.33313925 | Pleurotus cornucopiae | 5321 | Fungi | Fungi | 129 | 2.4899999999999996e-35 | NR | KAG9225082.1 | 5321 | g58482 | i0 | 75.6 | 0.955102040816327 | 78 | 19 | 95.5 | 0 | 241 | 8 | 68 | 145 | KAG9225082.1 hypothetical protein CCMSSC00406_0008754 [Pleurotus cornucopiae] | diamond | 234 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus cornucopiae | |
| 31400082 | 31400082 | PRJNA1218816_P_NODE_59396_length_245_cov_0.895349_g58963_i0 | PRJNA1218816 | 59396 | 245 | 0.895349 | 2.19360505 | Serendipita vermifera | 109899 | Fungi | Fungi | 43.5 | 0.0185 | NR | PVG03558.1 | 109899 | g58963 | i0 | 42.6 | 1.68979591836735 | 54 | 18 | 51.4 | 2 | 138 | 13 | 211 | 263 | PVG03558.1 hypothetical protein CPB86DRAFT_373706 [Serendipita vermifera] | diamond | 414 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 31558301 | 31558301 | PRJNA1218816_P_NODE_58496_length_246_cov_0.890173_g58063_i0 | PRJNA1218816 | 58496 | 246 | 0.890173 | 2.18982558 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 62.4 | 4.1e-9 | NR | XP_066823923.1 | 1397322 | g58063 | i0 | 58 | 1.1219512195122 | 50 | 18 | 57.3 | 1 | 235 | 95 | 117 | 166 | XP_066823923.1 ATPase, V0 complex, subunit D [Cystobasidium minutum MCA 4210] | diamond | 276 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum |
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);;