contig_metadata
23 rows where bioproject = "PRJNA1103784", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1486814 | 1486814 | PRJNA1103784_P_NODE_4022_length_282_cov_1.325359_g3967_i0 | PRJNA1103784 | 4022 | 282 | 1.325359 | 3.73751238 | Malassezia globosa | 76773 | Fungi | Fungi | 418 | 2.2299999999999995e-112 | NTclustered | gi|164657737|ref|XM_001729943.1| | 425265 | g3967 | i0 | 99.563 | 3.23049645390071 | 229 | 1 | 81 | 0 | 54 | 282 | 369 | 141 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2981), partial mRNA | blastn | 911 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 2762905 | 2762905 | PRJNA1103784_P_NODE_8043_length_231_cov_3.177215_g7988_i0 | PRJNA1103784 | 8043 | 231 | 3.177215 | 7.33936665 | Pseudozyma hubeiensis | 327079 | Fungi | Fungi | 122 | 1.55e-23 | NTclustered | gi|808368102|ref|XM_012334015.1| | 1305764 | g7988 | i0 | 91.954 | 8.75757575757576 | 87 | 7 | 38 | 0 | 2 | 88 | 370 | 456 | Pseudozyma hubeiensis SY62 hypothetical protein partial mRNA | blastn | 2023 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma hubeiensis | |
| 3570710 | 3570710 | PRJNA1103784_P_NODE_6423_length_247_cov_1.327586_g6368_i0 | PRJNA1103784 | 6423 | 247 | 1.327586 | 3.27913742 | Malassezia | 55193 | Fungi | Fungi | 457 | 4.05e-124 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g6368 | i0 | 100 | 47.7773279352227 | 247 | 0 | 100 | 0 | 1 | 247 | 1098 | 852 | Malassezia restricta mitochondrion, complete genome | blastn | 11801 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7397968 | 7397968 | PRJNA1103784_P_NODE_3226_length_306_cov_1.536481_g3171_i0 | PRJNA1103784 | 3226 | 306 | 1.536481 | 4.70163186 | Malassezia | 55193 | Fungi | Fungi | 566 | 8.239999999999998e-157 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g3171 | i0 | 100 | 66.9509803921569 | 306 | 0 | 100 | 0 | 1 | 306 | 33046 | 32741 | Malassezia restricta mitochondrion, complete genome | blastn | 20487 | 566 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7864890 | 7864890 | PRJNA1103784_P_NODE_7187_length_244_cov_0.900585_g7132_i0 | PRJNA1103784 | 7187 | 244 | 0.900585 | 2.1974274 | Malassezia restricta | 76775 | Fungi | Fungi | 326 | 1.17e-84 | NTclustered | gi|1546630767|ref|XM_027627044.1| | 76775 | g7132 | i0 | 100 | 1.02868852459016 | 176 | 0 | 72 | 0 | 69 | 244 | 1209 | 1034 | Malassezia restricta TBC1 domain family member 5 (MRET_0417), partial mRNA | blastn | 251 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9139782 | 9139782 | PRJNA1103784_P_NODE_7228_length_243_cov_3.376471_g7173_i0 | PRJNA1103784 | 7228 | 243 | 3.376471 | 8.20482453 | uncultured Boletaceae | 335445 | Fungi | Fungi | 204 | 5.71e-48 | NTclustered | gi|453073594|gb|JX215315.1| | 335445 | g7173 | i0 | 82.645 | 98.9506172839506 | 242 | 31 | 99 | 8 | 3 | 242 | 122 | 354 | Uncultured Boletaceae isolate DGGE gel band BJTL19 18S ribosomal RNA gene, partial sequence | blastn | 24045 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Boletaceae | uncultured Boletaceae | ||
| 10415510 | 10415510 | PRJNA1103784_P_NODE_3029_length_313_cov_11.129167_g2974_i0 | PRJNA1103784 | 3029 | 313 | 11.129167 | 34.83429271 | Malassezia restricta | 76775 | Fungi | Fungi | 573 | 5.049999999999998e-159 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g2974 | i0 | 100 | 77.8402555910543 | 310 | 0 | 99 | 0 | 4 | 313 | 3282 | 2973 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 24364 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10415604 | 10415604 | PRJNA1103784_P_NODE_7629_length_242_cov_0.911243_g7574_i0 | PRJNA1103784 | 7629 | 242 | 0.911243 | 2.20520806 | Malassezia restricta | 76775 | Fungi | Fungi | 448 | 2.3799999999999995e-121 | NTclustered | gi|1546630459|ref|XM_027626890.1| | 76775 | g7574 | i0 | 100 | 1.97520661157025 | 242 | 0 | 100 | 0 | 1 | 242 | 450 | 691 | Malassezia restricta nicotinamide mononucleotide adenylyltransferase (MRET_0263), partial mRNA | blastn | 478 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11223571 | 11223571 | PRJNA1103784_P_NODE_1389_length_430_cov_1.159664_g1334_i0 | PRJNA1103784 | 1389 | 430 | 1.159664 | 4.9865552 | Malassezia | 55193 | Fungi | Fungi | 789 | 0 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g1334 | i0 | 99.767 | 44.9697674418605 | 430 | 1 | 100 | 0 | 1 | 430 | 1757 | 1328 | Malassezia restricta mitochondrion, complete genome | blastn | 19337 | 789 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13773511 | 13773511 | PRJNA1103784_P_NODE_3831_length_286_cov_7.704225_g3776_i0 | PRJNA1103784 | 3831 | 286 | 7.704225 | 22.0340835 | Fungi | 4751 | Fungi | Fungi | 523 | 4.659999999999998e-144 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g3776 | i0 | 99.65 | 105.944055944056 | 286 | 1 | 100 | 0 | 1 | 286 | 2690 | 2405 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 30300 | 523 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13773526 | 13773526 | PRJNA1103784_P_NODE_911_length_517_cov_1.292793_g856_i0 | PRJNA1103784 | 911 | 517 | 1.292793 | 6.68373981 | Boletaceae | 5368 | Fungi | Fungi | 60.2 | 3.03e-4 | NTclustered | gi|2166981937|gb|MZ261925.1| | 121045 | g856 | i0 | 84.127 | 1.96131528046422 | 63 | 8 | 12 | 2 | 445 | 506 | 12248 | 12187 | Hemileccinum impolitum mitochondrion, complete genome | blastn | 1014 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Boletaceae | Hemileccinum | Hemileccinum impolitum | |
| 19337940 | 19337940 | PRJNA1103784_P_NODE_456_length_697_cov_3.184295_g403_i0 | PRJNA1103784 | 456 | 697 | 3.184295 | 22.19453615 | Fungi | 4751 | Fungi | Fungi | 311 | 2.22e-103 | NR | KAJ3564534.1 | 56174 | g403 | i0 | 66.5 | 25.9670014347202 | 215 | 72 | 92.5 | 0 | 684 | 40 | 83 | 297 | KAJ3564534.1 hypothetical protein NP233_g8232 [Leucocoprinus birnbaumii] | diamond | 18099 | 314 | 0.990445859872611 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Leucocoprinus | Leucocoprinus birnbaumii | |
| 19337997 | 19337997 | PRJNA1103784_P_NODE_7416_length_243_cov_0.905882_g7361_i0 | PRJNA1103784 | 7416 | 243 | 0.905882 | 2.20129326 | Malassezia sympodialis | 76777 | Fungi | Fungi | 154 | 5.84e-33 | NTclustered | gi|1092930699|ref|XM_018885006.1| | 1230383 | g7361 | i0 | 82.659 | 27.4362139917695 | 173 | 30 | 71 | 0 | 71 | 243 | 190 | 362 | Malassezia sympodialis ATCC 42132 uncharacterized protein (MSY001_3116), partial mRNA | blastn | 6667 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 20613338 | 20613338 | PRJNA1103784_P_NODE_6217_length_248_cov_1.062857_g6162_i0 | PRJNA1103784 | 6217 | 248 | 1.062857 | 2.63588536 | Malassezia globosa | 76773 | Fungi | Fungi | 420 | 5.34e-113 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g6162 | i0 | 97.177 | 83 | 248 | 7 | 100 | 0 | 1 | 248 | 2764 | 2517 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 20584 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 21888935 | 21888935 | PRJNA1103784_P_NODE_4298_length_276_cov_1.364532_g4243_i0 | PRJNA1103784 | 4298 | 276 | 1.364532 | 3.76610832 | Malassezia globosa | 76773 | Fungi | Fungi | 505 | 1.62e-138 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g4243 | i0 | 99.638 | 18.7608695652174 | 276 | 1 | 100 | 0 | 1 | 276 | 330 | 605 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 5178 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 21888974 | 21888974 | PRJNA1103784_P_NODE_7238_length_243_cov_2.264706_g7183_i0 | PRJNA1103784 | 7238 | 243 | 2.264706 | 5.50323558 | Schizopora paradoxa | 27342 | Fungi | Fungi | 99.4 | 6.929999999999999e-23 | NR | KLO06104.1 | 27342 | g7183 | i0 | 65.4 | 4.65432098765432 | 78 | 27 | 96.3 | 0 | 10 | 243 | 70 | 147 | KLO06104.1 large subunit ribosomal protein LP0 [Schizopora paradoxa] | diamond | 1131 | 99.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 23972459 | 23972459 | PRJNA1103784_P_NODE_3079_length_311_cov_2.432773_g3024_i0 | PRJNA1103784 | 3079 | 311 | 2.432773 | 7.56592403 | Trametes | 5324 | Fungi | Fungi | 575 | 1.3899999999999995e-159 | NTclustered | gi|2673161145|dbj|LC798859.1| | 5327 | g3024 | i0 | 100 | 98.3376205787781 | 311 | 0 | 100 | 0 | 1 | 311 | 953 | 1263 | Trametes hirsuta IFM 65545 genes for small subunit ribosomal RNA, ITS1, 5.8S ribosomal RNA, ITS2 and large subunit ribosomal RNA, partial and complete sequence | blastn | 30583 | 575 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes hirsuta | |
| 28195847 | 28195847 | PRJNA1103784_P_NODE_766_length_559_cov_1.899177_g712_i0 | PRJNA1103784 | 766 | 559 | 1.899177 | 10.61639943 | Fungi | 4751 | Fungi | Fungi | 146 | 4.56e-41 | NR | GAA6020434.1 | 86839 | g712 | i0 | 44.7 | 10.0626118067979 | 170 | 90 | 91.2 | 2 | 24 | 533 | 1 | 166 | GAA6020434.1 hypothetical protein JCM8202_000069 [Rhodotorula sphaerocarpa] | diamond | 5625 | 147 | 0.993197278911565 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sphaerocarpa | |
| 29656698 | 29656698 | PRJNA1103784_P_NODE_3690_length_289_cov_3.032407_g3635_i0 | PRJNA1103784 | 3690 | 289 | 3.032407 | 8.76365623 | Cantharellus anzutake | 1750568 | Fungi | Fungi | 86.3 | 4.75e-18 | NR | XP_038917079.1 | 1750568 | g3635 | i0 | 45.7 | 2.63667820069204 | 94 | 47 | 97.6 | 1 | 287 | 6 | 157 | 246 | XP_038917079.1 40S ribosomal protein S1 [Cantharellus anzutake] | diamond | 762 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Hydnaceae | Cantharellus | Cantharellus anzutake | |
| 30130531 | 30130531 | PRJNA1103784_P_NODE_4952_length_264_cov_1.167539_g4897_i0 | PRJNA1103784 | 4952 | 264 | 1.167539 | 3.08230296 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 102 | 6.61e-23 | NR | XP_017990559.1 | 77020 | g4897 | i0 | 91.1 | 1.375 | 56 | 5 | 63.6 | 0 | 171 | 4 | 340 | 395 | XP_017990559.1 hypothetical protein Malapachy_0576 [Malassezia pachydermatis] | diamond | 363 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 31742700 | 31742700 | PRJNA1103784_P_NODE_5657_length_251_cov_0.865169_g5602_i0 | PRJNA1103784 | 5657 | 251 | 0.865169 | 2.17157419 | Vararia minispora EC-137 | 1314806 | Fungi | Fungi | 63.2 | 5.09e-10 | NR | KAI0036451.1 | 1314806 | g5602 | i0 | 52.2 | 0.800796812749004 | 67 | 15 | 80.1 | 1 | 1 | 201 | 100 | 149 | KAI0036451.1 copper zinc superoxide dismutase, partial [Vararia minispora EC-137] | diamond | 201 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Lachnocladiaceae | Vararia | Vararia minispora | |
| 32303913 | 32303913 | PRJNA1103784_P_NODE_4019_length_282_cov_1.373206_g3964_i0 | PRJNA1103784 | 4019 | 282 | 1.373206 | 3.87244092 | Opisthokonta | 33154 | Fungi | Fungi | 137 | 7.199999999999999e-36 | NR | XP_052943822.1 | 4972 | g3964 | i0 | 71 | 26.6914893617021 | 93 | 27 | 98.9 | 0 | 280 | 2 | 394 | 486 | XP_052943822.1 HAD-like domain-containing protein [Dioszegia hungarica] | diamond | 7527 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 32565741 | 32565741 | PRJNA1103784_P_NODE_5419_length_254_cov_2.314917_g5364_i0 | PRJNA1103784 | 5419 | 254 | 2.314917 | 5.87988918 | Rhodotorula toruloides NP11 | 1130832 | Fungi | Fungi | 51.6 | 9.32e-6 | NR | XP_016275084.1 | 1130832 | g5364 | i0 | 43.1 | 0.767716535433071 | 65 | 34 | 76.8 | 1 | 228 | 34 | 84 | 145 | XP_016275084.1 nascent polypeptide-associated complex subunit alpha [Rhodotorula toruloides NP11] | diamond | 195 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides |
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);;