contig_metadata
27 rows where bioproject = "PRJNA1000943", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1419889 | 1419889 | PRJNA1000943_P_NODE_6042_length_328_cov_1.831373_g5904_i0 | PRJNA1000943 | 6042 | 328 | 1.831373 | 6.00690344 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 149 | 4.27e-43 | NR | XP_018649608.1 | 6183 | g5904 | i0 | 63.9 | 23.7073170731707 | 108 | 39 | 98.8 | 0 | 4 | 327 | 59 | 166 | XP_018649608.1 putative adp-ribosylation factor, arf [Schistosoma mansoni] | diamond | 7776 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 2695329 | 2695329 | PRJNA1000943_P_NODE_15823_length_233_cov_4.800000_g15685_i0 | PRJNA1000943 | 15823 | 233 | 4.8 | 11.184 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g15685 | i0 | 100 | 0.124463519313305 | 29 | 0 | 12 | 0 | 71 | 99 | 5361 | 5389 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 2695343 | 2695343 | PRJNA1000943_P_NODE_2443_length_488_cov_2.081928_g2306_i0 | PRJNA1000943 | 2443 | 488 | 2.081928 | 10.15980864 | root | 1 | Root_unresolved | Root_unresolved | 263 | 6.57e-84 | NR | VDL18401.1 | 6216 | g2306 | i0 | 78.1 | 11.7909836065574 | 160 | 35 | 98.4 | 0 | 483 | 4 | 241 | 400 | VDL18401.1 unnamed protein product [Hymenolepis diminuta] | diamond | 5754 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 2695377 | 2695377 | PRJNA1000943_P_NODE_5863_length_332_cov_1.567568_g5725_i0 | PRJNA1000943 | 5863 | 332 | 1.567568 | 5.20432576 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 185 | 1.3e-57 | NR | VDP95096.1 | 27848 | g5725 | i0 | 80.4 | 5.80120481927711 | 107 | 21 | 96.7 | 0 | 331 | 11 | 57 | 163 | VDP95096.1 unnamed protein product [Echinostoma caproni] | diamond | 1926 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 3971502 | 3971502 | PRJNA1000943_P_NODE_8484_length_284_cov_1.478673_g8346_i0 | PRJNA1000943 | 8484 | 284 | 1.478673 | 4.19943132 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 138 | 1.6e-39 | NR | XP_024353685.1 | 6210 | g8346 | i0 | 70.8 | 4.73239436619718 | 89 | 26 | 94 | 0 | 268 | 2 | 6 | 94 | XP_024353685.1 40S ribosomal protein S18 [Echinococcus granulosus] | diamond | 1344 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 7797666 | 7797666 | PRJNA1000943_P_NODE_4487_length_373_cov_2.600000_g4350_i0 | PRJNA1000943 | 4487 | 373 | 2.6 | 9.698 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 94 | 1.43e-22 | NR | KAA3682244.1 | 34504 | g4350 | i0 | 70.5 | 1.87399463806971 | 61 | 18 | 49.1 | 0 | 331 | 149 | 1 | 61 | KAA3682244.1 large subunit ribosomal protein L29e [Paragonimus westermani] | diamond | 699 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 11623752 | 11623752 | PRJNA1000943_P_NODE_5310_length_347_cov_1.591241_g5172_i0 | PRJNA1000943 | 5310 | 347 | 1.591241 | 5.52160627 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 116 | 7.61e-28 | NR | PAA76780.1 | 282301 | g5172 | i0 | 74.4 | 6.05187319884726 | 78 | 20 | 67.4 | 0 | 11 | 244 | 392 | 469 | PAA76780.1 hypothetical protein BOX15_Mlig017901g2 [Macrostomum lignano] | diamond | 2100 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 12898790 | 12898790 | PRJNA1000943_P_NODE_14371_length_244_cov_2.251462_g14233_i0 | PRJNA1000943 | 14371 | 244 | 2.251462 | 5.49356728 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 1.43e-31 | NR | XP_009163133.1 | 6198 | g14233 | i0 | 64.2 | 32.8647540983607 | 81 | 29 | 99.6 | 0 | 2 | 244 | 47 | 127 | XP_009163133.1 hypothetical protein T265_00954 [Opisthorchis viverrini] | diamond | 8019 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 23097327 | 23097327 | PRJNA1000943_P_NODE_4539_length_371_cov_1.946309_g4402_i0 | PRJNA1000943 | 4539 | 371 | 1.946309 | 7.22080639 | Taeniidae | 6208 | Platyhelminthes | Platyhelminthes | 165 | 1.31e-49 | NR | VDM31564.1 | 6205 | g4402 | i0 | 60.2 | 11.9191374663073 | 123 | 49 | 99.5 | 0 | 370 | 2 | 16 | 138 | VDM31564.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 4422 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 27160507 | 27160507 | PRJNA1000943_P_NODE_13962_length_245_cov_1.813953_g13824_i0 | PRJNA1000943 | 13962 | 245 | 1.813953 | 4.44418485 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 90.1 | 6.52e-21 | NR | PAA58490.1 | 282301 | g13824 | i0 | 57.5 | 3.94285714285714 | 80 | 34 | 98 | 0 | 243 | 4 | 41 | 120 | PAA58490.1 hypothetical protein BOX15_Mlig003755g3, partial [Macrostomum lignano] | diamond | 966 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27192259 | 27192259 | PRJNA1000943_P_NODE_7162_length_306_cov_1.339056_g7024_i0 | PRJNA1000943 | 7162 | 306 | 1.339056 | 4.09751136 | Schistosoma turkestanicum | 1163369 | Platyhelminthes | Platyhelminthes | 140 | 7.99e-39 | NR | CAH8563857.1 | 1163369 | g7024 | i0 | 62 | 3.90196078431373 | 100 | 38 | 98 | 0 | 301 | 2 | 30 | 129 | CAH8563857.1 unnamed protein product [Schistosoma turkestanicum] | diamond | 1194 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma turkestanicum | |
| 27698169 | 27698169 | PRJNA1000943_P_NODE_2164_length_517_cov_1.378378_g2027_i0 | PRJNA1000943 | 2164 | 517 | 1.378378 | 7.12621426 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 52.8 | 1.63e-4 | NR | PAA93605.1 | 282301 | g2027 | i0 | 26.8 | 1.29980657640232 | 112 | 79 | 65 | 2 | 336 | 1 | 254 | 362 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 672 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28700916 | 28700916 | PRJNA1000943_P_NODE_11847_length_251_cov_0.876404_g11709_i0 | PRJNA1000943 | 11847 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 3.48e-23 | NR | PAA48901.1 | 282301 | g11709 | i0 | 63.9 | 4.92430278884462 | 83 | 29 | 99.2 | 1 | 2 | 250 | 227 | 308 | PAA48901.1 hypothetical protein BOX15_Mlig033906g2, partial [Macrostomum lignano] | diamond | 1236 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29244949 | 29244949 | PRJNA1000943_P_NODE_16209_length_202_cov_4.589147_g16071_i0 | PRJNA1000943 | 16209 | 202 | 4.589147 | 9.27007694 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 44.7 | 0.00439 | NR | PAA86220.1 | 282301 | g16071 | i0 | 35 | 1.78217821782178 | 60 | 38 | 87.6 | 1 | 182 | 6 | 131 | 190 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 360 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29497488 | 29497488 | PRJNA1000943_P_NODE_8370_length_286_cov_1.089202_g8232_i0 | PRJNA1000943 | 8370 | 286 | 1.089202 | 3.11511772 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 55.1 | 2.79e-6 | NR | PAA93605.1 | 282301 | g8232 | i0 | 37.2 | 0.818181818181818 | 78 | 48 | 81.8 | 1 | 282 | 49 | 362 | 438 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 234 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29591850 | 29591850 | PRJNA1000943_P_NODE_6750_length_313_cov_1.387500_g6612_i0 | PRJNA1000943 | 6750 | 313 | 1.3875 | 4.342875 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 79.3 | 2.28e-16 | NR | AAW26348.1 | 6182 | g6612 | i0 | 56.3 | 1.8019169329073501 | 64 | 28 | 61.3 | 0 | 313 | 122 | 69 | 132 | AAW26348.1 SJCHGC02419 protein [Schistosoma japonicum] | diamond | 564 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29995559 | 29995559 | PRJNA1000943_P_NODE_12251_length_250_cov_0.881356_g12113_i0 | PRJNA1000943 | 12251 | 250 | 0.881356 | 2.20339 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 92 | 7.3e-20 | NR | PAA61011.1 | 282301 | g12113 | i0 | 76.9 | 8.58 | 65 | 15 | 78 | 0 | 3 | 197 | 299 | 363 | PAA61011.1 hypothetical protein BOX15_Mlig029764g1 [Macrostomum lignano] | diamond | 2145 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30350852 | 30350852 | PRJNA1000943_P_NODE_14752_length_244_cov_0.912281_g14614_i0 | PRJNA1000943 | 14752 | 244 | 0.912281 | 2.22596564 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 60.5 | 2.2e-8 | NR | CAH8454615.1 | 57078 | g14614 | i0 | 50.8 | 3.52868852459016 | 59 | 26 | 72.5 | 2 | 68 | 244 | 1065 | 1120 | CAH8454615.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 861 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 30571254 | 30571254 | PRJNA1000943_P_NODE_7993_length_292_cov_1.337900_g7855_i0 | PRJNA1000943 | 7993 | 292 | 1.3379 | 3.906668 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 71.2 | 9.01e-13 | NR | TGZ68568.1 | 147828 | g7855 | i0 | 34.4 | 3.78082191780822 | 93 | 39 | 95.5 | 2 | 12 | 290 | 110 | 180 | TGZ68568.1 hypothetical protein CRM22_004183 [Opisthorchis felineus] | diamond | 1104 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 31013809 | 31013809 | PRJNA1000943_P_NODE_1275_length_667_cov_2.072391_g1144_i0 | PRJNA1000943 | 1275 | 667 | 2.072391 | 13.82284797 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 261 | 4.94e-84 | NR | VDD81745.1 | 53468 | g1144 | i0 | 62.4 | 13.9565217391304 | 221 | 68 | 99.4 | 2 | 663 | 1 | 1 | 206 | VDD81745.1 unnamed protein product, partial [Mesocestoides corti] | diamond | 9309 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 31171558 | 31171558 | PRJNA1000943_P_NODE_9355_length_272_cov_1.567839_g9217_i0 | PRJNA1000943 | 9355 | 272 | 1.567839 | 4.26452208 | Taenia asiatica | 60517 | Platyhelminthes | Platyhelminthes | 47 | 0.00173 | NR | VDK22882.1 | 60517 | g9217 | i0 | 33.7 | 0.948529411764706 | 86 | 43 | 91.5 | 2 | 3 | 251 | 546 | 620 | VDK22882.1 unnamed protein product [Taenia asiatica] | diamond | 258 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 31266715 | 31266715 | PRJNA1000943_P_NODE_13455_length_247_cov_0.896552_g13317_i0 | PRJNA1000943 | 13455 | 247 | 0.896552 | 2.21448344 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 81.3 | 1.07e-15 | NR | CAH8633875.1 | 57078 | g13317 | i0 | 57.4 | 2.92712550607287 | 61 | 26 | 74.1 | 0 | 64 | 246 | 84 | 144 | CAH8633875.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 723 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 31607221 | 31607221 | PRJNA1000943_P_NODE_6376_length_321_cov_1.883065_g6238_i0 | PRJNA1000943 | 6376 | 321 | 1.883065 | 6.04463865 | Fasciolidae | 27843 | Platyhelminthes | Platyhelminthes | 50.8 | 4.32e-5 | NR | THD21769.1 | 6192 | g6238 | i0 | 35.4 | 1.47663551401869 | 79 | 47 | 70.1 | 1 | 321 | 97 | 74 | 152 | THD21769.1 Tetraspanin [Fasciola hepatica] | diamond | 474 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31709481 | 31709481 | PRJNA1000943_P_NODE_3017_length_444_cov_1.778976_g2880_i0 | PRJNA1000943 | 3017 | 444 | 1.778976 | 7.89865344 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 60.5 | 1.9e-7 | NR | PAA86220.1 | 282301 | g2880 | i0 | 33 | 0.695945945945946 | 103 | 64 | 67.6 | 3 | 302 | 3 | 76 | 176 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 309 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31930803 | 31930803 | PRJNA1000943_P_NODE_4997_length_356_cov_1.102473_g4860_i0 | PRJNA1000943 | 4997 | 356 | 1.102473 | 3.92480388 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 173 | 2.27e-50 | NR | PAA67099.1 | 282301 | g4860 | i0 | 62.7 | 2.95786516853933 | 118 | 44 | 99.4 | 0 | 355 | 2 | 9 | 126 | PAA67099.1 hypothetical protein BOX15_Mlig001464g3, partial [Macrostomum lignano] | diamond | 1053 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32437435 | 32437435 | PRJNA1000943_P_NODE_3499_length_415_cov_2.239766_g3362_i0 | PRJNA1000943 | 3499 | 415 | 2.239766 | 9.2950289 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 184 | 2.62e-57 | NR | AAY97887.1 | 6182 | g3362 | i0 | 72.7 | 0.925301204819277 | 128 | 35 | 92.5 | 0 | 7 | 390 | 1 | 128 | AAY97887.1 unknown [Schistosoma japonicum] | diamond | 384 | 184 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32878569 | 32878569 | PRJNA1000943_P_NODE_9200_length_274_cov_2.328358_g9062_i0 | PRJNA1000943 | 9200 | 274 | 2.328358 | 6.37970092 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 80.5 | 2.38e-15 | NR | PAA78765.1 | 282301 | g9062 | i0 | 66.1 | 3.48175182481752 | 62 | 20 | 67.9 | 1 | 88 | 273 | 85 | 145 | PAA78765.1 hypothetical protein BOX15_Mlig012266g3 [Macrostomum lignano] | diamond | 954 | 80.5 | 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);;