contig_metadata
6 rows where bioproject = "PRJNA1123686" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1555469 | 1555469 | PRJNA1123686_S_NODE_12002_length_179_cov_13.553333_g11970_i0 | PRJNA1123686 | 12002 | 179 | 13.553333 | 24.26046607 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 60.2 | 9.06e-5 | NTclustered | gi|1084296408|ref|XM_018799522.1| | 6183 | g11970 | i0 | 100 | 1.46927374301676 | 32 | 0 | 18 | 0 | 148 | 179 | 1635 | 1666 | Schistosoma mansoni putative slingshot dual specificity phosphatase partial mRNA | blastn | 263 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 8683252 | 8683252 | PRJNA1123686_S_NODE_5947_length_219_cov_26.421053_g5915_i0 | PRJNA1123686 | 5947 | 219 | 26.421053 | 57.86210607 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|2318764958|ref|XM_051218950.1| | 6185 | g5915 | i0 | 100 | 0.525114155251142 | 28 | 0 | 13 | 0 | 5 | 32 | 1054 | 1027 | Schistosoma haematobium uncharacterized protein (MS3_00010575), mRNA | blastn | 115 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 13034617 | 13034617 | PRJNA1123686_S_NODE_5511_length_224_cov_8.917949_g5479_i0 | PRJNA1123686 | 5511 | 224 | 8.917949 | 19.97620576 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 409 | 1.03e-109 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g5479 | i0 | 99.554 | 13.0848214285714 | 224 | 1 | 100 | 0 | 1 | 224 | 8980 | 8757 | Stenostomum sthenum mitochondrion, complete genome | blastn | 2931 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 27596649 | 27596649 | PRJNA1123686_S_NODE_11584_length_181_cov_13.855263_g11552_i0 | PRJNA1123686 | 11584 | 181 | 13.855263 | 25.07802603 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 50.4 | 3.19e-6 | NR | KAH9283247.1 | 6210 | g11552 | i0 | 78.6 | 1.95580110497238 | 28 | 6 | 46.4 | 0 | 179 | 96 | 61 | 88 | KAH9283247.1 Protein transport protein Sec61 subunit beta [Echinococcus granulosus] | diamond | 354 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28333521 | 28333521 | PRJNA1123686_S_NODE_15026_length_168_cov_2.395683_g14994_i0 | PRJNA1123686 | 15026 | 168 | 2.395683 | 4.02474744 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 41.2 | 0.049 | NR | VDL99704.1 | 70667 | g14994 | i0 | 56.8 | 0.785714285714286 | 44 | 19 | 78.6 | 0 | 1 | 132 | 358 | 401 | VDL99704.1 unnamed protein product [Schistocephalus solidus] | diamond | 132 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 31418198 | 31418198 | PRJNA1123686_S_NODE_11836_length_180_cov_8.774834_g11804_i0 | PRJNA1123686 | 11836 | 180 | 8.774834 | 15.7947012 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 47.4 | 5.16e-5 | NR | KAH9283247.1 | 6210 | g11804 | i0 | 75 | 1.96666666666667 | 28 | 7 | 46.7 | 0 | 3 | 86 | 61 | 88 | KAH9283247.1 Protein transport protein Sec61 subunit beta [Echinococcus granulosus] | diamond | 354 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus |
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);;