contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA448207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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);;