contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA493632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4288947 | 4288947 | PRJNA493632_P_NODE_335964_length_286_cov_1.352113_g332525_i0 | PRJNA493632 | 335964 | 286 | 1.352113 | 3.86704318 | Taeniidae | 6208 | Platyhelminthes | Platyhelminthes | 159 | 5.02e-45 | NR | CDS15399.1 | 6210 | g332525 | i0 | 71.3 | 224.811188811189 | 94 | 27 | 98.6 | 0 | 3 | 284 | 150 | 243 | CDS15399.1 serine:threonine protein phosphatase PP1 gamma [Echinococcus granulosus] | diamond | 64296 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 6207048 | 6207048 | PRJNA493632_P_NODE_633685_length_242_cov_3.644970_g630244_i0 | PRJNA493632 | 633685 | 242 | 3.64497 | 8.8208274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 5.31e-24 | NR | VDN13523.1 | 60516 | g630244 | i0 | 59.5 | 4.89669421487603 | 79 | 30 | 97.9 | 1 | 242 | 6 | 142 | 218 | VDN13523.1 unnamed protein product [Dibothriocephalus latus] | diamond | 1185 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 10665216 | 10665216 | PRJNA493632_P_NODE_307409_length_293_cov_1.127273_g303971_i0 | PRJNA493632 | 307409 | 293 | 1.127273 | 3.30290989 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 124 | 5.35e-31 | NR | XP_018651752.1 | 6183 | g303971 | i0 | 75.9 | 19.9249146757679 | 83 | 20 | 85 | 0 | 251 | 3 | 13 | 95 | XP_018651752.1 putative eukaryotic translation elongation factor [Schistosoma mansoni] | diamond | 5838 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 27187114 | 27187114 | PRJNA493632_P_NODE_624962_length_243_cov_0.905882_g621521_i0 | PRJNA493632 | 624962 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 134 | 1.42e-34 | NR | CAH8872176.1 | 157069 | g621521 | i0 | 78.9 | 16.8518518518519 | 76 | 16 | 93.8 | 0 | 229 | 2 | 191 | 266 | CAH8872176.1 unnamed protein product [Trichobilharzia regenti] | diamond | 4095 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 27313863 | 27313863 | PRJNA493632_P_NODE_251303_length_314_cov_0.958506_g247867_i0 | PRJNA493632 | 251303 | 314 | 0.958506 | 3.00970884 | root | 1 | Root_unresolved | Root_unresolved | 145 | 4.31e-38 | NR | XP_051066993.1 | 6185 | g247867 | i0 | 63.8 | 22.031847133758 | 105 | 37 | 99.4 | 1 | 314 | 3 | 415 | 519 | XP_051066993.1 hypothetical protein MS3_00008062 [Schistosoma haematobium] | diamond | 6918 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 27345481 | 27345481 | PRJNA493632_P_NODE_42423_length_649_cov_2.012153_g39259_i0 | PRJNA493632 | 42423 | 649 | 2.012153 | 13.05887297 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 57.4 | 5.06e-7 | NR | AAX30115.1 | 6182 | g39259 | i0 | 50.8 | 0.799691833590139 | 61 | 30 | 28.2 | 0 | 184 | 2 | 2 | 62 | AAX30115.1 unknown [Schistosoma japonicum] | diamond | 519 | 57.8 | 0.993079584775087 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27945303 | 27945303 | PRJNA493632_P_NODE_169765_length_368_cov_1.664407_g166337_i0 | PRJNA493632 | 169765 | 368 | 1.664407 | 6.12501776 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 94.7 | 1.79e-21 | NR | ADZ73519.1 | 6161 | g166337 | i0 | 50 | 21.375 | 96 | 47 | 78.3 | 1 | 80 | 367 | 1 | 95 | ADZ73519.1 Rho2 GTPase [Dugesia japonica] | diamond | 7866 | 95.5 | 0.991623036649215 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 28324062 | 28324062 | PRJNA493632_P_NODE_55426_length_580_cov_0.895464_g52164_i0 | PRJNA493632 | 55426 | 580 | 0.895464 | 5.1936912 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 86.7 | 6.69e-16 | NR | XP_018644951.1 | 6183 | g52164 | i0 | 53.6 | 6.88448275862069 | 69 | 32 | 35.7 | 0 | 552 | 346 | 825 | 893 | XP_018644951.1 choline/ethanolamine kinase, putative [Schistosoma mansoni] | diamond | 3993 | 87 | 0.996551724137931 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 28402974 | 28402974 | PRJNA493632_P_NODE_226306_length_328_cov_1.329412_g222871_i0 | PRJNA493632 | 226306 | 328 | 1.329412 | 4.36047136 | Schistosoma rodhaini | 6188 | Platyhelminthes | Platyhelminthes | 143 | 3.74e-37 | NR | CAH8590323.1 | 6188 | g222871 | i0 | 57.4 | 14.780487804878 | 108 | 46 | 98.8 | 0 | 325 | 2 | 369 | 476 | CAH8590323.1 unnamed protein product [Schistosoma rodhaini] | diamond | 4848 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 28576719 | 28576719 | PRJNA493632_P_NODE_671507_length_237_cov_6.079268_g668066_i0 | PRJNA493632 | 671507 | 237 | 6.079268 | 14.40786516 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 65.1 | 4.45e-10 | NR | VZH95280.1 | 99802 | g668066 | i0 | 96.4 | 51.0253164556962 | 28 | 1 | 35.4 | 0 | 152 | 235 | 52 | 79 | VZH95280.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 12093 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28592649 | 28592649 | PRJNA493632_P_NODE_642507_length_242_cov_0.911243_g639066_i0 | PRJNA493632 | 642507 | 242 | 0.911243 | 2.20520806 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 49.3 | 1.6e-4 | NR | VDO15372.1 | 102285 | g639066 | i0 | 81.5 | 2.24380165289256 | 27 | 5 | 33.5 | 0 | 82 | 2 | 17 | 43 | VDO15372.1 unnamed protein product [Rodentolepis nana] | diamond | 543 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 29381931 | 29381931 | PRJNA493632_P_NODE_674949_length_236_cov_3.705521_g671508_i0 | PRJNA493632 | 674949 | 236 | 3.705521 | 8.74502956 | Schistosoma spindalis | 6189 | Platyhelminthes | Platyhelminthes | 43.1 | 0.024 | NR | CAI2725967.1 | 6189 | g671508 | i0 | 39.7 | 2.94915254237288 | 58 | 27 | 73.7 | 2 | 1 | 174 | 297 | 346 | CAI2725967.1 unnamed protein product [Schistosoma spindalis] | diamond | 696 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma spindalis | |
| 30044952 | 30044952 | PRJNA493632_P_NODE_658531_length_241_cov_0.916667_g655090_i0 | PRJNA493632 | 658531 | 241 | 0.916667 | 2.20916747 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 67 | 1.98e-11 | NR | VZI42295.1 | 99802 | g655090 | i0 | 58.3 | 2.39004149377593 | 48 | 20 | 59.8 | 0 | 146 | 3 | 102 | 149 | VZI42295.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 576 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 30234567 | 30234567 | PRJNA493632_P_NODE_425592_length_267_cov_1.190722_g422153_i0 | PRJNA493632 | 425592 | 267 | 1.190722 | 3.17922774 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 48.5 | 4.59e-4 | NR | CAH8853420.1 | 157069 | g422153 | i0 | 52.3 | 1.97752808988764 | 44 | 21 | 49.4 | 0 | 134 | 3 | 17 | 60 | CAH8853420.1 unnamed protein product [Trichobilharzia regenti] | diamond | 528 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 30282407 | 30282407 | PRJNA493632_P_NODE_616052_length_244_cov_0.900585_g612611_i0 | PRJNA493632 | 616052 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 57.4 | 2.54e-7 | NR | CAH8549493.1 | 57078 | g612611 | i0 | 61.9 | 3.79918032786885 | 42 | 15 | 51.6 | 1 | 128 | 3 | 495 | 535 | CAH8549493.1 unnamed protein product, partial [Dicrocoelium dendriticum] | diamond | 927 | 57.8 | 0.993079584775087 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 30597824 | 30597824 | PRJNA493632_P_NODE_617393_length_244_cov_0.888889_g613952_i0 | PRJNA493632 | 617393 | 244 | 0.888889 | 2.16888916 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 137 | 1.77e-35 | NR | CAH8444676.1 | 39320 | g613952 | i0 | 78.8 | 19.7459016393443 | 80 | 17 | 98.4 | 0 | 5 | 244 | 194 | 273 | CAH8444676.1 unnamed protein product [Heterobilharzia americana] | diamond | 4818 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 30819176 | 30819176 | PRJNA493632_P_NODE_485894_length_255_cov_1.016484_g482455_i0 | PRJNA493632 | 485894 | 255 | 1.016484 | 2.5920342 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 132 | 1.75e-33 | NR | CAH8665380.1 | 48269 | g482455 | i0 | 69 | 25.6941176470588 | 84 | 26 | 98.8 | 0 | 3 | 254 | 254 | 337 | CAH8665380.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 6552 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei | |
| 32353086 | 32353086 | PRJNA493632_P_NODE_245719_length_317_cov_0.946721_g242283_i0 | PRJNA493632 | 245719 | 317 | 0.946721 | 3.00110557 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 77.4 | 5.9e-14 | NR | XP_018653579.1 | 6183 | g242283 | i0 | 38.9 | 3.40694006309148 | 90 | 52 | 82.3 | 1 | 11 | 271 | 236 | 325 | XP_018653579.1 hypothetical protein Smp_173950 [Schistosoma mansoni] | diamond | 1080 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 32527243 | 32527243 | PRJNA493632_P_NODE_382719_length_276_cov_1.187192_g379280_i0 | PRJNA493632 | 382719 | 276 | 1.187192 | 3.27664992 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 63.5 | 2.66e-9 | NR | CAX83701.1 | 6182 | g379280 | i0 | 34.9 | 4.14130434782609 | 109 | 51 | 96.7 | 3 | 275 | 9 | 856 | 964 | CAX83701.1 pol polyprotei [Schistosoma japonicum] | diamond | 1143 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32542997 | 32542997 | PRJNA493632_P_NODE_615699_length_244_cov_0.900585_g612258_i0 | PRJNA493632 | 615699 | 244 | 0.900585 | 2.1974274 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 91.3 | 3.05e-19 | NR | KAA0184763.1 | 27845 | g612258 | i0 | 74.6 | 4.14344262295082 | 63 | 16 | 77.5 | 0 | 3 | 191 | 171 | 233 | KAA0184763.1 hypothetical protein FBUS_00741 [Fasciolopsis buskii] | diamond | 1011 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 32621567 | 32621567 | PRJNA493632_P_NODE_581780_length_246_cov_0.890173_g578339_i0 | PRJNA493632 | 581780 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 47 | 9.71e-4 | NR | CAH8291295.1 | 39320 | g578339 | i0 | 51.3 | 11.5731707317073 | 39 | 19 | 47.6 | 0 | 20 | 136 | 99 | 137 | CAH8291295.1 unnamed protein product, partial [Heterobilharzia americana] | diamond | 2847 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 32731949 | 32731949 | PRJNA493632_P_NODE_625980_length_243_cov_0.905882_g622539_i0 | PRJNA493632 | 625980 | 243 | 0.905882 | 2.20129326 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 94 | 3.59e-20 | NR | KAL3314633.1 | 1844966 | g622539 | i0 | 56.1 | 1.93827160493827 | 82 | 35 | 100 | 1 | 1 | 243 | 228 | 309 | KAL3314633.1 ATP-binding cassette sub- F member 2 [Cichlidogyrus casuarinus] | diamond | 471 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 32747526 | 32747526 | PRJNA493632_P_NODE_296320_length_297_cov_1.147321_g292882_i0 | PRJNA493632 | 296320 | 297 | 1.147321 | 3.40754337 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 129 | 5.76e-33 | NR | XP_018646622.1 | 6183 | g292882 | i0 | 61 | 23.989898989899 | 100 | 37 | 99 | 1 | 2 | 295 | 181 | 280 | XP_018646622.1 hypothetical protein Smp_185370 [Schistosoma mansoni] | diamond | 7125 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni |
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);;