contig_metadata
10 rows where bioproject = "PRJNA1215813", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4873943 | 4873943 | PRJNA1215813_P_NODE_4264_length_370_cov_2.101010_g4184_i0 | PRJNA1215813 | 4264 | 370 | 2.10101 | 7.773737 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 219 | 7.6e-67 | NR | XP_009164529.1 | 6198 | g4184 | i0 | 80.5 | 150.575675675676 | 123 | 24 | 99.7 | 0 | 369 | 1 | 2 | 124 | XP_009164529.1 hypothetical protein T265_02106 [Opisthorchis viverrini] | diamond | 55713 | 221 | 0.990950226244344 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 7985245 | 7985245 | PRJNA1215813_P_NODE_9247_length_253_cov_1.644444_g9167_i0 | PRJNA1215813 | 9247 | 253 | 1.644444 | 4.16044332 | Monotoplana cf. diorchis | 104924 | Platyhelminthes | Platyhelminthes | 73.1 | 1.76e-8 | NTclustered | gi|10944981|emb|AJ270174.1| | 104924 | g9167 | i0 | 100 | 14.7944664031621 | 39 | 0 | 15 | 0 | 61 | 99 | 1633 | 1595 | Monotoplana cf. diorchis partial 28S rRNA gene | blastn | 3743 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Monotoplanidae | Monotoplana | Monotoplana cf. diorchis | |
| 9259804 | 9259804 | PRJNA1215813_P_NODE_8828_length_261_cov_2.489362_g8748_i0 | PRJNA1215813 | 8828 | 261 | 2.489362 | 6.49723482 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 460 | 3.3399999999999995e-125 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g8748 | i0 | 98.467 | 1 | 261 | 4 | 100 | 0 | 1 | 261 | 41 | 301 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 261 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27198884 | 27198884 | PRJNA1215813_P_NODE_9562_length_252_cov_0.871508_g9482_i0 | PRJNA1215813 | 9562 | 252 | 0.871508 | 2.19620016 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 44.3 | 0.0116 | NR | GAA48294.1 | 79923 | g9482 | i0 | 33.8 | 0.845238095238095 | 71 | 45 | 82.1 | 1 | 226 | 20 | 80 | 150 | GAA48294.1 hypothetical protein CLF_101429 [Clonorchis sinensis] | diamond | 213 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 27281252 | 27281252 | PRJNA1215813_P_NODE_10783_length_248_cov_0.891429_g10703_i0 | PRJNA1215813 | 10783 | 248 | 0.891429 | 2.21074392 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 70.9 | 4.92e-12 | NR | XP_009162149.1 | 6198 | g10703 | i0 | 43 | 36.7983870967742 | 79 | 40 | 89.5 | 2 | 248 | 27 | 592 | 670 | XP_009162149.1 hypothetical protein T265_00177 [Opisthorchis viverrini] | diamond | 9126 | 71.6 | 0.990223463687151 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 27420591 | 27420591 | PRJNA1215813_P_NODE_11883_length_244_cov_0.912281_g11803_i0 | PRJNA1215813 | 11883 | 244 | 0.912281 | 2.22596564 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 105 | 1.5999999999999999e-24 | NR | PAA76525.1 | 282301 | g11803 | i0 | 61.3 | 1.9672131147541 | 80 | 31 | 98.4 | 0 | 2 | 241 | 254 | 333 | PAA76525.1 hypothetical protein BOX15_Mlig016081g3 [Macrostomum lignano] | diamond | 480 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28986512 | 28986512 | PRJNA1215813_P_NODE_11848_length_244_cov_0.912281_g11768_i0 | PRJNA1215813 | 11848 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 1.4e-12 | NR | PAA54799.1 | 282301 | g11768 | i0 | 62.5 | 2.82786885245902 | 56 | 20 | 67.6 | 1 | 76 | 240 | 15 | 70 | PAA54799.1 hypothetical protein BOX15_Mlig010068g3 [Macrostomum lignano] | diamond | 690 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29365230 | 29365230 | PRJNA1215813_P_NODE_11489_length_245_cov_2.267442_g11409_i0 | PRJNA1215813 | 11489 | 245 | 2.267442 | 5.5552329 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 96.3 | 5.550000000000001e-21 | NR | VDM33619.1 | 6205 | g11409 | i0 | 53.7 | 13.7877551020408 | 82 | 37 | 99.2 | 1 | 245 | 3 | 126 | 207 | VDM33619.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 3378 | 97.1 | 0.991761071060762 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29661650 | 29661650 | PRJNA1215813_P_NODE_10490_length_249_cov_0.886364_g10410_i0 | PRJNA1215813 | 10490 | 249 | 0.886364 | 2.20704636 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 46.6 | 0.0018 | NR | VDM01867.1 | 70667 | g10410 | i0 | 36.5 | 3.19277108433735 | 63 | 34 | 75.9 | 2 | 225 | 37 | 253 | 309 | VDM01867.1 unnamed protein product [Schistocephalus solidus] | diamond | 795 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 32696283 | 32696283 | PRJNA1215813_P_NODE_8060_length_276_cov_1.536946_g7980_i0 | PRJNA1215813 | 8060 | 276 | 1.536946 | 4.24197096 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0295 | NR | PAA86220.1 | 282301 | g7980 | i0 | 45.2 | 0.456521739130435 | 42 | 23 | 45.7 | 0 | 171 | 46 | 76 | 117 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 126 | 43.5 | 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);;