contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA345071" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14422024 | 14422024 | PRJNA345071_P_NODE_1212_length_490_cov_2.393285_g1172_i0 | PRJNA345071 | 1212 | 490 | 2.393285 | 11.7270965 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 162 | 8.33e-44 | NR | YP_009391140.1 | 1611831 | g1172 | i0 | 71.3 | 0.789795918367347 | 129 | 37 | 79 | 0 | 490 | 104 | 59 | 187 | YP_009391140.1 NADH dehydrogenase subunit 5 [Stenostomum sthenum] | diamond | 387 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 20794710 | 20794710 | PRJNA345071_P_NODE_2757_length_355_cov_2.535461_g2717_i0 | PRJNA345071 | 2757 | 355 | 2.535461 | 9.00088655 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 155 | 2.4599999999999993e-43 | NR | AQN67657.1 | 52061 | g2717 | i0 | 90 | 0.676056338028169 | 80 | 8 | 67.6 | 0 | 333 | 94 | 15 | 94 | AQN67657.1 cytochrome b [Stenostomum leucops] | diamond | 240 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 22069937 | 22069937 | PRJNA345071_P_NODE_978_length_535_cov_2.424242_g938_i0 | PRJNA345071 | 978 | 535 | 2.424242 | 12.9696947 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 162 | 4.1999999999999996e-47 | NR | PAA66860.1 | 282301 | g938 | i0 | 56.1 | 1.73831775700935 | 155 | 65 | 86.9 | 1 | 468 | 4 | 1 | 152 | PAA66860.1 hypothetical protein BOX15_Mlig024683g1 [Macrostomum lignano] | diamond | 930 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 23345318 | 23345318 | PRJNA345071_P_NODE_6399_length_268_cov_1.594872_g6359_i0 | PRJNA345071 | 6399 | 268 | 1.594872 | 4.27425696 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 132 | 1.04e-33 | NR | PAA88911.1 | 282301 | g6359 | i0 | 71.8 | 9.51492537313433 | 85 | 24 | 95.1 | 0 | 266 | 12 | 150 | 234 | PAA88911.1 hypothetical protein BOX15_Mlig011760g2 [Macrostomum lignano] | diamond | 2550 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 24619537 | 24619537 | PRJNA345071_P_NODE_500_length_695_cov_5.400322_g461_i0 | PRJNA345071 | 500 | 695 | 5.400322 | 37.5322379 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 224 | 5.76e-70 | NR | AQN67664.1 | 52061 | g461 | i0 | 58.8 | 0.953956834532374 | 221 | 91 | 95.4 | 0 | 32 | 694 | 10 | 230 | AQN67664.1 cytochrome oxidase subunit 3 [Stenostomum leucops] | diamond | 663 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 24619548 | 24619548 | PRJNA345071_P_NODE_540_length_673_cov_1.745000_g500_i0 | PRJNA345071 | 540 | 673 | 1.745 | 11.74385 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 361 | 9.02e-123 | NR | XP_009171410.1 | 6198 | g500 | i0 | 81.7 | 44.741456166419 | 224 | 39 | 99.9 | 2 | 672 | 1 | 81 | 302 | XP_009171410.1 hypothetical protein T265_07589 [Opisthorchis viverrini] | diamond | 30111 | 362 | 0.997237569060773 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 27376724 | 27376724 | PRJNA345071_P_NODE_8963_length_248_cov_0.891429_g8923_i0 | PRJNA345071 | 8963 | 248 | 0.891429 | 2.21074392 | Taeniidae | 6208 | Platyhelminthes | Platyhelminthes | 50.8 | 5.67e-5 | NR | XP_024347792.1 | 6210 | g8923 | i0 | 49.1 | 1.28225806451613 | 53 | 25 | 64.1 | 1 | 53 | 211 | 159 | 209 | XP_024347792.1 Alpha-adducin [Echinococcus granulosus] | diamond | 318 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28576210 | 28576210 | PRJNA345071_P_NODE_9507_length_246_cov_1.034682_g9467_i0 | PRJNA345071 | 9507 | 246 | 1.034682 | 2.54531772 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 129 | 1.2099999999999999e-32 | NR | VZH97541.1 | 99802 | g9467 | i0 | 72.8 | 37.4146341463415 | 81 | 22 | 98.8 | 0 | 3 | 245 | 415 | 495 | VZH97541.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 9204 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28607824 | 28607824 | PRJNA345071_P_NODE_1887_length_409_cov_2.446429_g1847_i0 | PRJNA345071 | 1887 | 409 | 2.446429 | 10.00589461 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 163 | 5.7e-49 | NR | RTG85066.1 | 6184 | g1847 | i0 | 70.6 | 8.1638141809291 | 102 | 30 | 74.8 | 0 | 322 | 17 | 2 | 103 | RTG85066.1 cysteine and glycine-rich protein [Schistosoma bovis] | diamond | 3339 | 164 | 0.99390243902439 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 28843074 | 28843074 | PRJNA345071_P_NODE_6408_length_268_cov_1.528205_g6368_i0 | PRJNA345071 | 6408 | 268 | 1.528205 | 4.0955894 | Paragonimus skrjabini miyazakii | 59628 | Platyhelminthes | Platyhelminthes | 72.8 | 1.12e-13 | NR | KAF7262124.1 | 59628 | g6368 | i0 | 51.5 | 1.32089552238806 | 68 | 32 | 76.1 | 1 | 64 | 267 | 1 | 67 | KAF7262124.1 hypothetical protein EG68_00659 [Paragonimus skrjabini miyazakii] | diamond | 354 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 28906161 | 28906161 | PRJNA345071_P_NODE_868_length_561_cov_2.008197_g828_i0 | PRJNA345071 | 868 | 561 | 2.008197 | 11.26598517 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 67 | 3.12e-9 | NR | PAA59755.1 | 282301 | g828 | i0 | 39.8 | 1.75401069518717 | 108 | 65 | 57.8 | 0 | 236 | 559 | 426 | 533 | PAA59755.1 hypothetical protein BOX15_Mlig015143g2 [Macrostomum lignano] | diamond | 984 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29285112 | 29285112 | PRJNA345071_P_NODE_6969_length_260_cov_2.411765_g6929_i0 | PRJNA345071 | 6969 | 260 | 2.411765 | 6.270589 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 144 | 1.75e-39 | NR | AQN67659.1 | 52061 | g6929 | i0 | 87.2 | 0.992307692307692 | 86 | 11 | 99.2 | 0 | 3 | 260 | 145 | 230 | AQN67659.1 NADH dehydrogenase subunit 4 [Stenostomum leucops] | diamond | 258 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 29663799 | 29663799 | PRJNA345071_P_NODE_10090_length_244_cov_1.520468_g10050_i0 | PRJNA345071 | 10090 | 244 | 1.520468 | 3.70994192 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 104 | 2.37e-26 | NR | PAA50918.1 | 282301 | g10050 | i0 | 77.9 | 0.836065573770492 | 68 | 15 | 83.6 | 0 | 40 | 243 | 5 | 72 | PAA50918.1 hypothetical protein BOX15_Mlig006373g2 [Macrostomum lignano] | diamond | 204 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29744237 | 29744237 | PRJNA345071_P_NODE_11210_length_230_cov_2.356688_g11170_i0 | PRJNA345071 | 11210 | 230 | 2.356688 | 5.4203824 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 90.9 | 1.44e-19 | NR | AAX26915.2 | 6182 | g11170 | i0 | 71.4 | 9.52173913043478 | 56 | 16 | 73 | 0 | 230 | 63 | 286 | 341 | AAX26915.2 SJCHGC09060 protein, partial [Schistosoma japonicum] | diamond | 2190 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29916971 | 29916971 | PRJNA345071_P_NODE_6171_length_271_cov_2.797980_g6131_i0 | PRJNA345071 | 6171 | 271 | 2.79798 | 7.5825258 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 92.4 | 6.99e-20 | NR | PAA64676.1 | 282301 | g6131 | i0 | 76.9 | 3.91881918819188 | 52 | 12 | 57.6 | 0 | 269 | 114 | 313 | 364 | PAA64676.1 hypothetical protein BOX15_Mlig003753g1 [Macrostomum lignano] | diamond | 1062 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29948442 | 29948442 | PRJNA345071_P_NODE_8451_length_250_cov_0.881356_g8411_i0 | PRJNA345071 | 8451 | 250 | 0.881356 | 2.20339 | Stenostomum brevipharyngium | 2880247 | Platyhelminthes | Platyhelminthes | 67.8 | 5.96e-11 | NR | WMI31534.1 | 2880247 | g8411 | i0 | 69.4 | 1.02 | 85 | 23 | 98.4 | 2 | 248 | 3 | 364 | 448 | WMI31534.1 Pax4/6B [Stenostomum brevipharyngium] | diamond | 255 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum brevipharyngium | |||
| 30137568 | 30137568 | PRJNA345071_P_NODE_1392_length_465_cov_2.344388_g1352_i0 | PRJNA345071 | 1392 | 465 | 2.344388 | 10.9014042 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 107 | 5.850000000000001e-26 | NR | XP_009162061.1 | 6198 | g1352 | i0 | 39.9 | 3.70967741935484 | 148 | 86 | 94.8 | 2 | 19 | 459 | 56 | 201 | XP_009162061.1 hypothetical protein T265_00140 [Opisthorchis viverrini] | diamond | 1725 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 30154875 | 30154875 | PRJNA345071_P_NODE_10372_length_243_cov_1.458824_g10332_i0 | PRJNA345071 | 10372 | 243 | 1.458824 | 3.54494232 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 83.2 | 2.14e-16 | NR | XP_018647599.1 | 6183 | g10332 | i0 | 46.8 | 5.85185185185185 | 79 | 42 | 97.5 | 0 | 2 | 238 | 143 | 221 | XP_018647599.1 septate junction protein [Schistosoma mansoni] | diamond | 1422 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 30186624 | 30186624 | PRJNA345071_P_NODE_3872_length_316_cov_2.279835_g3832_i0 | PRJNA345071 | 3872 | 316 | 2.279835 | 7.2042786 | root | 1 | Root_unresolved | Root_unresolved | 77.4 | 3.56e-14 | NR | PAA62771.1 | 282301 | g3832 | i0 | 51.8 | 2.25949367088608 | 85 | 37 | 76.9 | 1 | 73 | 315 | 12 | 96 | PAA62771.1 hypothetical protein BOX15_Mlig014121g1 [Macrostomum lignano] | diamond | 714 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30611731 | 30611731 | PRJNA345071_P_NODE_1093_length_513_cov_1.061364_g1053_i0 | PRJNA345071 | 1093 | 513 | 1.061364 | 5.44479732 | Minona ileanae | 60013 | Platyhelminthes | Platyhelminthes | 62.8 | 5.96e-8 | NR | QEP99785.1 | 60013 | g1053 | i0 | 35.9 | 1.69590643274854 | 92 | 59 | 53.8 | 0 | 374 | 99 | 81 | 172 | QEP99785.1 intermediate filament b-like protein 1, partial [Minona ileanae] | diamond | 870 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Monocelididae | Minona | Minona ileanae | |
| 30881766 | 30881766 | PRJNA345071_P_NODE_10974_length_239_cov_2.186747_g10934_i0 | PRJNA345071 | 10974 | 239 | 2.186747 | 5.22632533 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 124 | 6.139999999999999e-31 | NR | PAA77121.1 | 282301 | g10934 | i0 | 68.4 | 4.9581589958159 | 79 | 25 | 99.2 | 0 | 239 | 3 | 69 | 147 | PAA77121.1 hypothetical protein BOX15_Mlig016849g2, partial [Macrostomum lignano] | diamond | 1185 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31054506 | 31054506 | PRJNA345071_P_NODE_1375_length_468_cov_1.929114_g1335_i0 | PRJNA345071 | 1375 | 468 | 1.929114 | 9.02825352 | Protopolystoma xenopodis | 117903 | Platyhelminthes | Platyhelminthes | 43.1 | 0.0463 | NR | VEL43780.1 | 117903 | g1335 | i0 | 31.8 | 0.423076923076923 | 66 | 44 | 41.7 | 1 | 2 | 196 | 39 | 104 | VEL43780.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 198 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 31085858 | 31085858 | PRJNA345071_P_NODE_7115_length_258_cov_3.200000_g7075_i0 | PRJNA345071 | 7115 | 258 | 3.2 | 8.256 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 46.6 | 6.55e-4 | NR | PAA49752.1 | 282301 | g7075 | i0 | 53.3 | 0.523255813953488 | 45 | 19 | 51.2 | 2 | 86 | 217 | 8 | 51 | PAA49752.1 hypothetical protein BOX15_Mlig009292g1, partial [Macrostomum lignano] | diamond | 135 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31419118 | 31419118 | PRJNA345071_P_NODE_6796_length_263_cov_1.231579_g6756_i0 | PRJNA345071 | 6796 | 263 | 1.231579 | 3.23905277 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 42.7 | 0.0137 | NR | GAA55086.1 | 79923 | g6756 | i0 | 43.8 | 3.77566539923954 | 64 | 36 | 73 | 0 | 3 | 194 | 31 | 94 | GAA55086.1 reticulon-1 [Clonorchis sinensis] | diamond | 993 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 31735308 | 31735308 | PRJNA345071_P_NODE_9237_length_247_cov_0.896552_g9197_i0 | PRJNA345071 | 9237 | 247 | 0.896552 | 2.21448344 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 72.4 | 2.06e-13 | NR | PAA48146.1 | 282301 | g9197 | i0 | 94.7 | 14.3076923076923 | 38 | 2 | 46.2 | 0 | 245 | 132 | 163 | 200 | PAA48146.1 hypothetical protein BOX15_Mlig002731g3 [Macrostomum lignano] | diamond | 3534 | 72.8 | 0.994505494505495 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32431636 | 32431636 | PRJNA345071_P_NODE_9079_length_248_cov_0.891429_g9039_i0 | PRJNA345071 | 9079 | 248 | 0.891429 | 2.21074392 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 86.7 | 1.42e-17 | NR | CAH8495400.1 | 39320 | g9039 | i0 | 50 | 16.4032258064516 | 80 | 40 | 96.8 | 0 | 247 | 8 | 1121 | 1200 | CAH8495400.1 unnamed protein product [Heterobilharzia americana] | diamond | 4068 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 32824416 | 32824416 | PRJNA345071_P_NODE_960_length_539_cov_3.557940_g920_i0 | PRJNA345071 | 960 | 539 | 3.55794 | 19.1772966 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 67.8 | 6.58e-11 | NR | THD25754.1 | 6192 | g920 | i0 | 37 | 2.71614100185529 | 119 | 72 | 65.7 | 2 | 44 | 397 | 4 | 120 | THD25754.1 Fatty acid-binding protein type 3 [Fasciola hepatica] | diamond | 1464 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica |
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);;