contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA371613" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1073519 | 1073519 | PRJNA371613_P_NODE_5721_length_195_cov_0.962025_g5545_i0 | PRJNA371613 | 5721 | 195 | 0.962025 | 1.87594875 | Tremellales | 5234 | Fungi | Fungi | 350 | 5.34e-92 | NTclustered | gi|363497964|gb|JN400745.1| | 4972 | g5545 | i0 | 98.974 | 99.9435897435897 | 195 | 2 | 100 | 0 | 1 | 195 | 216 | 22 | Dioszegia hungarica isolate TP-Snow-Y4 26S ribosomal RNA gene, partial sequence | blastn | 19489 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 2950167 | 2950167 | PRJNA371613_P_NODE_2763_length_335_cov_4.382550_g2587_i0 | PRJNA371613 | 2763 | 335 | 4.38255 | 14.6815425 | Malassezia restricta | 76775 | Fungi | Fungi | 457 | 5.729999999999999e-124 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g2587 | i0 | 91.964 | 88.8208955223881 | 336 | 12 | 100 | 11 | 1 | 335 | 3318 | 2997 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 29755 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7451426 | 7451426 | PRJNA371613_P_NODE_8446_length_165_cov_3.703125_g8270_i0 | PRJNA371613 | 8446 | 165 | 3.703125 | 6.11015625 | Malassezia | 55193 | Fungi | Fungi | 305 | 9.59e-79 | NTclustered | gi|953821272|gb|KT310070.1| | 76773 | g8270 | i0 | 100 | 100.012121212121 | 165 | 0 | 100 | 0 | 1 | 165 | 679 | 843 | Malassezia globosa isolate 1242 large subunit ribosomal RNA gene, partial sequence | blastn | 16502 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 8052790 | 8052790 | PRJNA371613_P_NODE_5287_length_206_cov_1.721893_g5111_i0 | PRJNA371613 | 5287 | 206 | 1.721893 | 3.54709958 | Lentinula edodes | 5353 | Fungi | Fungi | 381 | 2.0199999999999994e-101 | NTclustered | gi|2723225103|dbj|LC813565.1| | 5353 | g5111 | i0 | 100 | 100.834951456311 | 206 | 0 | 100 | 0 | 1 | 206 | 9346 | 9141 | Lentinula edodes BCRC:MU30948 DNA, clone Type1 | blastn | 20772 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 11878259 | 11878259 | PRJNA371613_P_NODE_4370_length_236_cov_2.085427_g4194_i0 | PRJNA371613 | 4370 | 236 | 2.085427 | 4.92160772 | Cystofilobasidium capitatum | 5412 | Fungi | Fungi | 392 | 1.0999999999999999e-104 | NTclustered | gi|501438057|gb|FJ644524.2| | 5412 | g4194 | i0 | 96.61 | 107.029661016949 | 236 | 8 | 100 | 0 | 1 | 236 | 1419 | 1654 | Cystofilobasidium capitatum voucher 01/04 28S ribosomal RNA gene, partial sequence | blastn | 25259 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Cystofilobasidiaceae | Cystofilobasidium | Cystofilobasidium capitatum | |
| 12552044 | 12552044 | PRJNA371613_P_NODE_2670_length_344_cov_3.306189_g2494_i0 | PRJNA371613 | 2670 | 344 | 3.306189 | 11.37329016 | Malassezia | 55193 | Fungi | Fungi | 630 | 3.289999999999999e-176 | NTclustered | gi|915512591|gb|KP825374.1| | 76773 | g2494 | i0 | 99.709 | 97.9040697674419 | 344 | 1 | 100 | 0 | 1 | 344 | 301 | 644 | Malassezia globosa strain ISOSEB48F 28S ribosomal RNA gene, partial sequence | blastn | 33679 | 630 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 13826910 | 13826910 | PRJNA371613_P_NODE_2031_length_417_cov_13.255263_g1856_i0 | PRJNA371613 | 2031 | 417 | 13.255263 | 55.27444671 | root | 1 | Root_unresolved | Root_unresolved | 765 | 0 | NTclustered | gi|1546635596|ref|XR_003525368.1| | 76775 | g1856 | i0 | 99.76 | 100 | 417 | 1 | 100 | 0 | 1 | 417 | 742 | 1158 | Malassezia restricta 18S ribosomal RNA (MRET_r0002), rRNA | blastn | 41700 | 765 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 15702263 | 15702263 | PRJNA371613_P_NODE_5353_length_204_cov_2.383234_g5177_i0 | PRJNA371613 | 5353 | 204 | 2.383234 | 4.86179736 | Malassezia restricta | 76775 | Fungi | Fungi | 366 | 5.599999999999998e-97 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5177 | i0 | 99.02 | 100.303921568627 | 204 | 2 | 100 | 0 | 1 | 204 | 1742 | 1945 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 20462 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 15702279 | 15702279 | PRJNA371613_P_NODE_7753_length_169_cov_0.969697_g7577_i0 | PRJNA371613 | 7753 | 169 | 0.969697 | 1.63878793 | Malassezia restricta | 76775 | Fungi | Fungi | 255 | 1e-63 | NTclustered | gi|1546637397|ref|XM_027630341.1| | 76775 | g7577 | i0 | 100 | 1.52662721893491 | 138 | 0 | 82 | 0 | 32 | 169 | 157 | 20 | Malassezia restricta myosin regulatory light chain cdc4 (MRET_3714), partial mRNA | blastn | 258 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;