contig_metadata
23 rows where bioproject = "PRJNA414036", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 418659 | 418659 | PRJNA414036_P_NODE_13441_length_396_cov_3.833795_g11800_i0 | PRJNA414036 | 13441 | 396 | 3.833795 | 15.1818282 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.011 | NTclustered | gi|690489241|emb|LN033914.1| | 99802 | g11800 | i0 | 100 | 0.0732323232323232 | 29 | 0 | 7 | 0 | 67 | 95 | 6891 | 6919 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0033214 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 6185951 | 6185951 | PRJNA414036_P_NODE_23645_length_312_cov_2.617329_g21913_i0 | PRJNA414036 | 23645 | 312 | 2.617329 | 8.16606648 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.029 | NTclustered | gi|690520673|emb|LN072066.1| | 99802 | g21913 | i0 | 100 | 0.179487179487179 | 28 | 0 | 9 | 0 | 1 | 28 | 532 | 559 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0069459 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 8072116 | 8072116 | PRJNA414036_P_NODE_7087_length_478_cov_3.661400_g5865_i0 | PRJNA414036 | 7087 | 478 | 3.6614 | 17.501492 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 54.7 | 0.013 | NTclustered | gi|2318761183|ref|XM_051214134.1| | 6185 | g5865 | i0 | 100 | 0.0606694560669456 | 29 | 0 | 6 | 0 | 215 | 243 | 1089 | 1061 | Schistosoma haematobium uncharacterized protein (MS3_00006035), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 9346943 | 9346943 | PRJNA414036_P_NODE_56648_length_229_cov_2.969072_g54909_i0 | PRJNA414036 | 56648 | 229 | 2.969072 | 6.79917488 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.02 | NTclustered | gi|690548685|emb|LN102200.1| | 99802 | g54909 | i0 | 96.774 | 0.135371179039301 | 31 | 1 | 14 | 0 | 63 | 93 | 3548 | 3518 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0096665 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 9346948 | 9346948 | PRJNA414036_P_NODE_59148_length_220_cov_1.827027_g57409_i0 | PRJNA414036 | 59148 | 220 | 1.827027 | 4.0194594 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.019 | NTclustered | gi|687163771|emb|LN041354.1| | 99802 | g57409 | i0 | 100 | 0.127272727272727 | 28 | 0 | 13 | 0 | 59 | 86 | 6505 | 6478 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0040372 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 11897696 | 11897696 | PRJNA414036_P_NODE_83550_length_157_cov_4.336066_g81811_i0 | PRJNA414036 | 83550 | 157 | 4.336066 | 6.80762362 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.013 | NTclustered | gi|690856779|emb|LN356732.1| | 99802 | g81811 | i0 | 100 | 0.178343949044586 | 28 | 0 | 18 | 0 | 23 | 50 | 564 | 591 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0126361 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27201775 | 27201775 | PRJNA414036_P_NODE_1462_length_676_cov_3.781591_g379_i2 | PRJNA414036 | 1462 | 676 | 3.781591 | 25.56355516 | Paragonimus kellicotti | 100269 | Platyhelminthes | Platyhelminthes | 45.8 | 0.0104 | NR | KAF6769089.1 | 100269 | g379 | i2 | 60 | 0.177514792899408 | 40 | 16 | 17.8 | 0 | 660 | 541 | 31 | 70 | KAF6769089.1 putative secreted peptide [Paragonimus kellicotti] | diamond | 120 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 28102738 | 28102738 | PRJNA414036_P_NODE_22825_length_317_cov_4.613475_g21094_i0 | PRJNA414036 | 22825 | 317 | 4.613475 | 14.62471575 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 95.1 | 2.64e-21 | NR | CAX70651.1 | 6182 | g21094 | i0 | 70.8 | 97.2018927444795 | 65 | 19 | 61.5 | 0 | 117 | 311 | 169 | 233 | CAX70651.1 alpha subunit of casein kinase II [Schistosoma japonicum] | diamond | 30813 | 95.9 | 0.991657977059437 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28260585 | 28260585 | PRJNA414036_P_NODE_7446_length_472_cov_4.665904_g6180_i0 | PRJNA414036 | 7446 | 472 | 4.665904 | 22.02306688 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 149 | 6.5e-42 | NR | VDL57253.1 | 6216 | g6180 | i0 | 57.8 | 54.5656779661017 | 154 | 65 | 97.9 | 0 | 472 | 11 | 31 | 184 | VDL57253.1 unnamed protein product [Hymenolepis diminuta] | diamond | 25755 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 29176600 | 29176600 | PRJNA414036_P_NODE_11149_length_421_cov_6.593264_g9587_i0 | PRJNA414036 | 11149 | 421 | 6.593264 | 27.75764144 | root | 1 | Root_unresolved | Root_unresolved | 157 | 1.1999999999999999e-41 | NR | TNN12723.1 | 6182 | g9587 | i0 | 83.7 | 411.106888361045 | 86 | 14 | 61.3 | 0 | 101 | 358 | 15 | 100 | TNN12723.1 Tubulin alpha-3 chain [Schistosoma japonicum] | diamond | 173076 | 158 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29349284 | 29349284 | PRJNA414036_P_NODE_32809_length_260_cov_9.435556_g31073_i0 | PRJNA414036 | 32809 | 260 | 9.435556 | 24.5324456 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 87 | 5.22e-18 | NR | VDO08988.1 | 102285 | g31073 | i0 | 59 | 0.957692307692308 | 83 | 34 | 95.8 | 0 | 10 | 258 | 53 | 135 | VDO08988.1 unnamed protein product [Rodentolepis nana] | diamond | 249 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 29759533 | 29759533 | PRJNA414036_P_NODE_76851_length_168_cov_3.338346_g75112_i0 | PRJNA414036 | 76851 | 168 | 3.338346 | 5.60842128 | Paragonimus kellicotti | 100269 | Platyhelminthes | Platyhelminthes | 45.4 | 3.13e-4 | NR | KAF6769089.1 | 100269 | g75112 | i0 | 56.3 | 1.71428571428571 | 48 | 21 | 85.7 | 0 | 2 | 145 | 12 | 59 | KAF6769089.1 putative secreted peptide [Paragonimus kellicotti] | diamond | 288 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 29934400 | 29934400 | PRJNA414036_P_NODE_24031_length_309_cov_3.919708_g22299_i0 | PRJNA414036 | 24031 | 309 | 3.919708 | 12.11189772 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.6 | 1.1e-6 | NR | VDL22002.1 | 6216 | g22299 | i0 | 76.3 | 82.8640776699029 | 38 | 9 | 36.9 | 0 | 195 | 308 | 869 | 906 | VDL22002.1 unnamed protein product [Hymenolepis diminuta] | diamond | 25605 | 57 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 30250404 | 30250404 | PRJNA414036_P_NODE_61572_length_210_cov_3.325714_g59833_i0 | PRJNA414036 | 61572 | 210 | 3.325714 | 6.9839994 | Cestoda | 6199 | Platyhelminthes | Platyhelminthes | 45.1 | 0.00155 | NR | VDD76545.1 | 53468 | g59833 | i0 | 54.3 | 2.62857142857143 | 46 | 21 | 65.7 | 0 | 170 | 33 | 17 | 62 | VDD76545.1 unnamed protein product [Mesocestoides corti] | diamond | 552 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 30755764 | 30755764 | PRJNA414036_P_NODE_52734_length_231_cov_1.760204_g50995_i0 | PRJNA414036 | 52734 | 231 | 1.760204 | 4.06607124 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0169 | NR | VDM33245.1 | 6205 | g50995 | i0 | 77.3 | 1.14285714285714 | 22 | 5 | 28.6 | 0 | 9 | 74 | 154 | 175 | VDM33245.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 264 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 31197609 | 31197609 | PRJNA414036_P_NODE_22335_length_320_cov_10.796491_g20605_i0 | PRJNA414036 | 22335 | 320 | 10.796491 | 34.5487712 | root | 1 | Root_unresolved | Root_unresolved | 84.3 | 2.16e-17 | NR | XP_009174184.1 | 6198 | g20605 | i0 | 97.8 | 136.70625 | 46 | 1 | 43.1 | 0 | 181 | 318 | 132 | 177 | XP_009174184.1 hypothetical protein T265_09750 [Opisthorchis viverrini] | diamond | 43746 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 31276176 | 31276176 | PRJNA414036_P_NODE_77475_length_167_cov_2.795455_g75736_i0 | PRJNA414036 | 77475 | 167 | 2.795455 | 4.66840985 | Taenia asiatica | 60517 | Platyhelminthes | Platyhelminthes | 46.2 | 7.91e-4 | NR | VDK39298.1 | 60517 | g75736 | i0 | 56.6 | 1.88622754491018 | 53 | 23 | 95.2 | 0 | 160 | 2 | 365 | 417 | VDK39298.1 unnamed protein product [Taenia asiatica] | diamond | 315 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 31324466 | 31324466 | PRJNA414036_P_NODE_34895_length_251_cov_7.245370_g33159_i0 | PRJNA414036 | 34895 | 251 | 7.24537 | 18.1858787 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 45.4 | 0.0047 | NR | RTG87629.1 | 6184 | g33159 | i0 | 77.4 | 58.5418326693227 | 31 | 7 | 37.1 | 0 | 15 | 107 | 956 | 986 | RTG87629.1 DNA-directed RNA polymerase II subunit RPB2 [Schistosoma bovis] | diamond | 14694 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 31830412 | 31830412 | PRJNA414036_P_NODE_18777_length_347_cov_4.663462_g17055_i0 | PRJNA414036 | 18777 | 347 | 4.663462 | 16.182213140000002 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 90.9 | 1.66e-18 | NR | OON16856.1 | 6198 | g17055 | i0 | 84.5 | 201.051873198847 | 58 | 9 | 50.1 | 0 | 111 | 284 | 490 | 547 | OON16856.1 HEAT repeat protein, partial [Opisthorchis viverrini] | diamond | 69765 | 91.3 | 0.995618838992333 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 31893851 | 31893851 | PRJNA414036_P_NODE_65957_length_195_cov_1.775000_g64218_i0 | PRJNA414036 | 65957 | 195 | 1.775 | 3.46125 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 51.2 | 1.85e-6 | NR | THD24764.1 | 6192 | g64218 | i0 | 53.6 | 15.5076923076923 | 56 | 26 | 86.2 | 0 | 3 | 170 | 32 | 87 | THD24764.1 AP-2 complex subunit mu [Fasciola hepatica] | diamond | 3024 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 32003860 | 32003860 | PRJNA414036_P_NODE_76878_length_168_cov_3.045113_g75139_i0 | PRJNA414036 | 76878 | 168 | 3.045113 | 5.11578984 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 58.9 | 1.55e-9 | NR | XP_018645103.1 | 6183 | g75139 | i0 | 60 | 0.892857142857143 | 50 | 20 | 89.3 | 0 | 15 | 164 | 7 | 56 | XP_018645103.1 unnamed protein product [Schistosoma mansoni] | diamond | 150 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 32652529 | 32652529 | PRJNA414036_P_NODE_82220_length_159_cov_4.298387_g80481_i0 | PRJNA414036 | 82220 | 159 | 4.298387 | 6.83443533 | root | 1 | Root_unresolved | Root_unresolved | 79.7 | 1.23e-16 | NR | KAH8860054.1 | 6182 | g80481 | i0 | 83.3 | 279.056603773585 | 48 | 8 | 90.6 | 0 | 156 | 13 | 51 | 98 | KAH8860054.1 Cdc42 like [Schistosoma japonicum] | diamond | 44370 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32778626 | 32778626 | PRJNA414036_P_NODE_24460_length_306_cov_6.723247_g22728_i0 | PRJNA414036 | 24460 | 306 | 6.723247 | 20.57313582 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 68.2 | 9.46e-11 | NR | CDS24365.1 | 6210 | g22728 | i0 | 53.2 | 54.3823529411765 | 94 | 32 | 92.2 | 1 | 290 | 9 | 1867 | 1948 | CDS24365.1 pre mRNA processing splicing factor 8 [Echinococcus granulosus] | diamond | 16641 | 68.6 | 0.994169096209913 | 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);;