contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJDB14274" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8584 | 8584 | PRJDB14274_S_NODE_7701_length_229_cov_0.922619_g7623_i0 | PRJDB14274 | 7701 | 229 | 0.922619 | 2.11279751 | Laccaria bicolor | 29883 | Fungi | Fungi | 60.2 | 1.22e-4 | NTclustered | gi|170106298|ref|XM_001884326.1| | 486041 | g7623 | i0 | 97.143 | 0.152838427947598 | 35 | 1 | 15 | 0 | 131 | 165 | 625 | 591 | Laccaria bicolor S238N-H82 uncharacterized protein (LACBIDRAFT_303903), partial mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hydnangiaceae | Laccaria | Laccaria bicolor | |
| 5110980 | 5110980 | PRJDB14274_S_NODE_5725_length_262_cov_1.253731_g5647_i0 | PRJDB14274 | 5725 | 262 | 1.253731 | 3.28477522 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|630966689|ref|XM_007881562.1| | 1277687 | g5647 | i0 | 100 | 0.110687022900763 | 29 | 0 | 11 | 0 | 93 | 121 | 132 | 104 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_04038), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 11486468 | 11486468 | PRJDB14274_S_NODE_6090_length_254_cov_2.062176_g6012_i0 | PRJDB14274 | 6090 | 254 | 2.062176 | 5.23792704 | Trichosporon asahii | 82508 | Fungi | Fungi | 58.4 | 4.96e-4 | NTclustered | gi|930416156|ref|XM_014326876.1| | 1186058 | g6012 | i0 | 97.143 | 0.267716535433071 | 35 | 0 | 14 | 1 | 203 | 237 | 912 | 945 | Trichosporon asahii var. asahii CBS 2479 uncharacterized protein (A1Q1_07892), partial mRNA | blastn | 68 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 16585374 | 16585374 | PRJDB14274_S_NODE_414_length_928_cov_5.076125_g370_i0 | PRJDB14274 | 414 | 928 | 5.076125 | 47.10644 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 388 | 6.289999999999998e-103 | NTclustered | gi|1423587035|ref|XM_025743209.1| | 58919 | g370 | i0 | 79.815 | 18.1713362068966 | 540 | 103 | 58 | 6 | 296 | 832 | 591 | 55 | Tilletiopsis washingtonensis putative GSP1-GTP-binding protein of the ras superfamily (FA09DRAFT_331860), mRNA | blastn | 16863 | 388 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 16585390 | 16585390 | PRJDB14274_S_NODE_8914_length_212_cov_1.841060_g8836_i0 | PRJDB14274 | 8914 | 212 | 1.84106 | 3.9030472 | Rhodotorula graminis | 29898 | Fungi | Fungi | 204 | 4.86e-48 | NTclustered | gi|1069930902|ref|XM_018412876.1| | 578459 | g8836 | i0 | 87.931 | 80.5094339622642 | 174 | 19 | 82 | 2 | 40 | 212 | 1826 | 1654 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_29596), mRNA | blastn | 17068 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 20409190 | 20409190 | PRJDB14274_S_NODE_9657_length_206_cov_1.655172_g9579_i0 | PRJDB14274 | 9657 | 206 | 1.655172 | 3.40965432 | Lentinus tigrinus | 5365 | Fungi | Fungi | 143 | 1.04e-29 | NTclustered | gi|2797387783|ref|XM_067683197.1| | 1328758 | g9579 | i0 | 81.183 | 2.88834951456311 | 186 | 27 | 88 | 8 | 3 | 184 | 2721 | 2902 | Lentinus tigrinus ALCF2SS1-7 26S proteasome regulatory complex, non-ATPase subcomplex, Rpn1 subunit (L226DRAFT_557747), mRNA | blastn | 595 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus |
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);;