contig_metadata
27 rows where bioproject = "PRJNA407087" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15717630 | 15717630 | PRJNA407087_S_NODE_1973_length_469_cov_65.850000_g1523_i0 | PRJNA407087 | 1973 | 469 | 65.85 | 308.8365 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 739 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g1523 | i0 | 97.045 | 0.93816631130064 | 440 | 12 | 94 | 1 | 2 | 441 | 450 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 440 | 739 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 16992454 | 16992454 | PRJNA407087_S_NODE_1954_length_471_cov_50.545249_g1504_i0 | PRJNA407087 | 1954 | 471 | 50.545249 | 238.06812279 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 627 | 5.98e-175 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g1504 | i0 | 93.602 | 0.895966029723992 | 422 | 24 | 89 | 3 | 24 | 443 | 432 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 422 | 627 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26790728 | 26790728 | PRJNA407087_S_NODE_7001_length_186_cov_1.751592_g6538_i0 | PRJNA407087 | 7001 | 186 | 1.751592 | 3.25796112 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 84 | 5.38e-17 | NR | CAH8624195.1 | 39320 | g6538 | i0 | 54.8 | 2.98387096774194 | 62 | 28 | 100 | 0 | 1 | 186 | 485 | 546 | CAH8624195.1 unnamed protein product [Heterobilharzia americana] | diamond | 555 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 26839230 | 26839230 | PRJNA407087_S_NODE_4621_length_249_cov_5.009091_g4158_i0 | PRJNA407087 | 4621 | 249 | 5.009091 | 12.47263659 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 94.4 | 2.74e-20 | NR | VDM32501.1 | 6205 | g4158 | i0 | 54.2 | 24.9759036144578 | 83 | 36 | 97.6 | 1 | 6 | 248 | 569 | 651 | VDM32501.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 6219 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 26854185 | 26854185 | PRJNA407087_S_NODE_2861_length_365_cov_10.392857_g2399_i0 | PRJNA407087 | 2861 | 365 | 10.392857 | 37.93392805 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 44.7 | 0.0285 | NR | PAA74793.1 | 282301 | g2399 | i0 | 44.2 | 0.863013698630137 | 43 | 24 | 35.3 | 0 | 158 | 30 | 177 | 219 | PAA74793.1 hypothetical protein BOX15_Mlig014438g2, partial [Macrostomum lignano] | diamond | 315 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27138212 | 27138212 | PRJNA407087_S_NODE_1702_length_511_cov_8.286307_g1269_i0 | PRJNA407087 | 1702 | 511 | 8.286307 | 42.34302877 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 45.8 | 0.0369 | NR | PAA74793.1 | 282301 | g1269 | i0 | 38.1 | 0.36986301369863 | 63 | 37 | 35.8 | 1 | 355 | 173 | 177 | 239 | PAA74793.1 hypothetical protein BOX15_Mlig014438g2, partial [Macrostomum lignano] | diamond | 189 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27138221 | 27138221 | PRJNA407087_S_NODE_4162_length_270_cov_3.311203_g3699_i0 | PRJNA407087 | 4162 | 270 | 3.311203 | 8.9402481 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 61.6 | 1.11e-8 | NR | PAA93605.1 | 282301 | g3699 | i0 | 38.8 | 0.944444444444444 | 85 | 50 | 94.4 | 2 | 259 | 5 | 334 | 416 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 255 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27391686 | 27391686 | PRJNA407087_S_NODE_5643_length_214_cov_3.945946_g5180_i0 | PRJNA407087 | 5643 | 214 | 3.945946 | 8.44432444 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 51.6 | 1.89e-5 | NR | PAA93605.1 | 282301 | g5180 | i0 | 43.6 | 1.54205607476636 | 55 | 30 | 77.1 | 1 | 166 | 2 | 362 | 415 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 330 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27565926 | 27565926 | PRJNA407087_S_NODE_7044_length_185_cov_2.115385_g6581_i0 | PRJNA407087 | 7044 | 185 | 2.115385 | 3.91346225 | Fasciolidae | 27843 | Platyhelminthes | Platyhelminthes | 68.9 | 2.52e-12 | NR | THD26413.1 | 6192 | g6581 | i0 | 55.7 | 1.97837837837838 | 61 | 25 | 95.7 | 1 | 184 | 8 | 15 | 75 | THD26413.1 Glutathione S-transferase Mu [Fasciola hepatica] | diamond | 366 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 27580887 | 27580887 | PRJNA407087_S_NODE_5464_length_219_cov_2.526316_g5001_i0 | PRJNA407087 | 5464 | 219 | 2.526316 | 5.53263204 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 62 | 2.15e-10 | NR | KAA0191485.1 | 27845 | g5001 | i0 | 60 | 1.6027397260274 | 40 | 16 | 54.8 | 0 | 4 | 123 | 63 | 102 | KAA0191485.1 Ubiquitin-fold modifier [Fasciolopsis buskii] | diamond | 351 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 28450331 | 28450331 | PRJNA407087_S_NODE_5706_length_213_cov_2.070652_g5243_i0 | PRJNA407087 | 5706 | 213 | 2.070652 | 4.41048876 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0126 | NR | RTG81988.1 | 6184 | g5243 | i0 | 68 | 2.8169014084507 | 25 | 8 | 35.2 | 0 | 4 | 78 | 228 | 252 | RTG81988.1 vacuolar protein-sorting-associated protein 4, partial [Schistosoma bovis] | diamond | 600 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 28906849 | 28906849 | PRJNA407087_S_NODE_4428_length_258_cov_2.982533_g3965_i0 | PRJNA407087 | 4428 | 258 | 2.982533 | 7.69493514 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 64.3 | 1.12e-9 | NR | PAA93605.1 | 282301 | g3965 | i0 | 42 | 1.6046511627907 | 69 | 39 | 80.2 | 1 | 210 | 4 | 362 | 429 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 414 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28923616 | 28923616 | PRJNA407087_S_NODE_5988_length_206_cov_2.790960_g5525_i0 | PRJNA407087 | 5988 | 206 | 2.79096 | 5.7493776 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 2.08e-29 | NR | RTG87242.1 | 6184 | g5525 | i0 | 77.9 | 50.504854368932 | 68 | 15 | 99 | 0 | 206 | 3 | 33 | 100 | RTG87242.1 26S proteasome regulatory subunit T2 [Schistosoma bovis] | diamond | 10404 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 28938745 | 28938745 | PRJNA407087_S_NODE_1008_length_709_cov_3.855882_g665_i0 | PRJNA407087 | 1008 | 709 | 3.855882 | 27.33820338 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 75.1 | 1.75e-11 | NR | CDS26013.2 | 85433 | g665 | i0 | 36.4 | 3.93088857545839 | 118 | 59 | 46.5 | 2 | 1 | 330 | 230 | 339 | CDS26013.2 polyadenylate binding protein [Hymenolepis microstoma] | diamond | 2787 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 29002230 | 29002230 | PRJNA407087_S_NODE_2648_length_386_cov_7.913165_g2187_i0 | PRJNA407087 | 2648 | 386 | 7.913165 | 30.5448169 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 53.9 | 2.08e-5 | NR | PAA93605.1 | 282301 | g2187 | i0 | 29.4 | 1.69430051813472 | 109 | 71 | 84.7 | 2 | 375 | 49 | 332 | 434 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 654 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29159853 | 29159853 | PRJNA407087_S_NODE_2169_length_444_cov_18.284337_g1709_i0 | PRJNA407087 | 2169 | 444 | 18.284337 | 81.18245628 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 68.6 | 1.61e-11 | NR | PAA82696.1 | 282301 | g1709 | i0 | 25.8 | 0.837837837837838 | 124 | 89 | 83.8 | 1 | 12 | 383 | 5 | 125 | PAA82696.1 hypothetical protein BOX15_Mlig024657g1, partial [Macrostomum lignano] | diamond | 372 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29492064 | 29492064 | PRJNA407087_S_NODE_7670_length_175_cov_4.801370_g7207_i0 | PRJNA407087 | 7670 | 175 | 4.80137 | 8.4023975 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.9 | 9.58e-11 | NR | THD22513.1 | 6192 | g7207 | i0 | 52.7 | 9.70285714285714 | 55 | 26 | 94.3 | 0 | 2 | 166 | 276 | 330 | THD22513.1 GDP-mannose pyrophosphorylase [Fasciola hepatica] | diamond | 1698 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 29664473 | 29664473 | PRJNA407087_S_NODE_330_length_1306_cov_11.637431_g205_i0 | PRJNA407087 | 330 | 1306 | 11.637431 | 151.98484886 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 99.4 | 1.73e-18 | NR | PAA86220.1 | 282301 | g205 | i0 | 32.9 | 0.369831546707504 | 161 | 107 | 36.8 | 1 | 636 | 157 | 76 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 483 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29854361 | 29854361 | PRJNA407087_S_NODE_1411_length_584_cov_7.475676_g1005_i0 | PRJNA407087 | 1411 | 584 | 7.475676 | 43.65794784 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 49.7 | 0.00287 | NR | PAA74793.1 | 282301 | g1005 | i0 | 36 | 0.38527397260274 | 75 | 46 | 37.5 | 1 | 428 | 210 | 177 | 251 | PAA74793.1 hypothetical protein BOX15_Mlig014438g2, partial [Macrostomum lignano] | diamond | 225 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30106934 | 30106934 | PRJNA407087_S_NODE_632_length_942_cov_16.703176_g396_i0 | PRJNA407087 | 632 | 942 | 16.703176 | 157.34391792 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 285 | 6.480000000000001e-91 | NR | PAA60767.1 | 282301 | g396 | i0 | 50.5 | 5.26433121019108 | 283 | 130 | 89.2 | 6 | 101 | 940 | 58 | 333 | PAA60767.1 hypothetical protein BOX15_Mlig033947g1, partial [Macrostomum lignano] | diamond | 4959 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30376902 | 30376902 | PRJNA407087_S_NODE_592_length_974_cov_10.736508_g367_i0 | PRJNA407087 | 592 | 974 | 10.736508 | 104.57358792 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 57.4 | 4.39e-5 | NR | KAA0197776.1 | 27845 | g367 | i0 | 20.2 | 2.45482546201232 | 262 | 190 | 79.2 | 6 | 167 | 937 | 73 | 320 | KAA0197776.1 Disulfide isomerase [Fasciolopsis buskii] | diamond | 2391 | 57.8 | 0.993079584775087 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 31609195 | 31609195 | PRJNA407087_S_NODE_10056_length_150_cov_2.388430_g9593_i0 | PRJNA407087 | 10056 | 150 | 2.38843 | 3.582645 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 90.9 | 2.92e-20 | NR | THD18209.1 | 6192 | g9593 | i0 | 75.5 | 14.38 | 49 | 12 | 98 | 0 | 148 | 2 | 257 | 305 | THD18209.1 Cathepsin B endopeptidase [Fasciola hepatica] | diamond | 2157 | 91.3 | 0.995618838992333 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 32035315 | 32035315 | PRJNA407087_S_NODE_5398_length_221_cov_2.578125_g4935_i0 | PRJNA407087 | 5398 | 221 | 2.578125 | 5.69765625 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 53.1 | 5.24e-6 | NR | KAL3314329.1 | 1844966 | g4935 | i0 | 40.7 | 4.39819004524887 | 54 | 32 | 73.3 | 0 | 169 | 8 | 96 | 149 | KAL3314329.1 hypothetical protein Ciccas_007056 [Cichlidogyrus casuarinus] | diamond | 972 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 32210280 | 32210280 | PRJNA407087_S_NODE_2378_length_417_cov_3.677835_g1917_i0 | PRJNA407087 | 2378 | 417 | 3.677835 | 15.33657195 | Opisthorchiidae | 6196 | Platyhelminthes | Platyhelminthes | 80.5 | 1.68e-14 | NR | OON14924.1 | 6198 | g1917 | i0 | 34.5 | 6.05755395683453 | 139 | 80 | 94.2 | 3 | 397 | 5 | 623 | 758 | OON14924.1 HEAT repeat protein [Opisthorchis viverrini] | diamond | 2526 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 32573440 | 32573440 | PRJNA407087_S_NODE_339_length_1289_cov_28.184921_g210_i0 | PRJNA407087 | 339 | 1289 | 28.184921 | 363.30363169 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 99.8 | 1.2e-18 | NR | PAA86220.1 | 282301 | g210 | i0 | 31.7 | 0.374709076803724 | 161 | 109 | 37.2 | 1 | 632 | 153 | 76 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 483 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32604663 | 32604663 | PRJNA407087_S_NODE_9000_length_159_cov_2.876923_g8537_i0 | PRJNA407087 | 9000 | 159 | 2.876923 | 4.57430757 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 41.2 | 0.0419 | NR | CAL5140211.1 | 300641 | g8537 | i0 | 41.2 | 0.962264150943396 | 51 | 25 | 96.2 | 1 | 155 | 3 | 284 | 329 | CAL5140211.1 unnamed protein product [Calicophoron daubneyi] | diamond | 153 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 32652493 | 32652493 | PRJNA407087_S_NODE_9040_length_159_cov_2.046154_g8577_i0 | PRJNA407087 | 9040 | 159 | 2.046154 | 3.25338486 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 98.6 | 2e-22 | NR | CAH8636691.1 | 57078 | g8577 | i0 | 80.8 | 4.88679245283019 | 52 | 10 | 98.1 | 0 | 3 | 158 | 401 | 452 | CAH8636691.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 777 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;