contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA599026" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1847411 | 1847411 | PRJNA599026_S_NODE_40782_length_180_cov_2.778626_g40326_i0 | PRJNA599026 | 40782 | 180 | 2.778626 | 5.0015268 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 84 | 4.73e-17 | NR | KAA3682172.1 | 34504 | g40326 | i0 | 72.9 | 21.3166666666667 | 59 | 16 | 98.3 | 0 | 179 | 3 | 931 | 989 | KAA3682172.1 Ca2+ transporting ATPase, plasma membrane [Paragonimus westermani] | diamond | 3837 | 84.3 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 19698102 | 19698102 | PRJNA599026_S_NODE_31316_length_198_cov_2.959732_g30860_i0 | PRJNA599026 | 31316 | 198 | 2.959732 | 5.86026936 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 119 | 3.099999999999999e-29 | NR | CAI2723193.1 | 6189 | g30860 | i0 | 83.3 | 56 | 66 | 11 | 100 | 0 | 198 | 1 | 287 | 352 | CAI2723193.1 unnamed protein product [Schistosoma spindalis] | diamond | 11088 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma spindalis | |
| 26966601 | 26966601 | PRJNA599026_S_NODE_8622_length_330_cov_1.427046_g8166_i0 | PRJNA599026 | 8622 | 330 | 1.427046 | 4.7092518 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 68.9 | 6.45e-11 | NR | VDL99842.1 | 70667 | g8166 | i0 | 63.6 | 5.53636363636364 | 44 | 16 | 40 | 0 | 269 | 138 | 446 | 489 | VDL99842.1 unnamed protein product [Schistocephalus solidus] | diamond | 1827 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 27048310 | 27048310 | PRJNA599026_S_NODE_34242_length_192_cov_1.713287_g33786_i0 | PRJNA599026 | 34242 | 192 | 1.713287 | 3.28951104 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 67 | 5.16e-11 | NR | VDM17183.1 | 6205 | g33786 | i0 | 61 | 2.75 | 59 | 22 | 90.6 | 1 | 191 | 18 | 402 | 460 | VDM17183.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 528 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 27522144 | 27522144 | PRJNA599026_S_NODE_30523_length_200_cov_1.622517_g30067_i0 | PRJNA599026 | 30523 | 200 | 1.622517 | 3.245034 | Paragonimus heterotremus | 100268 | Platyhelminthes | Platyhelminthes | 45.8 | 0.00174 | NR | KAF5401728.1 | 100268 | g30067 | i0 | 46.5 | 0.645 | 43 | 23 | 64.5 | 0 | 130 | 2 | 244 | 286 | KAF5401728.1 Long-chain acyl-CoA synthetase, partial [Paragonimus heterotremus] | diamond | 129 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus heterotremus | |
| 27693731 | 27693731 | PRJNA599026_S_NODE_39744_length_182_cov_1.533835_g39288_i0 | PRJNA599026 | 39744 | 182 | 1.533835 | 2.7915797 | Opisthorchis | 6197 | Platyhelminthes | Platyhelminthes | 49.3 | 7.82e-5 | NR | OON19075.1 | 6198 | g39288 | i0 | 63.6 | 2.71978021978022 | 33 | 12 | 54.4 | 0 | 133 | 35 | 76 | 108 | OON19075.1 dual specificity phosphatase, catalytic domain protein [Opisthorchis viverrini] | diamond | 495 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 27914314 | 27914314 | PRJNA599026_S_NODE_7185_length_359_cov_1.854839_g6729_i0 | PRJNA599026 | 7185 | 359 | 1.854839 | 6.65887201 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 87 | 4.42e-17 | NR | KAH9284251.1 | 6210 | g6729 | i0 | 52.2 | 117.242339832869 | 115 | 55 | 96.1 | 0 | 15 | 359 | 703 | 817 | KAH9284251.1 Calcium-transporting ATPase sarcoplasmic/endoplasmic reticulum type [Echinococcus granulosus] | diamond | 42090 | 87.8 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28293238 | 28293238 | PRJNA599026_S_NODE_20686_length_230_cov_1.408840_g20230_i0 | PRJNA599026 | 20686 | 230 | 1.40884 | 3.240332 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 106 | 1.3e-26 | NR | OON16988.1 | 6198 | g20230 | i0 | 63.2 | 51.3652173913043 | 76 | 28 | 99.1 | 0 | 1 | 228 | 35 | 110 | OON16988.1 Ras family protein [Opisthorchis viverrini] | diamond | 11814 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 28577527 | 28577527 | PRJNA599026_S_NODE_72427_length_160_cov_3.144144_g71971_i0 | PRJNA599026 | 72427 | 160 | 3.144144 | 5.0306304 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 57.8 | 6e-8 | NR | Q5D8V5.1 | 6182 | g71971 | i0 | 73 | 9.01875 | 37 | 9 | 67.5 | 1 | 159 | 52 | 137 | 173 | Q5D8V5.1 RecName: Full=Adenylosuccinate synthetase; Short=AMPSase; Short=AdSS; AltName: Full=IMP--aspartate ligase [Schistosoma japonicum] | diamond | 1443 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28924670 | 28924670 | PRJNA599026_S_NODE_62168_length_164_cov_0.834783_g61712_i0 | PRJNA599026 | 62168 | 164 | 0.834783 | 1.36904412 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 54.3 | 1.06e-6 | NR | VDM18775.1 | 6205 | g61712 | i0 | 53.8 | 16.4085365853659 | 52 | 24 | 95.1 | 0 | 9 | 164 | 446 | 497 | VDM18775.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 2691 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29650605 | 29650605 | PRJNA599026_S_NODE_42310_length_178_cov_1.503876_g41854_i0 | PRJNA599026 | 42310 | 178 | 1.503876 | 2.67689928 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 89.7 | 2.44e-19 | NR | XP_024345417.1 | 6210 | g41854 | i0 | 74.5 | 10.4831460674157 | 51 | 13 | 86 | 0 | 1 | 153 | 287 | 337 | XP_024345417.1 N-acyl-phosphatidylethanolamine-hydrolyzing phospholipase D [Echinococcus granulosus] | diamond | 1866 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 29682267 | 29682267 | PRJNA599026_S_NODE_59070_length_164_cov_2.747826_g58614_i0 | PRJNA599026 | 59070 | 164 | 2.747826 | 4.50643464 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 46.6 | 5.54e-4 | NR | CAH8624992.1 | 6188 | g58614 | i0 | 43.5 | 5.17682926829268 | 46 | 26 | 84.1 | 0 | 13 | 150 | 15 | 60 | CAH8624992.1 unnamed protein product [Schistosoma rodhaini] | diamond | 849 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 30048075 | 30048075 | PRJNA599026_S_NODE_12211_length_283_cov_2.384615_g11755_i0 | PRJNA599026 | 12211 | 283 | 2.384615 | 6.74846045 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 59.3 | 2.91e-8 | NR | KAL3313940.1 | 1844966 | g11755 | i0 | 35.9 | 6.61484098939929 | 78 | 50 | 82.7 | 0 | 9 | 242 | 54 | 131 | KAL3313940.1 ribosomal protein S5 [Cichlidogyrus casuarinus] | diamond | 1872 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 30598583 | 30598583 | PRJNA599026_S_NODE_11273_length_293_cov_2.508197_g10817_i0 | PRJNA599026 | 11273 | 293 | 2.508197 | 7.34901721 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 1.89e-5 | NR | KAF7257188.1 | 59628 | g10817 | i0 | 42 | 6.55290102389078 | 69 | 35 | 65.5 | 2 | 261 | 70 | 145 | 213 | KAF7257188.1 hypothetical protein EG68_05425 [Paragonimus skrjabini miyazakii] | diamond | 1920 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 30743370 | 30743370 | PRJNA599026_S_NODE_24854_length_215_cov_1.234940_g24398_i0 | PRJNA599026 | 24854 | 215 | 1.23494 | 2.655121 | Fasciola gigantica | 46835 | Platyhelminthes | Platyhelminthes | 53.5 | 3.93e-6 | NR | TPP56027.1 | 46835 | g24398 | i0 | 36.8 | 0.948837209302326 | 68 | 41 | 94.9 | 1 | 207 | 4 | 196 | 261 | TPP56027.1 Phosphatidylcholine-sterol acyltransferase (Lecithin-cholesterol acyltransferase)/ Phospholipase A [Fasciola gigantica] | diamond | 204 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 30806605 | 30806605 | PRJNA599026_S_NODE_29394_length_203_cov_1.181818_g28938_i0 | PRJNA599026 | 29394 | 203 | 1.181818 | 2.39909054 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 49.3 | 1.05e-4 | NR | VDL99704.1 | 70667 | g28938 | i0 | 49.3 | 1.98029556650246 | 67 | 34 | 99 | 0 | 2 | 202 | 334 | 400 | VDL99704.1 unnamed protein product [Schistocephalus solidus] | diamond | 402 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 31216901 | 31216901 | PRJNA599026_S_NODE_16175_length_252_cov_10.699507_g15719_i0 | PRJNA599026 | 16175 | 252 | 10.699507 | 26.96275764 | Paragonimus heterotremus | 100268 | Platyhelminthes | Platyhelminthes | 53.1 | 8.22e-6 | NR | KAF5400076.1 | 100268 | g15719 | i0 | 43.9 | 0.785714285714286 | 66 | 35 | 76.2 | 1 | 210 | 19 | 224 | 289 | KAF5400076.1 Calbindin [Paragonimus heterotremus] | diamond | 198 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus heterotremus | |
| 31818207 | 31818207 | PRJNA599026_S_NODE_3557_length_505_cov_6.896930_g3108_i0 | PRJNA599026 | 3557 | 505 | 6.89693 | 34.8294965 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 59.3 | 8.26e-7 | NR | XP_009173853.1 | 6198 | g3108 | i0 | 30.3 | 0.861386138613861 | 145 | 101 | 86.1 | 0 | 503 | 69 | 157 | 301 | XP_009173853.1 hypothetical protein T265_14865, partial [Opisthorchis viverrini] | diamond | 435 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 31894856 | 31894856 | PRJNA599026_S_NODE_64937_length_163_cov_0.894737_g64481_i0 | PRJNA599026 | 64937 | 163 | 0.894737 | 1.45842131 | root | 1 | Root_unresolved | Root_unresolved | 64.3 | 3.02e-10 | NR | BAA08663.1 | 6161 | g64481 | i0 | 50 | 3.97546012269939 | 54 | 27 | 99.4 | 0 | 2 | 163 | 180 | 233 | BAA08663.1 elongation factor-1alpha, partial [Dugesia japonica] | diamond | 648 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 31976414 | 31976414 | PRJNA599026_S_NODE_62518_length_163_cov_1.789474_g62062_i0 | PRJNA599026 | 62518 | 163 | 1.789474 | 2.91684262 | Dibothriocephalus latus | 60516 | Platyhelminthes | Platyhelminthes | 63.5 | 1.13e-10 | NR | VDN10080.1 | 60516 | g62062 | i0 | 69.4 | 4.71165644171779 | 36 | 11 | 66.3 | 0 | 1 | 108 | 51 | 86 | VDN10080.1 unnamed protein product [Dibothriocephalus latus] | diamond | 768 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 32432989 | 32432989 | PRJNA599026_S_NODE_51419_length_167_cov_0.864407_g50963_i0 | PRJNA599026 | 51419 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 8.22e-23 | NR | VDL59753.1 | 6216 | g50963 | i0 | 92.7 | 20.748502994012 | 55 | 4 | 98.8 | 0 | 165 | 1 | 283 | 337 | VDL59753.1 unnamed protein product [Hymenolepis diminuta] | diamond | 3465 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 32640322 | 32640322 | PRJNA599026_S_NODE_5560_length_405_cov_1.806180_g5105_i0 | PRJNA599026 | 5560 | 405 | 1.80618 | 7.315029 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 80.9 | 5.17e-16 | NR | CAL5129427.1 | 300641 | g5105 | i0 | 46.7 | 2.31111111111111 | 75 | 36 | 55.6 | 1 | 21 | 245 | 6 | 76 | CAL5129427.1 unnamed protein product [Calicophoron daubneyi] | diamond | 936 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 32779667 | 32779667 | PRJNA599026_S_NODE_21300_length_227_cov_2.382022_g20844_i0 | PRJNA599026 | 21300 | 227 | 2.382022 | 5.40718994 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 3.520000000000001e-27 | NR | VDL18831.1 | 6216 | g20844 | i0 | 67.1 | 1.98237885462555 | 76 | 24 | 99.1 | 1 | 227 | 3 | 107 | 182 | VDL18831.1 unnamed protein product [Hymenolepis diminuta] | diamond | 450 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta |
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);;