contig_metadata
24 rows where bioproject = "PRJNA448207", tax_phylum = "Platyhelminthes" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 438558 | 438558 | PRJNA448207_P_NODE_14841_length_330_cov_1.198444_g14678_i0 | PRJNA448207 | 14841 | 330 | 1.198444 | 3.9548652 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 333 | 9.909999999999998e-87 | NTclustered | gi|1373861866|ref|XM_024497310.1| | 6210 | g14678 | i0 | 99.454 | 0.927272727272727 | 183 | 1 | 55 | 0 | 1 | 183 | 150 | 332 | Echinococcus granulosus hypothetical protein (EGR_08061), partial mRNA | blastn | 306 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 4265797 | 4265797 | PRJNA448207_P_NODE_27244_length_249_cov_0.875000_g27081_i0 | PRJNA448207 | 27244 | 249 | 0.875 | 2.17875 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 353 | 5.52e-93 | NTclustered | gi|1373859962|ref|XM_024496358.1| | 6210 | g27081 | i0 | 100 | 1.14859437751004 | 191 | 0 | 100 | 0 | 1 | 191 | 5880 | 5690 | Echinococcus granulosus Ras-specific guanine nucleotide-releasing factor (EGR_07109), partial mRNA | blastn | 286 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 4920650 | 4920650 | PRJNA448207_S_NODE_1204_length_390_cov_1.000000_g1193_i0 | PRJNA448207 | 1204 | 390 | 1 | 3.9 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 58.4 | 8.01e-4 | NTclustered | gi|690513916|emb|LN064537.1| | 99802 | g1193 | i0 | 100 | 6.88717948717949 | 31 | 0 | 8 | 0 | 189 | 219 | 1880 | 1910 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0002114 | blastn | 2686 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5542601 | 5542601 | PRJNA448207_P_NODE_305_length_1594_cov_3.134780_g278_i0 | PRJNA448207 | 305 | 1594 | 3.13478 | 49.9683932 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 392 | 2.36e-122 | NR | CDS31835.1 | 85433 | g278 | i0 | 40.5 | 6.10539523212045 | 484 | 242 | 83 | 8 | 1588 | 266 | 345 | 825 | CDS31835.1 Papilin [Hymenolepis microstoma] | diamond | 9732 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 6816754 | 6816754 | PRJNA448207_S_NODE_26_length_1696_cov_3.533580_g24_i0 | PRJNA448207 | 26 | 1696 | 3.53358 | 59.9295168 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 394 | 2.52e-122 | NR | CDS31835.1 | 85433 | g24 | i0 | 40.3 | 5.75766509433962 | 491 | 247 | 79.2 | 8 | 36 | 1379 | 338 | 825 | CDS31835.1 Papilin [Hymenolepis microstoma] | diamond | 9765 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 9366862 | 9366862 | PRJNA448207_P_NODE_7108_length_456_cov_1.151436_g6946_i0 | PRJNA448207 | 7108 | 456 | 1.151436 | 5.25054816 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.044 | NTclustered | gi|687163270|emb|LN038880.1| | 99802 | g6946 | i0 | 100 | 0.0614035087719298 | 28 | 0 | 6 | 0 | 327 | 354 | 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 | |
| 10642581 | 10642581 | PRJNA448207_P_NODE_23909_length_260_cov_1.577540_g23746_i0 | PRJNA448207 | 23909 | 260 | 1.57754 | 4.101604 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 327 | 3.52e-85 | NTclustered | gi|1373845992|ref|XM_024489373.1| | 6210 | g23746 | i0 | 100 | 1.00384615384615 | 177 | 0 | 100 | 0 | 84 | 260 | 1044 | 868 | Echinococcus granulosus tRNA-specific adenosine deaminase-like protein (EGR_00124), partial mRNA | blastn | 261 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 11917380 | 11917380 | PRJNA448207_P_NODE_1930_length_830_cov_7.190225_g1804_i0 | PRJNA448207 | 1930 | 830 | 7.190225 | 59.6788675 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 528 | 5.729999999999999e-188 | NR | CAX70940.1 | 6182 | g1804 | i0 | 96.6 | 160.579518072289 | 264 | 9 | 95.4 | 0 | 38 | 829 | 1 | 264 | CAX70940.1 putative tubulin, beta, 2 [Schistosoma japonicum] | diamond | 133281 | 531 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 17016138 | 17016138 | PRJNA448207_P_NODE_30274_length_245_cov_0.895349_g30111_i0 | PRJNA448207 | 30274 | 245 | 0.895349 | 2.19360505 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 211 | 3.45e-50 | NTclustered | gi|1373848276|ref|XM_024490515.1| | 6210 | g30111 | i0 | 99.145 | 0.477551020408163 | 117 | 1 | 48 | 0 | 129 | 245 | 2103 | 1987 | Echinococcus granulosus Splicing factor, arginine/serine-rich (EGR_01266), partial mRNA | blastn | 117 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 19564435 | 19564435 | PRJNA448207_P_NODE_19796_length_289_cov_1.185185_g19633_i0 | PRJNA448207 | 19796 | 289 | 1.185185 | 3.42518465 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 207 | 5.3900000000000004e-49 | NTclustered | gi|1373864244|ref|XM_024498499.1| | 6210 | g19633 | i0 | 91.447 | 40.757785467128 | 152 | 12 | 52 | 1 | 15 | 165 | 665 | 816 | Echinococcus granulosus hypothetical protein (EGR_09250), partial mRNA | blastn | 11779 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 27186965 | 27186965 | PRJNA448207_S_NODE_2282_length_298_cov_1.711111_g2271_i0 | PRJNA448207 | 2282 | 298 | 1.711111 | 5.09911078 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 50.1 | 9.53e-5 | NR | VDN10303.1 | 60516 | g2271 | i0 | 40.3 | 1.97315436241611 | 67 | 39 | 66.4 | 1 | 5 | 202 | 111 | 177 | VDN10303.1 unnamed protein product [Dibothriocephalus latus] | diamond | 588 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 27377100 | 27377100 | PRJNA448207_S_NODE_3963_length_242_cov_0.911243_g3952_i0 | PRJNA448207 | 3963 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 91.7 | 2.22e-19 | NR | XP_009163574.1 | 6198 | g3952 | i0 | 84.3 | 11.4669421487603 | 51 | 8 | 63.2 | 0 | 237 | 85 | 614 | 664 | XP_009163574.1 hypothetical protein T265_01304 [Opisthorchis viverrini] | diamond | 2775 | 92.4 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 27518444 | 27518444 | PRJNA448207_P_NODE_13543_length_343_cov_0.962963_g13380_i0 | PRJNA448207 | 13543 | 343 | 0.962963 | 3.30296309 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 58.9 | 2.54e-7 | NR | PAA59296.1 | 282301 | g13380 | i0 | 50 | 0.769679300291545 | 44 | 22 | 38.5 | 0 | 14 | 145 | 285 | 328 | PAA59296.1 hypothetical protein BOX15_Mlig029643g1 [Macrostomum lignano] | diamond | 264 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27644927 | 27644927 | PRJNA448207_P_NODE_16944_length_311_cov_1.491597_g16781_i0 | PRJNA448207 | 16944 | 311 | 1.491597 | 4.63886667 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 52.4 | 2.12e-6 | NR | VDQ17541.1 | 157069 | g16781 | i0 | 65.1 | 3.58842443729904 | 43 | 15 | 41.5 | 0 | 299 | 171 | 7 | 49 | VDQ17541.1 unnamed protein product [Trichobilharzia regenti] | diamond | 1116 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 28086632 | 28086632 | PRJNA448207_P_NODE_10625_length_381_cov_0.814935_g10463_i0 | PRJNA448207 | 10625 | 381 | 0.814935 | 3.10490235 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 65.5 | 7.91e-10 | NR | VDP92820.1 | 27848 | g10463 | i0 | 35.1 | 2.21259842519685 | 74 | 48 | 58.3 | 0 | 367 | 146 | 101 | 174 | VDP92820.1 unnamed protein product [Echinostoma caproni] | diamond | 843 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 28307866 | 28307866 | PRJNA448207_S_NODE_66_length_1201_cov_2.221631_g64_i0 | PRJNA448207 | 66 | 1201 | 2.221631 | 26.68178831 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 52.8 | 0.00165 | NR | CDS27810.1 | 85433 | g64 | i0 | 28.4 | 0.654454621149043 | 116 | 68 | 25.2 | 5 | 1188 | 886 | 219 | 334 | CDS27810.1 trypsin-like protease [Hymenolepis microstoma] | diamond | 786 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 29381299 | 29381299 | PRJNA448207_P_NODE_27229_length_249_cov_0.875000_g27066_i0 | PRJNA448207 | 27229 | 249 | 0.875 | 2.17875 | Trichobilharzia szidati | 157070 | Platyhelminthes | Platyhelminthes | 48.9 | 2.68e-4 | NR | CAH8843533.1 | 157070 | g27066 | i0 | 40 | 1.02409638554217 | 85 | 38 | 86.7 | 3 | 8 | 223 | 711 | 795 | CAH8843533.1 unnamed protein product [Trichobilharzia szidati] | diamond | 255 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 29555238 | 29555238 | PRJNA448207_S_NODE_250_length_745_cov_4.187500_g241_i0 | PRJNA448207 | 250 | 745 | 4.1875 | 31.196875 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 496 | 1.6399999999999995e-175 | NR | CAX70940.1 | 6182 | g241 | i0 | 96.4 | 179.758389261745 | 248 | 9 | 99.9 | 0 | 2 | 745 | 13 | 260 | CAX70940.1 putative tubulin, beta, 2 [Schistosoma japonicum] | diamond | 133920 | 498 | 0.995983935742972 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30075946 | 30075946 | PRJNA448207_S_NODE_2932_length_269_cov_1.071429_g2921_i0 | PRJNA448207 | 2932 | 269 | 1.071429 | 2.88214401 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 53.1 | 1.03e-5 | NR | VDD82014.1 | 53468 | g2921 | i0 | 41.7 | 2.81040892193309 | 84 | 34 | 93.7 | 2 | 257 | 6 | 1 | 69 | VDD82014.1 unnamed protein product [Mesocestoides corti] | diamond | 756 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 30945519 | 30945519 | PRJNA448207_P_NODE_14174_length_336_cov_1.615970_g14011_i0 | PRJNA448207 | 14174 | 336 | 1.61597 | 5.4296592 | Opisthorchiidae | 6196 | Platyhelminthes | Platyhelminthes | 52 | 1.38e-5 | NR | OON18335.1 | 6198 | g14011 | i0 | 40.3 | 1.28571428571429 | 72 | 43 | 64.3 | 0 | 89 | 304 | 17 | 88 | OON18335.1 hypothetical protein X801_05811 [Opisthorchis viverrini] | diamond | 432 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 31197735 | 31197735 | PRJNA448207_P_NODE_14775_length_331_cov_0.968992_g14612_i0 | PRJNA448207 | 14775 | 331 | 0.968992 | 3.20736352 | Plagiorchiida | 27871 | Platyhelminthes | Platyhelminthes | 79.7 | 6.47e-17 | NR | THD23308.1 | 6192 | g14612 | i0 | 43.9 | 5.8368580060423 | 82 | 46 | 74.3 | 0 | 324 | 79 | 7 | 88 | THD23308.1 Dynein light chain cytoplasmic [Fasciola hepatica] | diamond | 1932 | 80.5 | 0.990062111801242 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31419492 | 31419492 | PRJNA448207_P_NODE_25036_length_252_cov_2.614525_g24873_i0 | PRJNA448207 | 25036 | 252 | 2.614525 | 6.588603 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 99 | 6.21e-25 | NR | CAX74960.1 | 6182 | g24873 | i0 | 65.8 | 6.07142857142857 | 73 | 25 | 86.9 | 0 | 3 | 221 | 17 | 89 | CAX74960.1 diazepam-binding inhibitor [Schistosoma japonicum] | diamond | 1530 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31609376 | 31609376 | PRJNA448207_P_NODE_16996_length_311_cov_1.142857_g16833_i0 | PRJNA448207 | 16996 | 311 | 1.142857 | 3.55428527 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 61.2 | 2.28e-8 | NR | VDD82014.1 | 53468 | g16833 | i0 | 41.5 | 2.62379421221865 | 94 | 49 | 90.7 | 1 | 308 | 27 | 22 | 109 | VDD82014.1 unnamed protein product [Mesocestoides corti] | diamond | 816 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 31719596 | 31719596 | PRJNA448207_P_NODE_8637_length_418_cov_1.927536_g8475_i0 | PRJNA448207 | 8637 | 418 | 1.927536 | 8.05710048 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 83.6 | 5.71e-16 | NR | PAA81674.1 | 282301 | g8475 | i0 | 56.2 | 1.06937799043062 | 73 | 32 | 52.4 | 0 | 343 | 125 | 26 | 98 | PAA81674.1 hypothetical protein BOX15_Mlig021371g5, partial [Macrostomum lignano] | diamond | 447 | 83.6 | 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);;