contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA889065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26675348 | 26675348 | PRJNA889065_S_NODE_26361_length_189_cov_1.575342_g26123_i0 | PRJNA889065 | 26361 | 189 | 1.575342 | 2.97739638 | Leishmania braziliensis MHOM/BR/75/M29 | 5660 | Euglenozoa | other_Eukaryota | 52.8 | 5.05e-6 | NR | XP_001563953.1 | 420245 | g26123 | i0 | 45.3 | 0.841269841269841 | 53 | 27 | 84.1 | 1 | 11 | 169 | 288 | 338 | XP_001563953.1 putative glycogen synthase kinase [Leishmania braziliensis MHOM/BR/75/M2904] | diamond | 159 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 27687716 | 27687716 | PRJNA889065_S_NODE_13884_length_260_cov_1.221198_g13646_i0 | PRJNA889065 | 13884 | 260 | 1.221198 | 3.1751148 | Trypanosoma vivax | 5699 | Euglenozoa | other_Eukaryota | 133 | 5.32e-34 | NR | KAG8346959.1 | 5699 | g13646 | i0 | 73.3 | 15.8769230769231 | 86 | 23 | 99.2 | 0 | 259 | 2 | 496 | 581 | KAG8346959.1 hypothetical protein TRVL_02215 [Trypanosoma vivax] | diamond | 4128 | 133 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 30474249 | 30474249 | PRJNA889065_S_NODE_13413_length_263_cov_3.759091_g13175_i0 | PRJNA889065 | 13413 | 263 | 3.759091 | 9.88640933 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 115 | 2.4199999999999997e-30 | NR | EPY34433.1 | 59799 | g13175 | i0 | 56.3 | 2.97718631178707 | 87 | 38 | 99.2 | 0 | 261 | 1 | 87 | 173 | EPY34433.1 large subunit ribosomal protein L23e [Angomonas deanei] | diamond | 783 | 115 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Angomonas | Angomonas deanei | ||
| 31920447 | 31920447 | PRJNA889065_S_NODE_4197_length_450_cov_11.884521_g3963_i0 | PRJNA889065 | 4197 | 450 | 11.884521 | 53.4803445 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 112 | 1.44e-25 | NR | KAJ9461372.1 | 91374 | g3963 | i0 | 40.3 | 0.826666666666667 | 124 | 74 | 82.7 | 0 | 6 | 377 | 506 | 629 | KAJ9461372.1 Proline dehydrogenase 1 [Diplonema papillatum] | diamond | 372 | 112 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 32371439 | 32371439 | PRJNA889065_S_NODE_18399_length_227_cov_1.190217_g18161_i0 | PRJNA889065 | 18399 | 227 | 1.190217 | 2.70179259 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 68.2 | 2.73e-11 | NR | CUE87609.1 | 75058 | g18161 | i0 | 69 | 2.77533039647577 | 42 | 13 | 55.5 | 0 | 219 | 94 | 307 | 348 | CUE87609.1 vacuolar ATP synthase subunit-like, putative [Bodo saltans] | diamond | 630 | 68.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 32592739 | 32592739 | PRJNA889065_S_NODE_559_length_934_cov_8.285073_g472_i0 | PRJNA889065 | 559 | 934 | 8.285073 | 77.38258182 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 70.1 | 2.59e-10 | NR | XP_029233789.1 | 5698 | g472 | i0 | 31.7 | 0.941113490364026 | 145 | 84 | 45.9 | 5 | 2 | 430 | 52 | 183 | XP_029233789.1 terbinafine resistance locus protein (yip1) [Trypanosoma rangeli] | diamond | 879 | 70.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma rangeli | ||
| 32710655 | 32710655 | PRJNA889065_S_NODE_14340_length_256_cov_1.727700_g14102_i0 | PRJNA889065 | 14340 | 256 | 1.7277 | 4.422912 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 78.2 | 1.49e-14 | NR | CUG89314.1 | 75058 | g14102 | i0 | 58.1 | 1.4296875 | 62 | 25 | 71.5 | 1 | 255 | 73 | 738 | 799 | CUG89314.1 Hypothetical protein, putative [Bodo saltans] | diamond | 366 | 78.2 | 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);;