contig_metadata
23 rows where bioproject = "PRJNA986481", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 973360 | 973360 | PRJNA986481_P_NODE_22921_length_342_cov_17.071672_g22396_i0 | PRJNA986481 | 22921 | 342 | 17.071672 | 58.38511824 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.032 | NTclustered | gi|690640268|emb|LN186750.1| | 99802 | g22396 | i0 | 100 | 0.0818713450292398 | 28 | 0 | 8 | 0 | 33 | 60 | 418 | 391 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0024628 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 974013 | 974013 | PRJNA986481_P_NODE_6641_length_626_cov_2.249567_g6163_i0 | PRJNA986481 | 6641 | 626 | 2.249567 | 14.08228942 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 145 | 3.55e-39 | NR | CAX78681.1 | 6182 | g6163 | i0 | 42.3 | 4.8258785942492 | 201 | 107 | 93.5 | 3 | 624 | 40 | 78 | 275 | CAX78681.1 ATP synthase gamma subunit [Schistosoma japonicum] | diamond | 3021 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 8626164 | 8626164 | PRJNA986481_P_NODE_11487_length_483_cov_3.976959_g10964_i0 | PRJNA986481 | 11487 | 483 | 3.976959 | 19.20871197 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 58.4 | 0.001 | NTclustered | gi|1084298719|ref|XM_018797412.1| | 6183 | g10964 | i0 | 97.143 | 0.072463768115942 | 35 | 0 | 7 | 1 | 218 | 251 | 347 | 313 | Schistosoma mansoni hypothetical protein partial mRNA | blastn | 35 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 11177116 | 11177116 | PRJNA986481_P_NODE_47469_length_255_cov_0.980583_g46944_i0 | PRJNA986481 | 47469 | 255 | 0.980583 | 2.50048665 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 155 | 6.189999999999999e-47 | NR | THD19570.1 | 6192 | g46944 | i0 | 79.8 | 0.988235294117647 | 84 | 17 | 98.8 | 0 | 254 | 3 | 11 | 94 | THD19570.1 peptidyl-prolyl cis-trans isomerase FKBP1B [Fasciola hepatica] | diamond | 252 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 11177171 | 11177171 | PRJNA986481_P_NODE_5089_length_701_cov_1.909509_g4657_i0 | PRJNA986481 | 5089 | 701 | 1.909509 | 13.38565809 | root | 1 | Root_unresolved | Root_unresolved | 272 | 1.12e-87 | NR | VEL24189.1 | 117903 | g4657 | i0 | 57.5 | 14.09272467903 | 240 | 92 | 99.7 | 4 | 3 | 701 | 44 | 280 | VEL24189.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 9879 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 15001120 | 15001120 | PRJNA986481_P_NODE_12172_length_469_cov_3.533333_g11648_i0 | PRJNA986481 | 12172 | 469 | 3.533333 | 16.57133177 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 719 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g11648 | i0 | 96.552 | 0.987206823027719 | 435 | 14 | 93 | 1 | 35 | 469 | 12 | 445 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 463 | 719 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 16276416 | 16276416 | PRJNA986481_P_NODE_3313_length_831_cov_3.210997_g2947_i0 | PRJNA986481 | 3313 | 831 | 3.210997 | 26.68338507 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 263 | 1.24e-79 | NR | VZI43868.1 | 99802 | g2947 | i0 | 56.3 | 7.96389891696751 | 254 | 106 | 89.9 | 2 | 2 | 748 | 391 | 644 | VZI43868.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 6618 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 16276562 | 16276562 | PRJNA986481_P_NODE_4333_length_748_cov_3.035765_g3925_i0 | PRJNA986481 | 4333 | 748 | 3.035765 | 22.7075222 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.021 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g3925 | i0 | 100 | 0.0387700534759358 | 29 | 0 | 4 | 0 | 165 | 193 | 5389 | 5361 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 27348634 | 27348634 | PRJNA986481_P_NODE_53563_length_248_cov_1.015075_g53038_i0 | PRJNA986481 | 53563 | 248 | 1.015075 | 2.517386 | root | 1 | Root_unresolved | Root_unresolved | 61.6 | 8.47e-9 | NR | PAA86614.1 | 282301 | g53038 | i0 | 38.3 | 10.4879032258065 | 81 | 50 | 98 | 0 | 6 | 248 | 272 | 352 | PAA86614.1 hypothetical protein BOX15_Mlig015420g1 [Macrostomum lignano] | diamond | 2601 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27405869 | 27405869 | PRJNA986481_P_NODE_21683_length_352_cov_1.537954_g21158_i0 | PRJNA986481 | 21683 | 352 | 1.537954 | 5.41359808 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 62.4 | 1.18e-8 | NR | CDS26181.1 | 85433 | g21158 | i0 | 52.6 | 1.09090909090909 | 57 | 27 | 48.6 | 0 | 351 | 181 | 218 | 274 | CDS26181.1 PDZ domain containing protein GIPC3 [Hymenolepis microstoma] | diamond | 384 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 28416145 | 28416145 | PRJNA986481_P_NODE_18426_length_381_cov_2.930723_g17901_i0 | PRJNA986481 | 18426 | 381 | 2.930723 | 11.16605463 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 52.8 | 5.51e-5 | NR | XP_018648288.1 | 6183 | g17901 | i0 | 30.4 | 9.98425196850394 | 112 | 64 | 77.2 | 1 | 46 | 339 | 404 | 515 | XP_018648288.1 putative vacuolar protein sorting 26, vps26 [Schistosoma mansoni] | diamond | 3804 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 28453737 | 28453737 | PRJNA986481_P_NODE_61286_length_236_cov_2.058824_g60761_i0 | PRJNA986481 | 61286 | 236 | 2.058824 | 4.85882464 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.2 | 1.87e-20 | NR | KAA0193465.1 | 27845 | g60761 | i0 | 56.8 | 8.21186440677966 | 81 | 32 | 99.2 | 2 | 1 | 234 | 42 | 122 | KAA0193465.1 Intron-binding protein aquarius [Fasciolopsis buskii] | diamond | 1938 | 94 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 29394881 | 29394881 | PRJNA986481_P_NODE_27489_length_313_cov_1.575758_g26964_i0 | PRJNA986481 | 27489 | 313 | 1.575758 | 4.93212254 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 78.6 | 1.77e-14 | NR | CAH8829328.1 | 157069 | g26964 | i0 | 48.1 | 2.14696485623003 | 77 | 40 | 73.8 | 0 | 79 | 309 | 321 | 397 | CAH8829328.1 unnamed protein product [Trichobilharzia regenti] | diamond | 672 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 29463519 | 29463519 | PRJNA986481_P_NODE_39970_length_264_cov_0.939535_g39445_i0 | PRJNA986481 | 39970 | 264 | 0.939535 | 2.4803724 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.6 | 0.00215 | NR | VZH95900.1 | 99802 | g39445 | i0 | 61.5 | 1.52272727272727 | 26 | 10 | 29.5 | 0 | 247 | 170 | 1407 | 1432 | VZH95900.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 402 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 30032466 | 30032466 | PRJNA986481_P_NODE_62131_length_230_cov_2.011050_g61606_i0 | PRJNA986481 | 62131 | 230 | 2.01105 | 4.625415 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.8 | 0.00176 | NR | VEL07385.1 | 117903 | g61606 | i0 | 30 | 4.0304347826087 | 60 | 42 | 78.3 | 0 | 1 | 180 | 14 | 73 | VEL07385.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 927 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 30879418 | 30879418 | PRJNA986481_P_NODE_46274_length_256_cov_1.753623_g45749_i0 | PRJNA986481 | 46274 | 256 | 1.753623 | 4.48927488 | Schistosoma margrebowiei | 48269 | Platyhelminthes | Platyhelminthes | 48.5 | 2.69e-5 | NR | VDO48312.1 | 48269 | g45749 | i0 | 68.4 | 0.4453125 | 38 | 12 | 44.5 | 0 | 139 | 252 | 1 | 38 | VDO48312.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 114 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei | |
| 30917220 | 30917220 | PRJNA986481_P_NODE_62254_length_229_cov_2.227778_g61729_i0 | PRJNA986481 | 62254 | 229 | 2.227778 | 5.10161162 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 99 | 1.94e-24 | NR | KAA3676974.1 | 34504 | g61729 | i0 | 73 | 5.3056768558952 | 63 | 17 | 82.5 | 0 | 192 | 4 | 9 | 71 | KAA3676974.1 large subunit ribosomal protein L13Ae [Paragonimus westermani] | diamond | 1215 | 99.4 | 0.995975855130785 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31486260 | 31486260 | PRJNA986481_P_NODE_1936_length_1030_cov_2.217125_g1653_i0 | PRJNA986481 | 1936 | 1030 | 2.217125 | 22.8363875 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 192 | 1.04e-52 | NR | KAF8570561.1 | 34504 | g1653 | i0 | 37.5 | 31.4912621359223 | 296 | 155 | 79.2 | 7 | 18 | 833 | 17 | 306 | KAF8570561.1 hypothetical protein P879_00404 [Paragonimus westermani] | diamond | 32436 | 193 | 0.994818652849741 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31865385 | 31865385 | PRJNA986481_P_NODE_17677_length_389_cov_3.135294_g17152_i0 | PRJNA986481 | 17677 | 389 | 3.135294 | 12.19629366 | Cestoda | 6199 | Platyhelminthes | Platyhelminthes | 93.6 | 1.61e-20 | NR | VDN13523.1 | 60516 | g17152 | i0 | 66.2 | 2.09768637532134 | 68 | 21 | 52.4 | 1 | 389 | 186 | 168 | 233 | VDN13523.1 unnamed protein product [Dibothriocephalus latus] | diamond | 816 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 31954465 | 31954465 | PRJNA986481_P_NODE_38957_length_265_cov_0.935185_g38432_i0 | PRJNA986481 | 38957 | 265 | 0.935185 | 2.47824025 | Schistosoma mattheei | 31246 | Platyhelminthes | Platyhelminthes | 93.6 | 1.08e-22 | NR | VDO74576.1 | 31246 | g38432 | i0 | 62.1 | 1.50566037735849 | 87 | 33 | 98.5 | 0 | 4 | 264 | 5 | 91 | VDO74576.1 unnamed protein product [Schistosoma mattheei] | diamond | 399 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mattheei | |
| 32277146 | 32277146 | PRJNA986481_P_NODE_29558_length_301_cov_1.650794_g29033_i0 | PRJNA986481 | 29558 | 301 | 1.650794 | 4.96888994 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 49.3 | 3.74e-4 | NR | XP_018644191.1 | 6183 | g29033 | i0 | 52.9 | 1.54485049833887 | 51 | 22 | 48.8 | 1 | 26 | 172 | 657 | 707 | XP_018644191.1 hydroxymethylglutaryl-CoA reductase (NADPH) [Schistosoma mansoni] | diamond | 465 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 32593352 | 32593352 | PRJNA986481_P_NODE_25739_length_323_cov_3.956204_g25214_i0 | PRJNA986481 | 25739 | 323 | 3.956204 | 12.77853892 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 2.3899999999999995e-32 | NR | VDM01124.1 | 70667 | g25214 | i0 | 53.8 | 10.7832817337461 | 106 | 48 | 98.5 | 1 | 5 | 322 | 14 | 118 | VDM01124.1 unnamed protein product [Schistocephalus solidus] | diamond | 3483 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 32744818 | 32744818 | PRJNA986481_P_NODE_15020_length_423_cov_2.489305_g14495_i0 | PRJNA986481 | 15020 | 423 | 2.489305 | 10.52976015 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 42.7 | 0.0387 | NR | CAH8586059.1 | 39320 | g14495 | i0 | 31.4 | 0.361702127659574 | 51 | 35 | 36.2 | 0 | 22 | 174 | 29 | 79 | CAH8586059.1 unnamed protein product [Heterobilharzia americana] | diamond | 153 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana |
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);;