contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1123309" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 278273 | 278273 | PRJNA1123309_P_NODE_27501_length_309_cov_1.211864_g27121_i0 | PRJNA1123309 | 27501 | 309 | 1.211864 | 3.74465976 | Mucor mucedo | 29922 | Fungi | Fungi | 60.2 | 1.72e-4 | NTclustered | gi|2324056763|ref|XM_051597082.1| | 29922 | g27121 | i0 | 97.143 | 0.297734627831715 | 35 | 1 | 11 | 0 | 170 | 204 | 459 | 493 | Mucor mucedo uncharacterized protein (EV154DRAFT_445331), partial mRNA | blastn | 92 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 278369 | 278369 | PRJNA1123309_P_NODE_35501_length_282_cov_0.837321_g35121_i0 | PRJNA1123309 | 35501 | 282 | 0.837321 | 2.36124522 | Halteromyces radiatus | 101107 | Fungi | Fungi | 126 | 1.51e-24 | NTclustered | gi|2323710896|ref|XM_051543820.1| | 101107 | g35121 | i0 | 89.796 | 0.347517730496454 | 98 | 10 | 35 | 0 | 179 | 276 | 64 | 161 | Halteromyces radiatus WD repeat domain phosphoinositide-interacting protein 3 (BX664DRAFT_324320), mRNA | blastn | 98 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 7931227 | 7931227 | PRJNA1123309_P_NODE_32487_length_289_cov_1.282407_g32107_i0 | PRJNA1123309 | 32487 | 289 | 1.282407 | 3.70615623 | Lichtheimia ornata | 688661 | Fungi | Fungi | 119 | 2.6e-22 | NTclustered | gi|2553561755|ref|XM_058483351.1| | 688661 | g32107 | i0 | 81.633 | 19.0899653979239 | 147 | 23 | 50 | 4 | 8 | 152 | 214 | 358 | Lichtheimia ornata histone H2B (O0I10_003280), partial mRNA | blastn | 5517 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 11756725 | 11756725 | PRJNA1123309_P_NODE_28050_length_306_cov_1.596567_g27670_i0 | PRJNA1123309 | 28050 | 306 | 1.596567 | 4.88549502 | Halteromyces radiatus | 101107 | Fungi | Fungi | 189 | 2.08e-43 | NTclustered | gi|2323755492|ref|XM_051541004.1| | 101107 | g27670 | i0 | 82.432 | 6.05555555555556 | 222 | 33 | 72 | 5 | 74 | 292 | 394 | 612 | Halteromyces radiatus methylcrotonoyl-CoA carboxylase beta chain (BX664DRAFT_268602), partial mRNA | blastn | 1853 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 20679650 | 20679650 | PRJNA1123309_P_NODE_27437_length_309_cov_1.631356_g27057_i0 | PRJNA1123309 | 27437 | 309 | 1.631356 | 5.04089004 | Halteromyces radiatus | 101107 | Fungi | Fungi | 267 | 9.47e-67 | NTclustered | gi|2323709937|ref|XM_051548792.1| | 101107 | g27057 | i0 | 82.993 | 51.7022653721683 | 294 | 50 | 95 | 0 | 6 | 299 | 1087 | 1380 | Halteromyces radiatus V-type proton ATPase catalytic subunit A (BX664DRAFT_377787), mRNA | blastn | 15976 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus |
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);;