contig_metadata
17 rows where bioproject = "PRJNA438572", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4919142 | 4919142 | PRJNA438572_P_NODE_1824_length_718_cov_6.300775_g1715_i0 | PRJNA438572 | 1824 | 718 | 6.300775 | 45.2395645 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 243 | 5.0899999999999995e-78 | NR | KAA0196388.1 | 27845 | g1715 | i0 | 68.2 | 2.89554317548746 | 173 | 55 | 72.3 | 0 | 42 | 560 | 4 | 176 | KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] | diamond | 2079 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 13188640 | 13188640 | PRJNA438572_P_NODE_17391_length_252_cov_1.513966_g17272_i0 | PRJNA438572 | 17391 | 252 | 1.513966 | 3.81519432 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 129 | 1.6499999999999998e-35 | NR | KAH8861459.1 | 6182 | g17272 | i0 | 75 | 20.0238095238095 | 80 | 20 | 95.2 | 0 | 11 | 250 | 1 | 80 | KAH8861459.1 Proteasome subunit alpha type-5 [Schistosoma japonicum] | diamond | 5046 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14463834 | 14463834 | PRJNA438572_P_NODE_5172_length_437_cov_6.156593_g5053_i0 | PRJNA438572 | 5172 | 437 | 6.156593 | 26.90431141 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 758 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g5053 | i0 | 97.941 | 1 | 437 | 9 | 100 | 0 | 1 | 437 | 13 | 449 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 437 | 758 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26917811 | 26917811 | PRJNA438572_P_NODE_7102_length_378_cov_2.642623_g6983_i0 | PRJNA438572 | 7102 | 378 | 2.642623 | 9.98911494 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 103 | 7.45e-25 | NR | PAA66860.1 | 282301 | g6983 | i0 | 45.8 | 1.9047619047619 | 120 | 55 | 88.1 | 2 | 41 | 373 | 1 | 119 | PAA66860.1 hypothetical protein BOX15_Mlig024683g1 [Macrostomum lignano] | diamond | 720 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27644874 | 27644874 | PRJNA438572_P_NODE_18284_length_251_cov_0.876404_g18165_i0 | PRJNA438572 | 18284 | 251 | 0.876404 | 2.19977404 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 40.8 | 0.0353 | NR | CAH8676583.1 | 6185 | g18165 | i0 | 36.5 | 0.752988047808765 | 63 | 37 | 75.3 | 2 | 18 | 206 | 18 | 77 | CAH8676583.1 unnamed protein product [Schistosoma haematobium] | diamond | 189 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 28307797 | 28307797 | PRJNA438572_P_NODE_446_length_1263_cov_2.612605_g402_i0 | PRJNA438572 | 446 | 1263 | 2.612605 | 32.99720115 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 96.7 | 1.19e-17 | NR | PAA86220.1 | 282301 | g402 | i0 | 30.4 | 0.382422802850356 | 161 | 111 | 38 | 1 | 613 | 134 | 76 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 483 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29097179 | 29097179 | PRJNA438572_P_NODE_5028_length_442_cov_2.674797_g4909_i0 | PRJNA438572 | 5028 | 442 | 2.674797 | 11.82260274 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 75.1 | 4.63e-14 | NR | PAA82696.1 | 282301 | g4909 | i0 | 28.9 | 0.868778280542986 | 128 | 88 | 86.9 | 1 | 431 | 48 | 5 | 129 | PAA82696.1 hypothetical protein BOX15_Mlig024657g1, partial [Macrostomum lignano] | diamond | 384 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29397530 | 29397530 | PRJNA438572_P_NODE_1989_length_688_cov_1.141463_g1878_i0 | PRJNA438572 | 1989 | 688 | 1.141463 | 7.85326544 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 103 | 2.1e-22 | NR | THD18101.1 | 6192 | g1878 | i0 | 28.6 | 7.02906976744186 | 231 | 156 | 97.7 | 5 | 672 | 1 | 36 | 264 | THD18101.1 Cysteine protease [Fasciola hepatica] | diamond | 4836 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 29523865 | 29523865 | PRJNA438572_P_NODE_6910_length_383_cov_1.006452_g6791_i0 | PRJNA438572 | 6910 | 383 | 1.006452 | 3.85471116 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 90.5 | 1.35e-18 | NR | XP_024356100.1 | 6210 | g6791 | i0 | 43.6 | 3.7597911227154 | 101 | 53 | 76 | 2 | 79 | 369 | 12 | 112 | XP_024356100.1 putative NADH dehydrogenase [ubiquinone] 1 alpha subcomplex subunit [Echinococcus granulosus] | diamond | 1440 | 91.3 | 0.991237677984666 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 30138797 | 30138797 | PRJNA438572_P_NODE_23132_length_244_cov_0.912281_g23013_i0 | PRJNA438572 | 23132 | 244 | 0.912281 | 2.22596564 | Paragonimus skrjabini miyazakii | 59628 | Platyhelminthes | Platyhelminthes | 73.6 | 1.7e-13 | NR | KAF7262449.1 | 59628 | g23013 | i0 | 52.3 | 1.59836065573771 | 65 | 30 | 79.9 | 1 | 1 | 195 | 190 | 253 | KAF7262449.1 hypothetical protein EG68_00283 [Paragonimus skrjabini miyazakii] | diamond | 390 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 30170657 | 30170657 | PRJNA438572_P_NODE_11532_length_303_cov_1.013043_g11413_i0 | PRJNA438572 | 11532 | 303 | 1.013043 | 3.06952029 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 162 | 8.17e-47 | NR | TNN04691.1 | 6182 | g11413 | i0 | 100 | 0.792079207920792 | 80 | 0 | 79.2 | 0 | 243 | 4 | 241 | 320 | TNN04691.1 hypothetical protein EWB00_000459 [Schistosoma japonicum] | diamond | 240 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30977126 | 30977126 | PRJNA438572_P_NODE_5754_length_417_cov_1.360465_g5635_i0 | PRJNA438572 | 5754 | 417 | 1.360465 | 5.67313905 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92 | 1.47e-18 | NR | GAA55654.1 | 79923 | g5635 | i0 | 45.7 | 3.33812949640288 | 116 | 58 | 82.7 | 3 | 73 | 417 | 179 | 290 | GAA55654.1 sphingosine-1-phosphate lyase 1 [Clonorchis sinensis] | diamond | 1392 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 31687824 | 31687824 | PRJNA438572_P_NODE_20237_length_248_cov_0.891429_g20118_i0 | PRJNA438572 | 20237 | 248 | 0.891429 | 2.21074392 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 77.8 | 1.07e-14 | NR | KAA3669865.1 | 34504 | g20118 | i0 | 57.7 | 0.858870967741935 | 71 | 30 | 85.9 | 0 | 3 | 215 | 31 | 101 | KAA3669865.1 uncharacterized protein DEA37_0013878 [Paragonimus westermani] | diamond | 213 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31687836 | 31687836 | PRJNA438572_P_NODE_9577_length_330_cov_1.836576_g9458_i0 | PRJNA438572 | 9577 | 330 | 1.836576 | 6.0607008 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 53.5 | 1.62e-5 | NR | PAA93605.1 | 282301 | g9458 | i0 | 28.7 | 1.83636363636364 | 101 | 71 | 91.8 | 1 | 324 | 22 | 327 | 426 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 606 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31798897 | 31798897 | PRJNA438572_P_NODE_23797_length_243_cov_0.917647_g23678_i0 | PRJNA438572 | 23797 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 74.3 | 2.86e-13 | NR | CAH8567987.1 | 57078 | g23678 | i0 | 56.1 | 3.40740740740741 | 66 | 26 | 81.5 | 1 | 219 | 22 | 48 | 110 | CAH8567987.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 828 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 32225852 | 32225852 | PRJNA438572_P_NODE_18358_length_251_cov_0.876404_g18239_i0 | PRJNA438572 | 18358 | 251 | 0.876404 | 2.19977404 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 45.4 | 0.00455 | NR | VDO09071.1 | 102285 | g18239 | i0 | 38.7 | 3.70517928286853 | 62 | 38 | 74.1 | 0 | 52 | 237 | 494 | 555 | VDO09071.1 unnamed protein product [Rodentolepis nana] | diamond | 930 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 32431982 | 32431982 | PRJNA438572_P_NODE_6199_length_403_cov_0.630303_g6080_i0 | PRJNA438572 | 6199 | 403 | 0.630303 | 2.54012109 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 137 | 1.08e-34 | NR | CAH8827783.1 | 157069 | g6080 | i0 | 48.7 | 4.52605459057072 | 152 | 56 | 96.8 | 1 | 2 | 391 | 347 | 498 | CAH8827783.1 unnamed protein product [Trichobilharzia regenti] | diamond | 1824 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti |
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);;