contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3282388 | 3282388 | PRJNA753704_P_NODE_23843_length_252_cov_0.871508_g23482_i0 | PRJNA753704 | 23843 | 252 | 0.871508 | 2.19620016 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 94.4 | 3e-20 | NR | CUG85679.1 | 75058 | g23482 | i0 | 80.4 | 1.35714285714286 | 51 | 10 | 60.7 | 0 | 4 | 156 | 902 | 952 | CUG85679.1 unnamed protein product [Bodo saltans] | diamond | 342 | 94.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 4559392 | 4559392 | PRJNA753704_P_NODE_12604_length_335_cov_1.076336_g12243_i0 | PRJNA753704 | 12604 | 335 | 1.076336 | 3.6057256 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 194 | 9.96e-57 | NR | CUG30453.1 | 75058 | g12243 | i0 | 91.9 | 1.98805970149254 | 111 | 9 | 99.4 | 0 | 2 | 334 | 220 | 330 | CUG30453.1 69 kDa paraflagellar rod protein 2C, putative [Bodo saltans] | diamond | 666 | 194 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 9659609 | 9659609 | PRJNA753704_P_NODE_27088_length_245_cov_0.906977_g26727_i0 | PRJNA753704 | 27088 | 245 | 0.906977 | 2.22209365 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 68.9 | 4.11e-12 | NR | XP_814742.1 | 5693 | g26727 | i0 | 60 | 3.79591836734694 | 65 | 25 | 79.6 | 1 | 243 | 49 | 132 | 195 | XP_814742.1 40S ribosomal protein S17, putative [Trypanosoma cruzi] | diamond | 930 | 68.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 10935067 | 10935067 | PRJNA753704_P_NODE_21109_length_265_cov_2.083333_g20748_i0 | PRJNA753704 | 21109 | 265 | 2.083333 | 5.52083245 | Euglenozoa | 33682 | Euglenozoa | other_Eukaryota | 136 | 1.47e-36 | NR | AAC99646.1 | 3039 | g20748 | i0 | 81.8 | 2.75094339622642 | 77 | 14 | 87.2 | 0 | 232 | 2 | 6 | 82 | AAC99646.1 actin [Euglena gracilis] | diamond | 729 | 137 | 0.992700729927007 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 13484922 | 13484922 | PRJNA753704_P_NODE_28511_length_242_cov_0.923077_g28150_i0 | PRJNA753704 | 28511 | 242 | 0.923077 | 2.23384634 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 63.2 | 6.02e-11 | NR | QLA09638.1 | 3039 | g28150 | i0 | 52.7 | 0.91735537190082606 | 74 | 35 | 91.7 | 0 | 240 | 19 | 7 | 80 | QLA09638.1 60S large subunit ribosomal protein eL38 [Euglena gracilis] | diamond | 222 | 63.2 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 17309148 | 17309148 | PRJNA753704_P_NODE_19614_length_274_cov_1.960199_g19253_i0 | PRJNA753704 | 19614 | 274 | 1.960199 | 5.37094526 | Trypanosoma conorhini | 83891 | Euglenozoa | other_Eukaryota | 94 | 3.25e-22 | NR | XP_029225757.1 | 83891 | g19253 | i0 | 64.8 | 2.33211678832117 | 71 | 25 | 77.7 | 0 | 27 | 239 | 73 | 143 | XP_029225757.1 60S ribosomal protein L29 [Trypanosoma conorhini] | diamond | 639 | 94 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 24957691 | 24957691 | PRJNA753704_P_NODE_31440_length_198_cov_5.240000_g31079_i0 | PRJNA753704 | 31440 | 198 | 5.24 | 10.3752 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 106 | 1.58e-26 | NR | CUG92052.1 | 75058 | g31079 | i0 | 73.8 | 5.90909090909091 | 65 | 17 | 98.5 | 0 | 197 | 3 | 57 | 121 | CUG92052.1 40S ribosomal protein SA, putative [Bodo saltans] | diamond | 1170 | 106 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 26863400 | 26863400 | PRJNA753704_P_NODE_13981_length_319_cov_2.508130_g13620_i0 | PRJNA753704 | 13981 | 319 | 2.50813 | 8.0009347 | Trypanosoma congolense IL3 | 5692 | Euglenozoa | other_Eukaryota | 89.4 | 4.03e-19 | NR | CCC92437.1 | 1068625 | g13620 | i0 | 45.8 | 1.00626959247649 | 107 | 48 | 99.7 | 3 | 319 | 2 | 74 | 171 | CCC92437.1 putative IgE-dependent histamine-releasing factor [Trypanosoma congolense IL3000] | diamond | 321 | 89.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma congolense | ||
| 27125560 | 27125560 | PRJNA753704_P_NODE_24862_length_250_cov_0.881356_g24501_i0 | PRJNA753704 | 24862 | 250 | 0.881356 | 2.20339 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.6 | 6.58e-16 | NR | KAJ9453354.1 | 91374 | g24501 | i0 | 44.6 | 4.896 | 83 | 46 | 99.6 | 0 | 249 | 1 | 50 | 132 | KAJ9453354.1 Penta-EF hand domain-containing protein 1 [Diplonema papillatum] | diamond | 1224 | 78.6 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 28221327 | 28221327 | PRJNA753704_P_NODE_28486_length_242_cov_0.923077_g28125_i0 | PRJNA753704 | 28486 | 242 | 0.923077 | 2.23384634 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 57 | 3.47e-7 | NR | CUG90295.1 | 75058 | g28125 | i0 | 36.8 | 2.03305785123967 | 76 | 42 | 94.2 | 2 | 236 | 9 | 157 | 226 | CUG90295.1 Hypothetical protein, putative, partial [Bodo saltans] | diamond | 492 | 57 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 28568746 | 28568746 | PRJNA753704_P_NODE_27787_length_243_cov_1.323529_g27426_i0 | PRJNA753704 | 27787 | 243 | 1.323529 | 3.21617547 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 91.3 | 2.82e-20 | NR | XP_819301.1 | 5693 | g27426 | i0 | 58.8 | 4.9382716049382704 | 80 | 33 | 98.8 | 0 | 4 | 243 | 83 | 162 | XP_819301.1 RNA-binding protein, putative [Trypanosoma cruzi] | diamond | 1200 | 91.3 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 28789675 | 28789675 | PRJNA753704_P_NODE_24787_length_250_cov_0.881356_g24426_i0 | PRJNA753704 | 24787 | 250 | 0.881356 | 2.20339 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 98.6 | 9.49e-22 | NR | KAJ9448611.1 | 91374 | g24426 | i0 | 60.8 | 0.948 | 79 | 31 | 94.8 | 0 | 249 | 13 | 454 | 532 | KAJ9448611.1 Laminin-like protein epi-1 [Diplonema papillatum] | diamond | 237 | 98.6 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 29042583 | 29042583 | PRJNA753704_P_NODE_15928_length_301_cov_1.881579_g15567_i0 | PRJNA753704 | 15928 | 301 | 1.881579 | 5.66355279 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 68.6 | 5.21e-11 | NR | CUG91360.1 | 75058 | g15567 | i0 | 40.2 | 0.867109634551495 | 87 | 52 | 86.7 | 0 | 12 | 272 | 19 | 105 | CUG91360.1 cysteine peptidase, putative [Bodo saltans] | diamond | 261 | 68.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 29515836 | 29515836 | PRJNA753704_P_NODE_23570_length_253_cov_0.866667_g23209_i0 | PRJNA753704 | 23570 | 253 | 0.866667 | 2.19266751 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 98.2 | 1.35e-21 | NR | CUG06733.1 | 75058 | g23209 | i0 | 54.2 | 0.984189723320158 | 83 | 38 | 98.4 | 0 | 5 | 253 | 1401 | 1483 | CUG06733.1 Hypothetical protein, putative [Bodo saltans] | diamond | 249 | 98.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30473641 | 30473641 | PRJNA753704_P_NODE_27773_length_243_cov_1.423529_g27412_i0 | PRJNA753704 | 27773 | 243 | 1.423529 | 3.45917547 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 46.6 | 2.28e-4 | NR | ADK12975.1 | 5659 | g27412 | i0 | 40.9 | 2.34567901234568 | 66 | 26 | 75.3 | 2 | 16 | 198 | 26 | 83 | ADK12975.1 ribosomal protein S12 [Leishmania amazonensis] | diamond | 570 | 47 | 0.991489361702128 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania amazonensis | ||
| 30558225 | 30558225 | PRJNA753704_P_NODE_27233_length_244_cov_2.140351_g26872_i0 | PRJNA753704 | 27233 | 244 | 2.140351 | 5.22245644 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 97.8 | 3.559999999999999e-23 | NR | CUF99855.1 | 75058 | g26872 | i0 | 59.5 | 0.971311475409836 | 79 | 32 | 97.1 | 0 | 239 | 3 | 83 | 161 | CUF99855.1 unnamed protein product [Bodo saltans] | diamond | 237 | 97.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31633071 | 31633071 | PRJNA753704_P_NODE_19816_length_273_cov_1.475000_g19455_i0 | PRJNA753704 | 19816 | 273 | 1.475 | 4.02675 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 147 | 2.76e-39 | NR | CUG85687.1 | 75058 | g19455 | i0 | 76.7 | 0.989010989010989 | 90 | 21 | 98.9 | 0 | 3 | 272 | 242 | 331 | CUG85687.1 protein kinase, putative [Bodo saltans] | diamond | 270 | 147 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31664646 | 31664646 | PRJNA753704_P_NODE_26177_length_247_cov_0.896552_g25816_i0 | PRJNA753704 | 26177 | 247 | 0.896552 | 2.21448344 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 148 | 2.3999999999999996e-44 | NR | WJH19444.1 | 3039 | g25816 | i0 | 84.1 | 0.995951417004049 | 82 | 13 | 99.6 | 0 | 247 | 2 | 7 | 88 | WJH19444.1 U6 snRNA-associated Sm-like protein LSm8 [Euglena gracilis] | diamond | 246 | 148 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 32107650 | 32107650 | PRJNA753704_P_NODE_26058_length_247_cov_0.896552_g25697_i0 | PRJNA753704 | 26058 | 247 | 0.896552 | 2.21448344 | Novymonas esmeraldas | 1808958 | Euglenozoa | other_Eukaryota | 97.4 | 1.02e-21 | NR | KAK7198624.1 | 1808958 | g25697 | i0 | 59.5 | 3.91093117408907 | 79 | 31 | 96 | 1 | 11 | 247 | 63 | 140 | KAK7198624.1 heat shock protein DNAJ [Novymonas esmeraldas] | diamond | 966 | 97.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Novymonas | Novymonas esmeraldas | ||
| 32519263 | 32519263 | PRJNA753704_P_NODE_15779_length_302_cov_2.213974_g15418_i0 | PRJNA753704 | 15779 | 302 | 2.213974 | 6.68620148 | Lepocinclis tripteris | 135494 | Euglenozoa | other_Eukaryota | 103 | 1.86e-23 | NR | ALR69623.1 | 135494 | g15418 | i0 | 59 | 1.61920529801324 | 83 | 34 | 82.5 | 0 | 249 | 1 | 151 | 233 | ALR69623.1 plastid fructose 1,6-bisphosphatase, partial [Lepocinclis tripteris] | diamond | 489 | 103 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Phacaceae | Lepocinclis | Lepocinclis tripteris |
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);;