contig_metadata
16 rows where bioproject = "PRJNA484127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4275449 | 4275449 | PRJNA484127_P_NODE_204_length_1788_cov_4.981924_g166_i0 | PRJNA484127 | 204 | 1788 | 4.981924 | 89.07680112 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 392 | 1.8699999999999995e-121 | NR | CDS31835.1 | 85433 | g166 | i0 | 40.5 | 5.4496644295302 | 484 | 242 | 74 | 8 | 12 | 1334 | 345 | 825 | CDS31835.1 Papilin [Hymenolepis microstoma] | diamond | 9744 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 8101500 | 8101500 | PRJNA484127_P_NODE_19707_length_296_cov_4.044843_g19558_i0 | PRJNA484127 | 19707 | 296 | 4.044843 | 11.97273528 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 503 | 6.309999999999998e-138 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g19558 | i0 | 97.02 | 126.226351351351 | 302 | 3 | 100 | 2 | 1 | 296 | 1303 | 1604 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 37363 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14476883 | 14476883 | PRJNA484127_P_NODE_13712_length_339_cov_1.466165_g13563_i0 | PRJNA484127 | 13712 | 339 | 1.466165 | 4.97029935 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 230 | 1.3799999999999996e-55 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g13563 | i0 | 85.981 | 5.54867256637168 | 214 | 30 | 63 | 0 | 126 | 339 | 1 | 214 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 1881 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 17025580 | 17025580 | PRJNA484127_P_NODE_1374_length_900_cov_6.778718_g1259_i0 | PRJNA484127 | 1374 | 900 | 6.778718 | 61.008462 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 568 | 2.07e-203 | NR | CAX70940.1 | 6182 | g1259 | i0 | 96.2 | 147.926666666667 | 286 | 11 | 95.3 | 0 | 859 | 2 | 1 | 286 | CAX70940.1 putative tubulin, beta, 2 [Schistosoma japonicum] | diamond | 133134 | 572 | 0.993006993006993 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 17025618 | 17025618 | PRJNA484127_P_NODE_1574_length_849_cov_7.198454_g1451_i0 | PRJNA484127 | 1574 | 849 | 7.198454 | 61.11487446 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 445 | 2.339999999999999e-152 | NR | CDS16437.1 | 6210 | g1451 | i0 | 82 | 410.473498233216 | 255 | 46 | 90.1 | 0 | 84 | 848 | 58 | 312 | CDS16437.1 tubulin alpha chain [Echinococcus granulosus] | diamond | 348492 | 449 | 0.99109131403118 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 17026015 | 17026015 | PRJNA484127_P_NODE_39554_length_237_cov_2.323171_g39405_i0 | PRJNA484127 | 39554 | 237 | 2.323171 | 5.50591527 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 209 | 1.19e-49 | NTclustered | gi|1084307901|ref|XM_018791342.1| | 6183 | g39405 | i0 | 88.439 | 33.4556962025316 | 173 | 20 | 73 | 0 | 65 | 237 | 30 | 202 | Schistosoma mansoni tubulin beta chain,putative partial mRNA | blastn | 7929 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 26981324 | 26981324 | PRJNA484127_P_NODE_35582_length_246_cov_0.901734_g35433_i0 | PRJNA484127 | 35582 | 246 | 0.901734 | 2.21826564 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 112 | 3.36e-28 | NR | PAA67400.1 | 282301 | g35433 | i0 | 62.2 | 1 | 82 | 30 | 100 | 1 | 246 | 1 | 153 | 233 | PAA67400.1 hypothetical protein BOX15_Mlig028091g1, partial [Macrostomum lignano] | diamond | 246 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27107704 | 27107704 | PRJNA484127_P_NODE_37822_length_243_cov_0.917647_g37673_i0 | PRJNA484127 | 37822 | 243 | 0.917647 | 2.22988221 | Paragonimus skrjabini miyazakii | 59628 | Platyhelminthes | Platyhelminthes | 48.5 | 3.5e-4 | NR | KAF7256799.1 | 59628 | g37673 | i0 | 50.9 | 1.30864197530864 | 53 | 26 | 65.4 | 0 | 1 | 159 | 404 | 456 | KAF7256799.1 hypothetical protein EG68_06714 [Paragonimus skrjabini miyazakii] | diamond | 318 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 27471709 | 27471709 | PRJNA484127_P_NODE_20523_length_292_cov_1.196347_g20374_i0 | PRJNA484127 | 20523 | 292 | 1.196347 | 3.49333324 | Opisthorchiidae | 6196 | Platyhelminthes | Platyhelminthes | 50.8 | 2.46e-5 | NR | OON18335.1 | 6198 | g20374 | i0 | 38.9 | 1.47945205479452 | 72 | 44 | 74 | 0 | 235 | 20 | 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 | |
| 28892220 | 28892220 | PRJNA484127_P_NODE_38548_length_242_cov_1.343195_g38399_i0 | PRJNA484127 | 38548 | 242 | 1.343195 | 3.2505319 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 100 | 1.29e-22 | NR | CAH8538525.1 | 6188 | g38399 | i0 | 55.7 | 12.7933884297521 | 79 | 35 | 97.9 | 0 | 241 | 5 | 74 | 152 | CAH8538525.1 unnamed protein product [Schistosoma rodhaini] | diamond | 3096 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 30076176 | 30076176 | PRJNA484127_P_NODE_25332_length_269_cov_1.591837_g25183_i0 | PRJNA484127 | 25332 | 269 | 1.591837 | 4.28204153 | Schistosoma mekongi | 38744 | Platyhelminthes | Platyhelminthes | 48.5 | 4.73e-4 | NR | KAK4475148.1 | 38744 | g25183 | i0 | 41.5 | 0.591078066914498 | 53 | 27 | 54.6 | 1 | 235 | 89 | 14 | 66 | KAK4475148.1 hypothetical protein MN116_002233, partial [Schistosoma mekongi] | diamond | 159 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mekongi | |
| 30139090 | 30139090 | PRJNA484127_P_NODE_2672_length_664_cov_3.343486_g2530_i0 | PRJNA484127 | 2672 | 664 | 3.343486 | 22.20074704 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 55.8 | 3.3e-5 | NR | CDS27810.1 | 85433 | g2530 | i0 | 28 | 1.12951807228916 | 125 | 75 | 49.7 | 5 | 12 | 341 | 210 | 334 | CDS27810.1 trypsin-like protease [Hymenolepis microstoma] | diamond | 750 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 30771559 | 30771559 | PRJNA484127_P_NODE_18634_length_303_cov_1.347826_g18485_i0 | PRJNA484127 | 18634 | 303 | 1.347826 | 4.08391278 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 130 | 1.2199999999999999e-32 | NR | CAH8574855.1 | 57078 | g18485 | i0 | 54.5 | 7.97029702970297 | 101 | 46 | 100 | 0 | 303 | 1 | 476 | 576 | CAH8574855.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 2415 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 30929374 | 30929374 | PRJNA484127_P_NODE_39914_length_233_cov_2.043750_g39765_i0 | PRJNA484127 | 39914 | 233 | 2.04375 | 4.7619375 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 70.1 | 7.6e-12 | NR | VZI45066.1 | 99802 | g39765 | i0 | 57.7 | 3.34763948497854 | 52 | 22 | 67 | 0 | 2 | 157 | 157 | 208 | VZI45066.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 780 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 31087342 | 31087342 | PRJNA484127_P_NODE_11535_length_362_cov_1.896194_g11386_i0 | PRJNA484127 | 11535 | 362 | 1.896194 | 6.86422228 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 53.1 | 3.05e-5 | NR | PAA52852.1 | 282301 | g11386 | i0 | 34.1 | 0.729281767955801 | 88 | 53 | 72.9 | 2 | 292 | 29 | 158 | 240 | PAA52852.1 hypothetical protein BOX15_Mlig010770g1, partial [Macrostomum lignano] | diamond | 264 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32415989 | 32415989 | PRJNA484127_P_NODE_20419_length_292_cov_2.027397_g20270_i0 | PRJNA484127 | 20419 | 292 | 2.027397 | 5.91999924 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 63.5 | 2.11e-10 | NR | CAL5138721.1 | 300641 | g20270 | i0 | 55.6 | 1.17123287671233 | 54 | 24 | 55.5 | 0 | 162 | 1 | 60 | 113 | CAL5138721.1 unnamed protein product [Calicophoron daubneyi] | diamond | 342 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi |
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);;