contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA738523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 719491 | 719491 | PRJNA738523_P_NODE_10201_length_253_cov_1.705556_g10130_i0 | PRJNA738523 | 10201 | 253 | 1.705556 | 4.31505668 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 111 | 3.73e-20 | NTclustered | gi|1063855304|ref|XM_018135375.1| | 77020 | g10130 | i0 | 80.921 | 9.05928853754941 | 152 | 19 | 58 | 7 | 92 | 238 | 219 | 73 | Malassezia pachydermatis 60s ribosomal protein l29 (Malapachy_0862), partial mRNA | blastn | 2292 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 1995634 | 1995634 | PRJNA738523_P_NODE_8422_length_270_cov_1.350254_g8351_i0 | PRJNA738523 | 8422 | 270 | 1.350254 | 3.6456858 | Malassezia restricta | 76775 | Fungi | Fungi | 161 | 3.94e-35 | NTclustered | gi|1546638709|ref|XM_027630996.1| | 76775 | g8351 | i0 | 100 | 0.322222222222222 | 87 | 0 | 32 | 0 | 1 | 87 | 87 | 1 | Malassezia restricta ribonucleoside-diphosphate reductase subunit M2 (MRET_4369), partial mRNA | blastn | 87 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7098197 | 7098197 | PRJNA738523_P_NODE_10866_length_251_cov_0.865169_g10795_i0 | PRJNA738523 | 10866 | 251 | 0.865169 | 2.17157419 | Serpula lacrymans | 85982 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|597935239|ref|XM_007321902.1| | 578457 | g10795 | i0 | 100 | 0.115537848605578 | 29 | 0 | 12 | 0 | 58 | 86 | 64 | 36 | Serpula lacrymans var. lacrymans S7.9 uncharacterized protein (SERLADRAFT_475614), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Serpulaceae | Serpula | Serpula lacrymans | |
| 7098274 | 7098274 | PRJNA738523_P_NODE_7426_length_280_cov_1.077295_g7355_i0 | PRJNA738523 | 7426 | 280 | 1.077295 | 3.016426 | Filobasidium floriforme | 5210 | Fungi | Fungi | 431 | 2.84e-116 | NTclustered | gi|2185536090|ref|XM_046180650.1| | 5210 | g7355 | i0 | 94.643 | 1 | 280 | 12 | 100 | 1 | 1 | 280 | 572 | 296 | Filobasidium floriforme acyl-CoA dehydrogenase/oxidase (HD553DRAFT_316656), mRNA | blastn | 280 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 14748492 | 14748492 | PRJNA738523_P_NODE_5472_length_308_cov_1.965957_g5401_i0 | PRJNA738523 | 5472 | 308 | 1.965957 | 6.05514756 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 156 | 2.13e-33 | NTclustered | gi|1423576474|ref|XM_025742275.1| | 58919 | g5401 | i0 | 81.818 | 5.59090909090909 | 187 | 32 | 60 | 2 | 36 | 221 | 83 | 268 | Tilletiopsis washingtonensis putative 40S ribosomal protein S27 (FA09DRAFT_329678), mRNA | blastn | 1722 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 15226292 | 15226292 | PRJNA738523_P_NODE_6132_length_294_cov_3.067873_g6061_i0 | PRJNA738523 | 6132 | 294 | 3.067873 | 9.01954662 | Opisthokonta | 33154 | Fungi | Fungi | 544 | 3.69e-150 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g6061 | i0 | 100 | 97.1428571428571 | 294 | 0 | 100 | 0 | 1 | 294 | 389 | 682 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 28560 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18571292 | 18571292 | PRJNA738523_P_NODE_12115_length_248_cov_0.880000_g12044_i0 | PRJNA738523 | 12115 | 248 | 0.88 | 2.1824 | Malassezia restricta | 76775 | Fungi | Fungi | 448 | 2.4499999999999996e-121 | NTclustered | gi|1546636989|ref|XM_027630137.1| | 76775 | g12044 | i0 | 99.194 | 2.3991935483871 | 248 | 2 | 100 | 0 | 1 | 248 | 592 | 345 | Malassezia restricta betaine lipid synthase (MRET_3510), partial mRNA | blastn | 595 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24149331 | 24149331 | PRJNA738523_P_NODE_10999_length_250_cov_1.463277_g10928_i0 | PRJNA738523 | 10999 | 250 | 1.463277 | 3.6581925 | Agaricomycetes | 155619 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|1372287894|ref|XM_024477871.1| | 670580 | g10928 | i0 | 90.698 | 0.4 | 43 | 1 | 17 | 1 | 187 | 229 | 1586 | 1625 | Postia placenta MAD-698-R-SB12 hypothetical protein (POSPLADRAFT_1041245), mRNA | blastn | 100 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Adustoporiaceae | Rhodonia | Rhodonia placenta |
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);;