contig_metadata
9 rows where bioproject = "PRJDB12578" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2553896 | 2553896 | PRJDB12578_S_NODE_198503_length_167_cov_1.161017_g175445_i0 | PRJDB12578 | 198503 | 167 | 1.161017 | 1.93889839 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 119 | 1.36e-22 | NTclustered | gi|687353142|emb|LK780258.1| | 57078 | g175445 | i0 | 97.143 | 13.125748502994 | 70 | 2 | 42 | 0 | 1 | 70 | 234 | 165 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0040174 | blastn | 2192 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 6083985 | 6083985 | PRJDB12578_S_NODE_186545_length_173_cov_1.661290_g163487_i0 | PRJDB12578 | 186545 | 173 | 1.66129 | 2.8740317 | Cestoda | 6199 | Platyhelminthes | Platyhelminthes | 84.2 | 5.15e-12 | NTclustered | gi|223670572|gb|FJ177099.1| | 595947 | g163487 | i0 | 96.154 | 28.4335260115607 | 52 | 1 | 30 | 1 | 106 | 157 | 1116 | 1066 | Anthocephalum cf. centrurum LRP4219 voucher LRP4219 (TE141) 28S ribosomal RNA gene, partial sequence | blastn | 4919 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Rhinebothriidea | Anthocephaliidae | Anthocephalum | Anthocephalum cf. centrurum LRP4219 | |
| 6381837 | 6381837 | PRJDB12578_S_NODE_184986_length_174_cov_1.656000_g161928_i0 | PRJDB12578 | 184986 | 174 | 1.656 | 2.88144 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.015 | NTclustered | gi|690516513|emb|LN067297.1| | 99802 | g161928 | i0 | 100 | 0.160919540229885 | 28 | 0 | 16 | 0 | 108 | 135 | 4774 | 4801 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0064998 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 7660672 | 7660672 | PRJDB12578_S_NODE_96447_length_304_cov_2.035294_g73389_i0 | PRJDB12578 | 96447 | 304 | 2.035294 | 6.18729376 | Trichobilharzia szidati | 157070 | Platyhelminthes | Platyhelminthes | 157 | 5.939999999999999e-43 | NR | CAH8858410.1 | 157070 | g73389 | i0 | 72.7 | 6.83881578947368 | 99 | 27 | 97.7 | 0 | 6 | 302 | 148 | 246 | CAH8858410.1 unnamed protein product [Trichobilharzia szidati] | diamond | 2079 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 11481357 | 11481357 | PRJDB12578_S_NODE_181950_length_176_cov_2.031496_g158892_i0 | PRJDB12578 | 181950 | 176 | 2.031496 | 3.57543296 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 52.8 | 0.015 | NTclustered | gi|226473727|emb|FN315817.1| | 6182 | g158892 | i0 | 96.875 | 0.727272727272727 | 32 | 0 | 18 | 1 | 92 | 122 | 1290 | 1321 | Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA3790.006|FSA001-P00026-I05, complete sequence | blastn | 128 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14032750 | 14032750 | PRJDB12578_S_NODE_218252_length_152_cov_2.145631_g195194_i0 | PRJDB12578 | 218252 | 152 | 2.145631 | 3.26135912 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 180 | 5.46e-41 | NTclustered | gi|687264096|emb|LK414130.1| | 57078 | g195194 | i0 | 88.235 | 12.2236842105263 | 153 | 14 | 99 | 4 | 2 | 152 | 1430 | 1280 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0020433 | blastn | 1858 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 17855840 | 17855840 | PRJDB12578_S_NODE_196635_length_168_cov_0.865546_g173577_i0 | PRJDB12578 | 196635 | 168 | 0.865546 | 1.45411728 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 135 | 1.3600000000000002e-27 | NTclustered | gi|687239658|emb|LK435610.1| | 57078 | g173577 | i0 | 81.287 | 1.75 | 171 | 29 | 100 | 2 | 1 | 168 | 81 | 251 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0041019 | blastn | 294 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 22959847 | 22959847 | PRJDB12578_S_NODE_85779_length_354_cov_4.354098_g62721_i0 | PRJDB12578 | 85779 | 354 | 4.354098 | 15.41350692 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.003 | NTclustered | gi|690574800|emb|LN124005.1| | 99802 | g62721 | i0 | 94.444 | 0.180790960451977 | 36 | 2 | 10 | 0 | 34 | 69 | 2914 | 2949 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0115363 | blastn | 64 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 26715440 | 26715440 | PRJDB12578_S_NODE_165761_length_189_cov_1.107143_g142703_i0 | PRJDB12578 | 165761 | 189 | 1.107143 | 2.09250027 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 43.5 | 0.00259 | NR | TGZ37688.1 | 147828 | g142703 | i0 | 50 | 0.571428571428571 | 36 | 18 | 57.1 | 0 | 154 | 47 | 51 | 86 | TGZ37688.1 hypothetical protein CRM22_011324 [Opisthorchis felineus] | diamond | 108 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus |
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);;