contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJEB14175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26319865 | 26319865 | PRJEB14175_P_NODE_157071_length_268_cov_4.589372_g154804_i0 | PRJEB14175 | 157071 | 268 | 4.589372 | 12.29951696 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 112 | 3.57e-30 | NR | CUG21192.1 | 75058 | g154804 | i0 | 77.3 | 1.67910447761194 | 75 | 15 | 81.7 | 1 | 18 | 236 | 5 | 79 | CUG21192.1 40S ribosomal protein S9, putative, partial [Bodo saltans] | diamond | 450 | 112 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 32939663 | 32939663 | PRJEB14175_P_NODE_211761_length_219_cov_3.613924_g209494_i0 | PRJEB14175 | 211761 | 219 | 3.613924 | 7.91449356 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 42.7 | 0.0221 | NR | EPY37429.1 | 59799 | g209494 | i0 | 62.5 | 1.04109589041096 | 24 | 9 | 32.9 | 0 | 25 | 96 | 176 | 199 | EPY37429.1 chaperone protein DNAJ [Angomonas deanei] | diamond | 228 | 42.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Angomonas | Angomonas deanei | ||
| 32943276 | 32943276 | PRJEB14175_P_NODE_193362_length_233_cov_5.127907_g191095_i0 | PRJEB14175 | 193362 | 233 | 5.127907 | 11.94802331 | Leishmania tarentolae | 5689 | Euglenozoa | other_Eukaryota | 42.4 | 0.0431 | NR | GET92556.1 | 5689 | g191095 | i0 | 52.2 | 0.592274678111588 | 46 | 22 | 59.2 | 0 | 155 | 18 | 297 | 342 | GET92556.1 40S ribosomal protein S3a, putative [Leishmania tarentolae] | diamond | 138 | 42.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania tarentolae | ||
| 32956817 | 32956817 | PRJEB14175_P_NODE_169962_length_254_cov_8.595855_g167695_i0 | PRJEB14175 | 169962 | 254 | 8.595855 | 21.8334717 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 4.96e-6 | NR | QLA09574.1 | 3039 | g167695 | i0 | 89.3 | 7.02755905511811 | 28 | 3 | 33.1 | 0 | 241 | 158 | 126 | 153 | QLA09574.1 40S small subunit ribosomal protein uS13 [Euglena gracilis] | diamond | 1785 | 52.4 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 32960572 | 32960572 | PRJEB14175_P_NODE_199954_length_228_cov_2.491018_g197687_i0 | PRJEB14175 | 199954 | 228 | 2.491018 | 5.67952104 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 68.6 | 7.93e-13 | NR | CUG89185.1 | 75058 | g197687 | i0 | 77.8 | 0.592105263157895 | 45 | 10 | 59.2 | 0 | 9 | 143 | 54 | 98 | CUG89185.1 60S ribosomal protein L36, putative [Bodo saltans] | diamond | 135 | 68.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 32974039 | 32974039 | PRJEB14175_P_NODE_223394_length_211_cov_2.493333_g221126_i0 | PRJEB14175 | 223394 | 211 | 2.493333 | 5.26093263 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 3.54e-5 | NR | KAJ9439272.1 | 91374 | g221126 | i0 | 66.7 | 1.30805687203791 | 36 | 12 | 51.2 | 0 | 10 | 117 | 83 | 118 | KAJ9439272.1 Small nuclear ribonucleoprotein Sm D2 [Diplonema papillatum] | diamond | 276 | 48.9 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 33028000 | 33028000 | PRJEB14175_P_NODE_119740_length_320_cov_2.548263_g117474_i0 | PRJEB14175 | 119740 | 320 | 2.548263 | 8.1544416 | Phytomonas sp. EM1 | 479712 | Euglenozoa | other_Eukaryota | 61.2 | 2.74e-8 | NR | CCW63416.1 | 479712 | g117474 | i0 | 39.3 | 1.640625 | 84 | 48 | 75.9 | 2 | 284 | 42 | 230 | 313 | CCW63416.1 unnamed protein product [Phytomonas sp. EM1] | diamond | 525 | 61.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Phytomonas | Phytomonas sp. EM1 | ||
| 33046343 | 33046343 | PRJEB14175_P_NODE_265437_length_195_cov_5.335821_g263169_i0 | PRJEB14175 | 265437 | 195 | 5.335821 | 10.40485095 | Porcisia hertigi | 2761500 | Euglenozoa | other_Eukaryota | 43.9 | 0.00428 | NR | XP_067759350.1 | 2761500 | g263169 | i0 | 48.6 | 1.4 | 37 | 19 | 56.9 | 0 | 189 | 79 | 104 | 140 | XP_067759350.1 hypothetical protein JKF63_06379 [Porcisia hertigi] | diamond | 273 | 43.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Porcisia | Porcisia hertigi | ||
| 33063059 | 33063059 | PRJEB14175_P_NODE_232245_length_208_cov_0.870748_g229977_i0 | PRJEB14175 | 232245 | 208 | 0.870748 | 1.81115584 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 60.5 | 8.42e-9 | NR | CUG91281.1 | 75058 | g229977 | i0 | 52.5 | 0.850961538461538 | 59 | 28 | 85.1 | 0 | 26 | 202 | 192 | 250 | CUG91281.1 stress-inducible protein STI1, putative [Bodo saltans] | diamond | 177 | 60.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 33076134 | 33076134 | PRJEB14175_P_NODE_183093_length_242_cov_1.530387_g180826_i0 | PRJEB14175 | 183093 | 242 | 1.530387 | 3.70353654 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 78.6 | 2.64e-17 | NR | XP_804510.1 | 5693 | g180826 | i0 | 72.3 | 5.82644628099174 | 47 | 13 | 58.3 | 0 | 12 | 152 | 11 | 57 | XP_804510.1 ribosomal protein S29, putative [Trypanosoma cruzi] | diamond | 1410 | 79.3 | 0.991172761664565 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 33096754 | 33096754 | PRJEB14175_P_NODE_178886_length_246_cov_1.372973_g176619_i0 | PRJEB14175 | 178886 | 246 | 1.372973 | 3.37751358 | Strigomonas culicis | 28005 | Euglenozoa | other_Eukaryota | 80.1 | 9.21e-17 | NR | EPY23444.1 | 28005 | g176619 | i0 | 64.2 | 1.63414634146341 | 67 | 24 | 81.7 | 0 | 24 | 224 | 93 | 159 | EPY23444.1 large subunit ribosomal protein L21e [Strigomonas culicis] | diamond | 402 | 80.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Strigomonas | Strigomonas culicis | ||
| 33132248 | 33132248 | PRJEB14175_P_NODE_85823_length_392_cov_2.824773_g83558_i0 | PRJEB14175 | 85823 | 392 | 2.824773 | 11.07311016 | Trypanosoma grayi | 71804 | Euglenozoa | other_Eukaryota | 72.4 | 7.45e-12 | NR | XP_009313326.1 | 71804 | g83558 | i0 | 36.9 | 0.849489795918367 | 111 | 58 | 84.2 | 2 | 369 | 40 | 344 | 443 | XP_009313326.1 pyruvate dehydrogenase (lipoamide) kinase [Trypanosoma grayi] | diamond | 333 | 72.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grayi | ||
| 33147685 | 33147685 | PRJEB14175_P_NODE_153736_length_272_cov_4.028436_g151469_i0 | PRJEB14175 | 153736 | 272 | 4.028436 | 10.95734592 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 82 | 1.35e-17 | NR | QLA09589.1 | 3039 | g151469 | i0 | 66.7 | 1.96323529411765 | 60 | 20 | 66.2 | 0 | 41 | 220 | 69 | 128 | QLA09589.1 40S small subunit ribosomal protein eS24 [Euglena gracilis] | diamond | 534 | 82 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 33161239 | 33161239 | PRJEB14175_P_NODE_129776_length_304_cov_4.028807_g127509_i0 | PRJEB14175 | 129776 | 304 | 4.028807 | 12.24757328 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 65.9 | 1.82e-10 | NR | KPI82408.1 | 5684 | g127509 | i0 | 46.8 | 2.80263157894737 | 94 | 34 | 77 | 2 | 25 | 258 | 124 | 217 | KPI82408.1 putative 60S ribosomal protein L13 [Leptomonas seymouri] | diamond | 852 | 65.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas seymouri | ||
| 33166107 | 33166107 | PRJEB14175_P_NODE_69872_length_441_cov_5.123684_g67614_i0 | PRJEB14175 | 69872 | 441 | 5.123684 | 22.59544644 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 58.9 | 4.32e-8 | NR | XP_015655658.1 | 157538 | g67614 | i0 | 44.4 | 0.551020408163265 | 81 | 44 | 55.1 | 1 | 151 | 393 | 25 | 104 | XP_015655658.1 hypothetical protein ABB37_07126 [Leptomonas pyrrhocoris] | diamond | 243 | 58.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris |
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);;