contig_metadata
25 rows where bioproject = "PRJNA975724", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3496951 | 3496951 | PRJNA975724_S_NODE_483_length_1001_cov_29.957974_g397_i0 | PRJNA975724 | 483 | 1001 | 29.957974 | 299.87931974 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 380 | 2.7e-129 | NR | CAX83046.1 | 6182 | g397 | i0 | 76.3 | 31.4595404595405 | 240 | 57 | 71.9 | 0 | 999 | 280 | 9 | 248 | CAX83046.1 60S ribosomal protein L8, partial [Schistosoma japonicum] | diamond | 31491 | 383 | 0.992167101827676 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 8598298 | 8598298 | PRJNA975724_S_NODE_10307_length_447_cov_11.786096_g10126_i0 | PRJNA975724 | 10307 | 447 | 11.786096 | 52.68384912 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 171 | 2.76e-51 | NR | OON21776.1 | 6198 | g10126 | i0 | 65 | 16.3489932885906 | 123 | 43 | 82.6 | 0 | 1 | 369 | 43 | 165 | OON21776.1 Ribosomal protein L11, RNA binding domain protein [Opisthorchis viverrini] | diamond | 7308 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 8599397 | 8599397 | PRJNA975724_S_NODE_54127_length_289_cov_1.972222_g53946_i0 | PRJNA975724 | 54127 | 289 | 1.972222 | 5.69972158 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.5 | 3.36e-10 | NR | KAF8561512.1 | 34504 | g53946 | i0 | 93.8 | 20.0138408304498 | 32 | 2 | 33.2 | 0 | 6 | 101 | 117 | 148 | KAF8561512.1 hypothetical protein P879_10906 [Paragonimus westermani] | diamond | 5784 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 12425458 | 12425458 | PRJNA975724_S_NODE_46170_length_305_cov_2.129310_g45989_i0 | PRJNA975724 | 46170 | 305 | 2.12931 | 6.4943955 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 152 | 1.02e-45 | NR | VDN10810.1 | 60516 | g45989 | i0 | 80.7 | 17.3016393442623 | 88 | 17 | 86.6 | 0 | 305 | 42 | 22 | 109 | VDN10810.1 unnamed protein product [Dibothriocephalus latus] | diamond | 5277 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 16249268 | 16249268 | PRJNA975724_S_NODE_51333_length_294_cov_8.705882_g51152_i0 | PRJNA975724 | 51333 | 294 | 8.705882 | 25.59529308 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 499 | 8.099999999999998e-137 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g51152 | i0 | 97.306 | 127.666666666667 | 297 | 2 | 100 | 3 | 2 | 294 | 1936 | 2230 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 37534 | 499 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 17523487 | 17523487 | PRJNA975724_S_NODE_15134_length_412_cov_2.628319_g14953_i0 | PRJNA975724 | 15134 | 412 | 2.628319 | 10.82867428 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.011 | NTclustered | gi|690557083|emb|LN112538.1| | 99802 | g14953 | i0 | 96.875 | 0.308252427184466 | 32 | 1 | 8 | 0 | 163 | 194 | 472 | 503 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0105655 | blastn | 127 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 26937188 | 26937188 | PRJNA975724_S_NODE_20642_length_383_cov_8.322581_g20461_i0 | PRJNA975724 | 20642 | 383 | 8.322581 | 31.87548523 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 125 | 1.3e-32 | NR | PAA54088.1 | 282301 | g20461 | i0 | 55.2 | 6.82245430809399 | 96 | 42 | 74.4 | 1 | 9 | 293 | 155 | 250 | PAA54088.1 hypothetical protein BOX15_Mlig011326g2, partial [Macrostomum lignano] | diamond | 2613 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27474636 | 27474636 | PRJNA975724_S_NODE_8003_length_472_cov_2.122807_g7822_i0 | PRJNA975724 | 8003 | 472 | 2.122807 | 10.01964904 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 125 | 4.85e-31 | NR | CAX73277.1 | 6182 | g7822 | i0 | 58 | 4.98305084745763 | 112 | 40 | 67.4 | 3 | 43 | 360 | 253 | 363 | CAX73277.1 putative TyrA protein [Schistosoma japonicum] | diamond | 2352 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28005387 | 28005387 | PRJNA975724_S_NODE_1725_length_692_cov_4.828756_g1564_i0 | PRJNA975724 | 1725 | 692 | 4.828756 | 33.41499152 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 151 | 9.61e-42 | NR | VDL89772.1 | 70667 | g1564 | i0 | 64 | 6.42485549132948 | 114 | 39 | 49.4 | 1 | 687 | 346 | 98 | 209 | VDL89772.1 unnamed protein product [Schistocephalus solidus] | diamond | 4446 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 28099807 | 28099807 | PRJNA975724_S_NODE_28665_length_352_cov_3.318996_g28484_i0 | PRJNA975724 | 28665 | 352 | 3.318996 | 11.68286592 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 49.7 | 2.48e-5 | NR | ABA40899.1 | 6182 | g28484 | i0 | 59 | 0.332386363636364 | 39 | 14 | 31.5 | 1 | 273 | 163 | 4 | 42 | ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] | diamond | 117 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28478818 | 28478818 | PRJNA975724_S_NODE_21946_length_377_cov_10.944079_g21765_i0 | PRJNA975724 | 21946 | 377 | 10.944079 | 41.25917783 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 115 | 3.14e-30 | NR | KAL3313757.1 | 1844966 | g21765 | i0 | 59.1 | 0.740053050397878 | 93 | 38 | 74 | 0 | 1 | 279 | 40 | 132 | KAL3313757.1 60S ribosomal protein L32 [Cichlidogyrus casuarinus] | diamond | 279 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 28731445 | 28731445 | PRJNA975724_S_NODE_89967_length_242_cov_0.911243_g89786_i0 | PRJNA975724 | 89967 | 242 | 0.911243 | 2.20520806 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 100 | 1.83e-24 | NR | AAX25032.2 | 6182 | g89786 | i0 | 69.4 | 0.892561983471074 | 72 | 22 | 89.3 | 0 | 23 | 238 | 116 | 187 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 216 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29394517 | 29394517 | PRJNA975724_S_NODE_86749_length_244_cov_2.257310_g86568_i0 | PRJNA975724 | 86749 | 244 | 2.25731 | 5.5078364 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 59.3 | 1.08e-8 | NR | PAA87181.1 | 282301 | g86568 | i0 | 57.6 | 1.45081967213115 | 59 | 22 | 71.3 | 3 | 218 | 45 | 105 | 161 | PAA87181.1 hypothetical protein BOX15_Mlig028611g2 [Macrostomum lignano] | diamond | 354 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30285401 | 30285401 | PRJNA975724_S_NODE_24232_length_368_cov_5.637288_g24051_i0 | PRJNA975724 | 24232 | 368 | 5.637288 | 20.74521984 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 53.5 | 1.02e-5 | NR | THD25903.1 | 6192 | g24051 | i0 | 58.7 | 0.75 | 46 | 19 | 37.5 | 0 | 367 | 230 | 146 | 191 | THD25903.1 Ras C3 botulinum toxin substrate 1 [Fasciola hepatica] | diamond | 276 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 30689389 | 30689389 | PRJNA975724_S_NODE_55793_length_286_cov_1.798122_g55612_i0 | PRJNA975724 | 55793 | 286 | 1.798122 | 5.14262892 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 46.2 | 0.00173 | NR | AAM55226.1 | 6182 | g55612 | i0 | 74.1 | 0.283216783216783 | 27 | 7 | 28.3 | 0 | 1 | 81 | 9 | 35 | AAM55226.1 CA protein [Schistosoma japonicum] | diamond | 81 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30847507 | 30847507 | PRJNA975724_S_NODE_44574_length_309_cov_1.114407_g44393_i0 | PRJNA975724 | 44574 | 309 | 1.114407 | 3.44351763 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 104 | 9.26e-24 | NR | XP_009165616.1 | 6198 | g44393 | i0 | 69.2 | 0.757281553398058 | 78 | 22 | 75.7 | 1 | 74 | 307 | 345 | 420 | XP_009165616.1 hypothetical protein T265_02973 [Opisthorchis viverrini] | diamond | 234 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 31037384 | 31037384 | PRJNA975724_S_NODE_80575_length_249_cov_1.585227_g80394_i0 | PRJNA975724 | 80575 | 249 | 1.585227 | 3.94721523 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 73.2 | 3.66e-14 | NR | AAX30334.2 | 6182 | g80394 | i0 | 86 | 1.03614457831325 | 43 | 6 | 51.8 | 0 | 129 | 1 | 55 | 97 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 258 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31106362 | 31106362 | PRJNA975724_S_NODE_17695_length_397_cov_9.561728_g17514_i0 | PRJNA975724 | 17695 | 397 | 9.561728 | 37.96006016 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 123 | 9.28e-33 | NR | VDP93278.1 | 27848 | g17514 | i0 | 65.5 | 5.85642317380353 | 87 | 30 | 65.7 | 0 | 397 | 137 | 79 | 165 | VDP93278.1 unnamed protein product [Echinostoma caproni] | diamond | 2325 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 31106364 | 31106364 | PRJNA975724_S_NODE_4755_length_528_cov_17.635165_g4576_i0 | PRJNA975724 | 4755 | 528 | 17.635165 | 93.1136712 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.8 | 3.32e-17 | NR | OON19547.1 | 6198 | g4576 | i0 | 55.2 | 2.73295454545455 | 96 | 28 | 54.5 | 1 | 12 | 299 | 203 | 283 | OON19547.1 ribosomal L18p/L5e family protein [Opisthorchis viverrini] | diamond | 1443 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 31232716 | 31232716 | PRJNA975724_S_NODE_76335_length_254_cov_1.000000_g76154_i0 | PRJNA975724 | 76335 | 254 | 1 | 2.54 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 45.4 | 0.00145 | NR | VDL92001.1 | 70667 | g76154 | i0 | 40.4 | 1.78346456692913 | 52 | 29 | 61.4 | 1 | 2 | 157 | 38 | 87 | VDL92001.1 unnamed protein product [Schistocephalus solidus] | diamond | 453 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 32080664 | 32080664 | PRJNA975724_S_NODE_75938_length_254_cov_1.674033_g75757_i0 | PRJNA975724 | 75938 | 254 | 1.674033 | 4.25204382 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 82.4 | 3.92e-16 | NR | PAA94762.1 | 282301 | g75757 | i0 | 59.5 | 0.874015748031496 | 74 | 29 | 87.4 | 1 | 5 | 226 | 364 | 436 | PAA94762.1 hypothetical protein BOX15_Mlig028472g1 [Macrostomum lignano] | diamond | 222 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32182009 | 32182009 | PRJNA975724_S_NODE_38598_length_323_cov_1.960000_g38417_i0 | PRJNA975724 | 38598 | 323 | 1.96 | 6.3308 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 90.9 | 5.28e-20 | NR | KAA0188103.1 | 27845 | g38417 | i0 | 50.6 | 14.1826625386997 | 81 | 39 | 75.2 | 1 | 252 | 10 | 113 | 192 | KAA0188103.1 3'-5' exoribonuclease 1 [Fasciolopsis buskii] | diamond | 4581 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 32239223 | 32239223 | PRJNA975724_S_NODE_77798_length_251_cov_3.713483_g77617_i0 | PRJNA975724 | 77798 | 251 | 3.713483 | 9.32084233 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 48.9 | 2.64e-4 | NR | KAL3314504.1 | 1844966 | g77617 | i0 | 51.4 | 0.418326693227092 | 35 | 17 | 41.8 | 0 | 249 | 145 | 90 | 124 | KAL3314504.1 Solute carrier 7 member 3 [Cichlidogyrus casuarinus] | diamond | 105 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 32807273 | 32807273 | PRJNA975724_S_NODE_84760_length_246_cov_0.930636_g84579_i0 | PRJNA975724 | 84760 | 246 | 0.930636 | 2.28936456 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 79.7 | 4.98e-16 | NR | AAW25818.1 | 6182 | g84579 | i0 | 63 | 0.658536585365854 | 54 | 20 | 65.9 | 0 | 6 | 167 | 168 | 221 | AAW25818.1 unknown [Schistosoma japonicum] | diamond | 162 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32907885 | 32907885 | PRJNA975724_S_NODE_81580_length_248_cov_2.714286_g81399_i0 | PRJNA975724 | 81580 | 248 | 2.714286 | 6.73142928 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 91.7 | 2.42e-19 | NR | XP_018646657.1 | 6183 | g81399 | i0 | 48.7 | 19.8508064516129 | 78 | 39 | 93.1 | 1 | 243 | 13 | 496 | 573 | XP_018646657.1 hypothetical protein Smp_160560 [Schistosoma mansoni] | diamond | 4923 | 92.4 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni |
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);;