contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24794390 | 24794390 | PRJNA596870_P_NODE_21020_length_292_cov_1.050228_g20887_i0 | PRJNA596870 | 21020 | 292 | 1.050228 | 3.06666576 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 97.4 | 4.28e-21 | NR | GEM07500.1 | 5286 | g20887 | i0 | 72.5 | 0.708904109589041 | 69 | 14 | 65.8 | 1 | 70 | 261 | 528 | 596 | GEM07500.1 transcription factor [Rhodotorula toruloides] | diamond | 207 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 26840318 | 26840318 | PRJNA596870_P_NODE_21281_length_290_cov_1.322581_g21148_i0 | PRJNA596870 | 21281 | 290 | 1.322581 | 3.8354849 | Malassezia | 55193 | Fungi | Fungi | 84.7 | 1.15e-16 | NR | AYO44753.1 | 425264 | g21148 | i0 | 48.4 | 3.80689655172414 | 93 | 44 | 95.2 | 2 | 12 | 287 | 65 | 154 | AYO44753.1 Mannosyl-oligosaccharide 1,2-alpha-mannosidase MNS1 [Malassezia restricta CBS 7877] | diamond | 1104 | 85.5 | 0.990643274853801 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27029912 | 27029912 | PRJNA596870_P_NODE_40622_length_230_cov_3.044586_g40489_i0 | PRJNA596870 | 40622 | 230 | 3.044586 | 7.0025478 | Agaricomycetes | 155619 | Fungi | Fungi | 105 | 4.13e-25 | NR | GAW09975.1 | 5353 | g40489 | i0 | 78.4 | 32.7782608695652 | 74 | 16 | 96.5 | 0 | 8 | 229 | 12 | 85 | GAW09975.1 40s ribosomal protein s15 [Lentinula edodes] | diamond | 7539 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 27882845 | 27882845 | PRJNA596870_P_NODE_15225_length_336_cov_0.874525_g15092_i0 | PRJNA596870 | 15225 | 336 | 0.874525 | 2.938404 | Agaricales | 5338 | Fungi | Fungi | 101 | 3.72e-24 | NR | KAG6918455.1 | 117070 | g15092 | i0 | 40.2 | 4.83035714285714 | 112 | 66 | 99.1 | 1 | 3 | 335 | 65 | 176 | KAG6918455.1 hypothetical protein DXG01_014332 [Tephrocybe rancida] | diamond | 1623 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Tephrocybe | Tephrocybe rancida | |
| 28103715 | 28103715 | PRJNA596870_P_NODE_28045_length_255_cov_2.093407_g27912_i0 | PRJNA596870 | 28045 | 255 | 2.093407 | 5.33818785 | Malassezia | 55193 | Fungi | Fungi | 73.6 | 6.13e-13 | NR | AYO44699.1 | 425264 | g27912 | i0 | 78.6 | 3.49411764705882 | 42 | 9 | 49.4 | 0 | 1 | 126 | 495 | 536 | AYO44699.1 Cytosol aminopeptidase [Malassezia restricta CBS 7877] | diamond | 891 | 73.9 | 0.995940460081191 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29511209 | 29511209 | PRJNA596870_P_NODE_3190_length_661_cov_1.268707_g3062_i0 | PRJNA596870 | 3190 | 661 | 1.268707 | 8.38615327 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 46.2 | 0.0496 | NR | AYO41595.1 | 425264 | g3062 | i0 | 36.3 | 0.462934947049924 | 102 | 52 | 40.4 | 3 | 445 | 179 | 161 | 262 | AYO41595.1 RNA polymerase II holoenzyme cyclin-like subunit [Malassezia restricta CBS 7877] | diamond | 306 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29808760 | 29808760 | PRJNA596870_P_NODE_40251_length_241_cov_0.916667_g40118_i0 | PRJNA596870 | 40251 | 241 | 0.916667 | 2.20916747 | Fungi | 4751 | Fungi | Fungi | 103 | 1.04e-25 | NR | KAI8462047.1 | 170000 | g40118 | i0 | 60.8 | 7.39419087136929 | 74 | 29 | 92.1 | 0 | 227 | 6 | 1 | 74 | KAI8462047.1 actin-related protein 2/3 complex subunit 3 [Phakopsora pachyrhizi] | diamond | 1782 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 30016744 | 30016744 | PRJNA596870_P_NODE_29731_length_251_cov_0.865169_g29598_i0 | PRJNA596870 | 29731 | 251 | 0.865169 | 2.17157419 | Rhizoctonia solani | 456999 | Fungi | Fungi | 120 | 1.81e-29 | NR | KAJ1304700.1 | 456999 | g29598 | i0 | 74.3 | 15.203187250996 | 70 | 18 | 83.7 | 0 | 212 | 3 | 459 | 528 | KAJ1304700.1 hypothetical protein OPQ81_005839 [Rhizoctonia solani] | diamond | 3816 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 30333068 | 30333068 | PRJNA596870_P_NODE_22352_length_285_cov_1.089623_g22219_i0 | PRJNA596870 | 22352 | 285 | 1.089623 | 3.10542555 | Volvariella volvacea WC 439 | 1457512 | Fungi | Fungi | 44.3 | 0.0125 | NR | KAF8651455.1 | 1457512 | g22219 | i0 | 42.9 | 1.54736842105263 | 63 | 28 | 66.3 | 1 | 230 | 42 | 149 | 203 | KAF8651455.1 hypothetical protein AX16_004754 [Volvariella volvacea WC 439] | diamond | 441 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pluteaceae | Volvariella | Volvariella volvacea | |
| 30585193 | 30585193 | PRJNA596870_P_NODE_39033_length_242_cov_0.911243_g38900_i0 | PRJNA596870 | 39033 | 242 | 0.911243 | 2.20520806 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 122 | 2.34e-32 | NR | SHO75675.1 | 1230383 | g38900 | i0 | 71.8 | 1.93388429752066 | 78 | 22 | 96.7 | 0 | 240 | 7 | 174 | 251 | SHO75675.1 Similar to S.cerevisiae protein RSM24 (Mitochondrial ribosomal protein of the small subunit) [Malassezia sympodialis ATCC 42132] | diamond | 468 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 30838112 | 30838112 | PRJNA596870_P_NODE_30514_length_250_cov_0.870056_g30381_i0 | PRJNA596870 | 30514 | 250 | 0.870056 | 2.17514 | Scleroderma citrinum | 68788 | Fungi | Fungi | 48.5 | 2.49e-4 | NR | KAL4076127.1 | 68788 | g30381 | i0 | 46.5 | 0.516 | 43 | 23 | 51.6 | 0 | 119 | 247 | 84 | 126 | KAL4076127.1 hypothetical protein J3A83DRAFT_4225108 [Scleroderma citrinum] | diamond | 129 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Sclerodermataceae | Scleroderma | Scleroderma citrinum | |
| 30914829 | 30914829 | PRJNA596870_P_NODE_36534_length_244_cov_0.900585_g36401_i0 | PRJNA596870 | 36534 | 244 | 0.900585 | 2.1974274 | Fungi | 4751 | Fungi | Fungi | 67.8 | 1.41e-11 | NR | CEQ41488.1 | 5005 | g36401 | i0 | 41.3 | 5.87704918032787 | 80 | 43 | 97.1 | 2 | 239 | 3 | 27 | 103 | CEQ41488.1 SPOSA6832_03210, partial [Sporobolomyces salmonicolor] | diamond | 1434 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor | |
| 31216865 | 31216865 | PRJNA596870_P_NODE_38615_length_242_cov_0.911243_g38482_i0 | PRJNA596870 | 38615 | 242 | 0.911243 | 2.20520806 | Fomitopsis serialis | 139415 | Fungi | Fungi | 41.6 | 0.0247 | NR | XP_047897697.1 | 139415 | g38482 | i0 | 39.6 | 0.59504132231405 | 48 | 29 | 59.5 | 0 | 196 | 53 | 49 | 96 | XP_047897697.1 uncharacterized protein B0H18DRAFT_985384 [Fomitopsis serialis] | diamond | 144 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Fomitopsis | Fomitopsis serialis | |
| 31705085 | 31705085 | PRJNA596870_P_NODE_27357_length_259_cov_1.327957_g27224_i0 | PRJNA596870 | 27357 | 259 | 1.327957 | 3.43940863 | Fungi | 4751 | Fungi | Fungi | 55.5 | 1.31e-7 | NR | CED84866.1 | 264483 | g27224 | i0 | 50 | 5.59459459459459 | 50 | 25 | 57.9 | 0 | 222 | 73 | 51 | 100 | CED84866.1 40s ribosomal protein s25 [Phaffia rhodozyma] | diamond | 1449 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Phaffia | Phaffia rhodozyma | |
| 31863039 | 31863039 | PRJNA596870_P_NODE_30957_length_250_cov_0.870056_g30824_i0 | PRJNA596870 | 30957 | 250 | 0.870056 | 2.17514 | Agaricomycetes | 155619 | Fungi | Fungi | 136 | 1.41e-35 | NR | KAF4616301.1 | 84607 | g30824 | i0 | 74.7 | 23.904 | 83 | 21 | 99.6 | 0 | 249 | 1 | 393 | 475 | KAF4616301.1 hypothetical protein D9613_008356 [Agrocybe pediades] | diamond | 5976 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Agrocybe | Agrocybe pediades | |
| 32008103 | 32008103 | PRJNA596870_P_NODE_33958_length_247_cov_0.885057_g33825_i0 | PRJNA596870 | 33958 | 247 | 0.885057 | 2.18609079 | Trametopsis cervina | 1111950 | Fungi | Fungi | 68.6 | 2.77e-11 | NR | KAI0347253.1 | 1111950 | g33825 | i0 | 58 | 0.838056680161943 | 69 | 26 | 83.8 | 1 | 207 | 1 | 11 | 76 | KAI0347253.1 thiamine diphosphate-binding protein [Trametopsis cervina] | diamond | 207 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Trametopsis | Trametopsis cervina | |
| 32369698 | 32369698 | PRJNA596870_P_NODE_37079_length_244_cov_0.900585_g36946_i0 | PRJNA596870 | 37079 | 244 | 0.900585 | 2.1974274 | Opisthokonta | 33154 | Fungi | Fungi | 124 | 8.089999999999999e-32 | NR | CAD6886482.1 | 13290 | g36946 | i0 | 71.6 | 5.85245901639344 | 81 | 21 | 97.1 | 1 | 3 | 239 | 77 | 157 | CAD6886482.1 unnamed protein product [Tilletia caries] | diamond | 1428 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia caries | |
| 32766383 | 32766383 | PRJNA596870_P_NODE_19960_length_299_cov_1.336283_g19827_i0 | PRJNA596870 | 19960 | 299 | 1.336283 | 3.99548617 | Cristinia sonorae | 1940300 | Fungi | Fungi | 49.3 | 3.46e-4 | NR | KAH8093756.1 | 1940300 | g19827 | i0 | 35.7 | 2.65886287625418 | 70 | 37 | 62.2 | 2 | 291 | 106 | 249 | 318 | KAH8093756.1 kinase-like domain-containing protein [Cristinia sonorae] | diamond | 795 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Stephanosporaceae | Cristinia | Cristinia sonorae |
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);;