contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA998413" and tax_phylum = "Euglenozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27595380 | 27595380 | PRJNA998413_S_NODE_14984_length_177_cov_4.754386_g14953_i0 | PRJNA998413 | 14984 | 177 | 4.754386 | 8.41526322 | Trypanosoma brucei gambiense DAL972 | 679716 | Euglenozoa | other_Eukaryota | 59.3 | 1.42e-9 | NR | XP_011775218.1 | 679716 | g14953 | i0 | 75.7 | 0.627118644067797 | 37 | 9 | 62.7 | 0 | 177 | 67 | 56 | 92 | XP_011775218.1 hypothetical protein, unlikely [Trypanosoma brucei gambiense DAL972] | diamond | 111 | 59.3 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 28479359 | 28479359 | PRJNA998413_S_NODE_5066_length_273_cov_3.795238_g5035_i0 | PRJNA998413 | 5066 | 273 | 3.795238 | 10.36099974 | Trypanosoma conorhini | 83891 | Euglenozoa | other_Eukaryota | 150 | 1.49e-44 | NR | XP_029226594.1 | 83891 | g5035 | i0 | 75.6 | 1.97802197802198 | 90 | 22 | 98.9 | 0 | 3 | 272 | 46 | 135 | XP_029226594.1 60S ribosomal protein L35A [Trypanosoma conorhini] | diamond | 540 | 150 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 30974527 | 30974527 | PRJNA998413_S_NODE_7894_length_239_cov_3.045455_g7863_i0 | PRJNA998413 | 7894 | 239 | 3.045455 | 7.27863745 | Trypanosoma brucei gambiense DAL972 | 679716 | Euglenozoa | other_Eukaryota | 79 | 7.74e-17 | NR | XP_011772066.1 | 679716 | g7863 | i0 | 64.5 | 3.10041841004184 | 62 | 22 | 77.8 | 0 | 238 | 53 | 49 | 110 | XP_011772066.1 ribosomal protein S25, putative [Trypanosoma brucei gambiense DAL972] | diamond | 741 | 79 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei |
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);;