contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 705795 | 705795 | PRJNA715462_P_NODE_33661_length_305_cov_1.387931_g32865_i0 | PRJNA715462 | 33661 | 305 | 1.387931 | 4.23318955 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 145 | 6.719999999999998e-42 | NR | ABN14943.1 | 60517 | g32865 | i0 | 70.3 | 101.773770491803 | 101 | 30 | 99.3 | 0 | 303 | 1 | 33 | 133 | ABN14943.1 neural class-II beta tubulin [Taenia asiatica] | diamond | 31041 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 706437 | 706437 | PRJNA715462_P_NODE_66621_length_242_cov_0.911243_g65825_i0 | PRJNA715462 | 66621 | 242 | 0.911243 | 2.20520806 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 133 | 1.76e-34 | NR | VZI16006.1 | 99802 | g65825 | i0 | 72.5 | 1.98347107438017 | 80 | 22 | 99.2 | 0 | 2 | 241 | 227 | 306 | VZI16006.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 480 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 7085216 | 7085216 | PRJNA715462_P_NODE_7906_length_799_cov_4.881543_g7184_i0 | PRJNA715462 | 7906 | 799 | 4.881543 | 39.00352857 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 241 | 1.98e-76 | NR | VEL29129.1 | 117903 | g7184 | i0 | 69.9 | 14.9511889862328 | 166 | 50 | 62.3 | 0 | 46 | 543 | 29 | 194 | VEL29129.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 11946 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 14734285 | 14734285 | PRJNA715462_P_NODE_15052_length_502_cov_1.951049_g14257_i0 | PRJNA715462 | 15052 | 502 | 1.951049 | 9.79426598 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 102 | 3.59e-24 | NR | TNN20708.1 | 6182 | g14257 | i0 | 47.7 | 2.36653386454183 | 132 | 64 | 77.7 | 2 | 502 | 113 | 30 | 158 | TNN20708.1 ATP synthase subunit gamma [Schistosoma japonicum] | diamond | 1188 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 21108253 | 21108253 | PRJNA715462_P_NODE_33517_length_306_cov_1.304721_g32721_i0 | PRJNA715462 | 33517 | 306 | 1.304721 | 3.99244626 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 159 | 1.83e-45 | NR | PAA78266.1 | 282301 | g32721 | i0 | 77.2 | 3.96078431372549 | 101 | 23 | 99 | 0 | 305 | 3 | 111 | 211 | PAA78266.1 hypothetical protein BOX15_Mlig024708g3, partial [Macrostomum lignano] | diamond | 1212 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 26682502 | 26682502 | PRJNA715462_P_NODE_23721_length_372_cov_1.839465_g22925_i0 | PRJNA715462 | 23721 | 372 | 1.839465 | 6.8428098 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 150 | 1.43e-44 | NR | CDS26820.1 | 85433 | g22925 | i0 | 69.9 | 12.4193548387097 | 103 | 30 | 83.1 | 1 | 312 | 4 | 1 | 102 | CDS26820.1 fk506 binding protein [Hymenolepis microstoma] | diamond | 4620 | 151 | 0.993377483443709 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 26925373 | 26925373 | PRJNA715462_P_NODE_41142_length_277_cov_2.264706_g40346_i0 | PRJNA715462 | 41142 | 277 | 2.264706 | 6.27323562 | Taenia asiatica | 60517 | Platyhelminthes | Platyhelminthes | 53.9 | 6e-6 | NR | VDK45750.1 | 60517 | g40346 | i0 | 44.1 | 2.20938628158845 | 68 | 37 | 72.6 | 1 | 42 | 242 | 21 | 88 | VDK45750.1 unnamed protein product [Taenia asiatica] | diamond | 612 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 27904549 | 27904549 | PRJNA715462_P_NODE_56665_length_248_cov_0.880000_g55869_i0 | PRJNA715462 | 56665 | 248 | 0.88 | 2.1824 | Trichobilharzia szidati | 157070 | Platyhelminthes | Platyhelminthes | 48.5 | 3.69e-4 | NR | CAH8851663.1 | 157070 | g55869 | i0 | 35.7 | 5.63709677419355 | 70 | 43 | 82.3 | 1 | 4 | 207 | 161 | 230 | CAH8851663.1 unnamed protein product [Trichobilharzia szidati] | diamond | 1398 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 27936473 | 27936473 | PRJNA715462_P_NODE_44885_length_266_cov_1.621762_g44089_i0 | PRJNA715462 | 44885 | 266 | 1.621762 | 4.31388692 | Trichobilharzia szidati | 157070 | Platyhelminthes | Platyhelminthes | 65.5 | 4.98e-10 | NR | CAH8821629.1 | 157070 | g44089 | i0 | 39.2 | 18.1353383458647 | 74 | 45 | 83.5 | 0 | 35 | 256 | 960 | 1033 | CAH8821629.1 unnamed protein product [Trichobilharzia szidati] | diamond | 4824 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 27967913 | 27967913 | PRJNA715462_P_NODE_58505_length_247_cov_0.885057_g57709_i0 | PRJNA715462 | 58505 | 247 | 0.885057 | 2.18609079 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 51.6 | 2.95e-5 | NR | TNN07625.1 | 6182 | g57709 | i0 | 45.2 | 1.02024291497976 | 42 | 23 | 51 | 0 | 122 | 247 | 314 | 355 | TNN07625.1 Retrovirus-related Pol polyprotein from type-2 retrotransposable element R2DM, partial [Schistosoma japonicum] | diamond | 252 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29073221 | 29073221 | PRJNA715462_P_NODE_48248_length_257_cov_1.255435_g47452_i0 | PRJNA715462 | 48248 | 257 | 1.255435 | 3.22646795 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 82.4 | 2.59e-17 | NR | CAL5133792.1 | 300641 | g47452 | i0 | 48.1 | 0.922178988326848 | 79 | 35 | 87.5 | 2 | 24 | 248 | 109 | 185 | CAL5133792.1 unnamed protein product [Calicophoron daubneyi] | diamond | 237 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 29073225 | 29073225 | PRJNA715462_P_NODE_52368_length_250_cov_0.870056_g51572_i0 | PRJNA715462 | 52368 | 250 | 0.870056 | 2.17514 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.2 | 3.92e-7 | NR | VZH92196.1 | 99802 | g51572 | i0 | 42.3 | 1.944 | 78 | 38 | 93.6 | 2 | 235 | 2 | 51 | 121 | VZH92196.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 486 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 29272823 | 29272823 | PRJNA715462_P_NODE_54349_length_249_cov_0.875000_g53553_i0 | PRJNA715462 | 54349 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 152 | 9.679999999999998e-42 | NR | AAW25790.1 | 6182 | g53553 | i0 | 86.7 | 22 | 83 | 11 | 100 | 0 | 1 | 249 | 272 | 354 | AAW25790.1 SJCHGC00214 protein [Schistosoma japonicum] | diamond | 5478 | 153 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29830743 | 29830743 | PRJNA715462_P_NODE_36731_length_291_cov_0.995413_g35935_i0 | PRJNA715462 | 36731 | 291 | 0.995413 | 2.89665183 | Schistosoma rodhaini | 6188 | Platyhelminthes | Platyhelminthes | 63.5 | 2.68e-9 | NR | CAH8485025.1 | 6188 | g35935 | i0 | 36.1 | 7.04123711340206 | 97 | 58 | 97.9 | 2 | 286 | 2 | 230 | 324 | CAH8485025.1 unnamed protein product [Schistosoma rodhaini] | diamond | 2049 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 29925701 | 29925701 | PRJNA715462_P_NODE_31031_length_320_cov_0.931174_g30235_i0 | PRJNA715462 | 31031 | 320 | 0.931174 | 2.9797568 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0394 | NR | PAA52598.1 | 282301 | g30235 | i0 | 39.1 | 0.646875 | 69 | 40 | 62.8 | 1 | 108 | 308 | 132 | 200 | PAA52598.1 hypothetical protein BOX15_Mlig022805g1 [Macrostomum lignano] | diamond | 207 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29925731 | 29925731 | PRJNA715462_P_NODE_7051_length_866_cov_1.973518_g6358_i0 | PRJNA715462 | 7051 | 866 | 1.973518 | 17.09066588 | Schistosoma mekongi | 38744 | Platyhelminthes | Platyhelminthes | 87 | 4.62e-15 | NR | KAK4468373.1 | 38744 | g6358 | i0 | 44 | 3.45034642032333 | 91 | 51 | 31.5 | 0 | 564 | 836 | 292 | 382 | KAK4468373.1 hypothetical protein MN116_000167 [Schistosoma mekongi] | diamond | 2988 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mekongi | |
| 30536422 | 30536422 | PRJNA715462_P_NODE_49553_length_253_cov_1.666667_g48757_i0 | PRJNA715462 | 49553 | 253 | 1.666667 | 4.21666751 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 48.1 | 5.3e-4 | NR | VDP45639.1 | 6186 | g48757 | i0 | 46.3 | 2.58498023715415 | 41 | 22 | 48.6 | 0 | 76 | 198 | 71 | 111 | VDP45639.1 unnamed protein product, partial [Schistosoma curassoni] | diamond | 654 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni | |
| 30757649 | 30757649 | PRJNA715462_P_NODE_65494_length_243_cov_0.905882_g64698_i0 | PRJNA715462 | 65494 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.2 | 2.41e-9 | NR | CAI2730967.1 | 6189 | g64698 | i0 | 40 | 6.82716049382716 | 70 | 42 | 86.4 | 0 | 213 | 4 | 347 | 416 | CAI2730967.1 unnamed protein product [Schistosoma spindalis] | diamond | 1659 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma spindalis | |
| 31063227 | 31063227 | PRJNA715462_P_NODE_60435_length_246_cov_0.890173_g59639_i0 | PRJNA715462 | 60435 | 246 | 0.890173 | 2.18982558 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 93.6 | 2.89e-21 | NR | VDP89518.1 | 27848 | g59639 | i0 | 57.3 | 4 | 82 | 32 | 100 | 2 | 246 | 1 | 94 | 172 | VDP89518.1 unnamed protein product [Echinostoma caproni] | diamond | 984 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 31548068 | 31548068 | PRJNA715462_P_NODE_68116_length_241_cov_1.494048_g67320_i0 | PRJNA715462 | 68116 | 241 | 1.494048 | 3.60065568 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 104 | 3.12e-24 | NR | CDS28886.1 | 85433 | g67320 | i0 | 59.5 | 10.8174273858921 | 79 | 32 | 98.3 | 0 | 241 | 5 | 344 | 422 | CDS28886.1 glycylpeptide N tetradecanoyltransferase [Hymenolepis microstoma] | diamond | 2607 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 32106671 | 32106671 | PRJNA715462_P_NODE_53918_length_249_cov_1.130682_g53122_i0 | PRJNA715462 | 53918 | 249 | 1.130682 | 2.81539818 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 103 | 1.5799999999999998e-23 | NR | PAA92267.1 | 282301 | g53122 | i0 | 59.5 | 7.01204819277108 | 84 | 32 | 98.8 | 1 | 3 | 248 | 927 | 1010 | PAA92267.1 hypothetical protein BOX15_Mlig016923g3, partial [Macrostomum lignano] | diamond | 1746 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32138356 | 32138356 | PRJNA715462_P_NODE_26638_length_348_cov_1.120000_g25842_i0 | PRJNA715462 | 26638 | 348 | 1.12 | 3.8976 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 96.7 | 1.56e-20 | NR | CDS16001.1 | 6210 | g25842 | i0 | 50 | 7.95689655172414 | 92 | 45 | 78.4 | 1 | 341 | 69 | 778 | 869 | CDS16001.1 eukaryotic translation initiation factor [Echinococcus granulosus] | diamond | 2769 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 32560523 | 32560523 | PRJNA715462_P_NODE_33859_length_304_cov_1.333333_g33063_i0 | PRJNA715462 | 33859 | 304 | 1.333333 | 4.05333232 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 102 | 6.01e-23 | NR | CAM0511897.1 | 6192 | g33063 | i0 | 46.5 | 7.82565789473684 | 99 | 53 | 97.7 | 0 | 302 | 6 | 103 | 201 | CAM0511897.1 unnamed protein product [Fasciola hepatica] | diamond | 2379 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 32581413 | 32581413 | PRJNA715462_P_NODE_18799_length_431_cov_2.631285_g18003_i0 | PRJNA715462 | 18799 | 431 | 2.631285 | 11.34083835 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 185 | 1.58e-57 | NR | AAY97887.1 | 6182 | g18003 | i0 | 72.7 | 0.890951276102088 | 128 | 35 | 89.1 | 0 | 6 | 389 | 1 | 128 | AAY97887.1 unknown [Schistosoma japonicum] | diamond | 384 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32686071 | 32686071 | PRJNA715462_P_NODE_70240_length_230_cov_2.210191_g69444_i0 | PRJNA715462 | 70240 | 230 | 2.210191 | 5.0834393 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 122 | 9.289999999999998e-31 | NR | OON19138.1 | 6198 | g69444 | i0 | 73.7 | 9.91304347826087 | 76 | 20 | 99.1 | 0 | 229 | 2 | 146 | 221 | OON19138.1 putative developmentally-regulated GTP-binding protein 1 [Opisthorchis viverrini] | diamond | 2280 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 32770045 | 32770045 | PRJNA715462_P_NODE_48780_length_255_cov_1.692308_g47984_i0 | PRJNA715462 | 48780 | 255 | 1.692308 | 4.3153854 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 66.2 | 2.37e-10 | NR | PAA82630.1 | 282301 | g47984 | i0 | 41.7 | 0.988235294117647 | 84 | 49 | 98.8 | 0 | 4 | 255 | 287 | 370 | PAA82630.1 hypothetical protein BOX15_Mlig028204g1, partial [Macrostomum lignano] | diamond | 252 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano |
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);;