contig_metadata
19 rows where bioproject = "PRJNA685060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1176065 | 1176065 | PRJNA685060_P_NODE_7261_length_353_cov_2.475000_g7171_i0 | PRJNA685060 | 7261 | 353 | 2.475 | 8.73675 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 651 | 0 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g7171 | i0 | 100 | 99.7167138810198 | 352 | 0 | 99 | 0 | 2 | 353 | 129 | 480 | Schistosoma japonicum unknown mRNA | blastn | 35200 | 651 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10870153 | 10870153 | PRJNA685060_P_NODE_149_length_1923_cov_9.264324_g133_i0 | PRJNA685060 | 149 | 1923 | 9.264324 | 178.15295052 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 394 | 2.7399999999999995e-121 | NR | CDS31835.1 | 85433 | g133 | i0 | 40.3 | 5.10764430577223 | 491 | 247 | 69.9 | 8 | 1870 | 527 | 338 | 825 | CDS31835.1 Papilin [Hymenolepis microstoma] | diamond | 9822 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 14695079 | 14695079 | PRJNA685060_P_NODE_11132_length_281_cov_2.471154_g11042_i0 | PRJNA685060 | 11132 | 281 | 2.471154 | 6.94394274 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 143 | 2.26e-37 | NR | OON23737.1 | 6198 | g11042 | i0 | 69.7 | 38.3701067615658 | 89 | 27 | 95 | 0 | 5 | 271 | 708 | 796 | OON23737.1 hypothetical protein X801_00354 [Opisthorchis viverrini] | diamond | 10782 | 144 | 0.993055555555556 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 15968807 | 15968807 | PRJNA685060_P_NODE_1193_length_904_cov_2.925391_g1122_i0 | PRJNA685060 | 1193 | 904 | 2.925391 | 26.44553464 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 84.3 | 1.49e-14 | NR | PAA81674.1 | 282301 | g1122 | i0 | 57.5 | 0.242256637168142 | 73 | 31 | 24.2 | 0 | 121 | 339 | 26 | 98 | PAA81674.1 hypothetical protein BOX15_Mlig021371g5, partial [Macrostomum lignano] | diamond | 219 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 15968925 | 15968925 | PRJNA685060_P_NODE_8993_length_316_cov_2.427984_g8903_i0 | PRJNA685060 | 8993 | 316 | 2.427984 | 7.67242944 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.03 | NTclustered | gi|690482098|emb|LN024774.1| | 99802 | g8903 | i0 | 100 | 0.0886075949367089 | 28 | 0 | 9 | 0 | 200 | 227 | 6654 | 6681 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0024345 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 18518247 | 18518247 | PRJNA685060_P_NODE_175_length_1857_cov_9.289238_g133_i1 | PRJNA685060 | 175 | 1857 | 9.289238 | 172.50114966 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 394 | 1.3899999999999998e-121 | NR | CDS31835.1 | 85433 | g133 | i1 | 40.3 | 5.2891760904685 | 491 | 247 | 72.4 | 8 | 1804 | 461 | 338 | 825 | CDS31835.1 Papilin [Hymenolepis microstoma] | diamond | 9822 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 24892340 | 24892340 | PRJNA685060_P_NODE_8060_length_335_cov_1.175573_g7970_i0 | PRJNA685060 | 8060 | 335 | 1.175573 | 3.93816955 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.009 | NTclustered | gi|690652912|emb|LN201090.1| | 99802 | g7970 | i0 | 92.105 | 0.791044776119403 | 38 | 3 | 11 | 0 | 178 | 215 | 148 | 185 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0171086 | blastn | 265 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27441678 | 27441678 | PRJNA685060_P_NODE_12743_length_258_cov_1.664865_g12653_i0 | PRJNA685060 | 12743 | 258 | 1.664865 | 4.2953517 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 85.1 | 2.44e-19 | NR | CDS26770.1 | 85433 | g12653 | i0 | 46.8 | 5.65116279069767 | 77 | 41 | 89.5 | 0 | 26 | 256 | 6 | 82 | CDS26770.1 presenilin enhancer [Hymenolepis microstoma] | diamond | 1458 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 27788855 | 27788855 | PRJNA685060_P_NODE_7044_length_359_cov_1.076923_g6954_i0 | PRJNA685060 | 7044 | 359 | 1.076923 | 3.86615357 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 181 | 1.4e-51 | NR | XP_009171032.1 | 6198 | g6954 | i0 | 78.1 | 26.5654596100279 | 105 | 23 | 87.7 | 0 | 44 | 358 | 107 | 211 | XP_009171032.1 hypothetical protein T265_14251, partial [Opisthorchis viverrini] | diamond | 9537 | 182 | 0.994505494505495 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 28262182 | 28262182 | PRJNA685060_P_NODE_11866_length_271_cov_1.166667_g11776_i0 | PRJNA685060 | 11866 | 271 | 1.166667 | 3.16166757 | Fasciolidae | 27843 | Platyhelminthes | Platyhelminthes | 72.8 | 2.24e-14 | NR | THD24281.1 | 6192 | g11776 | i0 | 42.5 | 1.61623616236162 | 73 | 42 | 80.8 | 0 | 52 | 270 | 14 | 86 | THD24281.1 Dynein light chain cytoplasmic [Fasciola hepatica] | diamond | 438 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 28293820 | 28293820 | PRJNA685060_P_NODE_9906_length_300_cov_1.396476_g9816_i0 | PRJNA685060 | 9906 | 300 | 1.396476 | 4.189428 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 53.5 | 1.19e-5 | NR | TPP62670.1 | 46835 | g9816 | i0 | 42.3 | 10.7 | 52 | 30 | 52 | 0 | 9 | 164 | 58 | 109 | TPP62670.1 Tyrosine-protein kinase [Fasciola gigantica] | diamond | 3210 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 28376972 | 28376972 | PRJNA685060_P_NODE_3726_length_506_cov_1.778291_g3636_i0 | PRJNA685060 | 3726 | 506 | 1.778291 | 8.99815246 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 53.5 | 8.25e-5 | NR | KAH9280019.1 | 6210 | g3636 | i0 | 39.1 | 0.515810276679842 | 87 | 47 | 49.8 | 3 | 152 | 403 | 1 | 84 | KAH9280019.1 UBX domain-containing protein 2 [Echinococcus granulosus] | diamond | 261 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28420418 | 28420418 | PRJNA685060_P_NODE_14106_length_249_cov_1.312500_g14016_i0 | PRJNA685060 | 14106 | 249 | 1.3125 | 3.268125 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 45.4 | 0.00431 | NR | CDS25645.1 | 85433 | g14016 | i0 | 83.3 | 1.44578313253012 | 24 | 4 | 28.9 | 0 | 248 | 177 | 416 | 439 | CDS25645.1 vacuolar protein sorting associated protein 4A [Hymenolepis microstoma] | diamond | 360 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 29008884 | 29008884 | PRJNA685060_P_NODE_11388_length_277_cov_2.058824_g11298_i0 | PRJNA685060 | 11388 | 277 | 2.058824 | 5.70294248 | Paragonimus skrjabini miyazakii | 59628 | Platyhelminthes | Platyhelminthes | 74.7 | 1.71e-13 | NR | KAF7259657.1 | 59628 | g11298 | i0 | 40 | 4.70036101083033 | 90 | 53 | 97.5 | 1 | 3 | 272 | 173 | 261 | KAF7259657.1 hypothetical protein EG68_02995 [Paragonimus skrjabini miyazakii] | diamond | 1302 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 29304244 | 29304244 | PRJNA685060_P_NODE_3389_length_536_cov_1.207343_g3299_i0 | PRJNA685060 | 3389 | 536 | 1.207343 | 6.47135848 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 57 | 7.46e-6 | NR | KAH9284518.1 | 6210 | g3299 | i0 | 44.8 | 2.92164179104478 | 58 | 32 | 32.5 | 0 | 361 | 188 | 745 | 802 | KAH9284518.1 putative cleavage and polyadenylation specificity factor subunit 2 [Echinococcus granulosus] | diamond | 1566 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 29513544 | 29513544 | PRJNA685060_P_NODE_2890_length_582_cov_1.357564_g2800_i0 | PRJNA685060 | 2890 | 582 | 1.357564 | 7.90102248 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 208 | 3.03e-64 | NR | VDM35634.1 | 6205 | g2800 | i0 | 51.4 | 0.93298969072165 | 181 | 88 | 93.3 | 0 | 39 | 581 | 1 | 181 | VDM35634.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 543 | 208 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 31167725 | 31167725 | PRJNA685060_P_NODE_15315_length_246_cov_1.462428_g15225_i0 | PRJNA685060 | 15315 | 246 | 1.462428 | 3.59757288 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 137 | 1.7e-37 | NR | THD27112.1 | 6192 | g15225 | i0 | 84 | 6.91463414634146 | 81 | 13 | 98.8 | 0 | 2 | 244 | 127 | 207 | THD27112.1 Arginine--tRNA ligase cytoplasmic [Fasciola hepatica] | diamond | 1701 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 32168870 | 32168870 | PRJNA685060_P_NODE_11738_length_272_cov_1.783920_g11648_i0 | PRJNA685060 | 11738 | 272 | 1.78392 | 4.8522624 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 49.7 | 1.85e-4 | NR | PAA52852.1 | 282301 | g11648 | i0 | 34.8 | 0.761029411764706 | 69 | 41 | 76.1 | 1 | 220 | 14 | 158 | 222 | PAA52852.1 hypothetical protein BOX15_Mlig010770g1, partial [Macrostomum lignano] | diamond | 207 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32717453 | 32717453 | PRJNA685060_P_NODE_3460_length_529_cov_1.337719_g3370_i0 | PRJNA685060 | 3460 | 529 | 1.337719 | 7.07653351 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 62 | 1.32e-7 | NR | CDS38124.2 | 6211 | g3370 | i0 | 62.2 | 0.998109640831758 | 45 | 17 | 25.5 | 0 | 6 | 140 | 183 | 227 | CDS38124.2 G protein signaling modulator 2 [Echinococcus multilocularis] | diamond | 528 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis |
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);;