contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1249042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1629120 | 1629120 | PRJNA1249042_S_NODE_25902_length_249_cov_458.820388_g25688_i0 | PRJNA1249042 | 25902 | 249 | 458.820388 | 1142.46276612 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 363 | 9.169999999999997e-96 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g25688 | i0 | 95.982 | 97.4819277108434 | 224 | 7 | 90 | 2 | 1 | 223 | 1909 | 1687 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 24273 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 2905532 | 2905532 | PRJNA1249042_S_NODE_7723_length_330_cov_2.745645_g7509_i0 | PRJNA1249042 | 7723 | 330 | 2.745645 | 9.0606285 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 571 | 1.9299999999999998e-158 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g7509 | i0 | 97.879 | 15.269696969697 | 330 | 7 | 100 | 0 | 1 | 330 | 371 | 42 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 5039 | 571 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5457813 | 5457813 | PRJNA1249042_S_NODE_32745_length_236_cov_2.191710_g32531_i0 | PRJNA1249042 | 32745 | 236 | 2.19171 | 5.1724356 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|1240504568|gb|MF667538.1| | 6161 | g32531 | i0 | 100 | 0.122881355932203 | 29 | 0 | 12 | 0 | 4 | 32 | 1 | 29 | Dugesia japonica 14-3-3 epsilon mRNA, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 6731913 | 6731913 | PRJNA1249042_S_NODE_102166_length_160_cov_1.205128_g101952_i0 | PRJNA1249042 | 102166 | 160 | 1.205128 | 1.9282048 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 291 | 2.5799999999999998e-74 | NTclustered | gi|20147784|gb|AF495883.1| | 6182 | g101952 | i0 | 99.375 | 25.03125 | 160 | 1 | 100 | 0 | 1 | 160 | 2095 | 1936 | Schistosoma japonicum CA1 protein mRNA, complete cds | blastn | 4005 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6732147 | 6732147 | PRJNA1249042_S_NODE_30746_length_240_cov_1.604061_g30532_i0 | PRJNA1249042 | 30746 | 240 | 1.604061 | 3.8497464 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g30532 | i0 | 100 | 0.120833333333333 | 29 | 0 | 12 | 0 | 96 | 124 | 5361 | 5389 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 6732643 | 6732643 | PRJNA1249042_S_NODE_92486_length_167_cov_1.895161_g92272_i0 | PRJNA1249042 | 92486 | 167 | 1.895161 | 3.16491887 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 309 | 7.53e-80 | NTclustered | gi|60695574|gb|AY915570.1| | 6182 | g92272 | i0 | 100 | 26.3652694610778 | 167 | 0 | 100 | 0 | 1 | 167 | 369 | 203 | Schistosoma japonicum SJCHGC07705 protein mRNA, partial cds | blastn | 4403 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 8007734 | 8007734 | PRJNA1249042_S_NODE_26347_length_248_cov_395.195122_g26133_i0 | PRJNA1249042 | 26347 | 248 | 395.195122 | 980.08390256 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 361 | 3.2799999999999995e-95 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g26133 | i0 | 95.964 | 97.7096774193548 | 223 | 8 | 90 | 1 | 27 | 248 | 1687 | 1909 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 24232 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 8007905 | 8007905 | PRJNA1249042_S_NODE_47867_length_213_cov_1.382353_g47653_i0 | PRJNA1249042 | 47867 | 213 | 1.382353 | 2.94441189 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 93.5 | 1.1e-14 | NTclustered | gi|60597479|gb|AY809400.1| | 6182 | g47653 | i0 | 100 | 0.234741784037559 | 50 | 0 | 23 | 0 | 160 | 209 | 483 | 434 | Schistosoma japonicum SJCHGC06993 protein mRNA, partial cds | blastn | 50 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9282600 | 9282600 | PRJNA1249042_S_NODE_27808_length_245_cov_739.707921_g27594_i0 | PRJNA1249042 | 27808 | 245 | 739.707921 | 1812.28440645 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 303 | 5.53e-78 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g27594 | i0 | 97.727 | 110.163265306122 | 176 | 4 | 100 | 0 | 70 | 245 | 1734 | 1909 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 26990 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9282765 | 9282765 | PRJNA1249042_S_NODE_45748_length_215_cov_16.796512_g45534_i0 | PRJNA1249042 | 45748 | 215 | 16.796512 | 36.1125008 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 355 | 1.29e-93 | NTclustered | gi|60598655|gb|AY809988.1| | 6182 | g45534 | i0 | 100 | 99.1255813953488 | 192 | 0 | 89 | 0 | 1 | 192 | 641 | 450 | Schistosoma japonicum SJCHGC09533 protein mRNA, partial cds | blastn | 21312 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9283071 | 9283071 | PRJNA1249042_S_NODE_83208_length_175_cov_1.666667_g82994_i0 | PRJNA1249042 | 83208 | 175 | 1.666667 | 2.91666725 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 313 | 6.13e-81 | NTclustered | gi|56759033|gb|AY815925.1| | 6182 | g82994 | i0 | 98.857 | 1 | 175 | 2 | 100 | 0 | 1 | 175 | 130 | 304 | Schistosoma japonicum SJCHGC07639 protein mRNA, complete cds | blastn | 175 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9283164 | 9283164 | PRJNA1249042_S_NODE_97488_length_163_cov_1.958333_g97274_i0 | PRJNA1249042 | 97488 | 163 | 1.958333 | 3.19208279 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 296 | 5.68e-76 | NTclustered | gi|60689342|gb|AY915233.1| | 6182 | g97274 | i0 | 99.387 | 46.1656441717791 | 163 | 1 | 100 | 0 | 1 | 163 | 80 | 242 | Schistosoma japonicum SJCHGC03747 protein mRNA, complete cds | blastn | 7525 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14383731 | 14383731 | PRJNA1249042_S_NODE_59332_length_199_cov_1.435897_g59118_i0 | PRJNA1249042 | 59332 | 199 | 1.435897 | 2.85743503 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 340 | 3.2899999999999996e-89 | NTclustered | gi|21260589|gb|AY099355.1| | 6182 | g59118 | i0 | 97.487 | 21.5427135678392 | 199 | 5 | 100 | 0 | 1 | 199 | 150 | 348 | Schistosoma japonicum MF-19 protein mRNA, complete cds | blastn | 4287 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 16931723 | 16931723 | PRJNA1249042_S_NODE_41374_length_222_cov_1.837989_g41160_i0 | PRJNA1249042 | 41374 | 222 | 1.837989 | 4.08033558 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 58.4 | 4.23e-4 | NTclustered | gi|690469750|emb|LN008856.1| | 99802 | g41160 | i0 | 97.059 | 1.02252252252252 | 34 | 1 | 15 | 0 | 148 | 181 | 10218 | 10251 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0008756 | blastn | 227 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 18206541 | 18206541 | PRJNA1249042_S_NODE_83175_length_175_cov_1.780303_g82961_i0 | PRJNA1249042 | 83175 | 175 | 1.780303 | 3.11553025 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.015 | NTclustered | gi|690672304|emb|LN223262.1| | 99802 | g82961 | i0 | 100 | 0.32 | 28 | 0 | 16 | 0 | 114 | 141 | 384 | 411 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0183650 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 19480299 | 19480299 | PRJNA1249042_S_NODE_13696_length_287_cov_2.905738_g13482_i0 | PRJNA1249042 | 13696 | 287 | 2.905738 | 8.33946806 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 63.9 | 1.23e-5 | NTclustered | gi|56753506|gb|AY813225.1| | 6182 | g13482 | i0 | 100 | 12.8641114982578 | 34 | 0 | 12 | 0 | 233 | 266 | 126 | 159 | Schistosoma japonicum SJCHGC06004 protein mRNA, complete cds | blastn | 3692 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 22030938 | 22030938 | PRJNA1249042_S_NODE_117238_length_150_cov_1.757009_g117024_i0 | PRJNA1249042 | 117238 | 150 | 1.757009 | 2.6355135 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 62.1 | 2.03e-5 | NTclustered | gi|690535542|emb|LN086890.1| | 99802 | g117024 | i0 | 100 | 0.866666666666667 | 33 | 0 | 22 | 0 | 57 | 89 | 1742 | 1774 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0083034 | blastn | 130 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 23307065 | 23307065 | PRJNA1249042_S_NODE_69799_length_187_cov_5.423611_g69585_i0 | PRJNA1249042 | 69799 | 187 | 5.423611 | 10.14215257 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 318 | 1.43e-82 | NTclustered | gi|60599244|gb|AY810282.1| | 6182 | g69585 | i0 | 97.326 | 9.81818181818182 | 187 | 5 | 100 | 0 | 1 | 187 | 125 | 311 | Schistosoma japonicum SJCHGC09564 protein mRNA, partial cds | blastn | 1836 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23307235 | 23307235 | PRJNA1249042_S_NODE_93039_length_166_cov_1581.650407_g92825_i0 | PRJNA1249042 | 93039 | 166 | 1581.650407 | 2625.53967562 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 302 | 1.2500000000000001e-77 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g92825 | i0 | 99.398 | 126.957831325301 | 166 | 1 | 100 | 0 | 1 | 166 | 1909 | 1744 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 21075 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 24581270 | 24581270 | PRJNA1249042_S_NODE_93040_length_166_cov_825.390244_g92826_i0 | PRJNA1249042 | 93040 | 166 | 825.390244 | 1370.14780504 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 279 | 5.86e-71 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g92826 | i0 | 96.988 | 126.807228915663 | 166 | 5 | 100 | 0 | 1 | 166 | 1909 | 1744 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 21050 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;