contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA724039" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4539628 | 4539628 | PRJNA724039_S_NODE_6644_length_264_cov_2.977974_g6437_i0 | PRJNA724039 | 6644 | 264 | 2.977974 | 7.86185136 | Dioszegia hungarica | 4972 | Fungi | Fungi | 72 | 6.49e-14 | NR | XP_052945900.1 | 4972 | g6437 | i0 | 78 | 2.79545454545455 | 41 | 9 | 46.6 | 0 | 263 | 141 | 71 | 111 | XP_052945900.1 60S ribosomal protein L36 [Dioszegia hungarica] | diamond | 738 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 13464893 | 13464893 | PRJNA724039_S_NODE_15691_length_161_cov_1.629032_g15484_i0 | PRJNA724039 | 15691 | 161 | 1.629032 | 2.62274152 | Wolfiporia cocos MD-1 | 81056 | Fungi | Fungi | 80.5 | 8.15e-18 | NR | PCH33518.1 | 742152 | g15484 | i0 | 75.5 | 1.99378881987578 | 53 | 13 | 98.8 | 0 | 159 | 1 | 28 | 80 | PCH33518.1 ribosomal protein L22e [Wolfiporia cocos MD-104 SS10] | diamond | 321 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phaeolaceae | Wolfiporia | Wolfiporia cocos | |
| 28578556 | 28578556 | PRJNA724039_S_NODE_16467_length_157_cov_1.691667_g16260_i0 | PRJNA724039 | 16467 | 157 | 1.691667 | 2.65591719 | Agaricales | 5338 | Fungi | Fungi | 57.4 | 6.2e-9 | NR | KAL0949195.1 | 104357 | g16260 | i0 | 52.2 | 12.6114649681529 | 46 | 22 | 87.9 | 0 | 156 | 19 | 57 | 102 | KAL0949195.1 hypothetical protein HGRIS_009273 [Hohenbuehelia grisea] | diamond | 1980 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Hohenbuehelia | Hohenbuehelia grisea | |
| 29367914 | 29367914 | PRJNA724039_S_NODE_7809_length_238_cov_2.019900_g7602_i0 | PRJNA724039 | 7809 | 238 | 2.0199 | 4.807362 | Basidiomycota | 5204 | Fungi | Fungi | 73.2 | 6.6e-13 | NR | QCI56435.1 | 39966 | g7602 | i0 | 66 | 3.15126050420168 | 50 | 17 | 63 | 0 | 1 | 150 | 428 | 477 | QCI56435.1 cytochrome c oxidase subunit 1 [Hypsizygus marmoreus] | diamond | 750 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Hypsizygus | Hypsizygus marmoreus | |
| 29578257 | 29578257 | PRJNA724039_S_NODE_14470_length_168_cov_1.106870_g14263_i0 | PRJNA724039 | 14470 | 168 | 1.10687 | 1.8595416 | Malassezia caprae | 1381934 | Fungi | Fungi | 75.5 | 3.79e-14 | NR | WFD19044.1 | 1381934 | g14263 | i0 | 55.6 | 5.78571428571429 | 54 | 24 | 96.4 | 0 | 2 | 163 | 1056 | 1109 | WFD19044.1 protein kinase C [Malassezia caprae] | diamond | 972 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia caprae | |
| 31727220 | 31727220 | PRJNA724039_S_NODE_13097_length_177_cov_1.464286_g12890_i0 | PRJNA724039 | 13097 | 177 | 1.464286 | 2.59178622 | Rhodotorula diobovata | 5288 | Fungi | Fungi | 68.6 | 7.2e-12 | NR | TNY21956.1 | 5288 | g12890 | i0 | 67.9 | 7.79661016949153 | 56 | 18 | 94.9 | 0 | 4 | 171 | 229 | 284 | TNY21956.1 ribosomal protein L10-domain-containing protein, partial [Rhodotorula diobovata] | diamond | 1380 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata |
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);;