contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21659 | 21659 | PRJEB17675_P_NODE_17781_length_188_cov_1.045752_g17477_i0 | PRJEB17675 | 17781 | 188 | 1.045752 | 1.96601376 | Malassezia restricta | 76775 | Fungi | Fungi | 348 | 1.84e-91 | NTclustered | gi|1546637503|ref|XM_027630394.1| | 76775 | g17477 | i0 | 100 | 1 | 188 | 0 | 100 | 0 | 1 | 188 | 225 | 38 | Malassezia restricta uncharacterized protein (MRET_3767), partial mRNA | blastn | 188 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21674 | 21674 | PRJEB17675_P_NODE_23881_length_156_cov_1.165289_g23577_i0 | PRJEB17675 | 23881 | 156 | 1.165289 | 1.81785084 | Apiotrichum porosum | 105984 | Fungi | Fungi | 115 | 1.62e-21 | NTclustered | gi|1607505658|ref|XM_028622500.1| | 105984 | g23577 | i0 | 88.421 | 0.608974358974359 | 95 | 11 | 61 | 0 | 1 | 95 | 379 | 285 | Apiotrichum porosum Eukaryotic translation initiation factor 6 (TIF6), partial mRNA | blastn | 95 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 21680 | 21680 | PRJEB17675_P_NODE_24981_length_152_cov_1.025641_g24677_i0 | PRJEB17675 | 24981 | 152 | 1.025641 | 1.55897432 | Marasmius oreades | 181124 | Fungi | Fungi | 93.5 | 7.32e-15 | NTclustered | gi|2083683966|ref|XM_043155689.1| | 181124 | g24677 | i0 | 79.389 | 2.84210526315789 | 131 | 27 | 86 | 0 | 1 | 131 | 1338 | 1468 | Marasmius oreades Elongation factor 2 (EFT1_2), mRNA | blastn | 432 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius oreades | |
| 21714 | 21714 | PRJEB17675_P_NODE_661_length_1118_cov_8.115420_g336_i2 | PRJEB17675 | 661 | 1118 | 8.11542 | 90.7303956 | Vanrija humicola | 5417 | Fungi | Fungi | 488 | 7.32e-133 | NTclustered | gi|921326975|dbj|AB919762.1| | 5417 | g336 | i2 | 80.088 | 57.4087656529517 | 678 | 117 | 60 | 18 | 450 | 1118 | 1195 | 527 | Vanrija humicola gene for adenosylhomocysteinase, complete sequence, strain: JCM 1457 | blastn | 64183 | 488 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija humicola | |
| 985842 | 985842 | PRJEB17675_P_NODE_22341_length_162_cov_1.259843_g22037_i0 | PRJEB17675 | 22341 | 162 | 1.259843 | 2.04094566 | Basidiomycota | 5204 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|2746398632|ref|XM_065967646.1| | 1734106 | g22037 | i0 | 100 | 0.703703703703704 | 29 | 0 | 18 | 0 | 96 | 124 | 1487 | 1459 | Kwoniella shandongensis uncharacterized protein (CI109_105304), partial mRNA | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shandongensis | |
| 7363544 | 7363544 | PRJEB17675_P_NODE_21486_length_166_cov_1.282443_g21182_i0 | PRJEB17675 | 21486 | 166 | 1.282443 | 2.12885538 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 307 | 2.69e-79 | NTclustered | gi|1102646183|gb|KY109753.1| | 5002 | g21182 | i0 | 100 | 100.024096385542 | 166 | 0 | 100 | 0 | 1 | 166 | 623 | 788 | Sporobolomyces johnsonii culture CBS:2648 large subunit ribosomal RNA gene, partial sequence | blastn | 16604 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces johnsonii | |
| 7673910 | 7673910 | PRJEB17675_P_NODE_19647_length_176_cov_1.134752_g19343_i0 | PRJEB17675 | 19647 | 176 | 1.134752 | 1.99716352 | Melanopsichium pennsylvanicum | 63383 | Fungi | Fungi | 60.2 | 8.87e-5 | NTclustered | gi|673527017|emb|HG529577.1| | 1398559 | g19343 | i0 | 91.111 | 1.44886363636364 | 45 | 3 | 34 | 1 | 79 | 122 | 29914 | 29870 | Melanopsichium pennsylvanicum 4 genomic scaffold, scaffold SCAFFOLD14 | blastn | 255 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Melanopsichium | Melanopsichium pennsylvanicum | |
| 7673959 | 7673959 | PRJEB17675_P_NODE_6067_length_384_cov_4.217765_g5767_i0 | PRJEB17675 | 6067 | 384 | 4.217765 | 16.1962176 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 111 | 5.96e-20 | NTclustered | gi|1022855339|ref|XM_016416258.1| | 1130832 | g5767 | i0 | 83.898 | 4.36458333333333 | 118 | 18 | 31 | 1 | 52 | 169 | 1 | 117 | Rhodotorula toruloides NP11 60S ribosomal protein l29 (RHTO_02584), partial mRNA | blastn | 1676 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 7673971 | 7673971 | PRJEB17675_P_NODE_7987_length_322_cov_1.254355_g7683_i0 | PRJEB17675 | 7987 | 322 | 1.254355 | 4.0390231 | Dichomitus squalens | 114155 | Fungi | Fungi | 54.7 | 0.008 | NTclustered | gi|597971912|ref|XM_007361009.1| | 732165 | g7683 | i0 | 100 | 0.0900621118012422 | 29 | 0 | 9 | 0 | 289 | 317 | 653 | 625 | Dichomitus squalens LYAD-421 SS1 uncharacterized protein (DICSQDRAFT_77624), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Dichomitus | Dichomitus squalens | |
| 10224421 | 10224421 | PRJEB17675_P_NODE_23709_length_156_cov_1.983471_g23405_i0 | PRJEB17675 | 23709 | 156 | 1.983471 | 3.09421476 | Ceraceosorus guamensis | 1522189 | Fungi | Fungi | 97.1 | 5.85e-16 | NTclustered | gi|1418843562|ref|XM_025513742.1| | 1522189 | g23405 | i0 | 80.315 | 5.83974358974359 | 127 | 25 | 81 | 0 | 1 | 127 | 11 | 137 | Ceraceosorus guamensis glyceraldehyde-3-phosphate dehydrogenase (IE81DRAFT_322770), mRNA | blastn | 911 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Ceraceosorales | Ceraceosoraceae | Ceraceosorus | Ceraceosorus guamensis | |
| 11189196 | 11189196 | PRJEB17675_P_NODE_14829_length_211_cov_1.835227_g14525_i0 | PRJEB17675 | 14829 | 211 | 1.835227 | 3.87232897 | Basidiomycota | 5204 | Fungi | Fungi | 132 | 2.31e-26 | NTclustered | gi|2292381268|ref|XM_003037490.2| | 578458 | g14525 | i0 | 90.099 | 74.5829383886256 | 101 | 10 | 48 | 0 | 10 | 110 | 840 | 740 | Schizophyllum commune H4-8 ubiquitin (SCHCODRAFT_02744056), mRNA | blastn | 15737 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 12775210 | 12775210 | PRJEB17675_P_NODE_13291_length_228_cov_1.243523_g12987_i0 | PRJEB17675 | 13291 | 228 | 1.243523 | 2.83523244 | Cystobasidium minutum | 29899 | Fungi | Fungi | 139 | 1.52e-28 | NTclustered | gi|2781584933|ref|XM_066964786.1| | 1397322 | g12987 | i0 | 83.007 | 0.671052631578947 | 153 | 26 | 67 | 0 | 37 | 189 | 129 | 281 | Cystobasidium minutum MCA 4210 40S ribosomal protein eS17 (P389DRAFT_165190), mRNA | blastn | 153 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 13739315 | 13739315 | PRJEB17675_P_NODE_3251_length_544_cov_10.290766_g2615_i1 | PRJEB17675 | 3251 | 544 | 10.290766 | 55.98176704 | Basidiomycota | 5204 | Fungi | Fungi | 313 | 2.22e-80 | NTclustered | gi|930409016|ref|XM_014323306.1| | 1186058 | g2615 | i1 | 81.108 | 27.4411764705882 | 397 | 69 | 72 | 6 | 75 | 468 | 420 | 27 | Trichosporon asahii var. asahii CBS 2479 60s ribosomal protein l23 (A1Q1_03508), partial mRNA | blastn | 14928 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 15323884 | 15323884 | PRJEB17675_P_NODE_9053_length_295_cov_3.896154_g8749_i0 | PRJEB17675 | 9053 | 295 | 3.896154 | 11.4936543 | Rhodotorula graminis | 29898 | Fungi | Fungi | 97.1 | 1.25e-15 | NTclustered | gi|1069920474|ref|XM_018418514.1| | 578459 | g8749 | i0 | 81.148 | 2.45762711864407 | 122 | 21 | 41 | 2 | 146 | 266 | 100 | 220 | Rhodotorula graminis WP1 40S ribosomal protein S2 (RHOBADRAFT_64558), partial mRNA | blastn | 725 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 16288525 | 16288525 | PRJEB17675_P_NODE_17013_length_193_cov_2.025316_g16709_i0 | PRJEB17675 | 17013 | 193 | 2.025316 | 3.90885988 | Fungi | 4751 | Fungi | Fungi | 355 | 1.13e-93 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g16709 | i0 | 100 | 99.4818652849741 | 192 | 0 | 99 | 0 | 1 | 192 | 25 | 216 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 19200 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16288529 | 16288529 | PRJEB17675_P_NODE_21853_length_164_cov_1.550388_g21549_i0 | PRJEB17675 | 21853 | 164 | 1.550388 | 2.54263632 | Tremellomycetes | 155616 | Fungi | Fungi | 303 | 3.42e-78 | NTclustered | gi|2843133344|gb|PQ530157.1| | 157611 | g21549 | i0 | 100 | 100.006097560976 | 164 | 0 | 100 | 0 | 1 | 164 | 813 | 650 | Bullera alba isolate gHaDeeP004 large subunit ribosomal RNA gene, partial sequence | blastn | 16401 | 303 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleraceae | Bullera | Bullera alba | |
| 16598506 | 16598506 | PRJEB17675_P_NODE_4014_length_488_cov_11.390728_g3723_i0 | PRJEB17675 | 4014 | 488 | 11.390728 | 55.58675264 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 167 | 1.63e-36 | NTclustered | gi|1423574600|ref|XM_025743711.1| | 58919 | g3723 | i0 | 88.889 | 14.3135245901639 | 135 | 15 | 28 | 0 | 254 | 388 | 201 | 67 | Tilletiopsis washingtonensis putative RPL42B-ribosomal protein L36a.e (FA09DRAFT_333974), partial mRNA | blastn | 6985 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 17873290 | 17873290 | PRJEB17675_P_NODE_2875_length_581_cov_10.106227_g2615_i0 | PRJEB17675 | 2875 | 581 | 10.106227 | 58.71717887 | Trichosporon asahii | 82508 | Fungi | Fungi | 291 | 1.1199999999999998e-73 | NTclustered | gi|930409016|ref|XM_014323306.1| | 1186058 | g2615 | i0 | 80.101 | 21.592082616179 | 397 | 73 | 68 | 6 | 77 | 470 | 27 | 420 | Trichosporon asahii var. asahii CBS 2479 60s ribosomal protein l23 (A1Q1_03508), partial mRNA | blastn | 12545 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 17873328 | 17873328 | PRJEB17675_P_NODE_855_length_1012_cov_8.789150_g336_i3 | PRJEB17675 | 855 | 1012 | 8.78915 | 88.946198 | Vanrija humicola | 5417 | Fungi | Fungi | 488 | 6.599999999999999e-133 | NTclustered | gi|921326975|dbj|AB919762.1| | 5417 | g336 | i3 | 80.088 | 63.2361660079051 | 678 | 117 | 66 | 18 | 1 | 669 | 527 | 1195 | Vanrija humicola gene for adenosylhomocysteinase, complete sequence, strain: JCM 1457 | blastn | 63995 | 488 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija humicola | |
| 20422374 | 20422374 | PRJEB17675_P_NODE_24337_length_154_cov_1.344538_g24033_i0 | PRJEB17675 | 24337 | 154 | 1.344538 | 2.07058852 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 84.2 | 4.48e-12 | NTclustered | gi|630965995|ref|XM_007881215.1| | 1277687 | g24033 | i0 | 92.982 | 3.68181818181818 | 57 | 4 | 37 | 0 | 3 | 59 | 191 | 247 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_03696), partial mRNA | blastn | 567 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 21698386 | 21698386 | PRJEB17675_P_NODE_21658_length_165_cov_1.538462_g21354_i0 | PRJEB17675 | 21658 | 165 | 1.538462 | 2.5384623 | Leucosporidium scottii | 5278 | Fungi | Fungi | 250 | 4.5599999999999996e-62 | NTclustered | gi|1358186634|gb|MH047191.1| | 5278 | g21354 | i0 | 93.939 | 39.9575757575758 | 165 | 10 | 100 | 0 | 1 | 165 | 4102 | 3938 | 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 | 6593 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium scottii | |
| 21698412 | 21698412 | PRJEB17675_P_NODE_5018_length_433_cov_1.761307_g4719_i0 | PRJEB17675 | 5018 | 433 | 1.761307 | 7.62645931 | Punctularia strigosozonata | 202698 | Fungi | Fungi | 52.8 | 0.042 | NTclustered | gi|599118230|ref|XM_007386715.1| | 741275 | g4719 | i0 | 100 | 0.0646651270207852 | 28 | 0 | 6 | 0 | 274 | 301 | 1652 | 1679 | Punctularia strigosozonata HHB-11173 SS5 protein prenylyltransferase (PUNSTDRAFT_145579), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Corticiales | Punctulariaceae | Punctularia | Punctularia strigosozonata | |
| 22662805 | 22662805 | PRJEB17675_P_NODE_9458_length_286_cov_2.784861_g9154_i0 | PRJEB17675 | 9458 | 286 | 2.784861 | 7.96470246 | Basidiomycota | 5204 | Fungi | Fungi | 477 | 3.679999999999999e-130 | NTclustered | gi|1503120285|ref|NG_062158.1| | 159573 | g9154 | i0 | 96.853 | 100.003496503497 | 286 | 8 | 100 | 1 | 1 | 286 | 1343 | 1627 | Vishniacozyma heimaeyensis CBS 8933 18S rRNA gene, partial sequence; from TYPE material | blastn | 28601 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Vishniacozyma | Vishniacozyma heimaeyensis |
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);;