contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 307967 | 307967 | PRJNA1159911_P_NODE_51981_length_339_cov_1.887218_g51439_i0 | PRJNA1159911 | 51981 | 339 | 1.887218 | 6.39766902 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 153 | 4.81e-45 | NR | pir|S41653| | 5691 | g51439 | i0 | 70.5 | 2.9646017699115 | 112 | 33 | 99.1 | 0 | 3 | 338 | 33 | 144 | pir|S41653| ribosomal protein L25, cytosolic - Trypanosoma brucei [Trypanosoma brucei] | diamond | 1005 | 154 | 0.993506493506494 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 9966089 | 9966089 | PRJNA1159911_P_NODE_52828_length_336_cov_1.068441_g52286_i0 | PRJNA1159911 | 52828 | 336 | 1.068441 | 3.58996176 | Trypanosoma brucei brucei TREU927 | 185431 | Euglenozoa | other_Eukaryota | 154 | 3.94e-44 | NR | XP_826989.1 | 185431 | g52286 | i0 | 73.9 | 2.97321428571429 | 111 | 29 | 99.1 | 0 | 335 | 3 | 113 | 223 | XP_826989.1 40S ribosomal protein S3, putative [Trypanosoma brucei brucei TREU927] | diamond | 999 | 154 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 11786873 | 11786873 | PRJNA1159911_P_NODE_64990_length_296_cov_1.381166_g64448_i0 | PRJNA1159911 | 64990 | 296 | 1.381166 | 4.08825136 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 147 | 6.34e-39 | NR | CUF66623.1 | 75058 | g64448 | i0 | 67.3 | 1.99662162162162 | 98 | 32 | 99.3 | 0 | 295 | 2 | 278 | 375 | CUF66623.1 phospholipase C 3-like, putative [Bodo saltans] | diamond | 591 | 147 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 21984095 | 21984095 | PRJNA1159911_P_NODE_17018_length_731_cov_1.668693_g16518_i0 | PRJNA1159911 | 17018 | 731 | 1.668693 | 12.19814583 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 133 | 7.81e-33 | NR | KAJ9468047.1 | 91374 | g16518 | i0 | 41.2 | 0.92749658002736 | 226 | 107 | 85.8 | 10 | 675 | 49 | 145 | 361 | KAJ9468047.1 hypothetical protein DIPPA_34511 [Diplonema papillatum] | diamond | 678 | 133 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 24533766 | 24533766 | PRJNA1159911_P_NODE_41700_length_391_cov_1.374214_g41158_i0 | PRJNA1159911 | 41700 | 391 | 1.374214 | 5.37317674 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 179 | 1.97e-54 | NR | EPY30869.1 | 28005 | g41158 | i0 | 74 | 4.65728900255754 | 123 | 31 | 93.6 | 1 | 367 | 2 | 46 | 168 | EPY30869.1 large subunit ribosomal protein L27Ae [Strigomonas culicis] | diamond | 1821 | 179 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Strigomonas | Strigomonas culicis | ||
| 26913680 | 26913680 | PRJNA1159911_P_NODE_54302_length_330_cov_1.198444_g53760_i0 | PRJNA1159911 | 54302 | 330 | 1.198444 | 3.9548652 | Phacus inflexus | 461210 | Euglenozoa | other_Eukaryota | 129 | 1.9099999999999999e-34 | NR | ALR69517.1 | 461210 | g53760 | i0 | 90.4 | 1.37272727272727 | 73 | 7 | 66.4 | 0 | 110 | 328 | 4 | 76 | ALR69517.1 plastid ribose-5-phosphate isomerase, partial [Phacus inflexus] | diamond | 453 | 129 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Phacaceae | Phacus | Phacus inflexus | ||
| 27324913 | 27324913 | PRJNA1159911_P_NODE_98163_length_243_cov_0.905882_g97621_i0 | PRJNA1159911 | 98163 | 243 | 0.905882 | 2.20129326 | Phytomonas sp. EM1 | 479712 | Euglenozoa | other_Eukaryota | 126 | 2.11e-35 | NR | CCW60375.1 | 479712 | g97621 | i0 | 83.3 | 2.88888888888889 | 78 | 13 | 96.3 | 0 | 9 | 242 | 1 | 78 | CCW60375.1 unnamed protein product [Phytomonas sp. EM1] | diamond | 702 | 126 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Phytomonas | Phytomonas sp. EM1 | ||
| 27514381 | 27514381 | PRJNA1159911_P_NODE_93923_length_246_cov_0.890173_g93381_i0 | PRJNA1159911 | 93923 | 246 | 0.890173 | 2.18982558 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 105 | 3.83e-24 | NR | CUE81527.1 | 75058 | g93381 | i0 | 61.3 | 0.975609756097561 | 80 | 31 | 97.6 | 0 | 241 | 2 | 276 | 355 | CUE81527.1 phospholipase B, putative [Bodo saltans] | diamond | 240 | 105 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 27533681 | 27533681 | PRJNA1159911_P_NODE_63623_length_300_cov_0.872247_g63081_i0 | PRJNA1159911 | 63623 | 300 | 0.872247 | 2.616741 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 138 | 3.06e-40 | NR | XP_011780987.1 | 679716 | g63081 | i0 | 74.7 | 1.74 | 87 | 21 | 86 | 1 | 258 | 1 | 1 | 87 | XP_011780987.1 cyclin dependant kinases regulatory subunit,putative [Trypanosoma brucei gambiense DAL972] | diamond | 522 | 138 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 27628602 | 27628602 | PRJNA1159911_P_NODE_85564_length_253_cov_1.288889_g85022_i0 | PRJNA1159911 | 85564 | 253 | 1.288889 | 3.26088917 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 70.9 | 1.22e-13 | NR | KAH8613585.1 | 5699 | g85022 | i0 | 60 | 1.57707509881423 | 70 | 27 | 81.8 | 1 | 22 | 228 | 1 | 70 | KAH8613585.1 putative 60s Acidic ribosomal protein [Trypanosoma vivax] | diamond | 399 | 71.6 | 0.990223463687151 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 29250754 | 29250754 | PRJNA1159911_P_NODE_92829_length_247_cov_0.885057_g92287_i0 | PRJNA1159911 | 92829 | 247 | 0.885057 | 2.18609079 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 119 | 1.4599999999999999e-31 | NR | CUF99855.1 | 75058 | g92287 | i0 | 67.9 | 0.983805668016194 | 81 | 24 | 96 | 1 | 1 | 237 | 41 | 121 | CUF99855.1 unnamed protein product [Bodo saltans] | diamond | 243 | 119 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 29522817 | 29522817 | PRJNA1159911_P_NODE_82150_length_259_cov_1.204301_g81608_i0 | PRJNA1159911 | 82150 | 259 | 1.204301 | 3.11913959 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 66.2 | 2.36e-10 | NR | KAG8347963.1 | 5699 | g81608 | i0 | 43 | 5.003861003861 | 86 | 45 | 97.3 | 2 | 3 | 254 | 337 | 420 | KAG8347963.1 putative translation elongation factor EF-2 [Trypanosoma vivax] | diamond | 1296 | 66.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 29597905 | 29597905 | PRJNA1159911_P_NODE_88030_length_250_cov_1.508475_g87488_i0 | PRJNA1159911 | 88030 | 250 | 1.508475 | 3.7711875 | Trypanosoma congolense IL3 | 5692 | Euglenozoa | other_Eukaryota | 66.2 | 1.39e-10 | NR | CCC93196.1 | 1068625 | g87488 | i0 | 50.6 | 1.896 | 79 | 36 | 91.2 | 1 | 230 | 3 | 1 | 79 | CCC93196.1 unnamed protein product [Trypanosoma congolense IL3000] | diamond | 474 | 66.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma congolense | ||
| 29755959 | 29755959 | PRJNA1159911_P_NODE_92831_length_247_cov_0.885057_g92289_i0 | PRJNA1159911 | 92831 | 247 | 0.885057 | 2.18609079 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 76.3 | 6.15e-14 | NR | CUG88655.1 | 75058 | g92289 | i0 | 45.8 | 0.874493927125506 | 72 | 39 | 87.4 | 0 | 238 | 23 | 419 | 490 | CUG88655.1 flagellar radial spoke protein, putative [Bodo saltans] | diamond | 216 | 76.3 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30470620 | 30470620 | PRJNA1159911_P_NODE_94353_length_246_cov_0.890173_g93811_i0 | PRJNA1159911 | 94353 | 246 | 0.890173 | 2.18982558 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 61.2 | 1.17e-8 | NR | KAG8343689.1 | 5699 | g93811 | i0 | 45.5 | 1.8780487804878 | 77 | 40 | 92.7 | 2 | 246 | 19 | 400 | 475 | KAG8343689.1 hypothetical protein TRVL_05489 [Trypanosoma vivax] | diamond | 462 | 61.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 30608977 | 30608977 | PRJNA1159911_P_NODE_39373_length_407_cov_1.550898_g38831_i0 | PRJNA1159911 | 39373 | 407 | 1.550898 | 6.31215486 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 102 | 2.7900000000000003e-22 | NR | CUG88796.1 | 75058 | g38831 | i0 | 37.9 | 0.914004914004914 | 124 | 73 | 89.2 | 3 | 4 | 366 | 464 | 586 | CUG88796.1 cation ATPase alpha subunit, putative, partial [Bodo saltans] | diamond | 372 | 102 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31083064 | 31083064 | PRJNA1159911_P_NODE_79215_length_264_cov_1.612565_g78673_i0 | PRJNA1159911 | 79215 | 264 | 1.612565 | 4.2571716 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 70.1 | 1e-11 | NR | KAJ9468047.1 | 91374 | g78673 | i0 | 53.7 | 1.45454545454545 | 67 | 24 | 68.2 | 2 | 182 | 3 | 240 | 306 | KAJ9468047.1 hypothetical protein DIPPA_34511 [Diplonema papillatum] | diamond | 384 | 70.1 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 31557585 | 31557585 | PRJNA1159911_P_NODE_77856_length_267_cov_1.190722_g77314_i0 | PRJNA1159911 | 77856 | 267 | 1.190722 | 3.17922774 | Leishmania orientalis | 2249476 | Euglenozoa | other_Eukaryota | 88.6 | 1.17e-19 | NR | XP_067059259.1 | 2249476 | g77314 | i0 | 54 | 0.97752808988764 | 87 | 40 | 97.8 | 0 | 262 | 2 | 6 | 92 | XP_067059259.1 hypothetical protein LSCM4_01519 [Leishmania orientalis] | diamond | 261 | 88.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania orientalis | ||
| 31987841 | 31987841 | PRJNA1159911_P_NODE_91358_length_248_cov_0.880000_g90816_i0 | PRJNA1159911 | 91358 | 248 | 0.88 | 2.1824 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 78.6 | 6.33e-16 | NR | XP_015664094.1 | 157538 | g90816 | i0 | 53.2 | 3.62903225806452 | 77 | 34 | 93.1 | 1 | 4 | 234 | 17 | 91 | XP_015664094.1 rer1 family-like protein [Leptomonas pyrrhocoris] | diamond | 900 | 78.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 32474999 | 32474999 | PRJNA1159911_P_NODE_88199_length_250_cov_1.276836_g87657_i0 | PRJNA1159911 | 88199 | 250 | 1.276836 | 3.19209 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 88.2 | 7.860000000000001e-21 | NR | CUG21192.1 | 75058 | g87657 | i0 | 69.2 | 4.68 | 65 | 20 | 78 | 0 | 248 | 54 | 15 | 79 | CUG21192.1 40S ribosomal protein S9, putative, partial [Bodo saltans] | diamond | 1170 | 88.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);;