contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22041066 | 22041066 | PRJNA168635_P_NODE_20958_length_179_cov_2.053846_g20542_i0 | PRJNA168635 | 20958 | 179 | 2.053846 | 3.67638434 | Rhodotorula | 5533 | Fungi | Fungi | 116 | 1.06e-28 | NR | GAA6013910.1 | 86839 | g20542 | i0 | 89.8 | 3.95530726256983 | 59 | 6 | 98.9 | 0 | 2 | 178 | 36 | 94 | GAA6013910.1 hypothetical protein JCM8202_000858 [Rhodotorula sphaerocarpa] | diamond | 708 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sphaerocarpa | |
| 26662080 | 26662080 | PRJNA168635_P_NODE_19581_length_184_cov_1.088889_g19165_i0 | PRJNA168635 | 19581 | 184 | 1.088889 | 2.00355576 | Pleurotus ostreatus PC15 | 1137138 | Fungi | Fungi | 40 | 0.0415 | NR | KDQ32286.1 | 1137138 | g19165 | i0 | 46.2 | 0.635869565217391 | 39 | 21 | 63.6 | 0 | 117 | 1 | 34 | 72 | KDQ32286.1 hypothetical protein PLEOSDRAFT_22346, partial [Pleurotus ostreatus PC15] | diamond | 117 | 40 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 26743175 | 26743175 | PRJNA168635_P_NODE_22321_length_175_cov_3.753968_g21905_i0 | PRJNA168635 | 22321 | 175 | 3.753968 | 6.569444 | Fungi | 4751 | Fungi | Fungi | 73.2 | 2.52e-14 | NR | CDO78072.1 | 5643 | g21905 | i0 | 66 | 12.0342857142857 | 53 | 18 | 90.9 | 0 | 164 | 6 | 124 | 176 | CDO78072.1 hypothetical protein BN946_scf184708.g6 [Trametes cinnabarina] | diamond | 2106 | 73.9 | 0.990527740189445 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes cinnabarina | |
| 26775409 | 26775409 | PRJNA168635_P_NODE_31721_length_162_cov_1.707965_g31305_i0 | PRJNA168635 | 31721 | 162 | 1.707965 | 2.7669033 | Lyophyllaceae | 930979 | Fungi | Fungi | 76.3 | 1.94e-14 | NR | KAG6854847.1 | 530045 | g31305 | i0 | 64.2 | 10.8148148148148 | 53 | 18 | 98.1 | 1 | 1 | 159 | 181 | 232 | KAG6854847.1 hypothetical protein C0991_012037 [Blastosporella zonata] | diamond | 1752 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Blastosporella | Blastosporella zonata | |
| 27895073 | 27895073 | PRJNA168635_P_NODE_34145_length_155_cov_7.971698_g33729_i0 | PRJNA168635 | 34145 | 155 | 7.971698 | 12.3561319 | Melampsora larici-populina 98AG31 | 747676 | Fungi | Fungi | 44.7 | 0.00192 | NR | EGG06257.1 | 747676 | g33729 | i0 | 78.6 | 5.41935483870968 | 28 | 6 | 54.2 | 0 | 1 | 84 | 33 | 60 | EGG06257.1 hypothetical protein MELLADRAFT_87416 [Melampsora larici-populina 98AG31] | diamond | 840 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 28039371 | 28039371 | PRJNA168635_P_NODE_29045_length_165_cov_0.896552_g28629_i0 | PRJNA168635 | 29045 | 165 | 0.896552 | 1.4793108 | Fungi | 4751 | Fungi | Fungi | 58.2 | 1.14e-8 | NR | KAK0543130.1 | 155126 | g28629 | i0 | 56.4 | 4 | 55 | 23 | 98.2 | 1 | 164 | 3 | 81 | 135 | KAK0543130.1 hypothetical protein OC845_006279 [Tilletia horrida] | diamond | 660 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia horrida | |
| 28242312 | 28242312 | PRJNA168635_P_NODE_21446_length_178_cov_1.403101_g21030_i0 | PRJNA168635 | 21446 | 178 | 1.403101 | 2.49751978 | Hebeloma cylindrosporum | 76867 | Fungi | Fungi | 60.8 | 6.23e-9 | NR | KIM34762.1 | 76867 | g21030 | i0 | 65.1 | 3.48876404494382 | 43 | 15 | 72.5 | 0 | 177 | 49 | 141 | 183 | KIM34762.1 hypothetical protein M413DRAFT_33045 [Hebeloma cylindrosporum] | diamond | 621 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hymenogastraceae | Hebeloma | Hebeloma cylindrosporum | |
| 28273920 | 28273920 | PRJNA168635_P_NODE_34066_length_156_cov_2.336449_g33650_i0 | PRJNA168635 | 34066 | 156 | 2.336449 | 3.64486044 | Ceratobasidium sp. AG-I | 305860 | Fungi | Fungi | 47 | 3.56e-4 | NR | KAF8593326.1 | 305860 | g33650 | i0 | 37.2 | 0.826923076923077 | 43 | 27 | 82.7 | 0 | 17 | 145 | 404 | 446 | KAF8593326.1 hypothetical protein BDV93DRAFT_252509 [Ceratobasidium sp. AG-I] | diamond | 129 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. AG-I | |
| 28716189 | 28716189 | PRJNA168635_P_NODE_34207_length_155_cov_4.094340_g33791_i0 | PRJNA168635 | 34207 | 155 | 4.09434 | 6.346227 | Mycena sanguinolenta | 230812 | Fungi | Fungi | 42.7 | 0.0111 | NR | KAJ6500462.1 | 230812 | g33791 | i0 | 39.5 | 7.0258064516129 | 38 | 23 | 73.5 | 0 | 41 | 154 | 72 | 109 | KAJ6500462.1 kinase-like domain-containing protein, partial [Mycena sanguinolenta] | diamond | 1089 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena sanguinolenta | |
| 29049783 | 29049783 | PRJNA168635_P_NODE_20148_length_182_cov_1.210526_g19732_i0 | PRJNA168635 | 20148 | 182 | 1.210526 | 2.20315732 | Opisthokonta | 33154 | Fungi | Fungi | 54.3 | 5.96e-7 | NR | XP_047751322.1 | 181762 | g19732 | i0 | 50.9 | 4.66483516483517 | 53 | 21 | 79.1 | 1 | 7 | 150 | 55 | 107 | XP_047751322.1 hypothetical protein JR316_0003168 [Psilocybe cubensis] | diamond | 849 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cubensis | |
| 29694570 | 29694570 | PRJNA168635_P_NODE_33790_length_156_cov_15.476636_g33374_i0 | PRJNA168635 | 33790 | 156 | 15.476636 | 24.14355216 | Melampsora larici-populina 98AG31 | 747676 | Fungi | Fungi | 42 | 0.00234 | NR | EGG06258.1 | 747676 | g33374 | i0 | 68 | 0.480769230769231 | 25 | 8 | 48.1 | 0 | 109 | 35 | 29 | 53 | EGG06258.1 hypothetical protein MELLADRAFT_87418 [Melampsora larici-populina 98AG31] | diamond | 75 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 30832169 | 30832169 | PRJNA168635_P_NODE_29814_length_164_cov_0.904348_g29398_i0 | PRJNA168635 | 29814 | 164 | 0.904348 | 1.48313072 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 96.3 | 4.27e-24 | NR | XP_025377244.1 | 215250 | g29398 | i0 | 98.1 | 1.90243902439024 | 52 | 1 | 95.1 | 0 | 157 | 2 | 61 | 112 | XP_025377244.1 putative 60S ribosomal protein L36 [Acaromyces ingoldii] | diamond | 312 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 31116307 | 31116307 | PRJNA168635_P_NODE_2055_length_563_cov_9.494163_g1685_i0 | PRJNA168635 | 2055 | 563 | 9.494163 | 53.45213769 | Melampsora larici-populina 98AG31 | 747676 | Fungi | Fungi | 45.8 | 0.0283 | NR | EGG11068.1 | 747676 | g1685 | i0 | 65.7 | 0.564831261101243 | 35 | 12 | 18.7 | 0 | 221 | 117 | 165 | 199 | EGG11068.1 hypothetical protein MELLADRAFT_92511 [Melampsora larici-populina 98AG31] | diamond | 318 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 31260821 | 31260821 | PRJNA168635_P_NODE_31135_length_163_cov_0.912281_g30719_i0 | PRJNA168635 | 31135 | 163 | 0.912281 | 1.48701803 | Agaricomycetes | 155619 | Fungi | Fungi | 70.1 | 1.88e-12 | NR | KAI9511555.1 | 71964 | g30719 | i0 | 61.1 | 12.7361963190184 | 54 | 21 | 99.4 | 0 | 1 | 162 | 112 | 165 | KAI9511555.1 cytochrome C1 family-domain-containing protein, partial [Russula earlei] | diamond | 2076 | 70.5 | 0.994326241134752 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula earlei | |
| 31323969 | 31323969 | PRJNA168635_P_NODE_15835_length_201_cov_3.144737_g15419_i0 | PRJNA168635 | 15835 | 201 | 3.144737 | 6.32092137 | root | 1 | Root_unresolved | Root_unresolved | 42.4 | 0.0299 | NR | KAJ7291204.1 | 1045383 | g15419 | i0 | 64.5 | 2.25373134328358 | 31 | 11 | 46.3 | 0 | 2 | 94 | 1089 | 1119 | KAJ7291204.1 ankyrin repeat-containing domain protein [Mycena rebaudengoi] | diamond | 453 | 42.7 | 0.992974238875878 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena rebaudengoi | |
| 31355821 | 31355821 | PRJNA168635_P_NODE_13796_length_218_cov_0.857988_g13380_i0 | PRJNA168635 | 13796 | 218 | 0.857988 | 1.87041384 | Exobasidiomycetes | 452283 | Fungi | Fungi | 81.6 | 6.44e-18 | NR | XP_025601698.1 | 58919 | g13380 | i0 | 95.5 | 4.84403669724771 | 44 | 2 | 60.6 | 0 | 210 | 79 | 79 | 122 | XP_025601698.1 sterol-binding-like protein [Tilletiopsis washingtonensis] | diamond | 1056 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 31622463 | 31622463 | PRJNA168635_P_NODE_22496_length_175_cov_1.626984_g22080_i0 | PRJNA168635 | 22496 | 175 | 1.626984 | 2.847222 | Austropuccinia psidii | 181123 | Fungi | Fungi | 57.4 | 4.75e-8 | NR | MBW0586003.1 | 1389203 | g22080 | i0 | 45.8 | 2.79428571428571 | 48 | 26 | 82.3 | 0 | 173 | 30 | 57 | 104 | MBW0586003.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 489 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 32033818 | 32033818 | PRJNA168635_P_NODE_28998_length_165_cov_0.896552_g28582_i0 | PRJNA168635 | 28998 | 165 | 0.896552 | 1.4793108 | Mycena leptocephala | 230808 | Fungi | Fungi | 42.4 | 0.0184 | NR | KAJ7929770.1 | 230808 | g28582 | i0 | 42.1 | 0.690909090909091 | 38 | 22 | 69.1 | 0 | 43 | 156 | 38 | 75 | KAJ7929770.1 hypothetical protein B0H13DRAFT_1859490 [Mycena leptocephala] | diamond | 114 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena leptocephala | |
| 32255653 | 32255653 | PRJNA168635_P_NODE_31538_length_162_cov_2.415929_g31122_i0 | PRJNA168635 | 31538 | 162 | 2.415929 | 3.91380498 | Physisporinus lineatus | 2056292 | Fungi | Fungi | 45.1 | 0.00184 | NR | KAJ3475665.1 | 2056292 | g31122 | i0 | 58.3 | 7.03703703703704 | 36 | 15 | 66.7 | 0 | 1 | 108 | 16 | 51 | KAJ3475665.1 hypothetical protein NLI96_g11684 [Physisporinus lineatus] | diamond | 1140 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meripilaceae | Meripilus | Meripilus lineatus | |
| 32273298 | 32273298 | PRJNA168635_P_NODE_14818_length_209_cov_1.931250_g14402_i0 | PRJNA168635 | 14818 | 209 | 1.93125 | 4.0363125 | Opisthokonta | 33154 | Fungi | Fungi | 77.8 | 1.37e-15 | NR | KAI8452562.1 | 170000 | g14402 | i0 | 67.2 | 3.44497607655502 | 58 | 19 | 83.3 | 0 | 176 | 3 | 144 | 201 | KAI8452562.1 40S ribosomal protein S8 [Phakopsora pachyrhizi] | diamond | 720 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 32666043 | 32666043 | PRJNA168635_P_NODE_32940_length_159_cov_11.463636_g32524_i0 | PRJNA168635 | 32940 | 159 | 11.463636 | 18.22718124 | Athelia psychrophila | 1759441 | Fungi | Fungi | 44.3 | 3.1e-4 | NR | KZP32736.1 | 1759441 | g32524 | i0 | 57.1 | 0.660377358490566 | 35 | 15 | 66 | 0 | 119 | 15 | 8 | 42 | KZP32736.1 hypothetical protein FIBSPDRAFT_482118 [Athelia psychrophila] | diamond | 105 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Atheliales | Atheliaceae | Athelia | Athelia psychrophila | |
| 32778182 | 32778182 | PRJNA168635_P_NODE_27740_length_166_cov_1.769231_g27324_i0 | PRJNA168635 | 27740 | 166 | 1.769231 | 2.93692346 | Basidiomycota | 5204 | Fungi | Fungi | 97.8 | 1.4399999999999994e-23 | NR | KIJ38898.1 | 990650 | g27324 | i0 | 78.2 | 38.7469879518072 | 55 | 12 | 99.4 | 0 | 165 | 1 | 7 | 61 | KIJ38898.1 hypothetical protein M422DRAFT_32973 [Sphaerobolus stellatus SS14] | diamond | 6432 | 98.6 | 0.991886409736308 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Geastrales | Sphaerobolaceae | Sphaerobolus | Sphaerobolus stellatus | |
| 32904177 | 32904177 | PRJNA168635_P_NODE_21300_length_178_cov_2.255814_g20884_i0 | PRJNA168635 | 21300 | 178 | 2.255814 | 4.01534892 | Basidiomycota | 5204 | Fungi | Fungi | 58.2 | 5.47e-8 | NR | KAI0793046.1 | 5319 | g20884 | i0 | 75 | 4.80337078651685 | 32 | 8 | 53.9 | 0 | 170 | 75 | 279 | 310 | KAI0793046.1 hypothetical protein BC629DRAFT_342154 [Irpex lacteus] | diamond | 855 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Irpex | Irpex lacteus |
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);;