contig_metadata
22 rows where bioproject = "PRJNA1248424", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2903745 | 2903745 | PRJNA1248424_P_NODE_56663_length_284_cov_1.417062_g50595_i0 | PRJNA1248424 | 56663 | 284 | 1.417062 | 4.02445608 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|687175187|emb|LN100089.1| | 99802 | g50595 | i0 | 100 | 0.200704225352113 | 29 | 0 | 10 | 0 | 131 | 159 | 578 | 550 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0094803 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 2904024 | 2904024 | PRJNA1248424_P_NODE_70363_length_250_cov_0.870056_g64294_i0 | PRJNA1248424 | 70363 | 250 | 0.870056 | 2.17514 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 52.8 | 0.023 | NTclustered | gi|60701501|gb|AY915894.1| | 6182 | g64294 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 12 | 39 | 337 | 364 | Schistosoma japonicum SJCHGC09830 protein mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6730500 | 6730500 | PRJNA1248424_P_NODE_46066_length_330_cov_1.945525_g40002_i0 | PRJNA1248424 | 46066 | 330 | 1.945525 | 6.4202325 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.031 | NTclustered | gi|690670154|emb|LN220880.1| | 99802 | g40002 | i0 | 88.372 | 0.3 | 43 | 5 | 13 | 0 | 83 | 125 | 156 | 114 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0182358 | blastn | 99 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 22029679 | 22029679 | PRJNA1248424_P_NODE_56298_length_285_cov_1.325472_g50230_i0 | PRJNA1248424 | 56298 | 285 | 1.325472 | 3.7775952 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.026 | NTclustered | gi|687549386|emb|LK635088.1| | 57078 | g50230 | i0 | 100 | 0.0982456140350877 | 28 | 0 | 10 | 0 | 27 | 54 | 612 | 639 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0022428 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26680042 | 26680042 | PRJNA1248424_P_NODE_71101_length_249_cov_1.312500_g65032_i0 | PRJNA1248424 | 71101 | 249 | 1.3125 | 3.268125 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 44.7 | 0.00146 | NR | VDO80586.1 | 48269 | g65032 | i0 | 42.6 | 1.40963855421687 | 61 | 34 | 72.3 | 1 | 249 | 70 | 24 | 84 | VDO80586.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 351 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei | |
| 27042010 | 27042010 | PRJNA1248424_P_NODE_37042_length_403_cov_1.200000_g30986_i0 | PRJNA1248424 | 37042 | 403 | 1.2 | 4.836 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 124 | 2.3699999999999996e-31 | NR | CAH8869896.1 | 157069 | g30986 | i0 | 43.3 | 2.68734491315136 | 120 | 68 | 89.3 | 0 | 3 | 362 | 139 | 258 | CAH8869896.1 unnamed protein product [Trichobilharzia regenti] | diamond | 1083 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 27515976 | 27515976 | PRJNA1248424_P_NODE_43503_length_347_cov_1.324818_g37440_i0 | PRJNA1248424 | 43503 | 347 | 1.324818 | 4.59711846 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 45.8 | 0.00932 | NR | KAA3673705.1 | 34504 | g37440 | i0 | 57.6 | 0.285302593659942 | 33 | 14 | 28.5 | 0 | 132 | 34 | 373 | 405 | KAA3673705.1 uncharacterized protein DEA37_0003356 [Paragonimus westermani] | diamond | 99 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 27705804 | 27705804 | PRJNA1248424_P_NODE_40584_length_368_cov_7.545763_g34523_i0 | PRJNA1248424 | 40584 | 368 | 7.545763 | 27.76840784 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 78.6 | 4.39e-14 | NR | VZH93166.1 | 99802 | g34523 | i0 | 52.2 | 8.47826086956522 | 69 | 33 | 56.3 | 0 | 43 | 249 | 561 | 629 | VZH93166.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 3120 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27849609 | 27849609 | PRJNA1248424_P_NODE_21944_length_773_cov_1.321429_g16225_i0 | PRJNA1248424 | 21944 | 773 | 1.321429 | 10.21464617 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 8.64e-4 | NR | CAH8586644.1 | 6186 | g16225 | i0 | 25.9 | 4.95989650711514 | 201 | 127 | 73 | 8 | 574 | 11 | 668 | 859 | CAH8586644.1 unnamed protein product [Schistosoma curassoni] | diamond | 3834 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni | |
| 27881325 | 27881325 | PRJNA1248424_P_NODE_70325_length_250_cov_0.870056_g64256_i0 | PRJNA1248424 | 70325 | 250 | 0.870056 | 2.17514 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 90.9 | 4.53e-19 | NR | VZI48410.1 | 99802 | g64256 | i0 | 61.2 | 20.076 | 67 | 26 | 80.4 | 0 | 249 | 49 | 266 | 332 | VZI48410.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 5019 | 91.3 | 0.995618838992333 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27989670 | 27989670 | PRJNA1248424_P_NODE_25985_length_617_cov_2.297794_g20016_i0 | PRJNA1248424 | 25985 | 617 | 2.297794 | 14.17738898 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 47.8 | 0.0183 | NR | KAF8560666.1 | 34504 | g20016 | i0 | 40.8 | 0.923824959481361 | 71 | 29 | 31.1 | 3 | 239 | 48 | 518 | 582 | KAF8560666.1 hypothetical protein P879_00606 [Paragonimus westermani] | diamond | 570 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 29459751 | 29459751 | PRJNA1248424_P_NODE_37790_length_395_cov_1.093168_g31733_i0 | PRJNA1248424 | 37790 | 395 | 1.093168 | 4.3180136 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 54.7 | 1.24e-5 | NR | VDL90484.1 | 70667 | g31733 | i0 | 58.1 | 2.28607594936709 | 43 | 18 | 32.7 | 0 | 213 | 341 | 189 | 231 | VDL90484.1 unnamed protein product [Schistocephalus solidus] | diamond | 903 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 29694232 | 29694232 | PRJNA1248424_P_NODE_40250_length_371_cov_1.550336_g34190_i0 | PRJNA1248424 | 40250 | 371 | 1.550336 | 5.75174656 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 110 | 3.1300000000000003e-26 | NR | CAH8846589.1 | 157069 | g34190 | i0 | 43.2 | 1.90835579514825 | 118 | 67 | 95.4 | 0 | 9 | 362 | 219 | 336 | CAH8846589.1 unnamed protein product [Trichobilharzia regenti] | diamond | 708 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 29852542 | 29852542 | PRJNA1248424_P_NODE_46171_length_330_cov_0.883268_g40107_i0 | PRJNA1248424 | 46171 | 330 | 0.883268 | 2.9147844 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 66.2 | 5.59e-10 | NR | VZI19895.1 | 99802 | g40107 | i0 | 45.8 | 2.57272727272727 | 72 | 36 | 62.7 | 1 | 122 | 328 | 386 | 457 | VZI19895.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 849 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 30439411 | 30439411 | PRJNA1248424_P_NODE_18013_length_994_cov_4.017372_g12868_i0 | PRJNA1248424 | 18013 | 994 | 4.017372 | 39.93267768 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 298 | 8.87e-91 | NR | VZH93166.1 | 99802 | g12868 | i0 | 47.6 | 7.10160965794769 | 336 | 166 | 99.9 | 4 | 993 | 1 | 449 | 779 | VZH93166.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 7059 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 30755250 | 30755250 | PRJNA1248424_P_NODE_58894_length_278_cov_2.287805_g52826_i0 | PRJNA1248424 | 58894 | 278 | 2.287805 | 6.3600979 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 54.3 | 4.45e-6 | NR | CAH8507980.1 | 6186 | g52826 | i0 | 38 | 2.16906474820144 | 71 | 43 | 75.5 | 1 | 222 | 13 | 267 | 337 | CAH8507980.1 unnamed protein product [Schistosoma curassoni] | diamond | 603 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni | |
| 31116014 | 31116014 | PRJNA1248424_P_NODE_51835_length_299_cov_5.402655_g45767_i0 | PRJNA1248424 | 51835 | 299 | 5.402655 | 16.15393845 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 53.9 | 2.96e-6 | NR | VDL89574.1 | 70667 | g45767 | i0 | 56.9 | 1.5752508361204 | 51 | 21 | 50.2 | 1 | 155 | 6 | 1 | 51 | VDL89574.1 unnamed protein product [Schistocephalus solidus] | diamond | 471 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 31242580 | 31242580 | PRJNA1248424_P_NODE_81255_length_233_cov_2.318750_g75186_i0 | PRJNA1248424 | 81255 | 233 | 2.31875 | 5.4026875 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 75.5 | 9.49e-14 | NR | CAH8840565.1 | 157069 | g75186 | i0 | 53.9 | 1.96995708154506 | 76 | 35 | 97.9 | 0 | 232 | 5 | 242 | 317 | CAH8840565.1 unnamed protein product [Trichobilharzia regenti] | diamond | 459 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 31369415 | 31369415 | PRJNA1248424_P_NODE_38956_length_383_cov_1.741935_g32896_i0 | PRJNA1248424 | 38956 | 383 | 1.741935 | 6.67161105 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 59.3 | 2.73e-7 | NR | VZI49151.1 | 99802 | g32896 | i0 | 33.8 | 0.556135770234987 | 71 | 47 | 55.6 | 0 | 7 | 219 | 398 | 468 | VZI49151.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 213 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 32350063 | 32350063 | PRJNA1248424_P_NODE_22839_length_732_cov_3.309560_g17046_i0 | PRJNA1248424 | 22839 | 732 | 3.30956 | 24.2259792 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 119 | 2.63e-27 | NR | VZH93430.1 | 99802 | g17046 | i0 | 44.4 | 5.04098360655738 | 153 | 80 | 60.7 | 1 | 562 | 119 | 209 | 361 | VZH93430.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 3690 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 32760253 | 32760253 | PRJNA1248424_P_NODE_42540_length_354_cov_1.032028_g36478_i0 | PRJNA1248424 | 42540 | 354 | 1.032028 | 3.65337912 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 48.1 | 0.00147 | NR | VZI31527.1 | 99802 | g36478 | i0 | 48.9 | 1.83898305084746 | 45 | 20 | 35.6 | 1 | 242 | 117 | 259 | 303 | VZI31527.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 651 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 32886027 | 32886027 | PRJNA1248424_P_NODE_11220_length_1607_cov_13.114733_g2441_i1 | PRJNA1248424 | 11220 | 1607 | 13.114733 | 210.75375931 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 140 | 1.63e-33 | NR | CAH8869896.1 | 157069 | g2441 | i1 | 53.1 | 0.477909147479776 | 128 | 60 | 23.9 | 0 | 585 | 202 | 127 | 254 | CAH8869896.1 unnamed protein product [Trichobilharzia regenti] | diamond | 768 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti |
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);;