contig_metadata
8 rows where bioproject = "PRJNA902515" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4710040 | 4710040 | PRJNA902515_P_NODE_9864_length_266_cov_1.616580_g9841_i0 | PRJNA902515 | 9864 | 266 | 1.61658 | 4.3001028 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 398 | 2.7099999999999996e-106 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g9841 | i0 | 93.609 | 103.785714285714 | 266 | 17 | 100 | 0 | 1 | 266 | 3895 | 4160 | Cystobasidium laryngis 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 | 27607 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis | |
| 5984434 | 5984434 | PRJNA902515_P_NODE_12665_length_250_cov_0.881356_g12642_i0 | PRJNA902515 | 12665 | 250 | 0.881356 | 2.20339 | Malassezia restricta | 76775 | Fungi | Fungi | 462 | 8.83e-126 | NTclustered | gi|1546636419|ref|XM_027629852.1| | 76775 | g12642 | i0 | 100 | 1 | 250 | 0 | 100 | 0 | 1 | 250 | 2047 | 2296 | Malassezia restricta uncharacterized protein (MRET_3225), partial mRNA | blastn | 250 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9809117 | 9809117 | PRJNA902515_P_NODE_12968_length_249_cov_0.886364_g12945_i0 | PRJNA902515 | 12968 | 249 | 0.886364 | 2.20704636 | Malassezia restricta | 76775 | Fungi | Fungi | 414 | 2.49e-111 | NTclustered | gi|1546637981|ref|XM_027630632.1| | 76775 | g12945 | i0 | 100 | 0.899598393574297 | 224 | 0 | 90 | 0 | 26 | 249 | 2229 | 2006 | Malassezia restricta RING-14 protein (MRET_4005), partial mRNA | blastn | 224 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9809177 | 9809177 | PRJNA902515_P_NODE_15188_length_244_cov_0.912281_g15165_i0 | PRJNA902515 | 15188 | 244 | 0.912281 | 2.22596564 | Malassezia restricta | 76775 | Fungi | Fungi | 440 | 4.019999999999999e-119 | NTclustered | gi|1546631678|ref|XM_027627499.1| | 76775 | g15165 | i0 | 99.18 | 1 | 244 | 2 | 100 | 0 | 1 | 244 | 5760 | 5517 | Malassezia restricta acetyl-CoA carboxylase, biotin containing enzyme (MRET_0872), partial mRNA | blastn | 244 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18732692 | 18732692 | PRJNA902515_P_NODE_14835_length_245_cov_0.906977_g14812_i0 | PRJNA902515 | 14835 | 245 | 0.906977 | 2.22209365 | Malassezia japonica | 223818 | Fungi | Fungi | 145 | 3.5499999999999996e-30 | NTclustered | gi|2594592763|ref|XM_060267335.1| | 223818 | g14812 | i0 | 79.703 | 7.78367346938775 | 202 | 39 | 82 | 2 | 37 | 237 | 1 | 201 | Malassezia japonica nucleoside-diphosphate kinase (ndk1_2), partial mRNA | blastn | 1907 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 19098128 | 19098128 | PRJNA902515_P_NODE_5515_length_333_cov_5.419231_g5492_i0 | PRJNA902515 | 5515 | 333 | 5.419231 | 18.04603923 | Opisthokonta | 33154 | Fungi | Fungi | 610 | 4.13e-170 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5492 | i0 | 99.7 | 92.981981981982 | 333 | 1 | 100 | 0 | 1 | 333 | 700 | 368 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 30963 | 610 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21283331 | 21283331 | PRJNA902515_P_NODE_5957_length_324_cov_4.888446_g5934_i0 | PRJNA902515 | 5957 | 324 | 4.888446 | 15.83856504 | Malassezia restricta | 76775 | Fungi | Fungi | 599 | 8.67e-167 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5934 | i0 | 100 | 80.3456790123457 | 324 | 0 | 100 | 0 | 1 | 324 | 2982 | 3305 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 26032 | 599 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29929670 | 29929670 | PRJNA902515_P_NODE_5651_length_331_cov_0.903101_g5628_i0 | PRJNA902515 | 5651 | 331 | 0.903101 | 2.98926431 | Amylostereum chailletii | 55340 | Fungi | Fungi | 223 | 1.21e-67 | NR | KAI0320106.1 | 55340 | g5628 | i0 | 98.2 | 0.987915407854985 | 109 | 2 | 98.8 | 0 | 2 | 328 | 144 | 252 | KAI0320106.1 glycoside hydrolase superfamily [Amylostereum chailletii] | diamond | 327 | 223 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Amylostereum | Amylostereum chailletii |
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);;