contig_metadata
19 rows where bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2069862 | 2069862 | PRJNA799842_P_NODE_173622_length_244_cov_0.900585_g172049_i0 | PRJNA799842 | 173622 | 244 | 0.900585 | 2.1974274 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|2318760655|ref|XM_051209955.1| | 6185 | g172049 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 200 | 227 | 1694 | 1721 | Schistosoma haematobium uncharacterized protein (MS3_00002383), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 4622748 | 4622748 | PRJNA799842_P_NODE_19004_length_695_cov_6.567524_g17514_i0 | PRJNA799842 | 19004 | 695 | 6.567524 | 45.6442918 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 231 | 8.299999999999998e-56 | NTclustered | gi|326417553|gb|HM204940.1| | 6161 | g17514 | i0 | 78.393 | 6.94244604316547 | 361 | 74 | 52 | 4 | 35 | 393 | 1 | 359 | Dugesia japonica Rho2 GTPase mRNA, complete cds | blastn | 4825 | 233 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 10998938 | 10998938 | PRJNA799842_P_NODE_4809_length_1385_cov_2.878049_g4103_i0 | PRJNA799842 | 4809 | 1385 | 2.878049 | 39.86097865 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 587 | 1.41e-203 | NR | VUZ55328.1 | 6216 | g4103 | i0 | 64.4 | 125.852707581227 | 432 | 149 | 92.9 | 2 | 1383 | 97 | 49 | 478 | VUZ55328.1 unnamed protein product [Hymenolepis diminuta] | diamond | 174306 | 587 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 25022674 | 25022674 | PRJNA799842_P_NODE_9680_length_1007_cov_61.821199_g8528_i1 | PRJNA799842 | 9680 | 1007 | 61.821199 | 622.53947393 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 257 | 4.33e-80 | NR | VDL97057.1 | 70667 | g8528 | i1 | 43.1 | 12.3396226415094 | 318 | 162 | 90.6 | 7 | 914 | 3 | 23 | 335 | VDL97057.1 unnamed protein product [Schistocephalus solidus] | diamond | 12426 | 258 | 0.996124031007752 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 26809909 | 26809909 | PRJNA799842_P_NODE_30401_length_527_cov_1.682819_g28839_i0 | PRJNA799842 | 30401 | 527 | 1.682819 | 8.86845613 | Fasciolidae | 27843 | Platyhelminthes | Platyhelminthes | 109 | 3.9e-25 | NR | KAA0184147.1 | 27845 | g28839 | i0 | 39.7 | 4.47438330170778 | 131 | 77 | 74 | 2 | 396 | 7 | 27 | 156 | KAA0184147.1 5'-amp-activated protein kinase gamma-2 non-catalytic subunit transcript variant 2 [Fasciolopsis buskii] | diamond | 2358 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 26927451 | 26927451 | PRJNA799842_P_NODE_172342_length_244_cov_0.900585_g170769_i0 | PRJNA799842 | 172342 | 244 | 0.900585 | 2.1974274 | Dibothriocephalus latus | 60516 | Platyhelminthes | Platyhelminthes | 60.8 | 1.19e-9 | NR | VDN08985.1 | 60516 | g170769 | i0 | 38 | 1.94262295081967 | 79 | 38 | 89.8 | 3 | 19 | 237 | 26 | 99 | VDN08985.1 unnamed protein product [Dibothriocephalus latus] | diamond | 474 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 27505591 | 27505591 | PRJNA799842_P_NODE_91923_length_302_cov_2.689956_g90350_i0 | PRJNA799842 | 91923 | 302 | 2.689956 | 8.12366712 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84.7 | 2.77e-18 | NR | VUZ41626.1 | 6216 | g90350 | i0 | 43.4 | 5.58278145695364 | 113 | 39 | 90.4 | 2 | 2 | 274 | 45 | 154 | VUZ41626.1 unnamed protein product [Hymenolepis diminuta] | diamond | 1686 | 85.1 | 0.995299647473561 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 27695130 | 27695130 | PRJNA799842_P_NODE_8284_length_1087_cov_2.832347_g7277_i0 | PRJNA799842 | 8284 | 1087 | 2.832347 | 30.78761189 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 75.5 | 3.75e-11 | NR | XP_018651719.1 | 6183 | g7277 | i0 | 23.9 | 7.48482060717571 | 289 | 207 | 76.4 | 6 | 966 | 136 | 21 | 308 | XP_018651719.1 putative annexin [Schistosoma mansoni] | diamond | 8136 | 75.9 | 0.994729907773386 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 27726863 | 27726863 | PRJNA799842_P_NODE_6584_length_1212_cov_2.131694_g5705_i0 | PRJNA799842 | 6584 | 1212 | 2.131694 | 25.83613128 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 319 | 9.52e-97 | NR | VZI39082.1 | 99802 | g5705 | i0 | 59.3 | 23.0693069306931 | 253 | 103 | 62.6 | 0 | 1212 | 454 | 186 | 438 | VZI39082.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 27960 | 319 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27780699 | 27780699 | PRJNA799842_P_NODE_151484_length_248_cov_0.880000_g149911_i0 | PRJNA799842 | 151484 | 248 | 0.88 | 2.1824 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 49.3 | 1.96e-4 | NR | VZI24942.1 | 99802 | g149911 | i0 | 60.5 | 0.459677419354839 | 38 | 15 | 46 | 0 | 115 | 2 | 839 | 876 | VZI24942.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 114 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27821307 | 27821307 | PRJNA799842_P_NODE_46184_length_418_cov_2.231884_g44611_i0 | PRJNA799842 | 46184 | 418 | 2.231884 | 9.32927512 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 122 | 3.5e-29 | NR | TNN09009.1 | 6182 | g44611 | i0 | 51.7 | 20.4688995215311 | 120 | 55 | 86.1 | 2 | 362 | 3 | 347 | 463 | TNN09009.1 TBC1 domain family member 9 [Schistosoma japonicum] | diamond | 8556 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27947491 | 27947491 | PRJNA799842_P_NODE_67385_length_348_cov_1.040000_g65812_i0 | PRJNA799842 | 67385 | 348 | 1.04 | 3.6192 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 91.7 | 6.9e-20 | NR | KAA0187197.1 | 27845 | g65812 | i0 | 40.2 | 11.0603448275862 | 92 | 55 | 79.3 | 0 | 72 | 347 | 55 | 146 | KAA0187197.1 Serine/threonine-protein kinase PAK 1 [Fasciolopsis buskii] | diamond | 3849 | 92.4 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 28073634 | 28073634 | PRJNA799842_P_NODE_2845_length_1681_cov_18.000622_g2342_i0 | PRJNA799842 | 2845 | 1681 | 18.000622 | 302.59045582 | Hymenolepididae | 6214 | Platyhelminthes | Platyhelminthes | 113 | 3.28e-25 | NR | CDS26983.2 | 85433 | g2342 | i0 | 42.5 | 0.580011897679952 | 160 | 73 | 27.5 | 3 | 1648 | 1187 | 2 | 148 | CDS26983.2 RNA and export factor binding protein 2 [Hymenolepis microstoma] | diamond | 975 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 28538571 | 28538571 | PRJNA799842_P_NODE_158687_length_247_cov_0.885057_g157114_i0 | PRJNA799842 | 158687 | 247 | 0.885057 | 2.18609079 | Paragonimus skrjabini miyazakii | 59628 | Platyhelminthes | Platyhelminthes | 51.2 | 3.52e-5 | NR | KAF7253001.1 | 59628 | g157114 | i0 | 38.4 | 1.77327935222672 | 73 | 39 | 86.2 | 2 | 2 | 214 | 164 | 232 | KAF7253001.1 hypothetical protein EG68_09847, partial [Paragonimus skrjabini miyazakii] | diamond | 438 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 29990928 | 29990928 | PRJNA799842_P_NODE_42051_length_440_cov_0.831063_g40480_i0 | PRJNA799842 | 42051 | 440 | 0.831063 | 3.6566772 | Paragonimus heterotremus | 100268 | Platyhelminthes | Platyhelminthes | 67.8 | 5.79e-10 | NR | KAF5401863.1 | 100268 | g40480 | i0 | 35.9 | 1.82727272727273 | 128 | 75 | 87.3 | 4 | 440 | 57 | 300 | 420 | KAF5401863.1 hypothetical protein PHET_04704 [Paragonimus heterotremus] | diamond | 804 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus heterotremus | |
| 30031488 | 30031488 | PRJNA799842_P_NODE_158631_length_247_cov_0.885057_g157058_i0 | PRJNA799842 | 158631 | 247 | 0.885057 | 2.18609079 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 45.1 | 0.00556 | NR | RTG89701.1 | 6184 | g157058 | i0 | 70.4 | 1.96761133603239 | 27 | 8 | 32.8 | 0 | 83 | 3 | 156 | 182 | RTG89701.1 T-box protein 1 [Schistosoma bovis] | diamond | 486 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 30085549 | 30085549 | PRJNA799842_P_NODE_75872_length_330_cov_1.046693_g74299_i0 | PRJNA799842 | 75872 | 330 | 1.046693 | 3.4540869 | Trichobilharzia szidati | 157070 | Platyhelminthes | Platyhelminthes | 70.9 | 9.16e-12 | NR | CAH8872033.1 | 157070 | g74299 | i0 | 44.4 | 0.818181818181818 | 90 | 50 | 81.8 | 0 | 272 | 3 | 25 | 114 | CAH8872033.1 unnamed protein product [Trichobilharzia szidati] | diamond | 270 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 32393650 | 32393650 | PRJNA799842_P_NODE_87039_length_310_cov_1.704641_g85466_i0 | PRJNA799842 | 87039 | 310 | 1.704641 | 5.2843871 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 62.8 | 7.79e-9 | NR | CAL5136495.1 | 300641 | g85466 | i0 | 48.2 | 3.50322580645161 | 56 | 29 | 54.2 | 0 | 1 | 168 | 405 | 460 | CAL5136495.1 unnamed protein product [Calicophoron daubneyi] | diamond | 1086 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 32740925 | 32740925 | PRJNA799842_P_NODE_49640_length_403_cov_1.545455_g48067_i0 | PRJNA799842 | 49640 | 403 | 1.545455 | 6.22818365 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 163 | 3.91e-44 | NR | VDM04108.1 | 70667 | g48067 | i0 | 59.4 | 5.95533498759305 | 133 | 54 | 99 | 0 | 401 | 3 | 484 | 616 | VDM04108.1 unnamed protein product [Schistocephalus solidus] | diamond | 2400 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus |
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);;