contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA383995" and tax_kingdom = "Fungi"
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 | |
| 15708026 | 15708026 | PRJNA383995_P_NODE_7293_length_237_cov_1.085106_g7194_i0 | PRJNA383995 | 7293 | 237 | 1.085106 | 2.57170122 | uncultured fungus | 175245 | Fungi | Fungi | 388 | 1.43e-103 | NTclustered | gi|400178660|gb|JX241713.1| | 175245 | g7194 | i0 | 96.203 | 70.9367088607595 | 237 | 9 | 100 | 0 | 1 | 237 | 320 | 84 | Uncultured fungus clone CheiFrLf2291 26S ribosomal RNA gene, partial sequence | blastn | 16812 | 388 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 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 | |
| 19531126 | 19531126 | PRJNA383995_P_NODE_3496_length_330_cov_2.259786_g3397_i0 | PRJNA383995 | 3496 | 330 | 2.259786 | 7.4572938 | uncultured fungus | 175245 | Fungi | Fungi | 560 | 4.17e-155 | NTclustered | gi|2159202719|emb|OU941147.1| | 175245 | g3397 | i0 | 97.273 | 77.6636363636364 | 330 | 9 | 100 | 0 | 1 | 330 | 1084 | 755 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus02441 | blastn | 25629 | 560 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 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 | |
| 21477485 | 21477485 | PRJNA383995_P_NODE_4577_length_291_cov_4.024793_g4478_i0 | PRJNA383995 | 4577 | 291 | 4.024793 | 11.71214763 | Opisthokonta | 33154 | Fungi | Fungi | 532 | 7.9e-147 | NTclustered | gi|2159202719|emb|OU941147.1| | 175245 | g4478 | i0 | 99.656 | 92.3470790378007 | 291 | 1 | 100 | 0 | 1 | 291 | 1899 | 1609 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus02441 | blastn | 26873 | 532 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 22752656 | 22752656 | PRJNA383995_P_NODE_13398_length_180_cov_1.114504_g13299_i0 | PRJNA383995 | 13398 | 180 | 1.114504 | 2.0061072 | Fungi | 4751 | Fungi | Fungi | 333 | 4.87e-87 | NTclustered | gi|767813157|gb|KP114602.1| | 29917 | g13299 | i0 | 100 | 100 | 180 | 0 | 100 | 0 | 1 | 180 | 210 | 31 | Cladosporium cladosporioides strain PF3 large subunit ribosomal RNA gene, partial sequence | blastn | 18000 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 24631635 | 24631635 | PRJNA383995_P_NODE_10460_length_202_cov_2.228758_g10361_i0 | PRJNA383995 | 10460 | 202 | 2.228758 | 4.50209116 | uncultured fungus | 175245 | Fungi | Fungi | 363 | 7.149999999999999e-96 | NTclustered | gi|507138797|gb|KC670390.1| | 175245 | g10361 | i0 | 99.01 | 100 | 202 | 2 | 100 | 0 | 1 | 202 | 150 | 351 | Uncultured fungus clone nco92g03c1 18S ribosomal RNA gene, partial sequence | blastn | 20200 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 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 |
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);;