contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA235310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6744980 | 6744980 | PRJNA235310_P_NODE_1426_length_338_cov_1.487889_g1400_i0 | PRJNA235310 | 1426 | 338 | 1.487889 | 5.02906482 | Hermanssonia centrifuga | 98765 | Fungi | Fungi | 153 | 4.96e-43 | NR | THG98393.1 | 98765 | g1400 | i0 | 61.3 | 3.94970414201183 | 111 | 43 | 98.5 | 0 | 336 | 4 | 188 | 298 | THG98393.1 hypothetical protein EW026_g3779 [Hermanssonia centrifuga] | diamond | 1335 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meruliaceae | Hermanssonia | Hermanssonia centrifuga | |
| 6745023 | 6745023 | PRJNA235310_P_NODE_3506_length_201_cov_1.710526_g3480_i0 | PRJNA235310 | 3506 | 201 | 1.710526 | 3.43815726 | Polyporales | 5303 | Fungi | Fungi | 86.3 | 9.69e-18 | NR | KAI0080806.1 | 1314784 | g3480 | i0 | 60.6 | 5.8955223880597 | 66 | 26 | 98.5 | 0 | 199 | 2 | 516 | 581 | KAI0080806.1 tripeptidyl peptidase A [Panus rudis PR-1116 ss-1] | diamond | 1185 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Panaceae | Panus | Panus rudis | |
| 15670175 | 15670175 | PRJNA235310_P_NODE_4453_length_176_cov_1.637795_g4427_i0 | PRJNA235310 | 4453 | 176 | 1.637795 | 2.8825192 | Fungi | 4751 | Fungi | Fungi | 109 | 1.51e-26 | NR | KAA1095001.1 | 56615 | g4427 | i0 | 86.2 | 31.6363636363636 | 58 | 8 | 98.9 | 0 | 2 | 175 | 169 | 226 | KAA1095001.1 Arp2/3 complex subunit, actin nucleation center [Puccinia graminis f. sp. tritici] | diamond | 5568 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis | |
| 16944627 | 16944627 | PRJNA235310_P_NODE_2054_length_274_cov_0.924444_g2028_i0 | PRJNA235310 | 2054 | 274 | 0.924444 | 2.53297656 | Eukaryota | 2759 | Fungi | Fungi | 126 | 8.22e-33 | NR | KAJ8297360.1 | 5286 | g2028 | i0 | 69.3 | 15.7335766423358 | 88 | 26 | 95.3 | 1 | 262 | 2 | 12 | 99 | KAJ8297360.1 ADP,ATP carrier protein [Rhodotorula toruloides] | diamond | 4311 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 19493281 | 19493281 | PRJNA235310_P_NODE_1256_length_360_cov_1.643087_g1230_i0 | PRJNA235310 | 1256 | 360 | 1.643087 | 5.9151132 | Schizophyllum commune H4-8 | 578458 | Fungi | Fungi | 86.3 | 7.73e-17 | NR | XP_003036186.1 | 578458 | g1230 | i0 | 45.8 | 1.95833333333333 | 118 | 51 | 89.2 | 3 | 2 | 322 | 337 | 452 | XP_003036186.1 uncharacterized protein SCHCODRAFT_02604934 [Schizophyllum commune H4-8] | diamond | 705 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 19493369 | 19493369 | PRJNA235310_P_NODE_976_length_402_cov_8.393768_g950_i0 | PRJNA235310 | 976 | 402 | 8.393768 | 33.74294736 | Agaricales | 5338 | Fungi | Fungi | 102 | 2.6799999999999998e-25 | NR | KAJ7068542.1 | 380012 | g950 | i0 | 69.4 | 1.61194029850746 | 72 | 22 | 53.7 | 0 | 349 | 134 | 30 | 101 | KAJ7068542.1 ribosomal protein S21e, partial [Mycena amicta] | diamond | 648 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena amicta | |
| 27800687 | 27800687 | PRJNA235310_P_NODE_684_length_471_cov_10.618483_g658_i0 | PRJNA235310 | 684 | 471 | 10.618483 | 50.01305493 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 128 | 1.0599999999999999e-34 | NR | SHO79069.1 | 1230383 | g658 | i0 | 45.8 | 1.6687898089172 | 131 | 71 | 83.4 | 0 | 12 | 404 | 1 | 131 | SHO79069.1 Ribosomal 60S subunit protein L14B [Malassezia sympodialis ATCC 42132] | diamond | 786 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 28147986 | 28147986 | PRJNA235310_P_NODE_2605_length_238_cov_1.312169_g2579_i0 | PRJNA235310 | 2605 | 238 | 1.312169 | 3.12296222 | Termitomyces sp. T112 | 1850345 | Fungi | Fungi | 90.5 | 4.16e-19 | NR | KAG5727686.1 | 1850345 | g2579 | i0 | 63.3 | 0.756302521008403 | 60 | 22 | 75.6 | 0 | 2 | 181 | 386 | 445 | KAG5727686.1 hypothetical protein E4T56_gene12245 [Termitomyces sp. T112] | diamond | 180 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Termitomyces | Termitomyces sp. T112 | |
| 28165653 | 28165653 | PRJNA235310_P_NODE_3265_length_210_cov_0.968944_g3239_i0 | PRJNA235310 | 3265 | 210 | 0.968944 | 2.0347824 | Russulales | 452342 | Fungi | Fungi | 75.5 | 1.66e-15 | NR | KAF8267794.1 | 111141 | g3239 | i0 | 60.6 | 11.4857142857143 | 66 | 23 | 94.3 | 1 | 198 | 1 | 23 | 85 | KAF8267794.1 60S ribosomal protein L33-A-like protein [Lactarius quietus] | diamond | 2412 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactarius | Lactarius quietus | |
| 29442110 | 29442110 | PRJNA235310_P_NODE_2850_length_226_cov_1.175141_g2824_i0 | PRJNA235310 | 2850 | 226 | 1.175141 | 2.65581866 | Hydnum rufescens UP5 | 139363 | Fungi | Fungi | 77 | 1.4e-14 | NR | KAF9520922.1 | 1448309 | g2824 | i0 | 55.6 | 0.836283185840708 | 63 | 27 | 82.3 | 1 | 213 | 28 | 184 | 246 | KAF9520922.1 hypothetical protein BS47DRAFT_1335601 [Hydnum rufescens UP504] | diamond | 189 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Hydnaceae | Hydnum | Hydnum rufescens | |
| 30042357 | 30042357 | PRJNA235310_P_NODE_1731_length_305_cov_1.203125_g1705_i0 | PRJNA235310 | 1731 | 305 | 1.203125 | 3.66953125 | Microbotryum intermedium | 269621 | Fungi | Fungi | 46.2 | 0.00454 | NR | SCV67859.1 | 269621 | g1705 | i0 | 51 | 0.481967213114754 | 49 | 24 | 48.2 | 0 | 279 | 133 | 231 | 279 | SCV67859.1 BQ2448_5470 [Microbotryum intermedium] | diamond | 147 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Microbotryales | Microbotryaceae | Microbotryum | Microbotryum intermedium | |
| 30042360 | 30042360 | PRJNA235310_P_NODE_3951_length_190_cov_1.312057_g3925_i0 | PRJNA235310 | 3951 | 190 | 1.312057 | 2.4929083 | Schizophyllum commune H4-8 | 578458 | Fungi | Fungi | 82 | 2.54e-16 | NR | XP_003026183.1 | 578458 | g3925 | i0 | 56.5 | 3.94736842105263 | 69 | 22 | 96.3 | 2 | 188 | 6 | 198 | 266 | XP_003026183.1 uncharacterized protein SCHCODRAFT_02645865 [Schizophyllum commune H4-8] | diamond | 750 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 30060011 | 30060011 | PRJNA235310_P_NODE_3531_length_201_cov_0.973684_g3505_i0 | PRJNA235310 | 3531 | 201 | 0.973684 | 1.95710484 | Basidiomycota | 5204 | Fungi | Fungi | 46.6 | 9.2e-4 | NR | KAI0273347.1 | 205761 | g3505 | i0 | 64.5 | 0.925373134328358 | 31 | 11 | 46.3 | 0 | 107 | 199 | 132 | 162 | KAI0273347.1 N-myristoyl transferase [Gloeopeniophorella convolvens] | diamond | 186 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Gloeopeniophorella | Gloeopeniophorella convolvens | ||
| 30105478 | 30105478 | PRJNA235310_P_NODE_4372_length_179_cov_0.807692_g4346_i0 | PRJNA235310 | 4372 | 179 | 0.807692 | 1.44576868 | Malassezia brasiliensis | 1821822 | Fungi | Fungi | 45.8 | 0.00131 | NR | WFC95400.1 | 1821822 | g4346 | i0 | 41.5 | 0.888268156424581 | 53 | 30 | 87.2 | 1 | 18 | 173 | 1403 | 1455 | WFC95400.1 phosphoinositide 5-phosphatase [Malassezia brasiliensis] | diamond | 159 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia brasiliensis | |
| 30439491 | 30439491 | PRJNA235310_P_NODE_1553_length_323_cov_1.142336_g1527_i0 | PRJNA235310 | 1553 | 323 | 1.142336 | 3.68974528 | Fungi | 4751 | Fungi | Fungi | 95.5 | 2.88e-20 | NR | KAF9501018.1 | 5323 | g1527 | i0 | 47.2 | 7.96904024767802 | 108 | 54 | 97.5 | 2 | 319 | 5 | 190 | 297 | KAF9501018.1 polyadenylate binding protein [Pleurotus eryngii] | diamond | 2574 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus eryngii | |
| 32065439 | 32065439 | PRJNA235310_P_NODE_4818_length_169_cov_1.291667_g4792_i0 | PRJNA235310 | 4818 | 169 | 1.291667 | 2.18291723 | Tulasnella sp. JGI-2 | 1905295 | Fungi | Fungi | 94.4 | 2.8100000000000003e-21 | NR | KAG8990909.1 | 2600232 | g4792 | i0 | 76.4 | 4.88165680473373 | 55 | 13 | 97.6 | 0 | 3 | 167 | 78 | 132 | KAG8990909.1 Delta(24)-sterol C-methyltransferase [Tulasnella sp. JGI-2019a] | diamond | 825 | 94.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella sp. JGI-2019a | ||
| 32620858 | 32620858 | PRJNA235310_P_NODE_3600_length_199_cov_1.040000_g3574_i0 | PRJNA235310 | 3600 | 199 | 1.04 | 2.0696 | Basidiomycota | 5204 | Fungi | Fungi | 83.2 | 1.15e-16 | NR | KAF9530967.1 | 179855 | g3574 | i0 | 64.5 | 15.2110552763819 | 62 | 22 | 93.5 | 0 | 2 | 187 | 461 | 522 | KAF9530967.1 t-complex protein 1 [Crepidotus variabilis] | diamond | 3027 | 84 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Crepidotaceae | Crepidotus | Crepidotus variabilis | |
| 32666119 | 32666119 | PRJNA235310_P_NODE_4460_length_176_cov_1.629921_g4434_i0 | PRJNA235310 | 4460 | 176 | 1.629921 | 2.86866096 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 79.7 | 5.83e-16 | NR | XP_025597293.1 | 58919 | g4434 | i0 | 65.5 | 2.96590909090909 | 58 | 20 | 98.9 | 0 | 174 | 1 | 89 | 146 | XP_025597293.1 putative CYT1-cytochrome c1, heme protein [Tilletiopsis washingtonensis] | diamond | 522 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 32697545 | 32697545 | PRJNA235310_P_NODE_2680_length_233_cov_1.945652_g2654_i0 | PRJNA235310 | 2680 | 233 | 1.945652 | 4.53336916 | Physisporinus lineatus | 2056292 | Fungi | Fungi | 42.7 | 0.00503 | NR | KAJ3483249.1 | 2056292 | g2654 | i0 | 47.5 | 0.515021459227468 | 40 | 21 | 51.5 | 0 | 93 | 212 | 22 | 61 | KAJ3483249.1 hypothetical protein NLI96_g6431 [Physisporinus lineatus] | diamond | 120 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meripilaceae | Meripilus | Meripilus lineatus |
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);;