contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJEB10320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1287811 | 1287811 | PRJEB10320_P_NODE_24042_length_168_cov_2.105263_g23784_i0 | PRJEB10320 | 24042 | 168 | 2.105263 | 3.53684184 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 91.6 | 2.99e-14 | NTclustered | gi|1423569936|ref|XM_025739965.1| | 58919 | g23784 | i0 | 84.211 | 26.4940476190476 | 95 | 13 | 56 | 2 | 7 | 100 | 132 | 39 | Tilletiopsis washingtonensis ribosomal protein S14 (FA09DRAFT_290831), partial mRNA | blastn | 4451 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 2563377 | 2563377 | PRJEB10320_P_NODE_12343_length_269_cov_2.504274_g12085_i0 | PRJEB10320 | 12343 | 269 | 2.504274 | 6.73649706 | Malassezia restricta | 76775 | Fungi | Fungi | 497 | 2.63e-136 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12085 | i0 | 100 | 73.8475836431227 | 269 | 0 | 100 | 0 | 1 | 269 | 3284 | 3016 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 19865 | 497 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5115932 | 5115932 | PRJEB10320_P_NODE_24585_length_166_cov_1.221374_g24327_i0 | PRJEB10320 | 24585 | 166 | 1.221374 | 2.02748084 | Leucosporidium sp. AY30 | 662878 | Fungi | Fungi | 209 | 7.8e-50 | NTclustered | gi|254927417|gb|GQ336996.1| | 662878 | g24327 | i0 | 92.053 | 74.433734939759 | 151 | 8 | 90 | 4 | 1 | 149 | 5798 | 5650 | Leucosporidium sp. AY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 12356 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium sp. AY30 | |
| 6391644 | 6391644 | PRJEB10320_P_NODE_12986_length_260_cov_3.524444_g12728_i0 | PRJEB10320 | 12986 | 260 | 3.524444 | 9.1635544 | Malassezia restricta | 76775 | Fungi | Fungi | 481 | 2.55e-131 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12728 | i0 | 100 | 100.884615384615 | 260 | 0 | 100 | 0 | 1 | 260 | 1744 | 1485 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 26230 | 481 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6391669 | 6391669 | PRJEB10320_P_NODE_19226_length_198_cov_1.472393_g18968_i0 | PRJEB10320 | 19226 | 198 | 1.472393 | 2.91533814 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 71.3 | 4.74e-8 | NTclustered | gi|1022864644|ref|XM_016418963.1| | 1130832 | g18968 | i0 | 97.561 | 0.207070707070707 | 41 | 1 | 21 | 0 | 139 | 179 | 608 | 568 | Rhodotorula toruloides NP11 60S ribosomal protein l10a (RHTO_05301), partial mRNA | blastn | 41 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 7360132 | 7360132 | PRJEB10320_P_NODE_15286_length_232_cov_3.116751_g15028_i0 | PRJEB10320 | 15286 | 232 | 3.116751 | 7.23086232 | Microbotryomycetes | 162481 | Fungi | Fungi | 278 | 3.1400000000000004e-70 | NTclustered | gi|1916685|gb|U75449.1|CHU75449 | 54203 | g15028 | i0 | 95.402 | 74.8879310344828 | 174 | 8 | 75 | 0 | 1 | 174 | 914 | 741 | Camptobasidium hydrophilum small subunit rRNA gene, partial sequence | blastn | 17374 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Kriegeriales | Camptobasidiaceae | Camptobasidium | Camptobasidium hydrophilum | |
| 10216260 | 10216260 | PRJEB10320_P_NODE_10309_length_304_cov_1.962825_g10051_i0 | PRJEB10320 | 10309 | 304 | 1.962825 | 5.966988 | Gloeophyllum trabeum | 104355 | Fungi | Fungi | 62.1 | 4.71e-5 | NTclustered | gi|630357210|ref|XM_007869715.1| | 670483 | g10051 | i0 | 91.111 | 0.697368421052632 | 45 | 4 | 15 | 0 | 3 | 47 | 322 | 366 | Gloeophyllum trabeum ATCC 11539 60S ribosomal protein L44 (GLOTRDRAFT_63194), mRNA | blastn | 212 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Gloeophyllum | Gloeophyllum trabeum | |
| 12767060 | 12767060 | PRJEB10320_P_NODE_15991_length_225_cov_1.678947_g15733_i0 | PRJEB10320 | 15991 | 225 | 1.678947 | 3.77763075 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 119 | 1.94e-22 | NTclustered | gi|630961921|ref|XM_007879178.1| | 1277687 | g15733 | i0 | 85.714 | 1.24 | 112 | 16 | 50 | 0 | 113 | 224 | 388 | 499 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_01668), partial mRNA | blastn | 279 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 13735914 | 13735914 | PRJEB10320_P_NODE_11951_length_275_cov_3.575000_g11693_i0 | PRJEB10320 | 11951 | 275 | 3.575 | 9.83125 | Opisthokonta | 33154 | Fungi | Fungi | 99 | 3.2e-16 | NTclustered | gi|2007404252|gb|MW762781.1| | 80591 | g11693 | i0 | 85.859 | 35.8072727272727 | 99 | 7 | 36 | 5 | 169 | 266 | 554 | 646 | Hygrophorus speciosus voucher MHKMU H.Y. Huang 1010 large subunit ribosomal RNA gene, partial sequence | blastn | 9847 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hygrophoraceae | Hygrophorus | Hygrophorus speciosus | |
| 14041595 | 14041595 | PRJEB10320_P_NODE_15692_length_228_cov_1.678756_g15434_i0 | PRJEB10320 | 15692 | 228 | 1.678756 | 3.82756368 | Dioszegia hungarica | 4972 | Fungi | Fungi | 220 | 5.26e-53 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g15434 | i0 | 84.416 | 120.017543859649 | 231 | 28 | 100 | 8 | 1 | 228 | 3302 | 3077 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 27364 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 16590416 | 16590416 | PRJEB10320_P_NODE_24054_length_168_cov_2.000000_g23796_i0 | PRJEB10320 | 24054 | 168 | 2 | 3.36 | Lentinus tigrinus | 5365 | Fungi | Fungi | 73.1 | 1.08e-8 | NTclustered | gi|2797383940|ref|XM_067676807.1| | 1328758 | g23796 | i0 | 87.302 | 1.27380952380952 | 63 | 8 | 38 | 0 | 28 | 90 | 170 | 108 | Lentinus tigrinus ALCF2SS1-7 40S ribosomal protein eS21 (L226DRAFT_478650), mRNA | blastn | 214 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus | |
| 17865264 | 17865264 | PRJEB10320_P_NODE_11895_length_276_cov_2.448133_g11637_i0 | PRJEB10320 | 11895 | 276 | 2.448133 | 6.75684708 | Kwoniella mangrovensis | 463800 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|1101807784|ref|XM_019144703.1| | 1296122 | g11637 | i0 | 100 | 0.105072463768116 | 29 | 0 | 11 | 0 | 12 | 40 | 1735 | 1763 | Kwoniella mangroviensis CBS 8507 uncharacterized protein (I203_105546), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella mangrovensis | |
| 17865305 | 17865305 | PRJEB10320_P_NODE_21035_length_186_cov_1.059603_g20777_i0 | PRJEB10320 | 21035 | 186 | 1.059603 | 1.97086158 | Kwoniella shandongensis | 1734106 | Fungi | Fungi | 115 | 2e-21 | NTclustered | gi|1799710213|ref|XM_032001286.1| | 1734106 | g20777 | i0 | 81.507 | 14.9354838709677 | 146 | 21 | 77 | 2 | 44 | 186 | 558 | 416 | Kwoniella shandongensis 40S ribosomal protein eS6 (CI109_102898), partial mRNA | blastn | 2778 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shandongensis | |
| 17865362 | 17865362 | PRJEB10320_P_NODE_9915_length_312_cov_1.859206_g9657_i0 | PRJEB10320 | 9915 | 312 | 1.859206 | 5.8007227200000004 | Leucosporidium scottii | 5278 | Fungi | Fungi | 510 | 4e-140 | NTclustered | gi|1358186634|gb|MH047191.1| | 5278 | g9657 | i0 | 96.154 | 102.490384615385 | 312 | 12 | 100 | 0 | 1 | 312 | 3821 | 4132 | Leucosporidium scottii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 31977 | 510 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium scottii | |
| 19139014 | 19139014 | PRJEB10320_P_NODE_16296_length_222_cov_1.754011_g16038_i0 | PRJEB10320 | 16296 | 222 | 1.754011 | 3.89390442 | Malassezia sympodialis | 76777 | Fungi | Fungi | 93.5 | 1.16e-14 | NTclustered | gi|1092926831|ref|XM_018886175.1| | 1230383 | g16038 | i0 | 93.548 | 1.36936936936937 | 62 | 4 | 28 | 0 | 1 | 62 | 1070 | 1131 | Malassezia sympodialis ATCC 42132 uncharacterized protein (MSY001_1072), partial mRNA | blastn | 304 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 22965406 | 22965406 | PRJEB10320_P_NODE_22159_length_179_cov_1.388889_g21901_i0 | PRJEB10320 | 22159 | 179 | 1.388889 | 2.48611131 | Apiotrichum porosum | 105984 | Fungi | Fungi | 145 | 2.43e-30 | NTclustered | gi|1607535959|ref|XM_028617697.1| | 105984 | g21901 | i0 | 82.424 | 17.877094972067 | 165 | 29 | 92 | 0 | 14 | 178 | 393 | 229 | Apiotrichum porosum 60S ribosomal protein L3 (RPL3), partial mRNA | blastn | 3200 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 24239413 | 24239413 | PRJEB10320_P_NODE_10360_length_303_cov_1.723881_g10102_i0 | PRJEB10320 | 10360 | 303 | 1.723881 | 5.22335943 | Kwoniella botswanensis | 1268659 | Fungi | Fungi | 167 | 9.66e-37 | NTclustered | gi|2725001752|ref|XM_064886569.1| | 1268659 | g10102 | i0 | 78.947 | 4.83168316831683 | 247 | 50 | 81 | 2 | 4 | 249 | 246 | 1 | Kwoniella botswanensis uncharacterized protein (L199_000810), partial mRNA | blastn | 1464 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella botswanensis | |
| 24239467 | 24239467 | PRJEB10320_P_NODE_24740_length_165_cov_1.623077_g24482_i0 | PRJEB10320 | 24740 | 165 | 1.623077 | 2.67807705 | Apiotrichum porosum | 105984 | Fungi | Fungi | 132 | 1.72e-26 | NTclustered | gi|1607552265|ref|XM_028620935.1| | 105984 | g24482 | i0 | 87.069 | 20.5878787878788 | 116 | 15 | 70 | 0 | 9 | 124 | 200 | 85 | Apiotrichum porosum 40S ribosomal protein S27 (RPS27), partial mRNA | blastn | 3397 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 25208512 | 25208512 | PRJEB10320_P_NODE_14160_length_245_cov_2.652381_g13902_i0 | PRJEB10320 | 14160 | 245 | 2.652381 | 6.49833345 | Malassezia | 55193 | Fungi | Fungi | 448 | 2.41e-121 | NTclustered | gi|953821272|gb|KT310070.1| | 76773 | g13902 | i0 | 99.592 | 91.5877551020408 | 245 | 1 | 100 | 0 | 1 | 245 | 690 | 446 | Malassezia globosa isolate 1242 large subunit ribosomal RNA gene, partial sequence | blastn | 22439 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa |
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);;