contig_metadata
18 rows where bioproject = "PRJDB14274" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 980948 | 980948 | PRJDB14274_S_NODE_9421_length_208_cov_0.884354_g9343_i0 | PRJDB14274 | 9421 | 208 | 0.884354 | 1.83945632 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 62.1 | 3.03e-5 | NTclustered | gi|690882270|emb|LN386135.1| | 99802 | g9343 | i0 | 97.222 | 3.87019230769231 | 36 | 1 | 17 | 0 | 156 | 191 | 554 | 519 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0238388 | blastn | 805 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 7660857 | 7660857 | PRJDB14274_S_NODE_47_length_1953_cov_6.556554_g40_i0 | PRJDB14274 | 47 | 1953 | 6.556554 | 128.04949962 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 393 | 5.3599999999999985e-121 | NR | CDS31835.1 | 85433 | g40 | i0 | 40.3 | 5 | 491 | 247 | 68.8 | 8 | 55 | 1398 | 338 | 825 | CDS31835.1 Papilin [Hymenolepis microstoma] | diamond | 9765 | 393 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 7660862 | 7660862 | PRJDB14274_S_NODE_567_length_783_cov_5.333795_g511_i0 | PRJDB14274 | 567 | 783 | 5.333795 | 41.76361485 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 449 | 2.09e-154 | NR | CDS16437.1 | 6210 | g511 | i0 | 82.1 | 456.578544061303 | 257 | 46 | 98.5 | 0 | 772 | 2 | 58 | 314 | CDS16437.1 tubulin alpha chain [Echinococcus granulosus] | diamond | 357501 | 453 | 0.991169977924945 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 11486470 | 11486470 | PRJDB14274_S_NODE_6830_length_242_cov_1.381215_g6752_i0 | PRJDB14274 | 6830 | 242 | 1.381215 | 3.3425403 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|687163270|emb|LN038880.1| | 99802 | g6752 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 106 | 133 | 741 | 768 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0037985 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 17558864 | 17558864 | PRJDB14274_S_NODE_10654_length_174_cov_6.522124_g10576_i0 | PRJDB14274 | 10654 | 174 | 6.522124 | 11.34849576 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 198 | 1.78e-46 | NTclustered | gi|684409700|ref|XM_009177569.1| | 6198 | g10576 | i0 | 87.647 | 99.2701149425287 | 170 | 21 | 98 | 0 | 3 | 172 | 205 | 374 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 17273 | 200 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 20409178 | 20409178 | PRJDB14274_S_NODE_617_length_750_cov_5.722787_g557_i0 | PRJDB14274 | 617 | 750 | 5.722787 | 42.9209025 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 450 | 2.3499999999999998e-157 | NR | CAX70940.1 | 6182 | g557 | i0 | 96 | 174.064 | 224 | 9 | 89.6 | 0 | 672 | 1 | 1 | 224 | CAX70940.1 putative tubulin, beta, 2 [Schistosoma japonicum] | diamond | 130548 | 452 | 0.995575221238938 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28226443 | 28226443 | PRJDB14274_S_NODE_5386_length_269_cov_1.846154_g5308_i0 | PRJDB14274 | 5386 | 269 | 1.846154 | 4.96615426 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 58.5 | 1.3e-7 | NR | VDP45124.1 | 6186 | g5308 | i0 | 40.2 | 11.4981412639405 | 97 | 47 | 95.9 | 2 | 259 | 2 | 19 | 115 | VDP45124.1 unnamed protein product [Schistosoma curassoni] | diamond | 3093 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni | |
| 28580020 | 28580020 | PRJDB14274_S_NODE_8107_length_223_cov_1.203704_g8029_i0 | PRJDB14274 | 8107 | 223 | 1.203704 | 2.68425992 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 44.3 | 0.00803 | NR | PAA79683.1 | 282301 | g8029 | i0 | 44.8 | 0.901345291479821 | 67 | 36 | 88.8 | 1 | 25 | 222 | 178 | 244 | PAA79683.1 hypothetical protein BOX15_Mlig004819g2, partial [Macrostomum lignano] | diamond | 201 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28611519 | 28611519 | PRJDB14274_S_NODE_10487_length_192_cov_2.458015_g10409_i0 | PRJDB14274 | 10487 | 192 | 2.458015 | 4.7193888 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 88.6 | 8.47e-19 | NR | PAA66530.1 | 282301 | g10409 | i0 | 60.3 | 3.9375 | 63 | 25 | 98.4 | 0 | 190 | 2 | 177 | 239 | PAA66530.1 hypothetical protein BOX15_Mlig030441g1 [Macrostomum lignano] | diamond | 756 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29521233 | 29521233 | PRJDB14274_S_NODE_5910_length_258_cov_1.329949_g5832_i0 | PRJDB14274 | 5910 | 258 | 1.329949 | 3.43126842 | Opisthorchiidae | 6196 | Platyhelminthes | Platyhelminthes | 50.8 | 1.65e-5 | NR | OON18335.1 | 6198 | g5832 | i0 | 40.3 | 1.67441860465116 | 72 | 43 | 83.7 | 0 | 248 | 33 | 17 | 88 | OON18335.1 hypothetical protein X801_05811 [Opisthorchis viverrini] | diamond | 432 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 29584112 | 29584112 | PRJDB14274_S_NODE_7970_length_225_cov_1.189024_g7892_i0 | PRJDB14274 | 7970 | 225 | 1.189024 | 2.675304 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 137 | 3.49e-36 | NR | CAH8612082.1 | 6185 | g7892 | i0 | 82.4 | 63.0266666666667 | 74 | 13 | 98.7 | 0 | 3 | 224 | 322 | 395 | CAH8612082.1 unnamed protein product [Schistosoma haematobium] | diamond | 14181 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 29716286 | 29716286 | PRJDB14274_S_NODE_3590_length_324_cov_1.231939_g3512_i0 | PRJDB14274 | 3590 | 324 | 1.231939 | 3.99148236 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 48.9 | 3.99e-4 | NR | VDP69948.1 | 27848 | g3512 | i0 | 68.8 | 0.296296296296296 | 32 | 10 | 29.6 | 0 | 97 | 2 | 29 | 60 | VDP69948.1 unnamed protein product [Echinostoma caproni] | diamond | 96 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 29937732 | 29937732 | PRJDB14274_S_NODE_5671_length_263_cov_1.638614_g5593_i0 | PRJDB14274 | 5671 | 263 | 1.638614 | 4.30955482 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 63.5 | 1.48e-10 | NR | CAL5138721.1 | 300641 | g5593 | i0 | 55.6 | 1.30038022813688 | 54 | 24 | 61.6 | 0 | 102 | 263 | 60 | 113 | CAL5138721.1 unnamed protein product [Calicophoron daubneyi] | diamond | 342 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 29995123 | 29995123 | PRJDB14274_S_NODE_10111_length_203_cov_0.915493_g10033_i0 | PRJDB14274 | 10111 | 203 | 0.915493 | 1.85845079 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 48.1 | 2.77e-4 | NR | CAH8471395.1 | 6184 | g10033 | i0 | 37.5 | 6.38423645320197 | 72 | 35 | 91.6 | 1 | 187 | 2 | 420 | 491 | CAH8471395.1 unnamed protein product [Schistosoma bovis] | diamond | 1296 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 30311404 | 30311404 | PRJDB14274_S_NODE_5572_length_265_cov_1.485294_g5494_i0 | PRJDB14274 | 5572 | 265 | 1.485294 | 3.9360291 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 105 | 1.17e-25 | NR | CAH8652332.1 | 39320 | g5494 | i0 | 54.9 | 21.9056603773585 | 82 | 37 | 92.8 | 0 | 264 | 19 | 168 | 249 | CAH8652332.1 unnamed protein product [Heterobilharzia americana] | diamond | 5805 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 30601013 | 30601013 | PRJDB14274_S_NODE_4633_length_288_cov_1.290749_g4555_i0 | PRJDB14274 | 4633 | 288 | 1.290749 | 3.71735712 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 72.8 | 9.51e-13 | NR | VDO05413.1 | 102285 | g4555 | i0 | 49.3 | 1.40625 | 67 | 34 | 69.8 | 0 | 284 | 84 | 240 | 306 | VDO05413.1 unnamed protein product [Rodentolepis nana] | diamond | 405 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 30974542 | 30974542 | PRJDB14274_S_NODE_5074_length_277_cov_0.902778_g4996_i0 | PRJDB14274 | 5074 | 277 | 0.902778 | 2.50069506 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 141 | 1.37e-36 | NR | THD26152.1 | 6192 | g4996 | i0 | 68.9 | 20.4259927797834 | 90 | 28 | 97.5 | 0 | 8 | 277 | 625 | 714 | THD26152.1 Pre mRNA splicing factor SYF1 [Fasciola hepatica] | diamond | 5658 | 142 | 0.992957746478873 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31232884 | 31232884 | PRJDB14274_S_NODE_6755_length_243_cov_1.780220_g6677_i0 | PRJDB14274 | 6755 | 243 | 1.78022 | 4.3259346 | Trichobilharzia szidati | 157070 | Platyhelminthes | Platyhelminthes | 52.4 | 1.45e-5 | NR | CAH8856828.1 | 157070 | g6677 | i0 | 43.3 | 4.77777777777778 | 67 | 32 | 75.3 | 1 | 6 | 188 | 77 | 143 | CAH8856828.1 unnamed protein product [Trichobilharzia szidati] | diamond | 1161 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati |
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);;