contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA728642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 712818 | 712818 | PRJNA728642_P_NODE_18001_length_245_cov_0.895349_g17730_i0 | PRJNA728642 | 18001 | 245 | 0.895349 | 2.19360505 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 142 | 4.95e-39 | NR | XP_017992104.1 | 77020 | g17730 | i0 | 75 | 6.84489795918367 | 80 | 20 | 98 | 0 | 243 | 4 | 201 | 280 | XP_017992104.1 cytochrome c peroxidase [Malassezia pachydermatis] | diamond | 1677 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 16015378 | 16015378 | PRJNA728642_P_NODE_19133_length_242_cov_0.911243_g18862_i0 | PRJNA728642 | 19133 | 242 | 0.911243 | 2.20520806 | Auricularia subglabra TFB-1 | 1331295 | Fungi | Fungi | 141 | 7.74e-38 | NR | EJD44682.1 | 717982 | g18862 | i0 | 93.2 | 0.90495867768595 | 73 | 5 | 90.5 | 0 | 220 | 2 | 1 | 73 | EJD44682.1 ammonium transporter [Auricularia subglabra TFB-10046 SS5] | diamond | 219 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia subglabra | |
| 26650836 | 26650836 | PRJNA728642_P_NODE_8001_length_361_cov_1.062500_g7730_i0 | PRJNA728642 | 8001 | 361 | 1.0625 | 3.835625 | Malassezia | 55193 | Fungi | Fungi | 50.1 | 3.59e-4 | NR | WFC97372.1 | 253288 | g7730 | i0 | 67.6 | 0.689750692520776 | 34 | 11 | 28.3 | 0 | 5 | 106 | 172 | 205 | WFC97372.1 peptidylprolyl isomerase [Malassezia yamatoensis] | diamond | 249 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia yamatoensis | |
| 26672128 | 26672128 | PRJNA728642_P_NODE_19261_length_242_cov_0.911243_g18990_i0 | PRJNA728642 | 19261 | 242 | 0.911243 | 2.20520806 | Mixia osmundae IAM 14324 | 764103 | Fungi | Fungi | 143 | 1.58e-38 | NR | XP_014569519.1 | 764103 | g18990 | i0 | 82.5 | 2.97520661157025 | 80 | 14 | 99.2 | 0 | 1 | 240 | 108 | 187 | XP_014569519.1 uncharacterized protein L969DRAFT_86189 [Mixia osmundae IAM 14324] | diamond | 720 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Mixiomycetes | Mixiales | Mixiaceae | Mixia | Mixia osmundae | |
| 27083957 | 27083957 | PRJNA728642_P_NODE_18122_length_245_cov_0.895349_g17851_i0 | PRJNA728642 | 18122 | 245 | 0.895349 | 2.19360505 | Malassezia globosa CBS 7966 | 425265 | Fungi | Fungi | 99 | 6.34e-22 | NR | XP_001730010.1 | 425265 | g17851 | i0 | 64.2 | 0.991836734693878 | 81 | 29 | 99.2 | 0 | 245 | 3 | 278 | 358 | XP_001730010.1 uncharacterized protein MGL_2996 [Malassezia globosa CBS 7966] | diamond | 243 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 28410420 | 28410420 | PRJNA728642_P_NODE_12606_length_284_cov_1.123223_g12335_i0 | PRJNA728642 | 12606 | 284 | 1.123223 | 3.18995332 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 73.9 | 6.78e-13 | NR | WFD16437.1 | 1514897 | g12335 | i0 | 68.3 | 0.665492957746479 | 63 | 8 | 53.9 | 1 | 2 | 154 | 938 | 1000 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 189 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 28452376 | 28452376 | PRJNA728642_P_NODE_19146_length_242_cov_0.911243_g18875_i0 | PRJNA728642 | 19146 | 242 | 0.911243 | 2.20520806 | Malassezia | 55193 | Fungi | Fungi | 95.1 | 1.37e-20 | NR | XP_001731387.1 | 425265 | g18875 | i0 | 67.6 | 4.42561983471074 | 71 | 23 | 88 | 0 | 215 | 3 | 173 | 243 | XP_001731387.1 uncharacterized protein MGL_1570 [Malassezia globosa CBS 7966] | diamond | 1071 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 29010651 | 29010651 | PRJNA728642_P_NODE_18468_length_244_cov_0.900585_g18197_i0 | PRJNA728642 | 18468 | 244 | 0.900585 | 2.1974274 | Austropuccinia psidii | 181123 | Fungi | Fungi | 52 | 2.08e-5 | NR | MBW0545626.1 | 1389203 | g18197 | i0 | 46.8 | 1.61065573770492 | 62 | 31 | 73.8 | 1 | 50 | 229 | 451 | 512 | MBW0545626.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 393 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 29641395 | 29641395 | PRJNA728642_P_NODE_16070_length_250_cov_1.672316_g15799_i0 | PRJNA728642 | 16070 | 250 | 1.672316 | 4.18079 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 114 | 3.3700000000000004e-27 | NR | CAD6576965.1 | 2778381 | g15799 | i0 | 91.5 | 0.708 | 59 | 5 | 70.8 | 0 | 248 | 72 | 80 | 138 | CAD6576965.1 MAG: hypothetical protein CYPHOPRED_000135 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 177 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 30589326 | 30589326 | PRJNA728642_P_NODE_16453_length_249_cov_1.329545_g16182_i0 | PRJNA728642 | 16453 | 249 | 1.329545 | 3.31056705 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 91.7 | 2.14e-19 | NR | XP_018739313.1 | 1230383 | g16182 | i0 | 53.8 | 1.09638554216867 | 91 | 31 | 96.4 | 3 | 9 | 248 | 182 | 272 | XP_018739313.1 Hypothetical protein, predicted to be GPI anchored [Malassezia sympodialis ATCC 42132] | diamond | 273 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 31411205 | 31411205 | PRJNA728642_P_NODE_12776_length_282_cov_1.196172_g12505_i0 | PRJNA728642 | 12776 | 282 | 1.196172 | 3.37320504 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 149 | 1.37e-43 | NR | AYO43044.1 | 425264 | g12505 | i0 | 85.1 | 1 | 94 | 14 | 100 | 0 | 282 | 1 | 12 | 105 | AYO43044.1 uncharacterized protein [Malassezia restricta CBS 7877] | diamond | 282 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 31664043 | 31664043 | PRJNA728642_P_NODE_17617_length_246_cov_0.890173_g17346_i0 | PRJNA728642 | 17617 | 246 | 0.890173 | 2.18982558 | Schizophyllum commune | 5334 | Fungi | Fungi | 152 | 9.349999999999999e-42 | NR | KAL1736121.1 | 5334 | g17346 | i0 | 86.4 | 0.98780487804878 | 81 | 11 | 98.8 | 0 | 244 | 2 | 271 | 351 | KAL1736121.1 hypothetical protein EV714DRAFT_266967 [Schizophyllum commune] | diamond | 243 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 31790487 | 31790487 | PRJNA728642_P_NODE_16717_length_249_cov_0.875000_g16446_i0 | PRJNA728642 | 16717 | 249 | 0.875 | 2.17875 | Exobasidium rhododendri | 63378 | Fungi | Fungi | 164 | 2.3999999999999994e-46 | NR | UZJ56728.1 | 63378 | g16446 | i0 | 89 | 1.97590361445783 | 82 | 9 | 98.8 | 0 | 248 | 3 | 184 | 265 | UZJ56728.1 hypothetical protein CBS101457_006048 [Exobasidium rhododendri] | diamond | 492 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Exobasidiaceae | Exobasidium | Exobasidium rhododendri | |
| 31948754 | 31948754 | PRJNA728642_P_NODE_15997_length_251_cov_0.865169_g15726_i0 | PRJNA728642 | 15997 | 251 | 0.865169 | 2.17157419 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 122 | 2.48e-30 | NR | XP_017991059.1 | 77020 | g15726 | i0 | 73.5 | 6.94422310756972 | 83 | 22 | 99.2 | 0 | 251 | 3 | 70 | 152 | XP_017991059.1 camp-dependent protein kinase regulatory subunit [Malassezia pachydermatis] | diamond | 1743 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 32770421 | 32770421 | PRJNA728642_P_NODE_17320_length_247_cov_0.885057_g17049_i0 | PRJNA728642 | 17320 | 247 | 0.885057 | 2.18609079 | Exobasidium rhododendri | 63378 | Fungi | Fungi | 89.7 | 1.16e-18 | NR | UZJ52588.1 | 63378 | g17049 | i0 | 61.8 | 0.825910931174089 | 68 | 26 | 82.6 | 0 | 2 | 205 | 620 | 687 | UZJ52588.1 hypothetical protein CBS101457_001908 [Exobasidium rhododendri] | diamond | 204 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Exobasidiaceae | Exobasidium | Exobasidium rhododendri | |
| 32801909 | 32801909 | PRJNA728642_P_NODE_16160_length_250_cov_0.870056_g15889_i0 | PRJNA728642 | 16160 | 250 | 0.870056 | 2.17514 | Malassezia vespertilionis | 2020962 | Fungi | Fungi | 99.8 | 3.77e-22 | NR | PKI83055.1 | 2020962 | g15889 | i0 | 50 | 2.496 | 104 | 31 | 99.6 | 1 | 249 | 1 | 1542 | 1645 | PKI83055.1 hypothetical protein MVES_002987 [Malassezia vespertilionis] | diamond | 624 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia vespertilionis |
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);;