contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5976148 | 5976148 | PRJNA896758_P_NODE_21765_length_250_cov_0.870056_g21375_i0 | PRJNA896758 | 21765 | 250 | 0.870056 | 2.17514 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 81.3 | 1.17e-16 | NR | CUF08074.1 | 75058 | g21375 | i0 | 71.7 | 1.56 | 60 | 17 | 72 | 0 | 20 | 199 | 157 | 216 | CUF08074.1 60S ribosomal protein L13, putative [Bodo saltans] | diamond | 390 | 82 | 0.991463414634146 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 27150062 | 27150062 | PRJNA896758_P_NODE_16282_length_285_cov_1.452830_g15892_i0 | PRJNA896758 | 16282 | 285 | 1.45283 | 4.1405655 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 53.1 | 1.32e-5 | NR | CUG07593.1 | 75058 | g15892 | i0 | 43.3 | 0.705263157894737 | 67 | 35 | 68.4 | 2 | 62 | 256 | 403 | 468 | CUG07593.1 bacterial-type signalling protein, putative [Bodo saltans] | diamond | 201 | 53.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 27466667 | 27466667 | PRJNA896758_P_NODE_24103_length_246_cov_0.890173_g23713_i0 | PRJNA896758 | 24103 | 246 | 0.890173 | 2.18982558 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 116 | 1.22e-29 | NR | CUG46586.1 | 75058 | g23713 | i0 | 74.4 | 1 | 82 | 21 | 100 | 0 | 246 | 1 | 184 | 265 | CUG46586.1 Hypothetical protein, putative [Bodo saltans] | diamond | 246 | 116 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 27876942 | 27876942 | PRJNA896758_P_NODE_21445_length_251_cov_0.865169_g21055_i0 | PRJNA896758 | 21445 | 251 | 0.865169 | 2.17157419 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 75.9 | 8.7e-14 | NR | CUG91552.1 | 75058 | g21055 | i0 | 41.5 | 0.9800796812749 | 82 | 48 | 98 | 0 | 248 | 3 | 75 | 156 | CUG91552.1 ornithine decarboxylase, putative, partial [Bodo saltans] | diamond | 246 | 75.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 27940210 | 27940210 | PRJNA896758_P_NODE_20205_length_258_cov_1.329730_g19815_i0 | PRJNA896758 | 20205 | 258 | 1.32973 | 3.4307034 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 62.8 | 5.77e-10 | NR | QLA09595.1 | 3039 | g19815 | i0 | 64.1 | 0.453488372093023 | 39 | 14 | 45.3 | 0 | 258 | 142 | 115 | 153 | QLA09595.1 40S small subunit ribosomal protein eS31 [Euglena gracilis] | diamond | 117 | 62.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 28129659 | 28129659 | PRJNA896758_P_NODE_17045_length_280_cov_1.449275_g16655_i0 | PRJNA896758 | 17045 | 280 | 1.449275 | 4.05797 | Leishmania tarentolae | 5689 | Euglenozoa | other_Eukaryota | 95.5 | 1.68e-20 | NR | GET89518.1 | 5689 | g16655 | i0 | 49.5 | 3.9 | 91 | 45 | 96.4 | 1 | 1 | 270 | 580 | 670 | GET89518.1 enoyl-coA hydratase/enoyl-coA isomerase/3-hydroxyacyl-coA dehydrogenase, putative [Leishmania tarentolae] | diamond | 1092 | 95.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania tarentolae | ||
| 28760921 | 28760921 | PRJNA896758_P_NODE_18587_length_270_cov_1.172589_g18197_i0 | PRJNA896758 | 18587 | 270 | 1.172589 | 3.1659903 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 60.1 | 4.16e-8 | NR | KAJ9445139.1 | 91374 | g18197 | i0 | 40.2 | 1.02222222222222 | 92 | 41 | 100 | 3 | 1 | 270 | 586 | 665 | KAJ9445139.1 hypothetical protein DIPPA_19525 [Diplonema papillatum] | diamond | 276 | 60.1 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 29866149 | 29866149 | PRJNA896758_P_NODE_16151_length_286_cov_1.446009_g15761_i0 | PRJNA896758 | 16151 | 286 | 1.446009 | 4.13558574 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 63.9 | 1.96e-9 | NR | CUI15578.1 | 75058 | g15761 | i0 | 47 | 0.692307692307692 | 66 | 33 | 67.1 | 1 | 35 | 226 | 295 | 360 | CUI15578.1 transmembrane protein, putative [Bodo saltans] | diamond | 198 | 63.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30687501 | 30687501 | PRJNA896758_P_NODE_24293_length_245_cov_1.343023_g23903_i0 | PRJNA896758 | 24293 | 245 | 1.343023 | 3.29040635 | Cryptobia salmositica | 86678 | Euglenozoa | other_Eukaryota | 64.3 | 9.14e-10 | NR | AAM09951.1 | 86678 | g23903 | i0 | 43 | 1.93469387755102 | 79 | 42 | 96.7 | 2 | 8 | 244 | 334 | 409 | AAM09951.1 49 kDa cysteine proteinase Cysp1 [Cryptobia salmositica] | diamond | 474 | 64.3 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Cryptobia | Cryptobia salmositica | |||
| 31224613 | 31224613 | PRJNA896758_P_NODE_22095_length_250_cov_0.870056_g21705_i0 | PRJNA896758 | 22095 | 250 | 0.870056 | 2.17514 | Novymonas esmeraldas | 1808958 | Euglenozoa | other_Eukaryota | 68.6 | 3.12e-11 | NR | KAK7197674.1 | 1808958 | g21705 | i0 | 45.2 | 1.404 | 62 | 29 | 74.4 | 1 | 15 | 200 | 171 | 227 | KAK7197674.1 Ankyrin repeats protein [Novymonas esmeraldas] | diamond | 351 | 68.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Novymonas | Novymonas esmeraldas | ||
| 31319574 | 31319574 | PRJNA896758_P_NODE_12135_length_330_cov_1.599222_g11745_i0 | PRJNA896758 | 12135 | 330 | 1.599222 | 5.2774326 | Trypanosoma grayi | 71804 | Euglenozoa | other_Eukaryota | 47.8 | 0.00138 | NR | XP_009306856.1 | 71804 | g11745 | i0 | 35.4 | 1.79090909090909 | 99 | 52 | 82.7 | 3 | 56 | 328 | 23 | 117 | XP_009306856.1 hypothetical protein DQ04_00261100 [Trypanosoma grayi] | diamond | 591 | 47.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grayi | ||
| 31359103 | 31359103 | PRJNA896758_P_NODE_17036_length_280_cov_1.487923_g16646_i0 | PRJNA896758 | 17036 | 280 | 1.487923 | 4.1661844 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.4 | 0.00139 | NR | BAB12024.1 | 3039 | g16646 | i0 | 42.4 | 4.275 | 59 | 34 | 63.2 | 0 | 227 | 51 | 1712 | 1770 | BAB12024.1 pyruvate: NADP+ oxidoreductase [Euglena gracilis] | diamond | 1197 | 47.4 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 32907451 | 32907451 | PRJNA896758_P_NODE_7400_length_417_cov_0.895349_g7010_i0 | PRJNA896758 | 7400 | 417 | 0.895349 | 3.73360533 | root | 1 | Root_unresolved | Root_unresolved | 140 | 9.12e-36 | NR | KAJ9472637.1 | 91374 | g7010 | i0 | 55.7 | 12.8561151079137 | 122 | 53 | 87.1 | 1 | 415 | 53 | 247 | 368 | KAJ9472637.1 Group 1 truncated hemoglobin GlbN [Diplonema papillatum] | diamond | 5361 | 140 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum |
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);;