contig_metadata
22 rows where bioproject = "PRJNA879221", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8509582 | 8509582 | PRJNA879221_P_NODE_13087_length_499_cov_14.241784_g12948_i0 | PRJNA879221 | 13087 | 499 | 14.241784000000001 | 71.06650216 | Cutaneotrichosporon spelunceum | 1672016 | Fungi | Fungi | 778 | 0 | NTclustered | gi|2523938254|dbj|AP028247.1| | 1672016 | g12948 | i0 | 96.603 | 13.6012024048096 | 471 | 13 | 94 | 1 | 29 | 499 | 11125 | 11592 | Cutaneotrichosporon spelunceum HIS016 mitochondrial DNA, complete genome | blastn | 6787 | 778 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon spelunceum | |
| 8510270 | 8510270 | PRJNA879221_P_NODE_8307_length_643_cov_12.873684_g8171_i0 | PRJNA879221 | 8307 | 643 | 12.873684 | 82.77778812 | Malassezia globosa | 76773 | Fungi | Fungi | 704 | 0 | NTclustered | gi|164656370|ref|XM_001729261.1| | 425265 | g8171 | i0 | 98.982 | 2.66874027993779 | 393 | 4 | 61 | 0 | 48 | 440 | 1 | 393 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3348), partial mRNA | blastn | 1716 | 704 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 9784559 | 9784559 | PRJNA879221_P_NODE_15328_length_458_cov_7.371429_g15189_i0 | PRJNA879221 | 15328 | 458 | 7.371429 | 33.76114482 | Malassezia restricta | 76775 | Fungi | Fungi | 586 | 9.849999999999997e-163 | NTclustered | gi|1546636309|ref|XM_027629797.1| | 76775 | g15189 | i0 | 93.434 | 1.73799126637555 | 396 | 25 | 86 | 1 | 33 | 427 | 1 | 396 | Malassezia restricta NADH dehydrogenase (ubiquinone) 1 alpha subcomplex subunit 6 (MRET_3170), partial mRNA | blastn | 796 | 586 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9785009 | 9785009 | PRJNA879221_P_NODE_50148_length_249_cov_0.875000_g50008_i0 | PRJNA879221 | 50148 | 249 | 0.875 | 2.17875 | Malassezia restricta | 76775 | Fungi | Fungi | 435 | 1.92e-117 | NTclustered | gi|1488178351|ref|NC_039455.1| | 76775 | g50008 | i0 | 98.776 | 9.0281124497992 | 245 | 2 | 99 | 1 | 3 | 247 | 23439 | 23196 | Malassezia restricta mitochondrion, complete genome | blastn | 2248 | 435 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12335916 | 12335916 | PRJNA879221_P_NODE_24070_length_359_cov_2.272727_g23930_i0 | PRJNA879221 | 24070 | 359 | 2.272727 | 8.15908993 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.034 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g23930 | i0 | 100 | 0.0779944289693593 | 28 | 0 | 8 | 0 | 332 | 359 | 30 | 3 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 13610944 | 13610944 | PRJNA879221_P_NODE_62471_length_242_cov_0.911243_g62331_i0 | PRJNA879221 | 62471 | 242 | 0.911243 | 2.20520806 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 424 | 4.01e-114 | NTclustered | gi|2635632557|gb|CP137882.1| | 5537 | g62331 | i0 | 99.149 | 3.21074380165289 | 235 | 2 | 97 | 0 | 8 | 242 | 34479 | 34245 | Rhodotorula mucilaginosa strain GDMCC2.30 mitochondrion, complete genome | blastn | 777 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 16159367 | 16159367 | PRJNA879221_P_NODE_14173_length_478_cov_4.965432_g14034_i0 | PRJNA879221 | 14173 | 478 | 4.965432 | 23.73476496 | Cystobasidium minutum | 29899 | Fungi | Fungi | 172 | 3.42e-38 | NTclustered | gi|2781626125|ref|XM_066965959.1| | 1397322 | g14034 | i0 | 77.743 | 0.9581589958159 | 319 | 46 | 62 | 9 | 184 | 478 | 140 | 457 | Cystobasidium minutum MCA 4210 uncharacterized protein (P389DRAFT_174145), mRNA | blastn | 458 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 17435137 | 17435137 | PRJNA879221_P_NODE_33694_length_303_cov_1.560870_g33554_i0 | PRJNA879221 | 33694 | 303 | 1.56087 | 4.7294361 | Malassezia restricta | 76775 | Fungi | Fungi | 560 | 3.79e-155 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g33554 | i0 | 100 | 101.531353135314 | 303 | 0 | 100 | 0 | 1 | 303 | 1472 | 1774 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 30764 | 560 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18708205 | 18708205 | PRJNA879221_P_NODE_21255_length_383_cov_4.193548_g21116_i0 | PRJNA879221 | 21255 | 383 | 4.193548 | 16.06128884 | Suillus luteus | 5384 | Fungi | Fungi | 58.4 | 7.85e-4 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g21116 | i0 | 100 | 0.0809399477806789 | 31 | 0 | 8 | 0 | 353 | 383 | 33 | 3 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 19983404 | 19983404 | PRJNA879221_P_NODE_15736_length_451_cov_5.912698_g15597_i0 | PRJNA879221 | 15736 | 451 | 5.912698 | 26.66626798 | Malassezia globosa | 76773 | Fungi | Fungi | 715 | 0 | NTclustered | gi|164656940|ref|XM_001729545.1| | 425265 | g15597 | i0 | 98.284 | 0.904656319290466 | 408 | 7 | 90 | 0 | 20 | 427 | 3567 | 3160 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3141), partial mRNA | blastn | 408 | 715 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 19983856 | 19983856 | PRJNA879221_P_NODE_50496_length_249_cov_0.875000_g50356_i0 | PRJNA879221 | 50496 | 249 | 0.875 | 2.17875 | Malassezia restricta | 76775 | Fungi | Fungi | 460 | 3.16e-125 | NTclustered | gi|1546632268|ref|XM_027627794.1| | 76775 | g50356 | i0 | 100 | 1 | 249 | 0 | 100 | 0 | 1 | 249 | 2656 | 2408 | Malassezia restricta magnesium transporter (MRET_1167), partial mRNA | blastn | 249 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19983950 | 19983950 | PRJNA879221_P_NODE_59476_length_244_cov_0.894737_g59336_i0 | PRJNA879221 | 59476 | 244 | 0.894737 | 2.18315828 | Malassezia restricta | 76775 | Fungi | Fungi | 446 | 8.639999999999999e-121 | NTclustered | gi|1546636887|ref|XM_027630086.1| | 76775 | g59336 | i0 | 99.59 | 1.92622950819672 | 244 | 1 | 100 | 0 | 1 | 244 | 363 | 120 | Malassezia restricta F-type H+-transporting ATPase subunit alpha (MRET_3459), partial mRNA | blastn | 470 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21258841 | 21258841 | PRJNA879221_P_NODE_22097_length_375_cov_20.433775_g21957_i0 | PRJNA879221 | 22097 | 375 | 20.433775 | 76.62665625 | Apiotrichum porosum | 105984 | Fungi | Fungi | 110 | 2.88e-25 | NR | XP_028479170.1 | 105984 | g21957 | i0 | 80.3 | 0.568 | 71 | 13 | 56.8 | 1 | 343 | 131 | 584 | 653 | XP_028479170.1 uncharacterized protein EHS24_004635 [Apiotrichum porosum] | diamond | 213 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 21259390 | 21259390 | PRJNA879221_P_NODE_7557_length_678_cov_14.388430_g7423_i0 | PRJNA879221 | 7557 | 678 | 14.38843 | 97.5535554 | Cystobasidium minutum | 29899 | Fungi | Fungi | 183 | 2.3e-41 | NTclustered | gi|2781613347|ref|XM_066968718.1| | 1397322 | g7423 | i0 | 76.923 | 0.479351032448378 | 325 | 73 | 48 | 2 | 28 | 351 | 708 | 1031 | Cystobasidium minutum MCA 4210 uncharacterized protein (P389DRAFT_211429), mRNA | blastn | 325 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 22533552 | 22533552 | PRJNA879221_P_NODE_23938_length_360_cov_4.045296_g23798_i0 | PRJNA879221 | 23938 | 360 | 4.045296 | 14.5630656 | Malassezia globosa | 76773 | Fungi | Fungi | 433 | 1.04e-116 | NTclustered | gi|164662322|ref|XM_001732231.1| | 425265 | g23798 | i0 | 96.899 | 4.89444444444444 | 258 | 8 | 72 | 0 | 31 | 288 | 1675 | 1932 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_0058), partial mRNA | blastn | 1762 | 433 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 25082746 | 25082746 | PRJNA879221_P_NODE_15960_length_448_cov_1.514667_g15821_i0 | PRJNA879221 | 15960 | 448 | 1.514667 | 6.78570816 | Malassezia sympodialis | 76777 | Fungi | Fungi | 368 | 3.79e-97 | NTclustered | gi|1092930879|ref|XM_018885105.1| | 1230383 | g15821 | i0 | 95.259 | 2.41517857142857 | 232 | 11 | 52 | 0 | 180 | 411 | 232 | 1 | Malassezia sympodialis ATCC 42132 uncharacterized protein (MSY001_3210), partial mRNA | blastn | 1082 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 25082770 | 25082770 | PRJNA879221_P_NODE_17700_length_423_cov_2.700000_g17561_i0 | PRJNA879221 | 17700 | 423 | 2.7 | 11.421 | Pseudomicrostroma glucosiphilum | 1684307 | Fungi | Fungi | 239 | 2.91e-58 | NTclustered | gi|1418635261|ref|XM_025490958.1| | 1684307 | g17561 | i0 | 81.107 | 0.794326241134752 | 307 | 50 | 72 | 8 | 77 | 379 | 242 | 544 | Pseudomicrostroma glucosiphilum hypothetical protein (BCV69DRAFT_271605), partial mRNA | blastn | 336 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Pseudomicrostroma | Pseudomicrostroma glucosiphilum | ||
| 25083096 | 25083096 | PRJNA879221_P_NODE_38880_length_279_cov_2.174757_g38740_i0 | PRJNA879221 | 38880 | 279 | 2.174757 | 6.06757203 | Cutaneotrichosporon oleaginosum | 879819 | Fungi | Fungi | 143 | 1.48e-29 | NTclustered | gi|2741445743|ref|XM_018426891.2| | 879819 | g38740 | i0 | 87.302 | 1.58064516129032 | 126 | 14 | 45 | 2 | 125 | 249 | 860 | 736 | Cutaneotrichosporon oleaginosum uncharacterized protein (COLE_01705), partial mRNA | blastn | 441 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum | |
| 27371668 | 27371668 | PRJNA879221_P_NODE_50623_length_249_cov_0.875000_g50483_i0 | PRJNA879221 | 50623 | 249 | 0.875 | 2.17875 | Rhodotorula dairenensis | 86832 | Fungi | Fungi | 74.3 | 2.65e-14 | NR | GAA5879141.1 | 86832 | g50483 | i0 | 100 | 0.891566265060241 | 37 | 0 | 44.6 | 0 | 139 | 249 | 124 | 160 | GAA5879141.1 hypothetical protein JCM3774_002093 [Rhodotorula dairenensis] | diamond | 222 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula dairenensis | |
| 28129250 | 28129250 | PRJNA879221_P_NODE_60005_length_243_cov_0.905882_g59865_i0 | PRJNA879221 | 60005 | 243 | 0.905882 | 2.20129326 | Rhodotorula dairenensis | 86832 | Fungi | Fungi | 105 | 4.339999999999999e-24 | NR | GAA5872563.1 | 86832 | g59865 | i0 | 87.1 | 0.765432098765432 | 62 | 8 | 76.5 | 0 | 243 | 58 | 177 | 238 | GAA5872563.1 hypothetical protein JCM3774_006852 [Rhodotorula dairenensis] | diamond | 186 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula dairenensis | |
| 30149856 | 30149856 | PRJNA879221_P_NODE_49892_length_249_cov_0.875000_g49752_i0 | PRJNA879221 | 49892 | 249 | 0.875 | 2.17875 | Filobasidium floriforme | 5210 | Fungi | Fungi | 55.1 | 1.77e-7 | NR | XP_046032878.1 | 5210 | g49752 | i0 | 67.4 | 0.518072289156627 | 43 | 11 | 51.8 | 1 | 249 | 121 | 9 | 48 | XP_046032878.1 uncharacterized protein HD553DRAFT_319877 [Filobasidium floriforme] | diamond | 129 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 30340193 | 30340193 | PRJNA879221_P_NODE_21252_length_384_cov_0.810289_g21113_i0 | PRJNA879221 | 21252 | 384 | 0.810289 | 3.11150976 | Thecaphora frezii | 1269715 | Fungi | Fungi | 64.3 | 8.51e-11 | NR | UOP57098.1 | 1269715 | g21113 | i0 | 64.2 | 0.4140625 | 53 | 19 | 41.4 | 0 | 232 | 74 | 1 | 53 | UOP57098.1 hypothetical protein [Thecaphora frezii] | diamond | 159 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Urocystidales | Glomosporiaceae | Thecaphora | Thecaphora frezii |
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);;