contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1047321" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1009791 | 1009791 | PRJNA1047321_P_NODE_5121_length_281_cov_12.740385_g4950_i0 | PRJNA1047321 | 5121 | 281 | 12.740385 | 35.80048185 | Cryptococcus | 5206 | Fungi | Fungi | 307 | 5.0100000000000005e-79 | NTclustered | gi|1338633128|gb|CP025718.1| | 5207 | g4950 | i0 | 87.004 | 141.565836298932 | 277 | 31 | 98 | 5 | 1 | 276 | 271466 | 271194 | Cryptococcus neoformans strain EN28 chromosome 2, complete sequence | blastn | 39780 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus neoformans | |
| 2285060 | 2285060 | PRJNA1047321_P_NODE_7662_length_246_cov_0.890173_g7491_i0 | PRJNA1047321 | 7662 | 246 | 0.890173 | 2.18982558 | Malassezia | 55193 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|1101565583|gb|KX839604.1| | 55194 | g7491 | i0 | 100 | 100 | 246 | 0 | 100 | 0 | 1 | 246 | 522 | 277 | Malassezia furfur isolate GDMUZJ2015140 26S ribosomal RNA gene, partial sequence | blastn | 24600 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 2285067 | 2285067 | PRJNA1047321_P_NODE_8922_length_234_cov_2.167702_g8751_i0 | PRJNA1047321 | 8922 | 234 | 2.167702 | 5.07242268 | Cryptococcus | 5206 | Fungi | Fungi | 252 | 1.93e-62 | NTclustered | gi|1338633128|gb|CP025718.1| | 5207 | g8751 | i0 | 86.066 | 139.461538461538 | 244 | 23 | 100 | 8 | 1 | 234 | 271222 | 271464 | Cryptococcus neoformans strain EN28 chromosome 2, complete sequence | blastn | 32634 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus neoformans | |
| 2724899 | 2724899 | PRJNA1047321_P_NODE_1983_length_485_cov_0.963592_g1814_i0 | PRJNA1047321 | 1983 | 485 | 0.963592 | 4.6734212 | Hannaella oryzae | 4979 | Fungi | Fungi | 436 | 1.12e-117 | NTclustered | gi|1511245097|ref|NC_039747.1| | 4979 | g1814 | i0 | 86.029 | 62.6350515463918 | 408 | 56 | 84 | 1 | 1 | 407 | 7633 | 8040 | Hannaella oryzae mitochondrion, complete genome | blastn | 30378 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Hannaella | Hannaella oryzae | |
| 4000904 | 4000904 | PRJNA1047321_P_NODE_4924_length_286_cov_2.408451_g4753_i0 | PRJNA1047321 | 4924 | 286 | 2.408451 | 6.88816986 | Flammulina velutipes | 38945 | Fungi | Fungi | 462 | 1.03e-125 | NTclustered | gi|1487130313|gb|MH468771.1| | 38945 | g4753 | i0 | 95.804 | 107.048951048951 | 286 | 12 | 100 | 0 | 1 | 286 | 5825 | 5540 | Flammulina velutipes strain strain NJ6-3 18S ribosomal RNA gene, 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 | 30616 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Flammulina | Flammulina velutipes | |
| 4837859 | 4837859 | PRJNA1047321_P_NODE_7464_length_246_cov_3.462428_g7293_i0 | PRJNA1047321 | 7464 | 246 | 3.462428 | 8.51757288 | Filobasidium | 5209 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|452084931|emb|HF568992.1| | 89934 | g7293 | i0 | 100 | 100.260162601626 | 246 | 0 | 100 | 0 | 1 | 246 | 289 | 44 | Filobasidium globisporum partial 18S rRNA gene, strain A10 | blastn | 24664 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium globisporum | |
| 5277250 | 5277250 | PRJNA1047321_P_NODE_7045_length_248_cov_1.428571_g6874_i0 | PRJNA1047321 | 7045 | 248 | 1.428571 | 3.54285608 | Malassezia globosa | 76773 | Fungi | Fungi | 442 | 1.1399999999999995e-119 | NTclustered | gi|915512562|gb|KP825345.1| | 76773 | g6874 | i0 | 98.79 | 99.9596774193548 | 248 | 3 | 100 | 0 | 1 | 248 | 284 | 37 | Malassezia globosa strain ISOSEB15I 28S ribosomal RNA gene, partial sequence | blastn | 24790 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7387584 | 7387584 | PRJNA1047321_P_NODE_3346_length_357_cov_3.323944_g3176_i0 | PRJNA1047321 | 3346 | 357 | 3.323944 | 11.86648008 | Tremellomycetes | 155616 | Fungi | Fungi | 654 | 0 | NTclustered | gi|406206|dbj|D13460.1|FILSSRD7 | 5210 | g3176 | i0 | 99.72 | 99.9607843137255 | 357 | 1 | 100 | 0 | 1 | 357 | 1614 | 1258 | Filobasidium floriforme gene for small subunit ribosomal RNA | blastn | 35686 | 654 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 7827060 | 7827060 | PRJNA1047321_P_NODE_6587_length_251_cov_0.865169_g6416_i0 | PRJNA1047321 | 6587 | 251 | 0.865169 | 2.17157419 | Malassezia restricta | 76775 | Fungi | Fungi | 448 | 2.48e-121 | NTclustered | gi|1546635504|ref|XM_027629411.1| | 76775 | g6416 | i0 | 98.805 | 1 | 251 | 3 | 100 | 0 | 1 | 251 | 582 | 832 | Malassezia restricta YagE family protein (MRET_2784), partial mRNA | blastn | 251 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8663022 | 8663022 | PRJNA1047321_P_NODE_8927_length_233_cov_4.712500_g8756_i0 | PRJNA1047321 | 8927 | 233 | 4.7125 | 10.980125 | Tremellales | 5234 | Fungi | Fungi | 431 | 2.2899999999999996e-116 | NTclustered | gi|229001878|emb|FN357212.1| | 159573 | g8756 | i0 | 100 | 99.9828326180258 | 233 | 0 | 100 | 0 | 1 | 233 | 247 | 15 | Cryptococcus heimaeyensis partial 26S rRNA gene, isolate AY-73 | blastn | 23296 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Vishniacozyma | Vishniacozyma heimaeyensis | |
| 11652937 | 11652937 | PRJNA1047321_P_NODE_2850_length_390_cov_2.735016_g2681_i0 | PRJNA1047321 | 2850 | 390 | 2.735016 | 10.6665624 | uncultured Filobasidiella | 1503101 | Fungi | Fungi | 704 | 0 | NTclustered | gi|387156411|emb|HE806144.1| | 1503101 | g2681 | i0 | 99.231 | 150.025641025641 | 390 | 3 | 100 | 0 | 1 | 390 | 1415 | 1804 | Uncultured Filobasidiella partial 26S rRNA gene, clone Ao0Yyyy6 | blastn | 58510 | 704 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | uncultured Filobasidiella | ||
| 11652997 | 11652997 | PRJNA1047321_P_NODE_8950_length_232_cov_2.075472_g8779_i0 | PRJNA1047321 | 8950 | 232 | 2.075472 | 4.81509504 | Malassezia restricta | 76775 | Fungi | Fungi | 429 | 8.2e-116 | NTclustered | gi|1546636613|ref|XM_027629949.1| | 76775 | g8779 | i0 | 100 | 1 | 232 | 0 | 100 | 0 | 1 | 232 | 286 | 517 | Malassezia restricta mitochondrial hypoxia responsive domain protein (MRET_3322), partial mRNA | blastn | 232 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14203156 | 14203156 | PRJNA1047321_P_NODE_8532_length_242_cov_0.911243_g8361_i0 | PRJNA1047321 | 8532 | 242 | 0.911243 | 2.20520806 | Pascua guehoae | 105714 | Fungi | Fungi | 182 | 2.66e-41 | NTclustered | gi|2386959624|ref|NC_068697.1| | 105714 | g8361 | i0 | 84.293 | 48.0619834710744 | 191 | 25 | 78 | 5 | 46 | 233 | 24037 | 24225 | Pascua guehoae mitochondrion, complete genome | blastn | 11631 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Pascua | Pascua guehoae | |
| 15477163 | 15477163 | PRJNA1047321_P_NODE_2653_length_407_cov_1.467066_g2484_i0 | PRJNA1047321 | 2653 | 407 | 1.467066 | 5.97095862 | Cylindrobasidium laeve | 202712 | Fungi | Fungi | 736 | 0 | NTclustered | gi|480327014|gb|JX535037.1| | 202712 | g2484 | i0 | 99.505 | 101.226044226044 | 404 | 2 | 99 | 0 | 1 | 404 | 1397 | 1800 | Cylindrobasidium laeve isolate 2 large subunit ribosomal RNA gene, partial sequence | blastn | 41199 | 736 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium laeve | |
| 16312228 | 16312228 | PRJNA1047321_P_NODE_2193_length_454_cov_4.330709_g2024_i0 | PRJNA1047321 | 2193 | 454 | 4.330709 | 19.66141886 | Tremellales | 5234 | Fungi | Fungi | 660 | 0 | NTclustered | gi|501438058|gb|FJ644525.2| | 5217 | g2024 | i0 | 92.795 | 109.449339207048 | 458 | 29 | 100 | 3 | 1 | 454 | 1221 | 1678 | Tremella mesenterica voucher TUB 019108 28S ribosomal RNA gene, partial sequence | blastn | 49690 | 660 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 16751382 | 16751382 | PRJNA1047321_P_NODE_8514_length_242_cov_0.911243_g8343_i0 | PRJNA1047321 | 8514 | 242 | 0.911243 | 2.20520806 | Malassezia restricta | 76775 | Fungi | Fungi | 431 | 2.4e-116 | NTclustered | gi|1546635244|ref|XM_027629281.1| | 76775 | g8343 | i0 | 98.76 | 1.17355371900826 | 242 | 3 | 100 | 0 | 1 | 242 | 56 | 297 | Malassezia restricta solute carrier family 25, member 39/40 (MRET_2654), partial mRNA | blastn | 284 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18026264 | 18026264 | PRJNA1047321_P_NODE_8355_length_242_cov_2.331361_g8184_i0 | PRJNA1047321 | 8355 | 242 | 2.331361 | 5.64189362 | Kwoniella heveanensis | 89924 | Fungi | Fungi | 292 | 1.18e-74 | NTclustered | gi|2678476216|gb|CP144515.1| | 1296119 | g8184 | i0 | 88.43 | 145.5 | 242 | 28 | 100 | 0 | 1 | 242 | 1615518 | 1615277 | Kwoniella heveanensis CBS 569 chromosome 2 | blastn | 35211 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 20136208 | 20136208 | PRJNA1047321_P_NODE_4776_length_292_cov_1.388128_g4605_i0 | PRJNA1047321 | 4776 | 292 | 1.388128 | 4.05333376 | Cylindrobasidium | 139105 | Fungi | Fungi | 540 | 4.74e-149 | NTclustered | gi|1473265577|gb|MH878521.1| | 139106 | g4605 | i0 | 100 | 100.167808219178 | 292 | 0 | 100 | 0 | 1 | 292 | 625 | 334 | Cylindrobasidium evolvens culture CBS:832.72 strain CBS 832.72 large subunit ribosomal RNA gene, partial sequence | blastn | 29249 | 540 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium evolvens | |
| 20575502 | 20575502 | PRJNA1047321_P_NODE_6077_length_258_cov_1.664865_g5906_i0 | PRJNA1047321 | 6077 | 258 | 1.664865 | 4.2953517 | Malassezia restricta | 76775 | Fungi | Fungi | 472 | 1.52e-128 | NTclustered | gi|1546637503|ref|XM_027630394.1| | 76775 | g5906 | i0 | 99.612 | 2 | 258 | 1 | 100 | 0 | 1 | 258 | 13 | 270 | Malassezia restricta uncharacterized protein (MRET_3767), partial mRNA | blastn | 516 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24400452 | 24400452 | PRJNA1047321_P_NODE_3340_length_358_cov_1.340351_g3170_i0 | PRJNA1047321 | 3340 | 358 | 1.340351 | 4.79845658 | Filobasidium wieringae | 104416 | Fungi | Fungi | 645 | 1.2199999999999996e-180 | NTclustered | gi|2843133256|gb|PQ530069.1| | 104416 | g3170 | i0 | 99.162 | 100 | 358 | 3 | 100 | 0 | 1 | 358 | 447 | 804 | Filobasidium wieringae isolate CHP-0015 large subunit ribosomal RNA gene, partial sequence | blastn | 35800 | 645 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium wieringae | |
| 25236119 | 25236119 | PRJNA1047321_P_NODE_7460_length_246_cov_5.849711_g7289_i0 | PRJNA1047321 | 7460 | 246 | 5.849711 | 14.39028906 | Malassezia | 55193 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|613475760|gb|KJ174372.1| | 76773 | g7289 | i0 | 100 | 99.9430894308943 | 246 | 0 | 100 | 0 | 1 | 246 | 347 | 592 | Malassezia globosa strain KCTC27521 large subunit ribosomal RNA gene, partial sequence | blastn | 24586 | 455 | 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);;