contig_metadata
6 rows where bioproject = "PRJNA827593", tax_clade = "Discoba" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8474665 | 8474665 | PRJNA827593_P_NODE_7947_length_792_cov_3.977747_g7670_i0 | PRJNA827593 | 7947 | 792 | 3.977747 | 31.50375624 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 54.7 | 0.022 | NTclustered | gi|1624757291|ref|XM_029029574.1| | 67003 | g7670 | i0 | 92.105 | 0.047979797979798 | 38 | 3 | 5 | 0 | 706 | 743 | 1146 | 1183 | Trypanosoma theileri glutaminyl cyclase (TM35_000381600), partial mRNA | blastn | 38 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 28539096 | 28539096 | PRJNA827593_P_NODE_66787_length_243_cov_0.905882_g66488_i0 | PRJNA827593 | 66787 | 243 | 0.905882 | 2.20129326 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 60.5 | 2.09e-8 | NR | CUG55385.1 | 75058 | g66488 | i0 | 41.6 | 0.950617283950617 | 77 | 40 | 88.9 | 2 | 241 | 26 | 617 | 693 | CUG55385.1 ion transporter, putative [Bodo saltans] | diamond | 231 | 60.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31159960 | 31159960 | PRJNA827593_P_NODE_39155_length_325_cov_1.126984_g38856_i0 | PRJNA827593 | 39155 | 325 | 1.126984 | 3.662698 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 77 | 8.82e-14 | NR | CUE71938.1 | 75058 | g38856 | i0 | 42.7 | 0.886153846153846 | 96 | 52 | 88.6 | 3 | 313 | 26 | 440 | 532 | CUE71938.1 cysteine peptidase, putative [Bodo saltans] | diamond | 288 | 77 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31476764 | 31476764 | PRJNA827593_P_NODE_46176_length_296_cov_1.986547_g45877_i0 | PRJNA827593 | 46176 | 296 | 1.986547 | 5.88017912 | Trypanosoma equiperdum | 5694 | Euglenozoa | other_Eukaryota | 48.1 | 8.97e-4 | NR | XP_067081428.1 | 5694 | g45877 | i0 | 37 | 0.932432432432432 | 92 | 54 | 91.2 | 2 | 5 | 274 | 554 | 643 | XP_067081428.1 translation elongation factor EF-2, putative [Trypanosoma equiperdum] | diamond | 276 | 48.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma equiperdum | ||
| 32552591 | 32552591 | PRJNA827593_P_NODE_61659_length_250_cov_1.610169_g61360_i0 | PRJNA827593 | 61659 | 250 | 1.610169 | 4.0254225 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 102 | 5.47e-23 | NR | KAJ9456071.1 | 91374 | g61360 | i0 | 71.2 | 2.124 | 59 | 17 | 70.8 | 0 | 54 | 230 | 394 | 452 | KAJ9456071.1 Beta-mannosidase A [Diplonema papillatum] | diamond | 531 | 102 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 32804109 | 32804109 | PRJNA827593_P_NODE_30460_length_375_cov_1.288079_g30161_i0 | PRJNA827593 | 30460 | 375 | 1.288079 | 4.83029625 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 90.1 | 4.26e-18 | NR | CUG92032.1 | 75058 | g30161 | i0 | 49.5 | 0.792 | 99 | 48 | 79.2 | 2 | 75 | 371 | 206 | 302 | CUG92032.1 Hypothetical protein, putative [Bodo saltans] | diamond | 297 | 90.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans |
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);;