contig_metadata
26 rows where bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8542969 | 8542969 | PRJNA906294_P_NODE_97187_length_424_cov_7.210826_g93072_i0 | PRJNA906294 | 97187 | 424 | 7.210826 | 30.57390224 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 704 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g93072 | i0 | 96.698 | 1 | 424 | 13 | 100 | 1 | 1 | 424 | 27 | 449 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 424 | 704 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 11091060 | 11091060 | PRJNA906294_P_NODE_190949_length_264_cov_1.591623_g186833_i0 | PRJNA906294 | 190949 | 264 | 1.591623 | 4.20188472 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 339 | 1.65e-88 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g186833 | i0 | 90.038 | 0.988636363636364 | 261 | 26 | 99 | 0 | 4 | 264 | 278 | 18 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 261 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 12728178 | 12728178 | PRJNA906294_P_NODE_234730_length_208_cov_4.274074_g230614_i0 | PRJNA906294 | 234730 | 208 | 4.274074 | 8.89007392 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 261 | 2.78e-65 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g230614 | i0 | 99.306 | 69.2307692307692 | 144 | 1 | 69 | 0 | 65 | 208 | 119 | 262 | Schistosoma japonicum unknown mRNA | blastn | 14400 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 16550673 | 16550673 | PRJNA906294_P_NODE_122713_length_358_cov_1.066667_g118597_i0 | PRJNA906294 | 122713 | 358 | 1.066667 | 3.81866786 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 660 | 0 | NTclustered | gi|60600609|gb|AY810873.1| | 6182 | g118597 | i0 | 100 | 51.1368715083799 | 357 | 0 | 99 | 0 | 2 | 358 | 451 | 95 | Schistosoma japonicum clone SJCHGC07419 unknown mRNA | blastn | 18307 | 660 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18738081 | 18738081 | PRJNA906294_P_NODE_155555_length_304_cov_1.268398_g151439_i0 | PRJNA906294 | 155555 | 304 | 1.268398 | 3.85592992 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 309 | 1.5200000000000002e-79 | NTclustered | gi|58197522|dbj|AB200392.1| | 6161 | g151439 | i0 | 87.833 | 74.8256578947368 | 263 | 32 | 87 | 0 | 41 | 303 | 40 | 302 | Dugesia japonica CaM mRNA for calmodulin, complete cds | blastn | 22747 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 21287339 | 21287339 | PRJNA906294_P_NODE_106837_length_395_cov_2.608696_g102722_i0 | PRJNA906294 | 106837 | 395 | 2.608696 | 10.3043492 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 205 | 1.84e-61 | NR | KAA0198055.1 | 27845 | g102722 | i0 | 79.5 | 6.50126582278481 | 122 | 25 | 92.7 | 0 | 394 | 29 | 323 | 444 | KAA0198055.1 Elongation factor 1-alpha C [Fasciolopsis buskii] | diamond | 2568 | 205 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 21287712 | 21287712 | PRJNA906294_P_NODE_122217_length_359_cov_1.038462_g118101_i0 | PRJNA906294 | 122217 | 359 | 1.038462 | 3.72807858 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 173 | 2.7399999999999997e-47 | NR | XP_024354781.1 | 6210 | g118101 | i0 | 68.9 | 2.97493036211699 | 119 | 37 | 99.4 | 0 | 1 | 357 | 826 | 944 | XP_024354781.1 Elongation factor 2 [Echinococcus granulosus] | diamond | 1068 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 27284711 | 27284711 | PRJNA906294_P_NODE_157783_length_301_cov_1.333333_g153667_i0 | PRJNA906294 | 157783 | 301 | 1.333333 | 4.01333233 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 108 | 5.79e-25 | NR | KAL3319696.1 | 1844966 | g153667 | i0 | 60 | 15.9468438538206 | 100 | 39 | 99.7 | 1 | 301 | 2 | 758 | 856 | KAL3319696.1 Dual specificity tyrosine-phosphorylation-regulated kinase 1A [Cichlidogyrus casuarinus] | diamond | 4800 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 28129889 | 28129889 | PRJNA906294_P_NODE_121525_length_360_cov_1.526132_g117409_i0 | PRJNA906294 | 121525 | 360 | 1.526132 | 5.4940752 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 53.5 | 2.24e-5 | NR | CAH8845934.1 | 157069 | g117409 | i0 | 70.3 | 3.05 | 37 | 11 | 30.8 | 0 | 242 | 352 | 204 | 240 | CAH8845934.1 unnamed protein product [Trichobilharzia regenti] | diamond | 1098 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 28161570 | 28161570 | PRJNA906294_P_NODE_187785_length_267_cov_2.340206_g183669_i0 | PRJNA906294 | 187785 | 267 | 2.340206 | 6.24835002 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 42.7 | 0.0485 | NR | PAA78136.1 | 282301 | g183669 | i0 | 57.6 | 0.370786516853933 | 33 | 14 | 37.1 | 0 | 165 | 263 | 381 | 413 | PAA78136.1 hypothetical protein BOX15_Mlig000630g11 [Macrostomum lignano] | diamond | 99 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28255963 | 28255963 | PRJNA906294_P_NODE_179466_length_276_cov_1.157635_g175350_i0 | PRJNA906294 | 179466 | 276 | 1.157635 | 3.1950726 | Fasciola gigantica | 46835 | Platyhelminthes | Platyhelminthes | 60.5 | 2.69e-8 | NR | TPP61293.1 | 46835 | g175350 | i0 | 40.2 | 1 | 92 | 47 | 96.7 | 2 | 9 | 275 | 28 | 114 | TPP61293.1 Cysteine protease [Fasciola gigantica] | diamond | 276 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 28508724 | 28508724 | PRJNA906294_P_NODE_145647_length_318_cov_1.138776_g141531_i0 | PRJNA906294 | 145647 | 318 | 1.138776 | 3.62130768 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 148 | 1.0299999999999998e-43 | NR | AAY97887.1 | 6182 | g141531 | i0 | 69.9 | 0.971698113207547 | 103 | 31 | 97.2 | 0 | 316 | 8 | 25 | 127 | AAY97887.1 unknown [Schistosoma japonicum] | diamond | 309 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29148064 | 29148064 | PRJNA906294_P_NODE_202949_length_252_cov_1.988827_g198833_i0 | PRJNA906294 | 202949 | 252 | 1.988827 | 5.01184404 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.7 | 3.46e-21 | NR | VDL92222.1 | 70667 | g198833 | i0 | 68.3 | 9.44047619047619 | 60 | 19 | 71.4 | 0 | 252 | 73 | 103 | 162 | VDL92222.1 unnamed protein product [Schistocephalus solidus] | diamond | 2379 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 29203518 | 29203518 | PRJNA906294_P_NODE_196509_length_259_cov_1.096774_g192393_i0 | PRJNA906294 | 196509 | 259 | 1.096774 | 2.84064466 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 84 | 1.35e-16 | NR | CAH8521059.1 | 57078 | g192393 | i0 | 76.4 | 1.27413127413127 | 55 | 13 | 63.7 | 0 | 168 | 4 | 18 | 72 | CAH8521059.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 330 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 29463052 | 29463052 | PRJNA906294_P_NODE_66470_length_568_cov_1.745455_g62379_i0 | PRJNA906294 | 66470 | 568 | 1.745455 | 9.9141844 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 83.6 | 6.63e-17 | NR | OON14596.1 | 6198 | g62379 | i0 | 69.2 | 9.25352112676056 | 52 | 16 | 27.5 | 0 | 412 | 567 | 1 | 52 | OON14596.1 Ras family protein [Opisthorchis viverrini] | diamond | 5256 | 84.3 | 0.991696322657177 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 30150484 | 30150484 | PRJNA906294_P_NODE_142092_length_323_cov_1.632000_g137976_i0 | PRJNA906294 | 142092 | 323 | 1.632 | 5.27136 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 90.1 | 2.13e-18 | NR | VDM17892.1 | 6205 | g137976 | i0 | 51.6 | 2.58204334365325 | 91 | 40 | 84.5 | 1 | 36 | 308 | 30 | 116 | VDM17892.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 834 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 30182269 | 30182269 | PRJNA906294_P_NODE_204412_length_251_cov_1.370787_g200296_i0 | PRJNA906294 | 204412 | 251 | 1.370787 | 3.44067537 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 44.7 | 0.00795 | NR | VDP90632.1 | 27848 | g200296 | i0 | 48.9 | 0.99203187250996006 | 45 | 23 | 53.8 | 0 | 35 | 169 | 47 | 91 | VDP90632.1 unnamed protein product [Echinostoma caproni] | diamond | 249 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 30884931 | 30884931 | PRJNA906294_P_NODE_212494_length_247_cov_1.327586_g208378_i0 | PRJNA906294 | 212494 | 247 | 1.327586 | 3.27913742 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 65.5 | 7.68e-11 | NR | VDD76335.1 | 53468 | g208378 | i0 | 41.1 | 2.7085020242915 | 73 | 43 | 88.7 | 0 | 228 | 10 | 51 | 123 | VDD76335.1 unnamed protein product [Mesocestoides corti] | diamond | 669 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 30909172 | 30909172 | PRJNA906294_P_NODE_234854_length_200_cov_5.181102_g230738_i0 | PRJNA906294 | 234854 | 200 | 5.181102 | 10.362204 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 80.5 | 2.89e-17 | NR | AAC99957.1 | 34504 | g230738 | i0 | 55.4 | 0.975 | 65 | 28 | 97.5 | 1 | 200 | 6 | 36 | 99 | AAC99957.1 cysteine proteinase, partial [Paragonimus westermani] | diamond | 195 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31003908 | 31003908 | PRJNA906294_P_NODE_217314_length_246_cov_0.878613_g213198_i0 | PRJNA906294 | 217314 | 246 | 0.878613 | 2.16138798 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 52 | 2.52e-6 | NR | VDP38773.1 | 27848 | g213198 | i0 | 51.9 | 0.634146341463415 | 52 | 25 | 63.4 | 0 | 238 | 83 | 8 | 59 | VDP38773.1 unnamed protein product [Echinostoma caproni] | diamond | 156 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 31105980 | 31105980 | PRJNA906294_P_NODE_113155_length_379_cov_1.601307_g109040_i0 | PRJNA906294 | 113155 | 379 | 1.601307 | 6.06895353 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 99 | 2.26e-21 | NR | GAA33604.2 | 79923 | g109040 | i0 | 49.5 | 9.3957783641161 | 101 | 48 | 79.9 | 1 | 10 | 312 | 342 | 439 | GAA33604.2 UDP-N-acetylglucosamine transporter [Clonorchis sinensis] | diamond | 3561 | 99.4 | 0.995975855130785 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 31129841 | 31129841 | PRJNA906294_P_NODE_169975_length_286_cov_1.741784_g165859_i0 | PRJNA906294 | 169975 | 286 | 1.741784 | 4.98150224 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 51.2 | 6.34e-5 | NR | PAA86220.1 | 282301 | g165859 | i0 | 27.1 | 1.84615384615385 | 96 | 69 | 99.7 | 1 | 2 | 286 | 115 | 210 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 528 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31580580 | 31580580 | PRJNA906294_P_NODE_91956_length_443_cov_1.305405_g87842_i0 | PRJNA906294 | 91956 | 443 | 1.305405 | 5.78294415 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 3.83e-29 | NR | KAH9281367.1 | 6210 | g87842 | i0 | 41.1 | 16.5711060948081 | 141 | 81 | 95.5 | 1 | 427 | 5 | 4386 | 4524 | KAH9281367.1 Dynein beta chain, ciliary [Echinococcus granulosus] | diamond | 7341 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31959981 | 31959981 | PRJNA906294_P_NODE_206277_length_250_cov_0.870056_g202161_i0 | PRJNA906294 | 206277 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 48.5 | 5.57e-5 | NR | KAA0199848.1 | 27845 | g202161 | i0 | 30.5 | 1.38 | 59 | 40 | 70.8 | 1 | 4 | 180 | 41 | 98 | KAA0199848.1 hypothetical protein FBUS_07349 [Fasciolopsis buskii] | diamond | 345 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 32079009 | 32079009 | PRJNA906294_P_NODE_142878_length_322_cov_1.236948_g138762_i0 | PRJNA906294 | 142878 | 322 | 1.236948 | 3.98297256 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 46.2 | 0.00541 | NR | PAA93605.1 | 282301 | g138762 | i0 | 42.6 | 2.59006211180124 | 54 | 26 | 50.3 | 1 | 89 | 250 | 386 | 434 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 834 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32718708 | 32718708 | PRJNA906294_P_NODE_217580_length_246_cov_0.867052_g213464_i0 | PRJNA906294 | 217580 | 246 | 0.867052 | 2.13294792 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 108 | 3.4600000000000005e-27 | NR | AAX27256.2 | 6182 | g213464 | i0 | 68.1 | 29.5487804878049 | 72 | 23 | 87.8 | 0 | 1 | 216 | 150 | 221 | AAX27256.2 SJCHGC03496 protein, partial [Schistosoma japonicum] | diamond | 7269 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;