contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA951388" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4763111 | 4763111 | PRJNA951388_S_NODE_4784_length_382_cov_9.330097_g4657_i0 | PRJNA951388 | 4784 | 382 | 9.330097 | 35.64097054 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 67 | 1.53e-11 | NR | CAH8438363.1 | 57078 | g4657 | i0 | 44.1 | 0.534031413612565 | 68 | 38 | 53.4 | 0 | 300 | 97 | 18 | 85 | CAH8438363.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 204 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 4763126 | 4763126 | PRJNA951388_S_NODE_8604_length_287_cov_2.158879_g8477_i0 | PRJNA951388 | 8604 | 287 | 2.158879 | 6.19598273 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 143 | 3.4099999999999996e-37 | NR | BAF63023.1 | 6161 | g8477 | i0 | 71.3 | 58.4216027874564 | 94 | 27 | 98.3 | 0 | 283 | 2 | 425 | 518 | BAF63023.1 clathrin heavy chain [Dugesia japonica] | diamond | 16767 | 144 | 0.993055555555556 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 8587739 | 8587739 | PRJNA951388_S_NODE_867_length_687_cov_2.522801_g753_i0 | PRJNA951388 | 867 | 687 | 2.522801 | 17.33164287 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 333 | 3.58e-108 | NR | KAH8873838.1 | 6182 | g753 | i0 | 66.5 | 231.248908296943 | 227 | 75 | 98.7 | 1 | 681 | 4 | 177 | 403 | KAH8873838.1 Serine/threonine-protein phosphatase 2B catalytic subunit beta isoform [Schistosoma japonicum] | diamond | 158868 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9862766 | 9862766 | PRJNA951388_S_NODE_628_length_768_cov_2.853237_g520_i0 | PRJNA951388 | 628 | 768 | 2.853237 | 21.91286016 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 201 | 7.719999999999999e-57 | NR | KAL3319068.1 | 1844966 | g520 | i0 | 45.1 | 1.92578125 | 246 | 132 | 94.9 | 2 | 37 | 765 | 50 | 295 | KAL3319068.1 Pre-mRNA-processing factor 19 [Cichlidogyrus casuarinus] | diamond | 1479 | 201 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 11138409 | 11138409 | PRJNA951388_S_NODE_7269_length_315_cov_6.033058_g7142_i0 | PRJNA951388 | 7269 | 315 | 6.033058 | 19.0041327 | Cestoda | 6199 | Platyhelminthes | Platyhelminthes | 77 | 7.83e-14 | NR | CDS29441.1 | 85433 | g7142 | i0 | 35.5 | 2.60952380952381 | 93 | 60 | 88.6 | 0 | 3 | 281 | 564 | 656 | CDS29441.1 glycoprotein N acetylgalactosamine [Hymenolepis microstoma] | diamond | 822 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 21336829 | 21336829 | PRJNA951388_S_NODE_4397_length_394_cov_10.087227_g4270_i0 | PRJNA951388 | 4397 | 394 | 10.087227 | 39.74367438 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 121 | 4.299999999999999e-32 | NR | VDL95202.1 | 70667 | g4270 | i0 | 59.1 | 9.00761421319797 | 115 | 44 | 87.6 | 1 | 376 | 32 | 3 | 114 | VDL95202.1 unnamed protein product [Schistocephalus solidus] | diamond | 3549 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 26620559 | 26620559 | PRJNA951388_S_NODE_10561_length_253_cov_2.133333_g10434_i0 | PRJNA951388 | 10561 | 253 | 2.133333 | 5.39733249 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 130 | 3.5900000000000004e-33 | NR | KAA0194405.1 | 27845 | g10434 | i0 | 68.7 | 20.6798418972332 | 83 | 26 | 98.4 | 0 | 4 | 252 | 296 | 378 | KAA0194405.1 Peptidylprolyl isomerase (Cyclophilin) 2 [Fasciolopsis buskii] | diamond | 5232 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 27246842 | 27246842 | PRJNA951388_S_NODE_4603_length_388_cov_3.193651_g4476_i0 | PRJNA951388 | 4603 | 388 | 3.193651 | 12.39136588 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 91.7 | 3.01e-19 | NR | VZI34023.1 | 99802 | g4476 | i0 | 53.1 | 1.94072164948454 | 81 | 38 | 62.6 | 0 | 1 | 243 | 217 | 297 | VZI34023.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 753 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27278529 | 27278529 | PRJNA951388_S_NODE_4103_length_404_cov_7.870091_g3976_i0 | PRJNA951388 | 4103 | 404 | 7.870091 | 31.79516764 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 73.6 | 1.49e-13 | NR | CAL5130566.1 | 300641 | g3976 | i0 | 34.9 | 2.48019801980198 | 83 | 54 | 61.6 | 0 | 138 | 386 | 44 | 126 | CAL5130566.1 unnamed protein product [Calicophoron daubneyi] | diamond | 1002 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 27721066 | 27721066 | PRJNA951388_S_NODE_5024_length_374_cov_5.116279_g4897_i0 | PRJNA951388 | 5024 | 374 | 5.116279 | 19.13488346 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 124 | 1.08e-31 | NR | VDL97057.1 | 70667 | g4897 | i0 | 50.5 | 0.890374331550802 | 111 | 53 | 87.4 | 1 | 3 | 329 | 227 | 337 | VDL97057.1 unnamed protein product [Schistocephalus solidus] | diamond | 333 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 28642966 | 28642966 | PRJNA951388_S_NODE_4947_length_377_cov_1.266447_g4820_i0 | PRJNA951388 | 4947 | 377 | 1.266447 | 4.77450519 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 139 | 2.29e-36 | NR | CAX72343.1 | 6182 | g4820 | i0 | 56.5 | 22.9814323607427 | 115 | 50 | 91.5 | 0 | 33 | 377 | 62 | 176 | CAX72343.1 cathepsin D (lysosomal aspartyl protease) [Schistosoma japonicum] | diamond | 8664 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28667964 | 28667964 | PRJNA951388_S_NODE_10367_length_256_cov_1.524590_g10240_i0 | PRJNA951388 | 10367 | 256 | 1.52459 | 3.9029504 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 97.4 | 2.18e-24 | NR | KAA0187444.1 | 27845 | g10240 | i0 | 63.5 | 2.21484375 | 63 | 23 | 73.8 | 0 | 253 | 65 | 20 | 82 | KAA0187444.1 Transcription elongation factor 1 [Fasciolopsis buskii] | diamond | 567 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 28706077 | 28706077 | PRJNA951388_S_NODE_7527_length_309_cov_3.190678_g7400_i0 | PRJNA951388 | 7527 | 309 | 3.190678 | 9.85919502 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 115 | 1.41e-28 | NR | PAA62541.1 | 282301 | g7400 | i0 | 46.6 | 5.66019417475728 | 103 | 43 | 100 | 1 | 309 | 1 | 222 | 312 | PAA62541.1 hypothetical protein BOX15_Mlig015028g1, partial [Macrostomum lignano] | diamond | 1749 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28863737 | 28863737 | PRJNA951388_S_NODE_6228_length_340_cov_2.644195_g6101_i0 | PRJNA951388 | 6228 | 340 | 2.644195 | 8.990263 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 44.3 | 0.00844 | NR | VDM30740.1 | 6205 | g6101 | i0 | 41.2 | 2.33823529411765 | 51 | 30 | 45 | 0 | 165 | 317 | 65 | 115 | VDM30740.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 795 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29362535 | 29362535 | PRJNA951388_S_NODE_7749_length_304_cov_4.536797_g7622_i0 | PRJNA951388 | 7749 | 304 | 4.536797 | 13.79186288 | Schistosoma turkestanicum | 1163369 | Platyhelminthes | Platyhelminthes | 86.3 | 2.1e-17 | NR | CAH8572382.1 | 1163369 | g7622 | i0 | 45.5 | 1.65789473684211 | 88 | 48 | 86.8 | 0 | 299 | 36 | 274 | 361 | CAH8572382.1 unnamed protein product [Schistosoma turkestanicum] | diamond | 504 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma turkestanicum | |
| 29369034 | 29369034 | PRJNA951388_S_NODE_709_length_734_cov_6.086233_g598_i0 | PRJNA951388 | 709 | 734 | 6.086233 | 44.67295022 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 92 | 1.77e-17 | NR | CAI2729993.1 | 6189 | g598 | i0 | 50 | 4.00953678474114 | 98 | 46 | 38.8 | 1 | 54 | 338 | 64 | 161 | CAI2729993.1 unnamed protein product [Schistosoma spindalis] | diamond | 2943 | 92.8 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma spindalis | |
| 29621118 | 29621118 | PRJNA951388_S_NODE_2830_length_459_cov_6.435233_g2703_i0 | PRJNA951388 | 2830 | 459 | 6.435233 | 29.53771947 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 140 | 5.46e-37 | NR | PAA70965.1 | 282301 | g2703 | i0 | 53.7 | 6.22875816993464 | 136 | 63 | 88.9 | 0 | 4 | 411 | 218 | 353 | PAA70965.1 hypothetical protein BOX15_Mlig022180g1 [Macrostomum lignano] | diamond | 2859 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30436619 | 30436619 | PRJNA951388_S_NODE_5633_length_357_cov_2.503521_g5506_i0 | PRJNA951388 | 5633 | 357 | 2.503521 | 8.93756997 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 89.7 | 4.72e-18 | NR | KAA0183881.1 | 27845 | g5506 | i0 | 39.8 | 2.84873949579832 | 113 | 68 | 95 | 0 | 340 | 2 | 662 | 774 | KAA0183881.1 Annexin [Fasciolopsis buskii] | diamond | 1017 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 30468225 | 30468225 | PRJNA951388_S_NODE_9433_length_271_cov_3.762626_g9306_i0 | PRJNA951388 | 9433 | 271 | 3.762626 | 10.19671646 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 84.3 | 3.49e-18 | NR | CDS33558.1 | 85433 | g9306 | i0 | 42.2 | 9.43173431734317 | 83 | 48 | 91.9 | 0 | 1 | 249 | 72 | 154 | CDS33558.1 expressed protein [Hymenolepis microstoma] | diamond | 2556 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 31106277 | 31106277 | PRJNA951388_S_NODE_2655_length_468_cov_20.875949_g2528_i0 | PRJNA951388 | 2655 | 468 | 20.875949 | 97.69944132 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 186 | 1.49e-56 | NR | KAH9284319.1 | 6210 | g2528 | i0 | 80.8 | 6.15384615384615 | 120 | 23 | 76.9 | 0 | 467 | 108 | 98 | 217 | KAH9284319.1 40S ribosomal protein S5 [Echinococcus granulosus] | diamond | 2880 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31858731 | 31858731 | PRJNA951388_S_NODE_8437_length_290_cov_5.276498_g8310_i0 | PRJNA951388 | 8437 | 290 | 5.276498 | 15.3018442 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 52 | 3.47e-5 | NR | THD25758.1 | 6192 | g8310 | i0 | 32.3 | 2.86551724137931 | 99 | 56 | 96.2 | 2 | 281 | 3 | 323 | 416 | THD25758.1 AP-3 complex subunit mu-1 [Fasciola hepatica] | diamond | 831 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 32112009 | 32112009 | PRJNA951388_S_NODE_9818_length_264_cov_3.926702_g9691_i0 | PRJNA951388 | 9818 | 264 | 3.926702 | 10.36649328 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 46.6 | 0.00191 | NR | VDP91799.1 | 27848 | g9691 | i0 | 46.5 | 0.488636363636364 | 43 | 23 | 48.9 | 0 | 117 | 245 | 143 | 185 | VDP91799.1 unnamed protein product [Echinostoma caproni] | diamond | 129 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni |
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);;