contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJEB25789" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15325393 | 15325393 | PRJEB25789_S_NODE_20353_length_235_cov_2.851852_g20274_i0 | PRJEB25789 | 20353 | 235 | 2.851852 | 6.7018522 | Cystobasidium minutum | 29899 | Fungi | Fungi | 198 | 2.56e-46 | NTclustered | gi|2781610320|ref|XM_066965710.1| | 1397322 | g20274 | i0 | 86.264 | 24.8765957446809 | 182 | 25 | 77 | 0 | 1 | 182 | 1092 | 911 | Cystobasidium minutum MCA 4210 putative ATP2-F1F0-ATPase complex, F1 beta subunit (P389DRAFT_172179), mRNA | blastn | 5846 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 19148535 | 19148535 | PRJEB25789_S_NODE_12056_length_284_cov_2.137441_g11977_i0 | PRJEB25789 | 12056 | 284 | 2.137441 | 6.07033244 | Kwoniella dendrophila | 4975 | Fungi | Fungi | 211 | 4.09e-50 | NTclustered | gi|2752982483|ref|XM_066217289.1| | 1295534 | g11977 | i0 | 82.4 | 12.0246478873239 | 250 | 37 | 87 | 7 | 3 | 249 | 323 | 78 | Kwoniella dendrophila CBS 6074 60S ribosomal protein L44 (L201_001500), partial mRNA | blastn | 3415 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dendrophila | |
| 24248919 | 24248919 | PRJEB25789_S_NODE_13380_length_273_cov_1.540000_g13301_i0 | PRJEB25789 | 13380 | 273 | 1.54 | 4.2042 | Kwoniella dendrophila | 4975 | Fungi | Fungi | 176 | 1.43e-39 | NTclustered | gi|2752998205|ref|XM_066219914.1| | 1295534 | g13301 | i0 | 81.034 | 99.1904761904762 | 232 | 35 | 84 | 7 | 45 | 273 | 229 | 4 | Kwoniella dendrophila CBS 6074 ubiquitin-60S ribosomal protein L40 (L201_004168), partial mRNA | blastn | 27079 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dendrophila | |
| 24249127 | 24249127 | PRJEB25789_S_NODE_6380_length_362_cov_2.228374_g6301_i0 | PRJEB25789 | 6380 | 362 | 2.228374 | 8.06671388 | Malassezia restricta | 76775 | Fungi | Fungi | 669 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g6301 | i0 | 100 | 106.649171270718 | 362 | 0 | 100 | 0 | 1 | 362 | 1502 | 1863 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 38607 | 669 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;