contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA796975" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2492298 | 2492298 | PRJNA796975_S_NODE_5402_length_203_cov_2.019481_g5325_i0 | PRJNA796975 | 5402 | 203 | 2.019481 | 4.09954643 | Erythrobasidium | 5413 | Fungi | Fungi | 370 | 4.3e-98 | NTclustered | gi|1674559207|gb|MK990696.1| | 5414 | g5325 | i0 | 99.507 | 94.4926108374384 | 203 | 1 | 100 | 0 | 1 | 203 | 541 | 339 | Erythrobasidium hasegawianum strain MCA6865 large subunit ribosomal RNA gene, partial sequence | blastn | 19182 | 370 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Erythrobasidium | Erythrobasidium hasegawianum | |
| 3332261 | 3332261 | PRJNA796975_S_NODE_15403_length_161_cov_0.910714_g15326_i0 | PRJNA796975 | 15403 | 161 | 0.910714 | 1.46624954 | Malassezia restricta | 76775 | Fungi | Fungi | 298 | 1.56e-76 | NTclustered | gi|1546630665|ref|XM_027626993.1| | 76775 | g15326 | i0 | 100 | 1 | 161 | 0 | 100 | 0 | 1 | 161 | 169 | 9 | Malassezia restricta uncharacterized protein (MRET_0366), partial mRNA | blastn | 161 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7159553 | 7159553 | PRJNA796975_S_NODE_13606_length_163_cov_0.894737_g13529_i0 | PRJNA796975 | 13606 | 163 | 0.894737 | 1.45842131 | Chondrostereum purpureum | 58369 | Fungi | Fungi | 265 | 1.6e-66 | NTclustered | gi|930580449|gb|KR264909.1| | 58369 | g13529 | i0 | 95.758 | 100.815950920245 | 165 | 5 | 100 | 1 | 1 | 163 | 6005 | 6169 | Chondrostereum purpureum 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence | blastn | 16433 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Cyphellaceae | Chondrostereum | Chondrostereum purpureum | |
| 7159582 | 7159582 | PRJNA796975_S_NODE_2006_length_299_cov_2.448000_g1929_i0 | PRJNA796975 | 2006 | 299 | 2.448 | 7.31952 | Erythrobasidium hasegawianum | 5414 | Fungi | Fungi | 542 | 1.35e-149 | NTclustered | gi|762216299|emb|HG421447.1| | 5414 | g1929 | i0 | 99.331 | 97.9397993311037 | 299 | 2 | 100 | 0 | 1 | 299 | 334 | 632 | Erythrobasidium hasegawianum mitochondrial partial 26S rRNA gene, isolate MOM_882 | blastn | 29284 | 542 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Erythrobasidium | Erythrobasidium hasegawianum | |
| 7159645 | 7159645 | PRJNA796975_S_NODE_9886_length_167_cov_0.864407_g9809_i0 | PRJNA796975 | 9886 | 167 | 0.864407 | 1.44355969 | Malassezia restricta | 76775 | Fungi | Fungi | 309 | 7.53e-80 | NTclustered | gi|1546634584|ref|XM_027628952.1| | 76775 | g9809 | i0 | 100 | 1.98203592814371 | 167 | 0 | 100 | 0 | 1 | 167 | 789 | 955 | Malassezia restricta DNA replication licensing factor MCM2 (MRET_2325), partial mRNA | blastn | 331 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7594981 | 7594981 | PRJNA796975_S_NODE_4546_length_216_cov_4.970060_g4469_i0 | PRJNA796975 | 4546 | 216 | 4.97006 | 10.7353296 | Erythrobasidium | 5413 | Fungi | Fungi | 399 | 5.909999999999999e-107 | NTclustered | gi|406205|dbj|D12803.1|ERHSSRD3 | 5414 | g4469 | i0 | 100 | 100.00462962963 | 216 | 0 | 100 | 0 | 1 | 216 | 73 | 288 | Erythrobasidium hasegawianum gene for small subunit ribosomal RNA | blastn | 21601 | 399 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Erythrobasidium | Erythrobasidium hasegawianum | |
| 10985180 | 10985180 | PRJNA796975_S_NODE_15249_length_161_cov_0.910714_g15172_i0 | PRJNA796975 | 15249 | 161 | 0.910714 | 1.46624954 | Malassezia restricta | 76775 | Fungi | Fungi | 241 | 2.66e-59 | NTclustered | gi|1546636589|ref|XM_027629937.1| | 76775 | g15172 | i0 | 99.248 | 0.826086956521739 | 133 | 1 | 83 | 0 | 1 | 133 | 133 | 1 | Malassezia restricta mitogen-activated protein kinase 1/3 (MRET_3310), partial mRNA | blastn | 133 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12260681 | 12260681 | PRJNA796975_S_NODE_13950_length_162_cov_0.902655_g13873_i0 | PRJNA796975 | 13950 | 162 | 0.902655 | 1.4623011 | Fomitiporia mediterranea | 208960 | Fungi | Fungi | 137 | 3.6199999999999997e-28 | NTclustered | gi|595770355|ref|XM_007263659.1| | 694068 | g13873 | i0 | 82.278 | 1.44444444444444 | 158 | 28 | 98 | 0 | 3 | 160 | 1816 | 1973 | Fomitiporia mediterranea MF3/22 ATP citrate lyase isoform 2 (FOMMEDRAFT_17859), mRNA | blastn | 234 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Fomitiporia | Fomitiporia mediterranea | |
| 16083711 | 16083711 | PRJNA796975_S_NODE_14213_length_162_cov_0.902655_g14136_i0 | PRJNA796975 | 14213 | 162 | 0.902655 | 1.4623011 | Malassezia restricta | 76775 | Fungi | Fungi | 294 | 2.03e-75 | NTclustered | gi|1546631291|ref|XM_027627306.1| | 76775 | g14136 | i0 | 99.383 | 1 | 162 | 1 | 100 | 0 | 1 | 162 | 6656 | 6817 | Malassezia restricta ferricrocin synthase (MRET_0679), partial mRNA | blastn | 162 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17359539 | 17359539 | PRJNA796975_S_NODE_11534_length_165_cov_0.879310_g11457_i0 | PRJNA796975 | 11534 | 165 | 0.87931 | 1.4508615 | Malassezia restricta | 76775 | Fungi | Fungi | 305 | 9.59e-79 | NTclustered | gi|1546637819|ref|XM_027630551.1| | 76775 | g11457 | i0 | 100 | 1 | 165 | 0 | 100 | 0 | 1 | 165 | 984 | 820 | Malassezia restricta vacuole morphology and inheritance protein 14 (MRET_3924), partial mRNA | blastn | 165 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18632690 | 18632690 | PRJNA796975_S_NODE_15175_length_161_cov_0.910714_g15098_i0 | PRJNA796975 | 15175 | 161 | 0.910714 | 1.46624954 | Malassezia restricta | 76775 | Fungi | Fungi | 298 | 1.56e-76 | NTclustered | gi|1546636765|ref|XM_027630025.1| | 76775 | g15098 | i0 | 100 | 1.96894409937888 | 161 | 0 | 100 | 0 | 1 | 161 | 1116 | 956 | Malassezia restricta myo-inositol-1-phosphate synthase (MRET_3398), partial mRNA | blastn | 317 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18632736 | 18632736 | PRJNA796975_S_NODE_7095_length_185_cov_1.147059_g7018_i0 | PRJNA796975 | 7095 | 185 | 1.147059 | 2.12205915 | Malassezia restricta | 76775 | Fungi | Fungi | 337 | 3.89e-88 | NTclustered | gi|1546637861|ref|XM_027630572.1| | 76775 | g7018 | i0 | 99.459 | 1 | 185 | 1 | 100 | 0 | 1 | 185 | 928 | 744 | Malassezia restricta uncharacterized protein (MRET_3945), partial mRNA | blastn | 185 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19068552 | 19068552 | PRJNA796975_S_NODE_4735_length_213_cov_2.664634_g4658_i0 | PRJNA796975 | 4735 | 213 | 2.664634 | 5.67567042 | Basidiomycota | 5204 | Fungi | Fungi | 350 | 5.94e-92 | NTclustered | gi|406205|dbj|D12803.1|ERHSSRD3 | 5414 | g4658 | i0 | 96.244 | 100.009389671362 | 213 | 8 | 100 | 0 | 1 | 213 | 1408 | 1620 | Erythrobasidium hasegawianum gene for small subunit ribosomal RNA | blastn | 21302 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Erythrobasidium | Erythrobasidium hasegawianum | |
| 19068567 | 19068567 | PRJNA796975_S_NODE_7515_length_181_cov_2.704545_g7438_i0 | PRJNA796975 | 7515 | 181 | 2.704545 | 4.89522645 | Basidiomycota | 5204 | Fungi | Fungi | 335 | 1.36e-87 | NTclustered | gi|110169462|gb|DQ663697.1| | 5414 | g7438 | i0 | 100 | 100.022099447514 | 181 | 0 | 100 | 0 | 1 | 181 | 926 | 746 | Erythrobasidium hasegawianum isolate AFTOL-ID 1771 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18104 | 335 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Erythrobasidium | Erythrobasidium hasegawianum | |
| 20343324 | 20343324 | PRJNA796975_S_NODE_6656_length_189_cov_1.457143_g6579_i0 | PRJNA796975 | 6656 | 189 | 1.457143 | 2.75400027 | Fungi | 4751 | Fungi | Fungi | 289 | 1.14e-73 | NTclustered | gi|1394846613|gb|MH427374.1| | 5535 | g6579 | i0 | 94.241 | 100.513227513228 | 191 | 7 | 100 | 3 | 1 | 189 | 370 | 182 | Rhodotorula glutinis strain SY01 large subunit ribosomal RNA gene, partial sequence | blastn | 18997 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula glutinis | |
| 21183720 | 21183720 | PRJNA796975_S_NODE_9857_length_167_cov_0.864407_g9780_i0 | PRJNA796975 | 9857 | 167 | 0.864407 | 1.44355969 | Wallemia mellicola | 1708541 | Fungi | Fungi | 309 | 7.53e-80 | NTclustered | gi|588260172|ref|XM_006959178.1| | 671144 | g9780 | i0 | 100 | 1 | 167 | 0 | 100 | 0 | 1 | 167 | 1587 | 1753 | Wallemia mellicola CBS 633.66 Coatomer, beta' subunit partial mRNA | blastn | 167 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia mellicola | |
| 21618992 | 21618992 | PRJNA796975_S_NODE_15657_length_159_cov_2.254545_g15580_i0 | PRJNA796975 | 15657 | 159 | 2.254545 | 3.58472655 | Erythrobasidium | 5413 | Fungi | Fungi | 294 | 1.98e-75 | NTclustered | gi|1826549609|gb|MT256141.1| | 5414 | g15580 | i0 | 100 | 100.25786163522 | 159 | 0 | 100 | 0 | 1 | 159 | 632 | 474 | Erythrobasidium hasegawianum isolate 1Y146 large subunit ribosomal RNA gene, partial sequence | blastn | 15941 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Erythrobasidium | Erythrobasidium hasegawianum | |
| 22458352 | 22458352 | PRJNA796975_S_NODE_14198_length_162_cov_0.902655_g14121_i0 | PRJNA796975 | 14198 | 162 | 0.902655 | 1.4623011 | Malassezia restricta | 76775 | Fungi | Fungi | 272 | 9.51e-69 | NTclustered | gi|1546632986|ref|XM_027628153.1| | 76775 | g14121 | i0 | 96.914 | 2.59259259259259 | 162 | 5 | 100 | 0 | 1 | 162 | 1034 | 1195 | Malassezia restricta O-acetylhomoserine/O-acetylserine sulfhydrylase (MRET_1526), partial mRNA | blastn | 420 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 25007559 | 25007559 | PRJNA796975_S_NODE_10200_length_166_cov_1.307692_g10123_i0 | PRJNA796975 | 10200 | 166 | 1.307692 | 2.17076872 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 241 | 2.76e-59 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g10123 | i0 | 92.771 | 103.072289156627 | 166 | 12 | 100 | 0 | 1 | 166 | 3929 | 4094 | Cystobasidium laryngis 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 | 17110 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis | |
| 25007674 | 25007674 | PRJNA796975_S_NODE_9920_length_167_cov_0.864407_g9843_i0 | PRJNA796975 | 9920 | 167 | 0.864407 | 1.44355969 | Malassezia restricta | 76775 | Fungi | Fungi | 235 | 1.3e-57 | NTclustered | gi|1546630447|ref|XM_027626884.1| | 76775 | g9843 | i0 | 92.169 | 0.994011976047904 | 166 | 13 | 99 | 0 | 2 | 167 | 571 | 736 | Malassezia restricta mitochondrial inner membrane carnitine transporter (MRET_0257), partial mRNA | blastn | 166 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;