contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA854078" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2117154 | 2117154 | PRJNA854078_P_NODE_9722_length_301_cov_33.438596_g9510_i0 | PRJNA854078 | 9722 | 301 | 33.438596 | 100.65017396 | Komagataella phaffii | 460519 | Fungi | Fungi | 329 | 1.1599999999999998e-85 | NTclustered | gi|254574191|ref|XM_002494160.1| | 644223 | g9510 | i0 | 86.379 | 209.358803986711 | 301 | 41 | 100 | 0 | 1 | 301 | 452 | 152 | Komagataella phaffii GS115 Ubiquitin (PAS_chr4_0762), partial mRNA | blastn | 63017 | 329 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella phaffii | |
| 8494571 | 8494571 | PRJNA854078_P_NODE_1527_length_773_cov_15.188571_g1338_i0 | PRJNA854078 | 1527 | 773 | 15.188571 | 117.40765383 | Fonsecaea nubica | 856822 | Fungi | Fungi | 56.5 | 0.006 | NTclustered | gi|1248737062|ref|XM_022639141.1| | 856822 | g1338 | i0 | 84.127 | 0.15653298835705 | 63 | 4 | 8 | 5 | 540 | 602 | 22 | 78 | Fonsecaea nubica rRNA 2'-O-methyltransferase fibrillarin (AYO20_00833), partial mRNA | blastn | 121 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Fonsecaea | Fonsecaea nubica | |
| 11438529 | 11438529 | PRJNA854078_P_NODE_11789_length_274_cov_2.243781_g11577_i0 | PRJNA854078 | 11789 | 274 | 2.243781 | 6.14795994 | Opisthokonta | 33154 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2530258994|gb|CP115805.1| | 5476 | g11577 | i0 | 100 | 2.42335766423358 | 30 | 0 | 11 | 0 | 59 | 88 | 1357582 | 1357553 | Candida albicans strain Fungi-01 chromosome 8 | blastn | 664 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida albicans | |
| 12320901 | 12320901 | PRJNA854078_P_NODE_14370_length_250_cov_0.870056_g14158_i0 | PRJNA854078 | 14370 | 250 | 0.870056 | 2.17514 | Cyphellophora europaea | 293227 | Fungi | Fungi | 150 | 7.799999999999999e-32 | NTclustered | gi|671155708|ref|XM_008718239.1| | 1220924 | g14158 | i0 | 78.205 | 1.364 | 234 | 51 | 94 | 0 | 15 | 248 | 942 | 709 | Cyphellophora europaea CBS 101466 uncharacterized protein (HMPREF1541_03891), partial mRNA | blastn | 341 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Cyphellophoraceae | Cyphellophora | Cyphellophora europaea | |
| 18692977 | 18692977 | PRJNA854078_P_NODE_14135_length_251_cov_0.865169_g13923_i0 | PRJNA854078 | 14135 | 251 | 0.865169 | 2.17157419 | Limtongia smithiae | 1125753 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2781505516|ref|XM_066901373.1| | 1125753 | g13923 | i0 | 96.875 | 0.127490039840637 | 32 | 1 | 13 | 0 | 66 | 97 | 634 | 603 | Limtongia smithiae Cupredoxin (V1518DRAFT_371911), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Limtongia | Limtongia smithiae |
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);;