contig_metadata
14 rows where bioproject = "PRJNA1120586", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1028345 | 1028345 | PRJNA1120586_P_NODE_20341_length_297_cov_8.793860_g20150_i0 | PRJNA1120586 | 20341 | 297 | 8.79386 | 26.1177642 | Malassezia | 55193 | Fungi | Fungi | 544 | 3.7299999999999996e-150 | NTclustered | gi|1101565660|gb|KX839636.1| | 55194 | g20150 | i0 | 99.663 | 99.993265993266 | 297 | 1 | 100 | 0 | 1 | 297 | 565 | 269 | Malassezia furfur isolate GDMUZJ2015102 26S ribosomal RNA gene, partial sequence | blastn | 29698 | 549 | 0.990892531876138 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 4856497 | 4856497 | PRJNA1120586_P_NODE_53364_length_224_cov_2.400000_g53173_i0 | PRJNA1120586 | 53364 | 224 | 2.4 | 5.376 | Cystobasidium | 203525 | Fungi | Fungi | 414 | 2.1999999999999996e-111 | NTclustered | gi|1708295083|gb|MN218620.1| | 106018 | g53173 | i0 | 100 | 99.3973214285714 | 224 | 0 | 100 | 0 | 1 | 224 | 367 | 590 | Cystobasidium slooffiae clone Y6_NL1 large subunit ribosomal RNA gene, partial sequence | blastn | 22265 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium slooffiae | |
| 7928866 | 7928866 | PRJNA1120586_P_NODE_27707_length_268_cov_1.140704_g27516_i0 | PRJNA1120586 | 27707 | 268 | 1.140704 | 3.05708672 | Eballistra lineata | 127113 | Fungi | Fungi | 490 | 4.39e-134 | NTclustered | gi|8489263|gb|AF229351.1|AF229351 | 127113 | g27516 | i0 | 99.627 | 99.3432835820896 | 268 | 1 | 100 | 0 | 1 | 268 | 228 | 495 | Eballistra lineata large subunit ribosomal RNA gene, partial sequence | blastn | 26624 | 490 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Georgefischeriales | Eballistraceae | Eballistra | Eballistra lineata | |
| 10480030 | 10480030 | PRJNA1120586_P_NODE_52729_length_226_cov_0.917197_g52538_i0 | PRJNA1120586 | 52729 | 226 | 0.917197 | 2.07286522 | Malassezia restricta | 76775 | Fungi | Fungi | 412 | 8.01e-111 | NTclustered | gi|1546631151|ref|XM_027627236.1| | 76775 | g52538 | i0 | 99.558 | 6.96017699115044 | 226 | 1 | 100 | 0 | 1 | 226 | 327 | 102 | Malassezia restricta dolichyl-diphosphooligosaccharide---protein glycosyltransferase (MRET_0609), partial mRNA | blastn | 1573 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11754845 | 11754845 | PRJNA1120586_P_NODE_47230_length_230_cov_0.894410_g47039_i0 | PRJNA1120586 | 47230 | 230 | 0.89441 | 2.057143 | Malassezia globosa | 76773 | Fungi | Fungi | 420 | 4.89e-113 | NTclustered | gi|164656906|ref|XM_001729528.1| | 425265 | g47039 | i0 | 99.565 | 1 | 230 | 1 | 100 | 0 | 1 | 230 | 189 | 418 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3124), partial mRNA | blastn | 230 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 11754972 | 11754972 | PRJNA1120586_P_NODE_52630_length_226_cov_0.917197_g52439_i0 | PRJNA1120586 | 52630 | 226 | 0.917197 | 2.07286522 | Malassezia restricta | 76775 | Fungi | Fungi | 418 | 1.7199999999999998e-112 | NTclustered | gi|1546632948|ref|XM_027628134.1| | 76775 | g52439 | i0 | 100 | 1 | 226 | 0 | 100 | 0 | 1 | 226 | 915 | 1140 | Malassezia restricta alpha/beta-hydrolase lipase (MRET_1507), partial mRNA | blastn | 226 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12507135 | 12507135 | PRJNA1120586_P_NODE_22610_length_287_cov_1.224771_g22419_i0 | PRJNA1120586 | 22610 | 287 | 1.224771 | 3.51509277 | Papiliotrema | 189450 | Fungi | Fungi | 508 | 1.31e-139 | NTclustered | gi|1102645166|gb|KY108736.1| | 192649 | g22419 | i0 | 98.606 | 106.968641114983 | 287 | 4 | 100 | 0 | 1 | 287 | 494 | 780 | Papiliotrema sp. 'fusca' culture CBS:9650 large subunit ribosomal RNA gene, partial sequence | blastn | 30700 | 508 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema fusca (nom. inval.) | |
| 14304671 | 14304671 | PRJNA1120586_P_NODE_18252_length_309_cov_1.179167_g18061_i0 | PRJNA1120586 | 18252 | 309 | 1.179167 | 3.64362603 | Pleurotus ostreatus | 5322 | Fungi | Fungi | 566 | 8.33e-157 | NTclustered | gi|148358037|gb|DQ071722.2| | 5322 | g18061 | i0 | 99.676 | 100.058252427184 | 309 | 1 | 100 | 0 | 1 | 309 | 1760 | 1452 | Pleurotus ostreatus voucher TUB 011571 28S large subunit ribosomal RNA gene, partial sequence | blastn | 30918 | 566 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 15578878 | 15578878 | PRJNA1120586_P_NODE_32273_length_254_cov_1.481081_g32082_i0 | PRJNA1120586 | 32273 | 254 | 1.481081 | 3.76194574 | Malassezia globosa | 76773 | Fungi | Fungi | 464 | 2.4999999999999994e-126 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g32082 | i0 | 99.606 | 85.8622047244095 | 254 | 1 | 100 | 0 | 1 | 254 | 29574 | 29827 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 21809 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 18128022 | 18128022 | PRJNA1120586_P_NODE_46375_length_230_cov_1.136646_g46184_i0 | PRJNA1120586 | 46375 | 230 | 1.136646 | 2.6142858 | Malassezia globosa | 76773 | Fungi | Fungi | 425 | 1.05e-114 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g46184 | i0 | 100 | 8.25217391304348 | 230 | 0 | 100 | 0 | 1 | 230 | 424 | 653 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 1898 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 20677622 | 20677622 | PRJNA1120586_P_NODE_40397_length_235_cov_0.867470_g40206_i0 | PRJNA1120586 | 40397 | 235 | 0.86747 | 2.0385545 | Malassezia restricta | 76775 | Fungi | Fungi | 429 | 8.33e-116 | NTclustered | gi|1546638463|ref|XM_027630873.1| | 76775 | g40206 | i0 | 99.574 | 1 | 235 | 1 | 100 | 0 | 1 | 235 | 1295 | 1529 | Malassezia restricta DNA polymerase gamma 1 (MRET_4246), partial mRNA | blastn | 235 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23228543 | 23228543 | PRJNA1120586_P_NODE_43819_length_232_cov_0.883436_g43628_i0 | PRJNA1120586 | 43819 | 232 | 0.883436 | 2.04957152 | Malassezia restricta | 76775 | Fungi | Fungi | 429 | 8.2e-116 | NTclustered | gi|1546634374|ref|XM_027628847.1| | 76775 | g43628 | i0 | 100 | 2.58189655172414 | 232 | 0 | 100 | 0 | 1 | 232 | 666 | 897 | Malassezia restricta kinesin family member 5 (MRET_2220), partial mRNA | blastn | 599 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30354945 | 30354945 | PRJNA1120586_P_NODE_41652_length_234_cov_0.872727_g41461_i0 | PRJNA1120586 | 41652 | 234 | 0.872727 | 2.04218118 | Gyrodon lividus | 85971 | Fungi | Fungi | 41.6 | 0.0449 | NR | KAF9228331.1 | 85971 | g41461 | i0 | 44.7 | 0.487179487179487 | 38 | 21 | 48.7 | 0 | 173 | 60 | 10 | 47 | KAF9228331.1 hypothetical protein BS17DRAFT_692150 [Gyrodon lividus] | diamond | 114 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Gyrodontaceae | Gyrodon | Gyrodon lividus | |
| 31745107 | 31745107 | PRJNA1120586_P_NODE_41877_length_234_cov_0.872727_g41686_i0 | PRJNA1120586 | 41877 | 234 | 0.872727 | 2.04218118 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 57 | 2.94e-7 | NR | XP_017991756.1 | 77020 | g41686 | i0 | 44.6 | 0.833333333333333 | 65 | 28 | 73.1 | 2 | 63 | 233 | 5 | 69 | XP_017991756.1 hypothetical protein Malapachy_3917 [Malassezia pachydermatis] | diamond | 195 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis |
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);;