contig_metadata
25 rows where bioproject = "PRJNA857143", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 843097 | 843097 | PRJNA857143_S_NODE_130641_length_282_cov_3.698565_g129548_i0 | PRJNA857143 | 130641 | 282 | 3.698565 | 10.4299533 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 67.6 | 9.29e-7 | NTclustered | gi|690633163|emb|LN178688.1| | 99802 | g129548 | i0 | 91.837 | 0.535460992907801 | 49 | 2 | 17 | 2 | 122 | 169 | 1124 | 1171 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0156785 | blastn | 151 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 2118469 | 2118469 | PRJNA857143_S_NODE_12382_length_627_cov_35.597473_g11359_i0 | PRJNA857143 | 12382 | 627 | 35.597473 | 223.19615571 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 195 | 5.61e-57 | NR | PAA90203.1 | 282301 | g11359 | i0 | 69.6 | 18.7416267942584 | 135 | 41 | 64.6 | 0 | 3 | 407 | 260 | 394 | PAA90203.1 hypothetical protein BOX15_Mlig031719g1, partial [Macrostomum lignano] | diamond | 11751 | 196 | 0.994897959183674 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 2119057 | 2119057 | PRJNA857143_S_NODE_181382_length_248_cov_0.891429_g180289_i0 | PRJNA857143 | 181382 | 248 | 0.891429 | 2.21074392 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|690495900|emb|LN042475.1| | 99802 | g180289 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 18 | 45 | 3230 | 3257 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0041455 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 3394635 | 3394635 | PRJNA857143_S_NODE_32983_length_451_cov_4.407407_g31891_i0 | PRJNA857143 | 32983 | 451 | 4.407407 | 19.87740557 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 127 | 3.4599999999999998e-34 | NR | VDO04279.1 | 102285 | g31891 | i0 | 71.3 | 2.12860310421286 | 80 | 23 | 53.2 | 0 | 450 | 211 | 70 | 149 | VDO04279.1 unnamed protein product [Rodentolepis nana] | diamond | 960 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 3395134 | 3395134 | PRJNA857143_S_NODE_83643_length_333_cov_5.326923_g82550_i0 | PRJNA857143 | 83643 | 333 | 5.326923 | 17.73865359 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.009 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g82550 | i0 | 100 | 0.0870870870870871 | 29 | 0 | 9 | 0 | 138 | 166 | 5361 | 5389 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 5946324 | 5946324 | PRJNA857143_S_NODE_126985_length_286_cov_1.107981_g125892_i0 | PRJNA857143 | 126985 | 286 | 1.107981 | 3.16882566 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 442 | 1.3399999999999994e-119 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g125892 | i0 | 94.737 | 118.461538461538 | 285 | 13 | 99 | 1 | 4 | 286 | 1205 | 1489 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 33880 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5947090 | 5947090 | PRJNA857143_S_NODE_197925_length_235_cov_2.407407_g196832_i0 | PRJNA857143 | 197925 | 235 | 2.407407 | 5.65740645 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.021 | NTclustered | gi|690843830|emb|LN342126.1| | 99802 | g196832 | i0 | 96.774 | 0.131914893617021 | 31 | 1 | 13 | 0 | 92 | 122 | 777 | 747 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0115339 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 7613343 | 7613343 | PRJNA857143_S_NODE_28706_length_472_cov_1.172932_g27614_i0 | PRJNA857143 | 28706 | 472 | 1.172932 | 5.53623904 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 54.7 | 0.013 | NTclustered | gi|690518042|emb|LN068899.1| | 99802 | g27614 | i0 | 96.875 | 0.665254237288136 | 32 | 1 | 7 | 0 | 12 | 43 | 3369 | 3400 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0066497 | blastn | 314 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 8496772 | 8496772 | PRJNA857143_S_NODE_22287_length_512_cov_18.974943_g21201_i0 | PRJNA857143 | 22287 | 512 | 18.974943 | 97.15170816 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 162 | 7.18e-47 | NR | VDL89772.1 | 70667 | g21201 | i0 | 72.5 | 10.3125 | 102 | 28 | 59.8 | 0 | 2 | 307 | 108 | 209 | VDL89772.1 unnamed protein product [Schistocephalus solidus] | diamond | 5280 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 12323410 | 12323410 | PRJNA857143_S_NODE_57030_length_379_cov_5.633987_g55937_i0 | PRJNA857143 | 57030 | 379 | 5.633987 | 21.35281073 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 89.7 | 3.58e-19 | NR | XP_024352596.1 | 6210 | g55937 | i0 | 53.7 | 4.70976253298153 | 82 | 38 | 64.9 | 0 | 375 | 130 | 71 | 152 | XP_024352596.1 60S ribosomal protein L21 [Echinococcus granulosus] | diamond | 1785 | 90.5 | 0.991160220994475 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 15263252 | 15263252 | PRJNA857143_S_NODE_142352_length_272_cov_6.768844_g141259_i0 | PRJNA857143 | 142352 | 272 | 6.768844 | 18.41125568 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|690665069|emb|LN215076.1| | 99802 | g141259 | i0 | 100 | 0.411764705882353 | 28 | 0 | 10 | 0 | 128 | 155 | 1402 | 1375 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0035947 | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 25069313 | 25069313 | PRJNA857143_S_NODE_140120_length_274_cov_2.328358_g139027_i0 | PRJNA857143 | 140120 | 274 | 2.328358 | 6.37970092 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|687237152|emb|LK406577.1| | 57078 | g139027 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 242 | 269 | 2115 | 2088 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0013130 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26738086 | 26738086 | PRJNA857143_S_NODE_116601_length_295_cov_4.409910_g115508_i0 | PRJNA857143 | 116601 | 295 | 4.40991 | 13.0092345 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 101 | 9.36e-25 | NR | CAL5129748.1 | 300641 | g115508 | i0 | 67.1 | 0.772881355932203 | 76 | 25 | 77.3 | 0 | 3 | 230 | 92 | 167 | CAL5129748.1 unnamed protein product [Calicophoron daubneyi] | diamond | 228 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 27505814 | 27505814 | PRJNA857143_S_NODE_107143_length_305_cov_2.211207_g106050_i0 | PRJNA857143 | 107143 | 305 | 2.211207 | 6.74418135 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 78.2 | 2.05e-16 | NR | PAA47994.1 | 282301 | g106050 | i0 | 48.6 | 2.20327868852459 | 70 | 36 | 68.9 | 0 | 50 | 259 | 20 | 89 | PAA47994.1 hypothetical protein BOX15_Mlig010661g1, partial [Macrostomum lignano] | diamond | 672 | 78.6 | 0.994910941475827 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27695353 | 27695353 | PRJNA857143_S_NODE_83864_length_333_cov_2.400000_g82771_i0 | PRJNA857143 | 83864 | 333 | 2.4 | 7.992 | Fasciola | 6191 | Platyhelminthes | Platyhelminthes | 163 | 6.55e-44 | NR | THD23899.1 | 6192 | g82771 | i0 | 71.7 | 30.1261261261261 | 106 | 30 | 95.5 | 0 | 1 | 318 | 3978 | 4083 | THD23899.1 Dynein heavy chain axonemal [Fasciola hepatica] | diamond | 10032 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 27852859 | 27852859 | PRJNA857143_S_NODE_155844_length_262_cov_1.650794_g154751_i0 | PRJNA857143 | 155844 | 262 | 1.650794 | 4.32508028 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.4 | 5.66e-9 | NR | VDD76947.1 | 53468 | g154751 | i0 | 43.8 | 2.54198473282443 | 80 | 44 | 91.6 | 1 | 1 | 240 | 380 | 458 | VDD76947.1 unnamed protein product [Mesocestoides corti] | diamond | 666 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 29013312 | 29013312 | PRJNA857143_S_NODE_42928_length_415_cov_3.347953_g41835_i0 | PRJNA857143 | 42928 | 415 | 3.347953 | 13.89400495 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 62 | 4.02e-8 | NR | XP_024350927.1 | 6210 | g41835 | i0 | 37.5 | 1.38795180722892 | 96 | 53 | 65.1 | 3 | 395 | 126 | 329 | 423 | XP_024350927.1 Villin-2 [Echinococcus granulosus] | diamond | 576 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 29021521 | 29021521 | PRJNA857143_S_NODE_51488_length_392_cov_3.504702_g50395_i0 | PRJNA857143 | 51488 | 392 | 3.504702 | 13.73843184 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 54.7 | 1.17e-5 | NR | VDP28720.1 | 6186 | g50395 | i0 | 41.3 | 0.933673469387755 | 63 | 36 | 47.4 | 1 | 384 | 199 | 307 | 369 | VDP28720.1 unnamed protein product [Schistosoma curassoni] | diamond | 366 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni | |
| 29052883 | 29052883 | PRJNA857143_S_NODE_66328_length_361_cov_2.166667_g65235_i0 | PRJNA857143 | 66328 | 361 | 2.166667 | 7.82166787 | Echinococcus | 6209 | Platyhelminthes | Platyhelminthes | 103 | 8.1e-26 | NR | KAH9279849.1 | 6210 | g65235 | i0 | 80.3 | 2.02770083102493 | 61 | 12 | 50.7 | 0 | 2 | 184 | 45 | 105 | KAH9279849.1 Cytochrome c [Echinococcus granulosus] | diamond | 732 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 29234095 | 29234095 | PRJNA857143_S_NODE_137549_length_276_cov_4.561576_g136456_i0 | PRJNA857143 | 137549 | 276 | 4.561576 | 12.58994976 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 60.8 | 1.26e-8 | NR | KAF8563457.1 | 34504 | g136456 | i0 | 53.3 | 0.489130434782609 | 45 | 21 | 48.9 | 0 | 274 | 140 | 200 | 244 | KAF8563457.1 hypothetical protein P879_10088 [Paragonimus westermani] | diamond | 135 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 30600252 | 30600252 | PRJNA857143_S_NODE_53793_length_387_cov_1.242038_g52700_i0 | PRJNA857143 | 53793 | 387 | 1.242038 | 4.80668706 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 88.2 | 5.83e-20 | NR | CDS41787.1 | 6211 | g52700 | i0 | 69.2 | 23.4031007751938 | 52 | 16 | 40.3 | 0 | 369 | 214 | 38 | 89 | CDS41787.1 dynein light chain [Echinococcus multilocularis] | diamond | 9057 | 88.6 | 0.99548532731377 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 30631803 | 30631803 | PRJNA857143_S_NODE_187973_length_245_cov_0.906977_g186880_i0 | PRJNA857143 | 187973 | 245 | 0.906977 | 2.22209365 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 47.4 | 3.6e-4 | NR | AAX27740.2 | 6182 | g186880 | i0 | 52.9 | 3.33061224489796 | 34 | 16 | 41.6 | 0 | 242 | 141 | 119 | 152 | AAX27740.2 SJCHGC05001 protein, partial [Schistosoma japonicum] | diamond | 816 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30916494 | 30916494 | PRJNA857143_S_NODE_202054_length_197_cov_5.112903_g200961_i0 | PRJNA857143 | 202054 | 197 | 5.112903 | 10.07241891 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 42.4 | 0.026 | NR | XP_024349005.1 | 6210 | g200961 | i0 | 86.4 | 4.02030456852792 | 22 | 3 | 33.5 | 0 | 2 | 67 | 229 | 250 | XP_024349005.1 Elongation factor 1-delta [Echinococcus granulosus] | diamond | 792 | 42.7 | 0.992974238875878 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31706736 | 31706736 | PRJNA857143_S_NODE_85437_length_331_cov_1.813953_g84344_i0 | PRJNA857143 | 85437 | 331 | 1.813953 | 6.00418443 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 117 | 4.27e-28 | NR | VDL94381.1 | 70667 | g84344 | i0 | 73.6 | 11.9456193353474 | 72 | 19 | 65.3 | 0 | 2 | 217 | 428 | 499 | VDL94381.1 unnamed protein product [Schistocephalus solidus] | diamond | 3954 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 32812844 | 32812844 | PRJNA857143_S_NODE_117420_length_295_cov_1.054054_g116327_i0 | PRJNA857143 | 117420 | 295 | 1.054054 | 3.1094593 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 54.7 | 3.8e-6 | NR | KAH9279678.1 | 6210 | g116327 | i0 | 47.5 | 5.13559322033898 | 59 | 26 | 54.9 | 1 | 12 | 173 | 149 | 207 | KAH9279678.1 Squidulin [Echinococcus granulosus] | diamond | 1515 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus |
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);;