contig_metadata
17 rows where bioproject = "PRJNA911178", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3443840 | 3443840 | PRJNA911178_P_NODE_307483_length_211_cov_4.985507_g305009_i0 | PRJNA911178 | 307483 | 211 | 4.985507 | 10.51941977 | Dolichomacrostomum uniporum | 683722 | Platyhelminthes | Platyhelminthes | 156 | 1.37e-33 | NTclustered | gi|261873730|gb|FJ715295.1| | 683722 | g305009 | i0 | 92.593 | 55.0473933649289 | 108 | 8 | 51 | 0 | 104 | 211 | 177 | 284 | Dolichomacrostomum uniporum voucher MTP LS 222 18S small subunit ribosomal RNA gene, partial sequence | blastn | 11615 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Dolichomacrostomidae | Dolichomacrostomum | Dolichomacrostomum uniporum | |
| 3443884 | 3443884 | PRJNA911178_P_NODE_33823_length_587_cov_1.778210_g31454_i0 | PRJNA911178 | 33823 | 587 | 1.77821 | 10.4380927 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 313 | 2.3599999999999996e-103 | NR | VDL90988.1 | 70667 | g31454 | i0 | 73.8 | 0.996592844974446 | 195 | 51 | 99.7 | 0 | 1 | 585 | 201 | 395 | VDL90988.1 unnamed protein product [Schistocephalus solidus] | diamond | 585 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 4720633 | 4720633 | PRJNA911178_P_NODE_200604_length_271_cov_2.131313_g198130_i0 | PRJNA911178 | 200604 | 271 | 2.131313 | 5.77585823 | root | 1 | Root_unresolved | Root_unresolved | 66.6 | 3.97e-11 | NR | CAH8627218.1 | 39320 | g198130 | i0 | 67.9 | 15.8413284132841 | 53 | 12 | 58.7 | 1 | 269 | 111 | 145 | 192 | CAH8627218.1 unnamed protein product [Heterobilharzia americana] | diamond | 4293 | 67 | 0.994029850746269 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 7628422 | 7628422 | PRJNA911178_P_NODE_290326_length_241_cov_2.232143_g287852_i0 | PRJNA911178 | 290326 | 241 | 2.232143 | 5.37946463 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 87.9 | 5.95e-13 | NTclustered | gi|10944725|emb|AJ270169.1| | 104912 | g287852 | i0 | 89.855 | 2.98755186721992 | 69 | 6 | 28 | 1 | 39 | 106 | 1635 | 1703 | Cirrifera dumosa partial 28S rRNA gene | blastn | 720 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Coelogynoporidae | Cirrifera | Cirrifera dumosa | |
| 11097132 | 11097132 | PRJNA911178_P_NODE_95249_length_369_cov_1.027027_g92779_i0 | PRJNA911178 | 95249 | 369 | 1.027027 | 3.78972963 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 115 | 4.16e-30 | NR | AAW25011.1 | 6182 | g92779 | i0 | 64.9 | 3.15447154471545 | 97 | 34 | 78.9 | 0 | 362 | 72 | 60 | 156 | AAW25011.1 SJCHGC00639 protein [Schistosoma japonicum] | diamond | 1164 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18744528 | 18744528 | PRJNA911178_P_NODE_303955_length_228_cov_2.916129_g301481_i0 | PRJNA911178 | 303955 | 228 | 2.916129 | 6.64877412 | Vorticeros auriculatum | 162278 | Platyhelminthes | Platyhelminthes | 73.1 | 1.56e-8 | NTclustered | gi|2316424318|gb|OP626913.1| | 162278 | g301481 | i0 | 89.474 | 0.25 | 57 | 6 | 25 | 0 | 2 | 58 | 1744 | 1688 | Vorticeros auriculatum large subunit ribosomal RNA gene, partial sequence | blastn | 57 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Prolecithophora | Plagiostomidae | Vorticeros | Vorticeros auriculatum | |
| 21293899 | 21293899 | PRJNA911178_P_NODE_182677_length_281_cov_2.163462_g180204_i0 | PRJNA911178 | 182677 | 281 | 2.163462 | 6.07932822 | Proteocephalus tetrastomus | 100447 | Platyhelminthes | Platyhelminthes | 359 | 1.36e-94 | NTclustered | gi|2396160519|gb|OP972512.1| | 100447 | g180204 | i0 | 90.842 | 79.7153024911032 | 273 | 18 | 96 | 4 | 11 | 281 | 4189 | 4456 | Proteocephalus tetrastomus isolate JP244a large subunit ribosomal RNA gene, partial sequence | blastn | 22400 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Proteocephalidea | Proteocephalidae | Proteocephalus | Proteocephalus tetrastomus | |
| 22569365 | 22569365 | PRJNA911178_P_NODE_223038_length_259_cov_2.096774_g220564_i0 | PRJNA911178 | 223038 | 259 | 2.096774 | 5.43064466 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.024 | NTclustered | gi|687173920|emb|LN091496.1| | 99802 | g220564 | i0 | 100 | 0.216216216216216 | 28 | 0 | 11 | 0 | 1 | 28 | 2697 | 2670 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0087159 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27727301 | 27727301 | PRJNA911178_P_NODE_237984_length_252_cov_1.368715_g235510_i0 | PRJNA911178 | 237984 | 252 | 1.368715 | 3.4491618 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 70.1 | 8.92e-12 | NR | VDN09792.1 | 60516 | g235510 | i0 | 34.6 | 9.52380952380952 | 78 | 51 | 92.9 | 0 | 234 | 1 | 66 | 143 | VDN09792.1 unnamed protein product [Dibothriocephalus latus] | diamond | 2400 | 70.5 | 0.994326241134752 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 28287661 | 28287661 | PRJNA911178_P_NODE_52426_length_479_cov_1.965517_g49991_i0 | PRJNA911178 | 52426 | 479 | 1.965517 | 9.41482643 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 219 | 3.0399999999999996e-67 | NR | PAA59047.1 | 282301 | g49991 | i0 | 69.4 | 16.0459290187891 | 160 | 48 | 99.6 | 1 | 479 | 3 | 220 | 379 | PAA59047.1 hypothetical protein BOX15_Mlig004255g2 [Macrostomum lignano] | diamond | 7686 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29273840 | 29273840 | PRJNA911178_P_NODE_242229_length_251_cov_0.865169_g239755_i0 | PRJNA911178 | 242229 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 50.8 | 5.94e-5 | NR | VDM17326.1 | 6205 | g239755 | i0 | 42.1 | 3 | 57 | 33 | 68.1 | 0 | 9 | 179 | 23 | 79 | VDM17326.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 753 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29361401 | 29361401 | PRJNA911178_P_NODE_80529_length_396_cov_1.390093_g78062_i0 | PRJNA911178 | 80529 | 396 | 1.390093 | 5.50476828 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 159 | 3.21e-42 | NR | PAA77462.1 | 282301 | g78062 | i0 | 58.5 | 97.0909090909091 | 123 | 51 | 93.2 | 0 | 11 | 379 | 704 | 826 | PAA77462.1 hypothetical protein BOX15_Mlig027115g1 [Macrostomum lignano] | diamond | 38448 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29779171 | 29779171 | PRJNA911178_P_NODE_280911_length_243_cov_1.317647_g278437_i0 | PRJNA911178 | 280911 | 243 | 1.317647 | 3.20188221 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 3.9899999999999997e-28 | NR | THD26383.1 | 6192 | g278437 | i0 | 72.2 | 179.962962962963 | 72 | 20 | 88.9 | 0 | 3 | 218 | 36 | 107 | THD26383.1 Stromal membrane-associated protein 1 [Fasciola hepatica] | diamond | 43731 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 29937211 | 29937211 | PRJNA911178_P_NODE_276511_length_244_cov_0.900585_g274037_i0 | PRJNA911178 | 276511 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 58.9 | 7.31e-8 | NR | CAL5139996.1 | 300641 | g274037 | i0 | 43.8 | 2.21311475409836 | 64 | 36 | 78.7 | 0 | 227 | 36 | 398 | 461 | CAL5139996.1 unnamed protein product [Calicophoron daubneyi] | diamond | 540 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 31264203 | 31264203 | PRJNA911178_P_NODE_188655_length_278_cov_1.443902_g186182_i0 | PRJNA911178 | 188655 | 278 | 1.443902 | 4.01404756 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 50.1 | 1.5e-4 | NR | XP_009166273.1 | 6198 | g186182 | i0 | 42.6 | 6.94964028776978 | 61 | 31 | 64.7 | 2 | 186 | 7 | 472 | 529 | XP_009166273.1 hypothetical protein T265_13260 [Opisthorchis viverrini] | diamond | 1932 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 31825937 | 31825937 | PRJNA911178_P_NODE_257777_length_248_cov_0.880000_g255303_i0 | PRJNA911178 | 257777 | 248 | 0.88 | 2.1824 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 56.2 | 6.79e-7 | NR | CAL5134809.1 | 300641 | g255303 | i0 | 47.8 | 0.810483870967742 | 67 | 26 | 81 | 1 | 246 | 46 | 352 | 409 | CAL5134809.1 unnamed protein product [Calicophoron daubneyi] | diamond | 201 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 32490709 | 32490709 | PRJNA911178_P_NODE_125399_length_329_cov_0.894531_g122927_i0 | PRJNA911178 | 125399 | 329 | 0.894531 | 2.94300699 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 43.9 | 0.0411 | NR | TGZ66094.1 | 147828 | g122927 | i0 | 58.6 | 0.52887537993921 | 29 | 12 | 26.4 | 0 | 92 | 6 | 1541 | 1569 | TGZ66094.1 hypothetical protein CRM22_005540 [Opisthorchis felineus] | diamond | 174 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus |
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);;