contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1981610 | 1981610 | PRJNA715462_P_NODE_25542_length_356_cov_6.795053_g24746_i0 | PRJNA715462 | 25542 | 356 | 6.795053 | 24.19038868 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 442 | 1.7099999999999995e-119 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g24746 | i0 | 89.076 | 1.00280898876405 | 357 | 37 | 100 | 2 | 1 | 356 | 12 | 367 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 357 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 4534456 | 4534456 | PRJNA715462_P_NODE_47224_length_260_cov_1.058824_g46428_i0 | PRJNA715462 | 47224 | 260 | 1.058824 | 2.7529424 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.024 | NTclustered | gi|690650432|emb|LN198122.1| | 99802 | g46428 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 12 | 39 | 924 | 897 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0169275 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5809757 | 5809757 | PRJNA715462_P_NODE_47625_length_259_cov_0.913978_g46829_i0 | PRJNA715462 | 47625 | 259 | 0.913978 | 2.36720302 | Monotoplana cf. diorchis | 104924 | Platyhelminthes | Platyhelminthes | 73.1 | 1.81e-8 | NTclustered | gi|10944981|emb|AJ270174.1| | 104924 | g46829 | i0 | 100 | 21.2586872586873 | 39 | 0 | 15 | 0 | 128 | 166 | 1595 | 1633 | Monotoplana cf. diorchis partial 28S rRNA gene | blastn | 5506 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Monotoplanidae | Monotoplana | Monotoplana cf. diorchis | |
| 8359662 | 8359662 | PRJNA715462_P_NODE_62387_length_245_cov_0.895349_g61591_i0 | PRJNA715462 | 62387 | 245 | 0.895349 | 2.19360505 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 405 | 1.47e-108 | NTclustered | gi|21308618|gb|AY067985.1| | 79327 | g61591 | i0 | 95.935 | 1.00408163265306 | 246 | 9 | 100 | 1 | 1 | 245 | 562 | 317 | Schmidtea mediterranea clone H.51.12a unknown mRNA sequence | blastn | 246 | 405 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 19833366 | 19833366 | PRJNA715462_P_NODE_67376_length_242_cov_0.911243_g66580_i0 | PRJNA715462 | 67376 | 242 | 0.911243 | 2.20520806 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|690596878|emb|LN150304.1| | 99802 | g66580 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 87 | 114 | 1774 | 1801 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0136384 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 21108064 | 21108064 | PRJNA715462_P_NODE_26217_length_351_cov_1.823741_g25421_i0 | PRJNA715462 | 26217 | 351 | 1.823741 | 6.40133091 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.033 | NTclustered | gi|687572767|emb|LK586392.1| | 57078 | g25421 | i0 | 100 | 0.0797720797720798 | 28 | 0 | 8 | 0 | 122 | 149 | 310 | 337 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0178600 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 24932762 | 24932762 | PRJNA715462_P_NODE_52900_length_250_cov_0.870056_g52104_i0 | PRJNA715462 | 52900 | 250 | 0.870056 | 2.17514 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 113 | 1.02e-20 | NTclustered | gi|29467009|dbj|AB071181.1| | 6211 | g52104 | i0 | 84.348 | 3.116 | 115 | 18 | 46 | 0 | 135 | 249 | 262 | 148 | Echinococcus multilocularis EmDLC mRNA for dynein light chain, complete cds | blastn | 779 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis |
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);;