contig_metadata
18 rows where bioproject = "PRJNA897077", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 873535 | 873535 | PRJNA897077_P_NODE_11101_length_297_cov_1.044643_g10974_i0 | PRJNA897077 | 11101 | 297 | 1.044643 | 3.10258971 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 167 | 2.58e-46 | NR | XP_009169500.1 | 6198 | g10974 | i0 | 85.6 | 58.7878787878788 | 97 | 14 | 98 | 0 | 5 | 295 | 309 | 405 | XP_009169500.1 hypothetical protein T265_06066 [Opisthorchis viverrini] | diamond | 17460 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 873544 | 873544 | PRJNA897077_P_NODE_11861_length_287_cov_2.915888_g11734_i0 | PRJNA897077 | 11861 | 287 | 2.915888 | 8.36859856 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 71.6 | 4.25e-12 | NR | VZH94925.1 | 99802 | g11734 | i0 | 48.1 | 2.90592334494774 | 81 | 41 | 84.7 | 1 | 247 | 5 | 13 | 92 | VZH94925.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 834 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 2148802 | 2148802 | PRJNA897077_P_NODE_10562_length_304_cov_1.458874_g10435_i0 | PRJNA897077 | 10562 | 304 | 1.458874 | 4.43497696 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 170 | 2.15e-49 | NR | TGZ75706.1 | 147828 | g10435 | i0 | 75.2 | 10.0164473684211 | 101 | 25 | 99.7 | 0 | 303 | 1 | 21 | 121 | TGZ75706.1 hypothetical protein CRM22_000212 [Opisthorchis felineus] | diamond | 3045 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 8526406 | 8526406 | PRJNA897077_P_NODE_16187_length_251_cov_0.876404_g16060_i0 | PRJNA897077 | 16187 | 251 | 0.876404 | 2.19977404 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 176 | 2.57e-50 | NR | XP_018647062.1 | 6183 | g16060 | i0 | 98.8 | 19.8406374501992 | 83 | 1 | 99.2 | 0 | 250 | 2 | 451 | 533 | XP_018647062.1 cell division control protein 48 aaa family protein (transitional endoplasmic reticulum atpase),putative [Schistosoma mansoni] | diamond | 4980 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 12352441 | 12352441 | PRJNA897077_P_NODE_1030_length_919_cov_4.517730_g931_i0 | PRJNA897077 | 1030 | 919 | 4.51773 | 41.5179387 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 1555 | 0 | NTclustered | gi|2905014696|gb|PV021483.1| | 234883 | g931 | i0 | 97.374 | 57.9542981501632 | 914 | 24 | 99 | 0 | 6 | 919 | 8528 | 9441 | Centrocestus formosanus mitochondrion, complete genome | blastn | 53260 | 1555 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus | |
| 17451733 | 17451733 | PRJNA897077_P_NODE_13494_length_270_cov_1.583756_g13367_i0 | PRJNA897077 | 13494 | 270 | 1.583756 | 4.2761412 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 411 | 3.5399999999999995e-110 | NTclustered | gi|2905014696|gb|PV021483.1| | 234883 | g13367 | i0 | 94.074 | 1 | 270 | 16 | 100 | 0 | 1 | 270 | 8154 | 8423 | Centrocestus formosanus mitochondrion, complete genome | blastn | 270 | 411 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus | |
| 21646290 | 21646290 | PRJNA897077_P_NODE_1237_length_848_cov_3.565161_g1133_i0 | PRJNA897077 | 1237 | 848 | 3.565161 | 30.23256528 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 528 | 7.3e-188 | NR | CAX70940.1 | 6182 | g1133 | i0 | 96.6 | 156.222877358491 | 264 | 9 | 93.4 | 0 | 792 | 1 | 1 | 264 | CAX70940.1 putative tubulin, beta, 2 [Schistosoma japonicum] | diamond | 132477 | 531 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 22550531 | 22550531 | PRJNA897077_P_NODE_4178_length_473_cov_1.167500_g4051_i0 | PRJNA897077 | 4178 | 473 | 1.1675 | 5.522275 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 290 | 4.219999999999999e-95 | NR | CDS15399.1 | 6210 | g4051 | i0 | 80.3 | 285.786469344609 | 157 | 31 | 99.6 | 0 | 472 | 2 | 105 | 261 | CDS15399.1 serine:threonine protein phosphatase PP1 gamma [Echinococcus granulosus] | diamond | 135177 | 290 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 27442937 | 27442937 | PRJNA897077_P_NODE_4363_length_463_cov_1.151282_g4236_i0 | PRJNA897077 | 4363 | 463 | 1.151282 | 5.33043566 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 77 | 4.58e-14 | NR | THD22600.1 | 6192 | g4236 | i0 | 37.3 | 1.68466522678186 | 118 | 70 | 74.5 | 2 | 432 | 88 | 7 | 123 | THD22600.1 Mitochondrial ATP synthase subunit OSCP subunit [Fasciola hepatica] | diamond | 780 | 77.4 | 0.994832041343669 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 28137445 | 28137445 | PRJNA897077_P_NODE_18925_length_244_cov_0.912281_g18798_i0 | PRJNA897077 | 18925 | 244 | 0.912281 | 2.22596564 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 100 | 3.38e-23 | NR | KAA3679560.1 | 34504 | g18798 | i0 | 58 | 5.96311475409836 | 81 | 34 | 99.6 | 0 | 2 | 244 | 220 | 300 | KAA3679560.1 glucosamine-6-phosphate deaminase [Paragonimus westermani] | diamond | 1455 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 28768661 | 28768661 | PRJNA897077_P_NODE_11687_length_289_cov_2.074074_g11560_i0 | PRJNA897077 | 11687 | 289 | 2.074074 | 5.99407386 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 108 | 7.63e-26 | NR | THD23159.1 | 6192 | g11560 | i0 | 61.4 | 10.5467128027682 | 83 | 31 | 86.2 | 1 | 2 | 250 | 276 | 357 | THD23159.1 Cell division cycle protein 37 [Fasciola hepatica] | diamond | 3048 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 28926562 | 28926562 | PRJNA897077_P_NODE_11748_length_289_cov_1.083333_g11621_i0 | PRJNA897077 | 11748 | 289 | 1.083333 | 3.13083237 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 129 | 2.41e-32 | NR | XP_009173790.1 | 6198 | g11621 | i0 | 65.3 | 4.93079584775086 | 95 | 33 | 98.6 | 0 | 3 | 287 | 401 | 495 | XP_009173790.1 LOW QUALITY PROTEIN: hypothetical protein T265_14849 [Opisthorchis viverrini] | diamond | 1425 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 29148013 | 29148013 | PRJNA897077_P_NODE_19149_length_244_cov_0.912281_g19022_i0 | PRJNA897077 | 19149 | 244 | 0.912281 | 2.22596564 | Trichobilharzia | 100601 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0191 | NR | VDP98702.1 | 157069 | g19022 | i0 | 33.3 | 3.40573770491803 | 69 | 43 | 84.8 | 1 | 230 | 24 | 320 | 385 | VDP98702.1 unnamed protein product [Trichobilharzia regenti] | diamond | 831 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 29684079 | 29684079 | PRJNA897077_P_NODE_13570_length_270_cov_1.000000_g13443_i0 | PRJNA897077 | 13570 | 270 | 1 | 2.7 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 49.3 | 2.69e-4 | NR | VDN97566.1 | 102285 | g13443 | i0 | 45.8 | 1.07777777777778 | 48 | 26 | 53.3 | 0 | 147 | 4 | 567 | 614 | VDN97566.1 unnamed protein product [Rodentolepis nana] | diamond | 291 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 29771276 | 29771276 | PRJNA897077_P_NODE_16871_length_249_cov_0.886364_g16744_i0 | PRJNA897077 | 16871 | 249 | 0.886364 | 2.20704636 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 74.3 | 1.9e-13 | NR | TGZ68102.1 | 147828 | g16744 | i0 | 52.6 | 0.91566265060241 | 76 | 34 | 91.6 | 1 | 230 | 3 | 12 | 85 | TGZ68102.1 hypothetical protein CRM22_004443 [Opisthorchis felineus] | diamond | 228 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 30537348 | 30537348 | PRJNA897077_P_NODE_13633_length_269_cov_1.520408_g13506_i0 | PRJNA897077 | 13633 | 269 | 1.520408 | 4.08989752 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 131 | 1.98e-33 | NR | KAH8867818.1 | 6182 | g13506 | i0 | 67.4 | 9.84758364312268 | 89 | 29 | 99.3 | 0 | 3 | 269 | 193 | 281 | KAH8867818.1 Long-chain fatty acid transport protein 1 [Schistosoma japonicum] | diamond | 2649 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31043223 | 31043223 | PRJNA897077_P_NODE_1435_length_793_cov_1.050000_g1326_i0 | PRJNA897077 | 1435 | 793 | 1.05 | 8.3265 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 59.3 | 6.22e-6 | NR | CDS38124.2 | 6211 | g1326 | i0 | 64.3 | 1.39974779319042 | 42 | 15 | 15.9 | 0 | 3 | 128 | 186 | 227 | CDS38124.2 G protein signaling modulator 2 [Echinococcus multilocularis] | diamond | 1110 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 32118308 | 32118308 | PRJNA897077_P_NODE_12918_length_276_cov_1.502463_g12791_i0 | PRJNA897077 | 12918 | 276 | 1.502463 | 4.14679788 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 70.9 | 6.92e-12 | NR | VZI31655.1 | 99802 | g12791 | i0 | 41.9 | 5.70652173913043 | 86 | 49 | 92.4 | 1 | 6 | 260 | 257 | 342 | VZI31655.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 1575 | 71.6 | 0.990223463687151 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;