contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA401346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24032833 | 24032833 | PRJNA401346_P_NODE_2059_length_346_cov_0.838596_g2038_i0 | PRJNA401346 | 2059 | 346 | 0.838596 | 2.90154216 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 193 | 6.68e-61 | NR | EPY38564.1 | 59799 | g2038 | i0 | 80.9 | 3.98843930635838 | 115 | 22 | 99.7 | 0 | 346 | 2 | 31 | 145 | EPY38564.1 large subunit ribosomal protein L15e, partial [Angomonas deanei] | diamond | 1380 | 193 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Angomonas | Angomonas deanei | ||
| 27597837 | 27597837 | PRJNA401346_P_NODE_6424_length_209_cov_0.864865_g6403_i0 | PRJNA401346 | 6424 | 209 | 0.864865 | 1.80756785 | Trypanosomatida | 2704949 | Euglenozoa | other_Eukaryota | 83.2 | 5.76e-17 | NR | XP_009314379.1 | 71804 | g6403 | i0 | 58 | 1.95215311004785 | 69 | 29 | 99 | 0 | 209 | 3 | 9 | 77 | XP_009314379.1 60S acidic ribosomal subunit protein [Trypanosoma grayi] | diamond | 408 | 83.6 | 0.995215311004785 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grayi | ||
| 28117570 | 28117570 | PRJNA401346_P_NODE_7985_length_204_cov_0.888112_g7964_i0 | PRJNA401346 | 7985 | 204 | 0.888112 | 1.81174848 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 63.9 | 7.67e-10 | NR | CUG89826.1 | 75058 | g7964 | i0 | 61.8 | 0.808823529411765 | 55 | 21 | 80.9 | 0 | 4 | 168 | 564 | 618 | CUG89826.1 Hypothetical protein, putative [Bodo saltans] | diamond | 165 | 63.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30486213 | 30486213 | PRJNA401346_P_NODE_6413_length_209_cov_0.864865_g6392_i0 | PRJNA401346 | 6413 | 209 | 0.864865 | 1.80756785 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 108 | 1.19e-25 | NR | CUG87383.1 | 75058 | g6392 | i0 | 68.7 | 0.961722488038278 | 67 | 21 | 96.2 | 0 | 3 | 203 | 3758 | 3824 | CUG87383.1 dynein heavy chain, putative [Bodo saltans] | diamond | 201 | 108 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 32193577 | 32193577 | PRJNA401346_P_NODE_2678_length_310_cov_1.028112_g2657_i0 | PRJNA401346 | 2678 | 310 | 1.028112 | 3.1871472 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 138 | 2.25e-37 | NR | CUG82058.1 | 75058 | g2657 | i0 | 67 | 2.54516129032258 | 91 | 30 | 88.1 | 0 | 4 | 276 | 232 | 322 | CUG82058.1 40S ribosomal protein S27, putative [Bodo saltans] | diamond | 789 | 138 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 32225238 | 32225238 | PRJNA401346_P_NODE_4918_length_240_cov_1.089385_g4897_i0 | PRJNA401346 | 4918 | 240 | 1.089385 | 2.614524 | Trypanosoma grayi | 71804 | Euglenozoa | other_Eukaryota | 95.9 | 1.59e-22 | NR | XP_009309631.1 | 71804 | g4897 | i0 | 70.3 | 2.4 | 64 | 19 | 80 | 0 | 49 | 240 | 3 | 66 | XP_009309631.1 hypothetical protein DQ04_01971000 [Trypanosoma grayi] | diamond | 576 | 95.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grayi | ||
| 32431809 | 32431809 | PRJNA401346_P_NODE_8479_length_202_cov_0.907801_g8458_i0 | PRJNA401346 | 8479 | 202 | 0.907801 | 1.83375802 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 119 | 5.959999999999999e-31 | NR | EKG02897.1 | 5693 | g8458 | i0 | 79.1 | 1.99009900990099 | 67 | 14 | 99.5 | 0 | 2 | 202 | 168 | 234 | EKG02897.1 ADP,ATP carrier protein 1, mitochondrial precursor, putative,ADP/ATP translocase 1, putative [Trypanosoma cruzi] | diamond | 402 | 120 | 0.991666666666667 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi |
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);;