contig_metadata
25 rows where bioproject = "PRJNA1011833" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1430072 | 1430072 | PRJNA1011833_S_NODE_10642_length_361_cov_4.908805_g10223_i0 | PRJNA1011833 | 10642 | 361 | 4.908805 | 17.72078605 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 67 | 1.22e-11 | NR | CAH8438363.1 | 57078 | g10223 | i0 | 44.1 | 0.565096952908587 | 68 | 38 | 56.5 | 0 | 88 | 291 | 18 | 85 | CAH8438363.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 204 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 6533555 | 6533555 | PRJNA1011833_S_NODE_32526_length_206_cov_1.110429_g32106_i0 | PRJNA1011833 | 32526 | 206 | 1.110429 | 2.28748374 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 267 | 5.91e-67 | NTclustered | gi|1124902734|gb|AY812498.2| | 6182 | g32106 | i0 | 99.32 | 81.7330097087379 | 147 | 1 | 95 | 0 | 1 | 147 | 976 | 1122 | Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds | blastn | 16837 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9082805 | 9082805 | PRJNA1011833_S_NODE_10588_length_362_cov_2.567398_g10170_i0 | PRJNA1011833 | 10588 | 362 | 2.567398 | 9.29398076 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 183 | 1.17e-41 | NTclustered | gi|21308046|gb|AY067413.1| | 79327 | g10170 | i0 | 86.047 | 39.975138121547 | 172 | 22 | 47 | 2 | 190 | 360 | 205 | 35 | Schmidtea mediterranea clone H.61.1b(T3) unknown mRNA sequence | blastn | 14471 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 10358487 | 10358487 | PRJNA1011833_S_NODE_27849_length_224_cov_1.856354_g27429_i0 | PRJNA1011833 | 27849 | 224 | 1.856354 | 4.15823296 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 137 | 1.09e-35 | NR | XP_009169500.1 | 6198 | g27429 | i0 | 91.9 | 64.4196428571429 | 74 | 6 | 99.1 | 0 | 3 | 224 | 338 | 411 | XP_009169500.1 hypothetical protein T265_06066 [Opisthorchis viverrini] | diamond | 14430 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 27508853 | 27508853 | PRJNA1011833_S_NODE_45343_length_172_cov_1.860465_g44923_i0 | PRJNA1011833 | 45343 | 172 | 1.860465 | 3.1999998 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 82.8 | 9.63e-17 | NR | VDD83995.1 | 53468 | g44923 | i0 | 67.9 | 13.0813953488372 | 56 | 18 | 97.7 | 0 | 168 | 1 | 4 | 59 | VDD83995.1 unnamed protein product [Mesocestoides corti] | diamond | 2250 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 27824572 | 27824572 | PRJNA1011833_S_NODE_5624_length_450_cov_5.697789_g5212_i0 | PRJNA1011833 | 5624 | 450 | 5.697789 | 25.6400505 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 163 | 4.929999999999999e-48 | NR | CAH8870758.1 | 157069 | g5212 | i0 | 52.3 | 22.8533333333333 | 149 | 71 | 99.3 | 0 | 448 | 2 | 24 | 172 | CAH8870758.1 unnamed protein product [Trichobilharzia regenti] | diamond | 10284 | 164 | 0.99390243902439 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 28037909 | 28037909 | PRJNA1011833_S_NODE_29085_length_219_cov_1.556818_g28665_i0 | PRJNA1011833 | 29085 | 219 | 1.556818 | 3.40943142 | root | 1 | Root_unresolved | Root_unresolved | 72.4 | 9.41e-13 | NR | XP_024356082.1 | 6210 | g28665 | i0 | 58.9 | 1.64383561643836 | 56 | 22 | 75.3 | 1 | 205 | 41 | 88 | 143 | XP_024356082.1 NADPH--cytochrome P450 reductase [Echinococcus granulosus] | diamond | 360 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28511405 | 28511405 | PRJNA1011833_S_NODE_3827_length_507_cov_12.721983_g3428_i0 | PRJNA1011833 | 3827 | 507 | 12.721983 | 64.50045381 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 92.8 | 3.35e-19 | NR | TNN12967.1 | 6182 | g3428 | i0 | 47.6 | 10.0059171597633 | 103 | 53 | 60.4 | 1 | 507 | 202 | 158 | 260 | TNN12967.1 DnaJ subfamily A member 1 isoform 3 [Schistosoma japonicum] | diamond | 5073 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28543213 | 28543213 | PRJNA1011833_S_NODE_58507_length_152_cov_0.880734_g58087_i0 | PRJNA1011833 | 58507 | 152 | 0.880734 | 1.33871568 | Hymenolepis | 6215 | Platyhelminthes | Platyhelminthes | 72.4 | 3.69e-13 | NR | VUZ45360.1 | 6216 | g58087 | i0 | 59.6 | 8.38815789473684 | 47 | 19 | 92.8 | 0 | 141 | 1 | 200 | 246 | VUZ45360.1 unnamed protein product [Hymenolepis diminuta] | diamond | 1275 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 28771582 | 28771582 | PRJNA1011833_S_NODE_15267_length_309_cov_2.706767_g14847_i0 | PRJNA1011833 | 15267 | 309 | 2.706767 | 8.36391003 | Schistosoma turkestanicum | 1163369 | Platyhelminthes | Platyhelminthes | 87.4 | 8.86e-18 | NR | CAH8572382.1 | 1163369 | g14847 | i0 | 45.5 | 1.63106796116505 | 88 | 48 | 85.4 | 0 | 270 | 7 | 274 | 361 | CAH8572382.1 unnamed protein product [Schistosoma turkestanicum] | diamond | 504 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma turkestanicum | |
| 28834767 | 28834767 | PRJNA1011833_S_NODE_33188_length_203_cov_2.812500_g32768_i0 | PRJNA1011833 | 33188 | 203 | 2.8125 | 5.709375 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 81.3 | 2.93e-17 | NR | VDP75191.1 | 27848 | g32768 | i0 | 56.5 | 5.06896551724138 | 69 | 26 | 96.1 | 2 | 9 | 203 | 85 | 153 | VDP75191.1 unnamed protein product [Echinostoma caproni] | diamond | 1029 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 29710862 | 29710862 | PRJNA1011833_S_NODE_33130_length_204_cov_0.894410_g32710_i0 | PRJNA1011833 | 33130 | 204 | 0.89441 | 1.8245964 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 44.3 | 0.00622 | NR | CAH8867447.1 | 157070 | g32710 | i0 | 51.2 | 2.30882352941176 | 41 | 19 | 58.8 | 1 | 199 | 80 | 300 | 340 | CAH8867447.1 unnamed protein product [Trichobilharzia szidati] | diamond | 471 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 29971489 | 29971489 | PRJNA1011833_S_NODE_23771_length_245_cov_1.292079_g23351_i0 | PRJNA1011833 | 23771 | 245 | 1.292079 | 3.16559355 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 40.8 | 0.0382 | NR | CAH8518454.1 | 57078 | g23351 | i0 | 40.7 | 0.722448979591837 | 59 | 33 | 72.2 | 1 | 12 | 188 | 8 | 64 | CAH8518454.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 177 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 30508642 | 30508642 | PRJNA1011833_S_NODE_11513_length_350_cov_2.941368_g11093_i0 | PRJNA1011833 | 11513 | 350 | 2.941368 | 10.294788 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 211 | 1.39e-63 | NR | AAX28387.3 | 6182 | g11093 | i0 | 100 | 9.42857142857143 | 110 | 0 | 94.3 | 0 | 2 | 331 | 363 | 472 | AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] | diamond | 3300 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30658963 | 30658963 | PRJNA1011833_S_NODE_20793_length_264_cov_2.171946_g20373_i0 | PRJNA1011833 | 20793 | 264 | 2.171946 | 5.73393744 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 131 | 1.8199999999999999e-34 | NR | OON22600.1 | 6198 | g20373 | i0 | 67.4 | 25.4090909090909 | 86 | 28 | 97.7 | 0 | 263 | 6 | 160 | 245 | OON22600.1 glutamine synthetase, beta-grasp domain protein [Opisthorchis viverrini] | diamond | 6708 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 30943472 | 30943472 | PRJNA1011833_S_NODE_17634_length_288_cov_3.126531_g17214_i0 | PRJNA1011833 | 17634 | 288 | 3.126531 | 9.00440928 | Plagiorchiida | 27871 | Platyhelminthes | Platyhelminthes | 117 | 9.2e-30 | NR | CAH8478998.1 | 57078 | g17214 | i0 | 59.7 | 5.14583333333333 | 72 | 29 | 75 | 0 | 73 | 288 | 188 | 259 | CAH8478998.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 1482 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 30975066 | 30975066 | PRJNA1011833_S_NODE_24734_length_239_cov_3.183673_g24314_i0 | PRJNA1011833 | 24734 | 239 | 3.183673 | 7.60897847 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 49.3 | 1.65e-4 | NR | TNN06724.1 | 6182 | g24314 | i0 | 26.3 | 2.86192468619247 | 76 | 56 | 95.4 | 0 | 235 | 8 | 244 | 319 | TNN06724.1 Syntaxin-18 isoform 3 [Schistosoma japonicum] | diamond | 684 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31108808 | 31108808 | PRJNA1011833_S_NODE_9795_length_373_cov_3.687879_g9377_i0 | PRJNA1011833 | 9795 | 373 | 3.687879 | 13.75578867 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 89.4 | 7.6e-20 | NR | CAL5130566.1 | 300641 | g9377 | i0 | 39 | 5.53351206434316 | 100 | 61 | 80.4 | 0 | 372 | 73 | 27 | 126 | CAL5130566.1 unnamed protein product [Calicophoron daubneyi] | diamond | 2064 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 31678066 | 31678066 | PRJNA1011833_S_NODE_12597_length_337_cov_3.727891_g12177_i0 | PRJNA1011833 | 12597 | 337 | 3.727891 | 12.56299267 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 48.9 | 7.33e-4 | NR | CAH8845418.1 | 157069 | g12177 | i0 | 28.6 | 0.997032640949555 | 112 | 73 | 96.1 | 4 | 5 | 328 | 415 | 523 | CAH8845418.1 unnamed protein product [Trichobilharzia regenti] | diamond | 336 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 31772968 | 31772968 | PRJNA1011833_S_NODE_21397_length_260_cov_1.677419_g20977_i0 | PRJNA1011833 | 21397 | 260 | 1.677419 | 4.3612894 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 46.6 | 3.06e-4 | NR | VDM26664.1 | 6205 | g20977 | i0 | 41.7 | 0.692307692307692 | 60 | 32 | 69.2 | 1 | 46 | 225 | 6 | 62 | VDM26664.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 180 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 31923536 | 31923536 | PRJNA1011833_S_NODE_5677_length_448_cov_9.538272_g5265_i0 | PRJNA1011833 | 5677 | 448 | 9.538272 | 42.73145856 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 194 | 5.419999999999999e-60 | NR | KAH9284319.1 | 6210 | g5265 | i0 | 81.5 | 7.47321428571429 | 124 | 23 | 83 | 0 | 1 | 372 | 94 | 217 | KAH9284319.1 40S ribosomal protein S5 [Echinococcus granulosus] | diamond | 3348 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 32018515 | 32018515 | PRJNA1011833_S_NODE_56618_length_153_cov_1.309091_g56198_i0 | PRJNA1011833 | 56618 | 153 | 1.309091 | 2.00290923 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.9 | 3.71e-10 | NR | VDD75608.1 | 53468 | g56198 | i0 | 60.4 | 21.6274509803922 | 48 | 19 | 94.1 | 0 | 144 | 1 | 194 | 241 | VDD75608.1 unnamed protein product [Mesocestoides corti] | diamond | 3309 | 64.3 | 0.993779160186625 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 32429936 | 32429936 | PRJNA1011833_S_NODE_21379_length_260_cov_1.990783_g20959_i0 | PRJNA1011833 | 21379 | 260 | 1.990783 | 5.1760358 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 146 | 1.08e-38 | NR | TNN17402.1 | 6182 | g20959 | i0 | 82.6 | 14.8846153846154 | 86 | 15 | 99.2 | 0 | 258 | 1 | 405 | 490 | TNN17402.1 tRNA-splicing ligase RtcB isoform 2 [Schistosoma japonicum] | diamond | 3870 | 147 | 0.993197278911565 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32437747 | 32437747 | PRJNA1011833_S_NODE_45899_length_171_cov_1.500000_g45479_i0 | PRJNA1011833 | 45899 | 171 | 1.5 | 2.565 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 57 | 1.01e-7 | NR | CDI96811.1 | 6211 | g45479 | i0 | 57.1 | 0.736842105263158 | 42 | 18 | 73.7 | 0 | 127 | 2 | 18 | 59 | CDI96811.1 acyl protein thioesterase 12 [Echinococcus multilocularis] | diamond | 126 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 32721504 | 32721504 | PRJNA1011833_S_NODE_16360_length_299_cov_2.175781_g15940_i0 | PRJNA1011833 | 16360 | 299 | 2.175781 | 6.50558519 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 104 | 1.4000000000000002e-23 | NR | VDM32730.1 | 6205 | g15940 | i0 | 53 | 3.01003344481605 | 100 | 45 | 98.3 | 1 | 3 | 296 | 425 | 524 | VDM32730.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 900 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis |
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);;