contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA382558" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405029 | 405029 | PRJNA382558_S_NODE_8401_length_182_cov_5.565517_g8397_i0 | PRJNA382558 | 8401 | 182 | 5.565517 | 10.12924094 | Malassezia globosa | 76773 | Fungi | Fungi | 337 | 3.82e-88 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g8397 | i0 | 100 | 75.8021978021978 | 182 | 0 | 100 | 0 | 1 | 182 | 29870 | 29689 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 13796 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 2351039 | 2351039 | PRJNA382558_S_NODE_10042_length_172_cov_28.503704_g10038_i0 | PRJNA382558 | 10042 | 172 | 28.503704 | 49.02637088 | Malassezia | 55193 | Fungi | Fungi | 318 | 1.2899999999999999e-82 | NTclustered | gi|56474918|gb|AY743630.1| | 76773 | g10038 | i0 | 100 | 100 | 172 | 0 | 100 | 0 | 1 | 172 | 430 | 259 | Malassezia globosa strain CBS 7966 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17200 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 4903690 | 4903690 | PRJNA382558_S_NODE_1864_length_274_cov_9.540084_g1860_i0 | PRJNA382558 | 1864 | 274 | 9.540084 | 26.13983016 | Malassezia | 55193 | Fungi | Fungi | 470 | 5.859999999999999e-128 | NTclustered | gi|2175024210|gb|OM190400.1| | 76773 | g1860 | i0 | 97.802 | 99.6350364963504 | 273 | 5 | 99 | 1 | 1 | 273 | 41 | 312 | Malassezia globosa strain SB930 small subunit ribosomal RNA gene, partial sequence | blastn | 27300 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 6178706 | 6178706 | PRJNA382558_S_NODE_4005_length_224_cov_13.529412_g4001_i0 | PRJNA382558 | 4005 | 224 | 13.529412 | 30.30588288 | Agaricomycetes | 155619 | Fungi | Fungi | 409 | 1.03e-109 | NTclustered | gi|2120247073|gb|OK606155.1| | 5353 | g4001 | i0 | 100 | 98.6607142857143 | 221 | 0 | 99 | 0 | 1 | 221 | 409 | 629 | Lentinula edodes strain YS89 large subunit ribosomal RNA gene, partial sequence | blastn | 22100 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 8728354 | 8728354 | PRJNA382558_S_NODE_1187_length_305_cov_26.276119_g1183_i0 | PRJNA382558 | 1187 | 305 | 26.276119 | 80.14216295 | Malassezia | 55193 | Fungi | Fungi | 558 | 1.37e-154 | NTclustered | gi|724086716|gb|KM269140.1| | 76773 | g1183 | i0 | 99.672 | 98.383606557376993 | 305 | 1 | 100 | 0 | 1 | 305 | 1183 | 879 | Malassezia globosa strain 123.1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 30007 | 558 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 11278860 | 11278860 | PRJNA382558_S_NODE_10629_length_169_cov_15.378788_g10625_i0 | PRJNA382558 | 10629 | 169 | 15.378788 | 25.99015172 | Basidiomycota | 5204 | Fungi | Fungi | 292 | 7.64e-75 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g10625 | i0 | 98.204 | 98.585798816568 | 167 | 3 | 99 | 0 | 1 | 167 | 1301 | 1467 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 16661 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11883665 | 11883665 | PRJNA382558_S_NODE_6630_length_195_cov_6.443038_g6626_i0 | PRJNA382558 | 6630 | 195 | 6.443038 | 12.5639241 | Malassezia restricta | 76775 | Fungi | Fungi | 357 | 3.19e-94 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g6626 | i0 | 100 | 53.574358974359 | 193 | 0 | 99 | 0 | 3 | 195 | 3356 | 3164 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 10447 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16378197 | 16378197 | PRJNA382558_S_NODE_2473_length_254_cov_30.903226_g2469_i0 | PRJNA382558 | 2473 | 254 | 30.903226 | 78.49419404 | Malassezia | 55193 | Fungi | Fungi | 468 | 1.93e-127 | NTclustered | gi|613475760|gb|KJ174372.1| | 76773 | g2469 | i0 | 100 | 99.5984251968504 | 253 | 0 | 99 | 0 | 1 | 253 | 338 | 590 | Malassezia globosa strain KCTC27521 large subunit ribosomal RNA gene, partial sequence | blastn | 25298 | 468 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 18256368 | 18256368 | PRJNA382558_S_NODE_15115_length_152_cov_26.539130_g15111_i0 | PRJNA382558 | 15115 | 152 | 26.53913 | 40.3394776 | Malassezia restricta | 76775 | Fungi | Fungi | 252 | 1.1399999999999999e-62 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g15111 | i0 | 97.945 | 93.6513157894737 | 146 | 2 | 96 | 1 | 7 | 152 | 3209 | 3065 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 14235 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19530855 | 19530855 | PRJNA382558_S_NODE_8016_length_184_cov_8.469388_g8012_i0 | PRJNA382558 | 8016 | 184 | 8.469388 | 15.58367392 | Lentinula edodes | 5353 | Fungi | Fungi | 335 | 1.3899999999999996e-87 | NTclustered | gi|2723225103|dbj|LC813565.1| | 5353 | g8012 | i0 | 99.457 | 99.9239130434783 | 184 | 1 | 100 | 0 | 1 | 184 | 963 | 780 | Lentinula edodes BCRC:MU30948 DNA, clone Type1 | blastn | 18386 | 335 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 20201833 | 20201833 | PRJNA382558_S_NODE_15436_length_151_cov_13.140351_g15432_i0 | PRJNA382558 | 15436 | 151 | 13.140351 | 19.84193001 | Malassezia | 55193 | Fungi | Fungi | 274 | 2.42e-69 | NTclustered | gi|953821272|gb|KT310070.1| | 76773 | g15432 | i0 | 99.338 | 100.072847682119 | 151 | 1 | 100 | 0 | 1 | 151 | 679 | 829 | Malassezia globosa isolate 1242 large subunit ribosomal RNA gene, partial sequence | blastn | 15111 | 274 | 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);;