contig_metadata
18 rows where bioproject = "PRJNA643700", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168957 | 3168957 | PRJNA643700_P_NODE_280783_length_220_cov_1.824561_g279227_i0 | PRJNA643700 | 280783 | 220 | 1.824561 | 4.0140342 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 54.7 | 0.005 | NTclustered | gi|2318762208|ref|XM_012942153.2| | 6185 | g279227 | i0 | 100 | 0.131818181818182 | 29 | 0 | 13 | 0 | 59 | 87 | 509 | 481 | Schistosoma haematobium Neuronal acetylcholine receptor subunit alpha-2 (CHRNA2_6), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 4445736 | 4445736 | PRJNA643700_P_NODE_146164_length_338_cov_1.325260_g144609_i0 | PRJNA643700 | 146164 | 338 | 1.32526 | 4.4793788 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.032 | NTclustered | gi|690674268|emb|LN225907.1| | 99802 | g144609 | i0 | 100 | 0.0828402366863905 | 28 | 0 | 8 | 0 | 145 | 172 | 509 | 482 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0040870 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 6262466 | 6262466 | PRJNA643700_P_NODE_426505_length_162_cov_0.920354_g424949_i0 | PRJNA643700 | 426505 | 162 | 0.920354 | 1.49097348 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 300 | 4.36e-77 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g424949 | i0 | 100 | 100 | 162 | 0 | 100 | 0 | 1 | 162 | 201 | 362 | Schistosoma japonicum unknown mRNA | blastn | 16200 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 7536673 | 7536673 | PRJNA643700_P_NODE_99786_length_418_cov_1.184282_g98233_i0 | PRJNA643700 | 99786 | 418 | 1.184282 | 4.95029876 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 8.65e-4 | NTclustered | gi|690519347|emb|LN070435.1| | 99802 | g98233 | i0 | 89.13 | 5.73205741626794 | 46 | 5 | 11 | 0 | 201 | 246 | 1970 | 2015 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0067927 | blastn | 2396 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 10822264 | 10822264 | PRJNA643700_P_NODE_118549_length_380_cov_3.888218_g116994_i0 | PRJNA643700 | 118549 | 380 | 3.888218 | 14.7752284 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.036 | NTclustered | gi|687312678|emb|LK534398.1| | 57078 | g116994 | i0 | 100 | 0.0736842105263158 | 28 | 0 | 7 | 0 | 167 | 194 | 927 | 900 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0132908 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 12097531 | 12097531 | PRJNA643700_P_NODE_221050_length_260_cov_4.682464_g219494_i0 | PRJNA643700 | 221050 | 260 | 4.682464 | 12.1744064 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 52.8 | 0.024 | NTclustered | gi|2318758607|ref|XM_051209130.1| | 6185 | g219494 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 218 | 245 | 1911 | 1884 | Schistosoma haematobium uncharacterized protein (MS3_00001660), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 13372287 | 13372287 | PRJNA643700_P_NODE_391671_length_168_cov_1.310924_g390115_i0 | PRJNA643700 | 391671 | 168 | 1.310924 | 2.20235232 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|690573906|emb|LN122752.1| | 99802 | g390115 | i0 | 100 | 0.172619047619048 | 29 | 0 | 17 | 0 | 90 | 118 | 2912 | 2940 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0114302 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 14646988 | 14646988 | PRJNA643700_P_NODE_193232_length_285_cov_0.961864_g191676_i0 | PRJNA643700 | 193232 | 285 | 0.961864 | 2.7413124 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|687557375|emb|LK635155.1| | 57078 | g191676 | i0 | 100 | 0.101754385964912 | 29 | 0 | 10 | 0 | 221 | 249 | 771 | 743 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0219612 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 14647001 | 14647001 | PRJNA643700_P_NODE_209692_length_270_cov_1.411765_g208136_i0 | PRJNA643700 | 209692 | 270 | 1.411765 | 3.8117655 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|690549337|emb|LN102989.1| | 99802 | g208136 | i0 | 100 | 0.837037037037037 | 30 | 0 | 11 | 0 | 206 | 235 | 3295 | 3324 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0097379 | blastn | 226 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 14647127 | 14647127 | PRJNA643700_P_NODE_369652_length_176_cov_1.637795_g368096_i0 | PRJNA643700 | 369652 | 176 | 1.637795 | 2.8825192 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 56.5 | 0.001 | NTclustered | gi|2318773809|ref|XM_051217792.1| | 6185 | g368096 | i0 | 96.97 | 0.505681818181818 | 33 | 1 | 19 | 0 | 117 | 149 | 2974 | 3006 | Schistosoma haematobium uncharacterized protein (MS3_00009423), mRNA | blastn | 89 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 15920988 | 15920988 | PRJNA643700_P_NODE_258373_length_234_cov_1.378378_g256817_i0 | PRJNA643700 | 258373 | 234 | 1.378378 | 3.22540452 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 52.8 | 0.021 | NTclustered | gi|164510874|emb|AM293349.1| | 6161 | g256817 | i0 | 94.118 | 0.145299145299145 | 34 | 2 | 15 | 0 | 96 | 129 | 269 | 302 | Dugesia japonica mRNA for msh2 protein | blastn | 34 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 18470504 | 18470504 | PRJNA643700_P_NODE_390215_length_168_cov_2.621849_g388659_i0 | PRJNA643700 | 390215 | 168 | 2.621849 | 4.40470632 | Liliatrema skrjabini | 2725056 | Platyhelminthes | Platyhelminthes | 267 | 4.63e-67 | NTclustered | gi|1829007491|gb|MT303945.1| | 2725056 | g388659 | i0 | 95.238 | 96.1666666666667 | 168 | 8 | 100 | 0 | 1 | 168 | 2287 | 2120 | Liliatrema skrjabini voucher L13_2 large subunit ribosomal RNA gene, partial sequence | blastn | 16156 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Liliatrematidae | Liliatrema | Liliatrema skrjabini | |
| 19745046 | 19745046 | PRJNA643700_P_NODE_344016_length_188_cov_1.496403_g342460_i0 | PRJNA643700 | 344016 | 188 | 1.496403 | 2.81323764 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.001 | NTclustered | gi|687159675|emb|LN023398.1| | 99802 | g342460 | i0 | 100 | 0.159574468085106 | 30 | 0 | 16 | 0 | 42 | 71 | 8609 | 8638 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0022994 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 22295421 | 22295421 | PRJNA643700_P_NODE_70338_length_499_cov_2.322222_g68805_i0 | PRJNA643700 | 70338 | 499 | 2.322222 | 11.58788778 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 54.7 | 0.014 | NTclustered | gi|1988312818|tpg|BK014290.1| | 79327 | g68805 | i0 | 100 | 0.226452905811623 | 29 | 0 | 6 | 0 | 119 | 147 | 2932 | 2904 | TPA_exp: Schmidtea mediterranea strain S2 lipoprotein receptor 5/6 gene, complete cds | blastn | 113 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 23570925 | 23570925 | PRJNA643700_P_NODE_36279_length_675_cov_2.408946_g34959_i0 | PRJNA643700 | 36279 | 675 | 2.408946 | 16.2603855 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 69.4 | 6.68e-7 | NTclustered | gi|687155214|emb|LN004749.1| | 99802 | g34959 | i0 | 95.349 | 0.21481481481481501 | 43 | 2 | 6 | 0 | 480 | 522 | 10872 | 10914 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0004705 | blastn | 145 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27618494 | 27618494 | PRJNA643700_P_NODE_350444_length_185_cov_1.529412_g348888_i0 | PRJNA643700 | 350444 | 185 | 1.529412 | 2.8294122 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 41.6 | 0.044 | NR | VDM04734.1 | 70667 | g348888 | i0 | 60 | 0.405405405405405 | 25 | 10 | 40.5 | 0 | 139 | 65 | 219 | 243 | VDM04734.1 unnamed protein product, partial [Schistocephalus solidus] | diamond | 75 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 30334451 | 30334451 | PRJNA643700_P_NODE_226552_length_256_cov_2.072464_g224996_i0 | PRJNA643700 | 226552 | 256 | 2.072464 | 5.30550784 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 47 | 1.52e-4 | NR | AAM80477.1 | 6182 | g224996 | i0 | 56.5 | 0.5390625 | 46 | 11 | 43.4 | 1 | 222 | 112 | 34 | 79 | AAM80477.1 Hm1 protein [Schistosoma japonicum] | diamond | 138 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32893709 | 32893709 | PRJNA643700_P_NODE_81280_length_464_cov_3.233735_g79734_i0 | PRJNA643700 | 81280 | 464 | 3.233735 | 15.0045304 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 57.8 | 1.36e-6 | NR | VZH90273.1 | 99802 | g79734 | i0 | 46 | 1.33836206896552 | 50 | 27 | 32.3 | 0 | 211 | 360 | 201 | 250 | VZH90273.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 621 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;