contig_metadata
22 rows where bioproject = "PRJNA812715", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2087529 | 2087529 | PRJNA812715_P_NODE_106762_length_248_cov_2.605714_g104961_i0 | PRJNA812715 | 106762 | 248 | 2.605714 | 6.46217072 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 259 | 1.23e-64 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g104961 | i0 | 86.192 | 4.92741935483871 | 239 | 33 | 96 | 0 | 6 | 244 | 5154 | 5392 | Stenostomum sthenum mitochondrion, complete genome | blastn | 1222 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 4643132 | 4643132 | PRJNA812715_P_NODE_85444_length_276_cov_1.137931_g83643_i0 | PRJNA812715 | 85444 | 276 | 1.137931 | 3.14068956 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|690658596|emb|LN207720.1| | 99802 | g83643 | i0 | 96.774 | 0.22463768115942 | 31 | 1 | 11 | 0 | 235 | 265 | 1271 | 1301 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0174958 | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 8465513 | 8465513 | PRJNA812715_P_NODE_18447_length_808_cov_13.580952_g16886_i0 | PRJNA812715 | 18447 | 808 | 13.580952 | 109.73409216 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 1288 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g16886 | i0 | 95.432 | 26.3341584158416 | 810 | 33 | 100 | 4 | 1 | 808 | 8964 | 8157 | Stenostomum sthenum mitochondrion, complete genome | blastn | 21278 | 1288 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 11017028 | 11017028 | PRJNA812715_P_NODE_38249_length_461_cov_3.644330_g36459_i0 | PRJNA812715 | 38249 | 461 | 3.64433 | 16.8003613 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 514 | 4.75e-141 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g36459 | i0 | 86.9 | 78.353579175705 | 458 | 60 | 99 | 0 | 3 | 460 | 457 | 914 | Stenostomum sthenum mitochondrion, complete genome | blastn | 36121 | 514 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 13565261 | 13565261 | PRJNA812715_P_NODE_100431_length_252_cov_2.513966_g98630_i0 | PRJNA812715 | 100431 | 252 | 2.513966 | 6.33519432 | Brachylaima thompsoni | 138588 | Platyhelminthes | Platyhelminthes | 466 | 6.89e-127 | NTclustered | gi|31711564|gb|AY222085.1| | 138588 | g98630 | i0 | 100 | 86.515873015873 | 252 | 0 | 100 | 0 | 1 | 252 | 657 | 908 | Brachylaima thompsoni 18S ribosomal RNA gene, partial sequence | blastn | 21802 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Diplostomida | Brachylaimidae | Brachylaima | Brachylaima thompsoni | |
| 16116294 | 16116294 | PRJNA812715_P_NODE_56693_length_351_cov_2.115108_g54894_i0 | PRJNA812715 | 56693 | 351 | 2.115108 | 7.42402908 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 58.4 | 7.13e-4 | NTclustered | gi|687277514|emb|LK436380.1| | 57078 | g54894 | i0 | 86.207 | 0.925925925925926 | 58 | 3 | 15 | 4 | 247 | 300 | 215 | 271 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0041755 | blastn | 325 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 22490121 | 22490121 | PRJNA812715_P_NODE_42218_length_430_cov_1.725490_g40423_i0 | PRJNA812715 | 42218 | 430 | 1.72549 | 7.419607 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 154 | 2.03e-41 | NR | VDM34723.1 | 6205 | g40423 | i0 | 53.7 | 24.2232558139535 | 147 | 64 | 99.8 | 1 | 2 | 430 | 46 | 192 | VDM34723.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 10416 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 23765537 | 23765537 | PRJNA812715_P_NODE_34279_length_501_cov_1.794393_g32497_i0 | PRJNA812715 | 34279 | 501 | 1.794393 | 8.98990893 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 124 | 8.26e-32 | NR | AQN67664.1 | 52061 | g32497 | i0 | 90.9 | 0.395209580838323 | 66 | 6 | 39.5 | 0 | 199 | 2 | 165 | 230 | AQN67664.1 cytochrome oxidase subunit 3 [Stenostomum leucops] | diamond | 198 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 25039681 | 25039681 | PRJNA812715_P_NODE_41660_length_434_cov_2.060942_g39865_i0 | PRJNA812715 | 41660 | 434 | 2.060942 | 8.94448828 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 92 | 3.21e-19 | NR | YP_009391134.1 | 1611831 | g39865 | i0 | 70.4 | 0.490783410138249 | 71 | 21 | 49.1 | 0 | 433 | 221 | 40 | 110 | YP_009391134.1 NADH dehydrogenase subunit 1 [Stenostomum sthenum] | diamond | 213 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 27054393 | 27054393 | PRJNA812715_P_NODE_115902_length_244_cov_0.900585_g114101_i0 | PRJNA812715 | 115902 | 244 | 0.900585 | 2.1974274 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 110 | 3.18e-29 | NR | AQN67663.1 | 52061 | g114101 | i0 | 86.3 | 0.897540983606557 | 73 | 10 | 89.8 | 0 | 26 | 244 | 2 | 74 | AQN67663.1 NADH dehydrogenase subunit 3 [Stenostomum leucops] | diamond | 219 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 28096639 | 28096639 | PRJNA812715_P_NODE_94525_length_261_cov_2.117021_g92724_i0 | PRJNA812715 | 94525 | 261 | 2.117021 | 5.52542481 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 63.9 | 1.47e-9 | NR | PAA67170.1 | 282301 | g92724 | i0 | 65.4 | 3.27586206896552 | 52 | 17 | 59.8 | 1 | 105 | 260 | 312 | 362 | PAA67170.1 hypothetical protein BOX15_Mlig028343g3 [Macrostomum lignano] | diamond | 855 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28105238 | 28105238 | PRJNA812715_P_NODE_60265_length_338_cov_1.162264_g58466_i0 | PRJNA812715 | 60265 | 338 | 1.162264 | 3.92845232 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 56.2 | 1.31e-6 | NR | XP_009164229.1 | 6198 | g58466 | i0 | 63.2 | 1.01183431952663 | 38 | 14 | 33.7 | 0 | 117 | 4 | 2 | 39 | XP_009164229.1 hypothetical protein T265_01855 [Opisthorchis viverrini] | diamond | 342 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 28357803 | 28357803 | PRJNA812715_P_NODE_63246_length_327_cov_1.212598_g61447_i0 | PRJNA812715 | 63246 | 327 | 1.212598 | 3.96519546 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.0213 | NR | KAA0189579.1 | 27845 | g61447 | i0 | 59.4 | 0.871559633027523 | 32 | 13 | 29.4 | 0 | 1 | 96 | 612 | 643 | KAA0189579.1 Ankyrin 23:unc44 [Fasciolopsis buskii] | diamond | 285 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 28958082 | 28958082 | PRJNA812715_P_NODE_115388_length_244_cov_0.900585_g113587_i0 | PRJNA812715 | 115388 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 70.9 | 4.79e-12 | NR | XP_009162298.1 | 6198 | g113587 | i0 | 46.4 | 6.17213114754098 | 84 | 41 | 98.4 | 2 | 244 | 5 | 511 | 594 | XP_009162298.1 hypothetical protein T265_00289 [Opisthorchis viverrini] | diamond | 1506 | 71.2 | 0.995786516853933 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 29012573 | 29012573 | PRJNA812715_P_NODE_57808_length_347_cov_1.186131_g56009_i0 | PRJNA812715 | 57808 | 347 | 1.186131 | 4.11587457 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 62 | 1.93e-8 | NR | PAA73431.1 | 282301 | g56009 | i0 | 35.7 | 0.994236311239193 | 115 | 74 | 99.4 | 0 | 347 | 3 | 170 | 284 | PAA73431.1 hypothetical protein BOX15_Mlig020812g1 [Macrostomum lignano] | diamond | 345 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29147688 | 29147688 | PRJNA812715_P_NODE_48289_length_391_cov_28.273585_g46492_i0 | PRJNA812715 | 48289 | 391 | 28.273585 | 110.54971735 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 52.4 | 6.27e-5 | NR | CDS37392.1 | 6211 | g46492 | i0 | 41.3 | 1.71099744245524 | 75 | 32 | 54.5 | 4 | 312 | 100 | 206 | 272 | CDS37392.1 calbindin 32 [Echinococcus multilocularis] | diamond | 669 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 29422516 | 29422516 | PRJNA812715_P_NODE_92729_length_264_cov_1.612565_g90928_i0 | PRJNA812715 | 92729 | 264 | 1.612565 | 4.2571716 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 93.2 | 6.619999999999999e-23 | NR | PAA52392.1 | 282301 | g90928 | i0 | 84 | 3.54545454545455 | 50 | 8 | 56.8 | 0 | 234 | 85 | 1 | 50 | PAA52392.1 hypothetical protein BOX15_Mlig007628g1 [Macrostomum lignano] | diamond | 936 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30085799 | 30085799 | PRJNA812715_P_NODE_106332_length_249_cov_0.875000_g104531_i0 | PRJNA812715 | 106332 | 249 | 0.875 | 2.17875 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 102 | 4.0799999999999996e-23 | NR | PAA64936.1 | 282301 | g104531 | i0 | 53.7 | 1.96385542168675 | 82 | 38 | 98.8 | 0 | 247 | 2 | 2124 | 2205 | PAA64936.1 hypothetical protein BOX15_Mlig007406g1, partial [Macrostomum lignano] | diamond | 489 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30370750 | 30370750 | PRJNA812715_P_NODE_77692_length_288_cov_1.432558_g75892_i0 | PRJNA812715 | 77692 | 288 | 1.432558 | 4.12576704 | Schistosoma margrebowiei | 48269 | Platyhelminthes | Platyhelminthes | 47 | 0.00183 | NR | VDP17315.1 | 48269 | g75892 | i0 | 38.9 | 5.25 | 72 | 40 | 75 | 2 | 233 | 18 | 174 | 241 | VDP17315.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 1512 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei | |
| 30622848 | 30622848 | PRJNA812715_P_NODE_100173_length_253_cov_1.283333_g98372_i0 | PRJNA812715 | 100173 | 253 | 1.283333 | 3.24683249 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 57.8 | 2.15e-7 | NR | TGZ60883.1 | 147828 | g98372 | i0 | 32.1 | 3.84189723320158 | 81 | 54 | 94.9 | 1 | 13 | 252 | 120 | 200 | TGZ60883.1 hypothetical protein CRM22_008284 [Opisthorchis felineus] | diamond | 972 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 30907622 | 30907622 | PRJNA812715_P_NODE_89234_length_270_cov_1.172589_g87433_i0 | PRJNA812715 | 89234 | 270 | 1.172589 | 3.1659903 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 51.6 | 3.58e-5 | NR | PAA86061.1 | 282301 | g87433 | i0 | 43.9 | 1.26666666666667 | 57 | 27 | 57.8 | 1 | 107 | 262 | 272 | 328 | PAA86061.1 hypothetical protein BOX15_Mlig034042g1, partial [Macrostomum lignano] | diamond | 342 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31485391 | 31485391 | PRJNA812715_P_NODE_18656_length_801_cov_2.067308_g17093_i0 | PRJNA812715 | 18656 | 801 | 2.067308 | 16.55913708 | Echinococcus | 6209 | Platyhelminthes | Platyhelminthes | 53.5 | 4.12e-4 | NR | XP_024350927.1 | 6210 | g17093 | i0 | 37.9 | 0.973782771535581 | 87 | 47 | 30.3 | 3 | 553 | 795 | 329 | 414 | XP_024350927.1 Villin-2 [Echinococcus granulosus] | diamond | 780 | 53.5 | 1 | 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);;