contig_metadata
19 rows where bioproject = "PRJNA438111", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1709409 | 1709409 | PRJNA438111_P_NODE_6802_length_382_cov_3.436261_g6195_i0 | PRJNA438111 | 6802 | 382 | 3.436261 | 13.12651702 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 191 | 5.88e-60 | NR | CDS37580.1 | 6211 | g6195 | i0 | 74.8 | 33.1570680628272 | 123 | 31 | 96.6 | 0 | 381 | 13 | 26 | 148 | CDS37580.1 iron sulfur cluster assembly enzyme ISCU [Echinococcus multilocularis] | diamond | 12666 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 13188313 | 13188313 | PRJNA438111_P_NODE_77091_length_160_cov_2.824427_g76466_i0 | PRJNA438111 | 77091 | 160 | 2.824427 | 4.5190832 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 89 | 5.88e-19 | NR | XP_009171032.1 | 6198 | g76466 | i0 | 71.2 | 11.7 | 52 | 15 | 97.5 | 0 | 158 | 3 | 115 | 166 | XP_009171032.1 hypothetical protein T265_14251, partial [Opisthorchis viverrini] | diamond | 1872 | 89.4 | 0.995525727069351 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 27423859 | 27423859 | PRJNA438111_P_NODE_68823_length_165_cov_2.977941_g68198_i0 | PRJNA438111 | 68823 | 165 | 2.977941 | 4.91360265 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 59.3 | 1.79e-8 | NR | PAA70601.1 | 282301 | g68198 | i0 | 51.1 | 2.56363636363636 | 47 | 23 | 85.5 | 0 | 163 | 23 | 377 | 423 | PAA70601.1 hypothetical protein BOX15_Mlig017585g1 [Macrostomum lignano] | diamond | 423 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27440212 | 27440212 | PRJNA438111_P_NODE_14783_length_272_cov_6.008230_g14158_i0 | PRJNA438111 | 14783 | 272 | 6.00823 | 16.3423856 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 95.9 | 1.11e-20 | NR | TNN10996.1 | 6182 | g14158 | i0 | 54.3 | 13.7095588235294 | 81 | 37 | 89.3 | 0 | 12 | 254 | 500 | 580 | TNN10996.1 Receptor-type tyrosine-protein phosphatase F [Schistosoma japonicum] | diamond | 3729 | 96.3 | 0.995846313603323 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27692799 | 27692799 | PRJNA438111_P_NODE_66044_length_167_cov_2.521739_g65419_i0 | PRJNA438111 | 66044 | 167 | 2.521739 | 4.21130413 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.0343 | NR | CAH8433973.1 | 39320 | g65419 | i0 | 34.9 | 1.76047904191617 | 43 | 28 | 77.2 | 0 | 167 | 39 | 223 | 265 | CAH8433973.1 unnamed protein product [Heterobilharzia americana] | diamond | 294 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 27755944 | 27755944 | PRJNA438111_P_NODE_86484_length_153_cov_2.395161_g85859_i0 | PRJNA438111 | 86484 | 153 | 2.395161 | 3.66459633 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 75.1 | 5.97e-15 | NR | VDN15161.1 | 60516 | g85859 | i0 | 66 | 2.94117647058824 | 50 | 17 | 98 | 0 | 152 | 3 | 7 | 56 | VDN15161.1 unnamed protein product [Dibothriocephalus latus] | diamond | 450 | 75.5 | 0.994701986754967 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 27913381 | 27913381 | PRJNA438111_P_NODE_85665_length_153_cov_5.669355_g85040_i0 | PRJNA438111 | 85665 | 153 | 5.669355 | 8.67411315 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 59.3 | 1.51e-8 | NR | VDN09529.1 | 60516 | g85040 | i0 | 65.1 | 2.52941176470588 | 43 | 15 | 84.3 | 0 | 1 | 129 | 308 | 350 | VDN09529.1 unnamed protein product [Dibothriocephalus latus] | diamond | 387 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 28149890 | 28149890 | PRJNA438111_P_NODE_16945_length_257_cov_4.074561_g16320_i0 | PRJNA438111 | 16945 | 257 | 4.074561 | 10.47162177 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 47 | 0.00132 | NR | VDL98146.1 | 70667 | g16320 | i0 | 30.9 | 2.42801556420233 | 68 | 47 | 79.4 | 0 | 250 | 47 | 135 | 202 | VDL98146.1 unnamed protein product [Schistocephalus solidus] | diamond | 624 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 28576561 | 28576561 | PRJNA438111_P_NODE_49267_length_182_cov_4.169935_g48642_i0 | PRJNA438111 | 49267 | 182 | 4.169935 | 7.5892817 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 70.5 | 2.63e-12 | NR | KAF8572223.1 | 34504 | g48642 | i0 | 50.8 | 3.89010989010989 | 59 | 27 | 97.3 | 1 | 179 | 3 | 278 | 334 | KAF8572223.1 hypothetical protein P879_00282 [Paragonimus westermani] | diamond | 708 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 29507449 | 29507449 | PRJNA438111_P_NODE_86610_length_153_cov_2.250000_g85985_i0 | PRJNA438111 | 86610 | 153 | 2.25 | 3.4425 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 45.1 | 0.00165 | NR | PAA64119.1 | 282301 | g85985 | i0 | 44 | 1.96078431372549 | 50 | 27 | 98 | 1 | 151 | 2 | 737 | 785 | PAA64119.1 hypothetical protein BOX15_Mlig033620g1, partial [Macrostomum lignano] | diamond | 300 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29981193 | 29981193 | PRJNA438111_P_NODE_20191_length_239_cov_1.952381_g19566_i0 | PRJNA438111 | 20191 | 239 | 1.952381 | 4.66619059 | Trichobilharzia szidati | 157070 | Platyhelminthes | Platyhelminthes | 43.9 | 0.00203 | NR | CAH8830947.1 | 157070 | g19566 | i0 | 48.9 | 1.12970711297071 | 47 | 24 | 59 | 0 | 33 | 173 | 28 | 74 | CAH8830947.1 unnamed protein product [Trichobilharzia szidati] | diamond | 270 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 30707805 | 30707805 | PRJNA438111_P_NODE_44474_length_188_cov_3.213836_g43849_i0 | PRJNA438111 | 44474 | 188 | 3.213836 | 6.04201168 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 44.7 | 0.00384 | NR | PAA71197.1 | 282301 | g43849 | i0 | 39.3 | 3.57446808510638 | 56 | 34 | 89.4 | 0 | 9 | 176 | 2902 | 2957 | PAA71197.1 hypothetical protein BOX15_Mlig014784g1 [Macrostomum lignano] | diamond | 672 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30992307 | 30992307 | PRJNA438111_P_NODE_35294_length_204_cov_3.205714_g34669_i0 | PRJNA438111 | 35294 | 204 | 3.205714 | 6.53965656 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 64.7 | 3.69e-10 | NR | PAA59047.1 | 282301 | g34669 | i0 | 55.8 | 25.3382352941176 | 52 | 23 | 76.5 | 0 | 2 | 157 | 329 | 380 | PAA59047.1 hypothetical protein BOX15_Mlig004255g2 [Macrostomum lignano] | diamond | 5169 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31023870 | 31023870 | PRJNA438111_P_NODE_61795_length_170_cov_2.312057_g61170_i0 | PRJNA438111 | 61795 | 170 | 2.312057 | 3.9304969 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 41.6 | 0.0362 | NR | PAA76865.1 | 282301 | g61170 | i0 | 36.1 | 1.07647058823529 | 61 | 30 | 91.8 | 2 | 3 | 158 | 287 | 347 | PAA76865.1 hypothetical protein BOX15_Mlig002966g1 [Macrostomum lignano] | diamond | 183 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31212924 | 31212924 | PRJNA438111_P_NODE_36255_length_201_cov_5.023256_g35630_i0 | PRJNA438111 | 36255 | 201 | 5.023256 | 10.09674456 | Paragonimus kellicotti | 100269 | Platyhelminthes | Platyhelminthes | 52 | 4.38e-6 | NR | KAF6769199.1 | 100269 | g35630 | i0 | 47 | 1.98507462686567 | 66 | 35 | 98.5 | 0 | 201 | 4 | 57 | 122 | KAF6769199.1 hypothetical protein AHF37_10844, partial [Paragonimus kellicotti] | diamond | 399 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 31434706 | 31434706 | PRJNA438111_P_NODE_50056_length_181_cov_5.269737_g49431_i0 | PRJNA438111 | 50056 | 181 | 5.269737 | 9.53822397 | Paragonimus heterotremus | 100268 | Platyhelminthes | Platyhelminthes | 64.7 | 1.94e-10 | NR | KAF5394800.1 | 100268 | g49431 | i0 | 50.9 | 0.911602209944751 | 55 | 27 | 91.2 | 0 | 2 | 166 | 35 | 89 | KAF5394800.1 hypothetical protein PHET_10133 [Paragonimus heterotremus] | diamond | 165 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus heterotremus | |
| 31529805 | 31529805 | PRJNA438111_P_NODE_11756_length_301_cov_3.117647_g11131_i0 | PRJNA438111 | 11756 | 301 | 3.117647 | 9.38411747 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 129 | 5.36e-33 | NR | CAL5141415.1 | 300641 | g11131 | i0 | 61 | 2.99003322259136 | 100 | 38 | 99.7 | 1 | 301 | 2 | 334 | 432 | CAL5141415.1 unnamed protein product [Calicophoron daubneyi] | diamond | 900 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 32337165 | 32337165 | PRJNA438111_P_NODE_60499_length_171_cov_2.000000_g59874_i0 | PRJNA438111 | 60499 | 171 | 2 | 3.42 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 84.3 | 1.19e-17 | NR | VDP86878.1 | 27848 | g59874 | i0 | 71.9 | 16.0877192982456 | 57 | 16 | 100 | 0 | 171 | 1 | 71 | 127 | VDP86878.1 unnamed protein product [Echinostoma caproni] | diamond | 2751 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 32573926 | 32573926 | PRJNA438111_P_NODE_2699_length_591_cov_7.259786_g2239_i0 | PRJNA438111 | 2699 | 591 | 7.259786 | 42.90533526 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 52.8 | 3.01e-4 | NR | TNN07890.1 | 6182 | g2239 | i0 | 50.9 | 0.558375634517767 | 55 | 26 | 27.9 | 1 | 2 | 166 | 300 | 353 | TNN07890.1 Ankyrin repeat and death domain-containing protein 1A isoform 1 [Schistosoma japonicum] | diamond | 330 | 52.8 | 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);;