contig_metadata
18 rows where bioproject = "PRJEB7366", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513343 | 6513343 | PRJEB7366_P_NODE_16946_length_188_cov_1.045752_g16512_i0 | PRJEB7366 | 16946 | 188 | 1.045752 | 1.96601376 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 56.5 | 0.001 | NTclustered | gi|2318751697|ref|XM_051218766.1| | 6185 | g16512 | i0 | 96.97 | 0.175531914893617 | 33 | 1 | 18 | 0 | 126 | 158 | 616 | 648 | Schistosoma haematobium Ribosomal protein S6 kinase alpha-1 (RPS6KA1), partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 10338296 | 10338296 | PRJEB7366_P_NODE_21089_length_165_cov_1.230769_g20655_i0 | PRJEB7366 | 21089 | 165 | 1.230769 | 2.03076885 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 105 | 5.55e-25 | NR | CAH8874540.1 | 157069 | g20655 | i0 | 79.6 | 4.90909090909091 | 54 | 11 | 98.2 | 0 | 3 | 164 | 101 | 154 | CAH8874540.1 unnamed protein product [Trichobilharzia regenti] | diamond | 810 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 21812030 | 21812030 | PRJEB7366_P_NODE_24878_length_150_cov_1.043478_g24444_i0 | PRJEB7366 | 24878 | 150 | 1.043478 | 1.565217 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.003 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g24444 | i0 | 100 | 0.193333333333333 | 29 | 0 | 19 | 0 | 41 | 69 | 5389 | 5361 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 21812062 | 21812062 | PRJEB7366_P_NODE_9338_length_275_cov_1.833333_g8904_i0 | PRJEB7366 | 9338 | 275 | 1.833333 | 5.04166575 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 129 | 4.769999999999999e-35 | NR | VDP96317.1 | 157069 | g8904 | i0 | 74.4 | 13.6909090909091 | 78 | 20 | 85.1 | 0 | 234 | 1 | 100 | 177 | VDP96317.1 unnamed protein product [Trichobilharzia regenti] | diamond | 3765 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 26685829 | 26685829 | PRJEB7366_P_NODE_9121_length_279_cov_1.864754_g8687_i0 | PRJEB7366 | 9121 | 279 | 1.864754 | 5.20266366 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0309 | NR | TGZ75416.1 | 147828 | g8687 | i0 | 42.9 | 0.978494623655914 | 91 | 32 | 94.6 | 5 | 2 | 265 | 578 | 651 | TGZ75416.1 hypothetical protein CRM22_000375 [Opisthorchis felineus] | diamond | 273 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 27097275 | 27097275 | PRJEB7366_P_NODE_11282_length_243_cov_1.625000_g10848_i0 | PRJEB7366 | 11282 | 243 | 1.625 | 3.94875 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 55.8 | 8.02e-7 | NR | AAF76330.1 | 6192 | g10848 | i0 | 62.5 | 3.60493827160494 | 40 | 14 | 49.4 | 1 | 2 | 121 | 288 | 326 | AAF76330.1 cathepsin L [Fasciola hepatica] | diamond | 876 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 27627373 | 27627373 | PRJEB7366_P_NODE_5224_length_396_cov_2.639889_g4791_i0 | PRJEB7366 | 5224 | 396 | 2.639889 | 10.45396044 | root | 1 | Root_unresolved | Root_unresolved | 47 | 0.00569 | NR | RTG86105.1 | 6184 | g4791 | i0 | 38.9 | 4.57575757575758 | 72 | 40 | 54.5 | 2 | 301 | 86 | 253 | 320 | RTG86105.1 uncharacterized protein DC041_0005673 [Schistosoma bovis] | diamond | 1812 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 27753717 | 27753717 | PRJEB7366_P_NODE_19784_length_171_cov_1.602941_g19350_i0 | PRJEB7366 | 19784 | 171 | 1.602941 | 2.74102911 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 62 | 4.66e-10 | NR | XP_009175450.1 | 6198 | g19350 | i0 | 52.9 | 6.33333333333333 | 51 | 24 | 89.5 | 0 | 11 | 163 | 84 | 134 | XP_009175450.1 hypothetical protein T265_10726 [Opisthorchis viverrini] | diamond | 1083 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 28897288 | 28897288 | PRJEB7366_P_NODE_8488_length_291_cov_3.320312_g8054_i0 | PRJEB7366 | 8488 | 291 | 3.320312 | 9.66210792 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 93.6 | 6.6e-23 | NR | PAA52392.1 | 282301 | g8054 | i0 | 84 | 3.21649484536082 | 50 | 8 | 51.5 | 0 | 40 | 189 | 1 | 50 | PAA52392.1 hypothetical protein BOX15_Mlig007628g1 [Macrostomum lignano] | diamond | 936 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29055404 | 29055404 | PRJEB7366_P_NODE_5688_length_375_cov_8.435294_g5255_i0 | PRJEB7366 | 5688 | 375 | 8.435294 | 31.6323525 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 52.4 | 5.37e-5 | NR | VDO09905.1 | 102285 | g5255 | i0 | 39.7 | 1.88 | 78 | 41 | 61.6 | 3 | 304 | 74 | 208 | 280 | VDO09905.1 unnamed protein product [Rodentolepis nana] | diamond | 705 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 29111323 | 29111323 | PRJEB7366_P_NODE_1028_length_975_cov_2.594681_g781_i0 | PRJEB7366 | 1028 | 975 | 2.594681 | 25.29813975 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 70.9 | 1.36e-9 | NR | AEK32590.1 | 6183 | g781 | i0 | 35.9 | 2.26461538461538 | 92 | 52 | 28.3 | 1 | 662 | 937 | 6 | 90 | AEK32590.1 venom allergen-like protein 6 isoform 36 [Schistosoma mansoni] | diamond | 2208 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 29300663 | 29300663 | PRJEB7366_P_NODE_13809_length_213_cov_2.011236_g13375_i0 | PRJEB7366 | 13809 | 213 | 2.011236 | 4.28393268 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 114 | 4.1e-29 | NR | VDM01649.1 | 70667 | g13375 | i0 | 75.4 | 2.94366197183099 | 69 | 17 | 97.2 | 0 | 208 | 2 | 152 | 220 | VDM01649.1 unnamed protein product [Schistocephalus solidus] | diamond | 627 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 29686406 | 29686406 | PRJEB7366_P_NODE_17810_length_182_cov_1.360544_g17376_i0 | PRJEB7366 | 17810 | 182 | 1.360544 | 2.47619008 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 63.9 | 2.19e-10 | NR | VDP94056.1 | 27848 | g17376 | i0 | 51 | 2.7032967032967 | 49 | 23 | 79.1 | 1 | 146 | 3 | 3 | 51 | VDP94056.1 unnamed protein product [Echinostoma caproni] | diamond | 492 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 30311815 | 30311815 | PRJEB7366_P_NODE_17552_length_184_cov_0.939597_g17118_i0 | PRJEB7366 | 17552 | 184 | 0.939597 | 1.72885848 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 76.6 | 3.05e-15 | NR | PAA68107.1 | 282301 | g17118 | i0 | 60.7 | 4.95652173913043 | 61 | 24 | 99.5 | 0 | 183 | 1 | 71 | 131 | PAA68107.1 hypothetical protein BOX15_Mlig004111g1, partial [Macrostomum lignano] | diamond | 912 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31385871 | 31385871 | PRJEB7366_P_NODE_16776_length_189_cov_1.188312_g16342_i0 | PRJEB7366 | 16776 | 189 | 1.188312 | 2.24590968 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 73.6 | 3.31e-14 | NR | THD24660.1 | 6192 | g16342 | i0 | 59.6 | 25.8412698412698 | 57 | 23 | 90.5 | 0 | 171 | 1 | 34 | 90 | THD24660.1 Cell division control protein 42 [Fasciola hepatica] | diamond | 4884 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31670355 | 31670355 | PRJEB7366_P_NODE_6017_length_361_cov_14.432515_g5584_i0 | PRJEB7366 | 6017 | 361 | 14.432515 | 52.10137915 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 52 | 6.47e-5 | NR | CDS37392.1 | 6211 | g5584 | i0 | 41 | 1.90304709141274 | 78 | 34 | 61.5 | 4 | 64 | 285 | 206 | 275 | CDS37392.1 calbindin 32 [Echinococcus multilocularis] | diamond | 687 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 31765232 | 31765232 | PRJEB7366_P_NODE_22857_length_157_cov_1.639344_g22423_i0 | PRJEB7366 | 22857 | 157 | 1.639344 | 2.57377008 | Paragonimus | 34503 | Platyhelminthes | Platyhelminthes | 52.4 | 4.59e-6 | NR | KAF7236144.1 | 59628 | g22423 | i0 | 51 | 1.94904458598726 | 51 | 25 | 97.5 | 0 | 2 | 154 | 314 | 364 | KAF7236144.1 hypothetical protein EG68_11467 [Paragonimus skrjabini miyazakii] | diamond | 306 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 32588018 | 32588018 | PRJEB7366_P_NODE_13839_length_213_cov_1.275281_g13405_i0 | PRJEB7366 | 13839 | 213 | 1.275281 | 2.71634853 | root | 1 | Root_unresolved | Root_unresolved | 84.7 | 3.82e-18 | NR | AAX27256.2 | 6182 | g13405 | i0 | 63.6 | 20.2957746478873 | 55 | 20 | 77.5 | 0 | 211 | 47 | 171 | 225 | AAX27256.2 SJCHGC03496 protein, partial [Schistosoma japonicum] | diamond | 4323 | 85.5 | 0.990643274853801 | 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);;