contig_metadata
12 rows where bioproject = "PRJNA383995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2955939 | 2955939 | PRJNA383995_P_NODE_14603_length_172_cov_0.975610_g14504_i0 | PRJNA383995 | 14603 | 172 | 0.97561 | 1.6780492 | Malassezia globosa | 76773 | Fungi | Fungi | 318 | 1.2899999999999999e-82 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g14504 | i0 | 100 | 71.6104651162791 | 172 | 0 | 100 | 0 | 1 | 172 | 29713 | 29542 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 12317 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 4232393 | 4232393 | PRJNA383995_P_NODE_18484_length_162_cov_0.902655_g18385_i0 | PRJNA383995 | 18484 | 162 | 0.902655 | 1.4623011 | Malassezia globosa | 76773 | Fungi | Fungi | 287 | 3.39e-73 | NTclustered | gi|164656600|ref|XM_001729376.1| | 425265 | g18385 | i0 | 98.758 | 1.45679012345679 | 161 | 2 | 99 | 0 | 2 | 162 | 1498 | 1658 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3463), partial mRNA | blastn | 236 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 9333326 | 9333326 | PRJNA383995_P_NODE_10648_length_201_cov_0.953947_g10549_i0 | PRJNA383995 | 10648 | 201 | 0.953947 | 1.91743347 | Malassezia furfur | 55194 | Fungi | Fungi | 361 | 2.5599999999999998e-95 | NTclustered | gi|2175024207|gb|OM190397.1| | 55194 | g10549 | i0 | 99.005 | 84 | 201 | 2 | 100 | 0 | 1 | 201 | 625 | 825 | Malassezia furfur strain SB910 small subunit ribosomal RNA gene, partial sequence | blastn | 16884 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 15708019 | 15708019 | PRJNA383995_P_NODE_5213_length_275_cov_1.805310_g5114_i0 | PRJNA383995 | 5213 | 275 | 1.80531 | 4.9646025 | Malassezia restricta | 76775 | Fungi | Fungi | 342 | 1.3399999999999999e-89 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5114 | i0 | 89.892 | 84.0472727272727 | 277 | 12 | 100 | 12 | 1 | 275 | 3041 | 3303 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 23113 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16378305 | 16378305 | PRJNA383995_P_NODE_4253_length_301_cov_1.837302_g4154_i0 | PRJNA383995 | 4253 | 301 | 1.837302 | 5.53027902 | Malassezia | 55193 | Fungi | Fungi | 545 | 1.0499999999999999e-150 | NTclustered | gi|915512619|gb|KP825402.1| | 76775 | g4154 | i0 | 99.336 | 98.0033222591362 | 301 | 2 | 100 | 0 | 1 | 301 | 307 | 7 | Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence | blastn | 29499 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18927321 | 18927321 | PRJNA383995_P_NODE_4395_length_296_cov_2.477733_g4296_i0 | PRJNA383995 | 4395 | 296 | 2.477733 | 7.33408968 | Malassezia | 55193 | Fungi | Fungi | 545 | 1.03e-150 | NTclustered | gi|1101565238|gb|KX808622.1| | 55194 | g4296 | i0 | 100 | 99.6418918918919 | 295 | 0 | 99 | 0 | 2 | 296 | 557 | 263 | Malassezia furfur isolate GDMUZJ2015046 26S ribosomal RNA gene, partial sequence | blastn | 29494 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 20806861 | 20806861 | PRJNA383995_P_NODE_16517_length_165_cov_0.879310_g16418_i0 | PRJNA383995 | 16517 | 165 | 0.87931 | 1.4508615 | Malassezia restricta | 76775 | Fungi | Fungi | 292 | 7.47e-75 | NTclustered | gi|674654174|gb|KJ847269.1| | 76775 | g16418 | i0 | 99.379 | 10.4727272727273 | 161 | 1 | 98 | 0 | 5 | 165 | 535 | 695 | Malassezia restricta strain NCCPF127152 intergenic spacer 1, partial sequence | blastn | 1728 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24631668 | 24631668 | PRJNA383995_P_NODE_17920_length_163_cov_0.894737_g17821_i0 | PRJNA383995 | 17920 | 163 | 0.894737 | 1.45842131 | Moniliophthora roreri | 221103 | Fungi | Fungi | 58.4 | 2.92e-4 | NTclustered | gi|330339441|ref|NC_015400.1| | 221103 | g17821 | i0 | 97.143 | 0.214723926380368 | 35 | 0 | 21 | 1 | 82 | 116 | 33616 | 33649 | Moniliophthora roreri mitochondrion, complete genome | blastn | 35 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Moniliophthora | Moniliophthora roreri | |
| 27011834 | 27011834 | PRJNA383995_P_NODE_16182_length_166_cov_0.871795_g16083_i0 | PRJNA383995 | 16182 | 166 | 0.871795 | 1.4471797 | Malassezia sp. CBS 17886 | 3031751 | Fungi | Fungi | 100 | 6.03e-23 | NR | WFD31456.1 | 3031751 | g16083 | i0 | 83 | 0.957831325301205 | 53 | 9 | 95.8 | 0 | 7 | 165 | 1220 | 1272 | WFD31456.1 cell division cycle- protein [Malassezia sp. CBS 17886] | diamond | 159 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sp. CBS 17886 | |
| 28780348 | 28780348 | PRJNA383995_P_NODE_17647_length_163_cov_0.894737_g17548_i0 | PRJNA383995 | 17647 | 163 | 0.894737 | 1.45842131 | Malassezia japonica | 223818 | Fungi | Fungi | 75.9 | 2.46e-14 | NR | XP_060120574.1 | 223818 | g17548 | i0 | 76 | 4.49079754601227 | 50 | 12 | 92 | 0 | 161 | 12 | 350 | 399 | XP_060120574.1 uncharacterized protein MJAP1_000624 [Malassezia japonica] | diamond | 732 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 29001932 | 29001932 | PRJNA383995_P_NODE_18768_length_161_cov_0.910714_g18669_i0 | PRJNA383995 | 18768 | 161 | 0.910714 | 1.46624954 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 54.3 | 1.01e-6 | NR | XP_018739843.1 | 1230383 | g18669 | i0 | 56 | 1.86335403726708 | 50 | 21 | 93.2 | 1 | 154 | 5 | 417 | 465 | XP_018739843.1 uncharacterized protein MSY001_1246 [Malassezia sympodialis ATCC 42132] | diamond | 300 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 32098256 | 32098256 | PRJNA383995_P_NODE_18478_length_162_cov_0.902655_g18379_i0 | PRJNA383995 | 18478 | 162 | 0.902655 | 1.4623011 | Malassezia furfur | 55194 | Fungi | Fungi | 90.1 | 2.25e-19 | NR | KAI3629254.1 | 55194 | g18379 | i0 | 86.8 | 0.981481481481482 | 53 | 7 | 98.1 | 0 | 161 | 3 | 334 | 386 | KAI3629254.1 hypothetical protein CBS9595_000326 [Malassezia furfur] | diamond | 159 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur |
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);;