contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1947557 | 1947557 | PRJNA690592_S_NODE_214922_length_241_cov_1.119048_g213908_i0 | PRJNA690592 | 214922 | 241 | 1.119048 | 2.69690568 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|690525644|emb|LN077112.1| | 99802 | g213908 | i0 | 100 | 0.377593360995851 | 28 | 0 | 12 | 0 | 85 | 112 | 3281 | 3254 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0074116 | blastn | 91 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5007281 | 5007281 | PRJNA690592_S_NODE_146744_length_279_cov_4.616505_g145730_i0 | PRJNA690592 | 146744 | 279 | 4.616505 | 12.88004895 | Aporocotylidae | 45375 | Platyhelminthes | Platyhelminthes | 132 | 3.21e-26 | NTclustered | gi|138752562|emb|AM489593.1| | 421533 | g145730 | i0 | 84.559 | 12.2903225806452 | 136 | 18 | 48 | 3 | 147 | 279 | 1434 | 1569 | Paradeontacylix ibericus partial 28S rRNA gene | blastn | 3429 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Aporocotylidae | Paradeontacylix | Paradeontacylix iberica | |
| 12149977 | 12149977 | PRJNA690592_S_NODE_101070_length_326_cov_1.636364_g100056_i0 | PRJNA690592 | 101070 | 326 | 1.636364 | 5.33454664 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|687733078|emb|LK475270.1| | 57078 | g100056 | i0 | 90.909 | 0.659509202453988 | 44 | 1 | 13 | 2 | 120 | 161 | 1340 | 1382 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0078369 | blastn | 215 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 12150163 | 12150163 | PRJNA690592_S_NODE_127170_length_297_cov_1.415179_g126156_i0 | PRJNA690592 | 127170 | 297 | 1.415179 | 4.20308163 | Taenia crassiceps | 6207 | Platyhelminthes | Platyhelminthes | 217 | 9.25e-52 | NTclustered | gi|1352278505|gb|MG516807.1| | 6207 | g126156 | i0 | 80.137 | 18.037037037037 | 292 | 56 | 98 | 2 | 1 | 291 | 257 | 547 | Taenia crassiceps enolase A (ENO1) mRNA, complete cds | blastn | 5357 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia crassiceps | |
| 14699639 | 14699639 | PRJNA690592_S_NODE_103972_length_322_cov_11.421687_g102958_i0 | PRJNA690592 | 103972 | 322 | 11.421687 | 36.77783214 | Notocaryoplana arctica | 993670 | Platyhelminthes | Platyhelminthes | 137 | 8.11e-28 | NTclustered | gi|588313911|gb|KC869869.1| | 993670 | g102958 | i0 | 80 | 2.23291925465838 | 190 | 34 | 58 | 4 | 1 | 188 | 1299 | 1486 | Notocaryoplana arctica 28S ribosomal RNA gene, partial sequence | blastn | 719 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Otoplanidae | Notocaryoplana | Notocaryoplana arctica | |
| 14700730 | 14700730 | PRJNA690592_S_NODE_48172_length_446_cov_65.686327_g47158_i0 | PRJNA690592 | 48172 | 446 | 65.686327 | 292.96101842 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 739 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g47158 | i0 | 97.045 | 0.986547085201794 | 440 | 12 | 99 | 1 | 7 | 446 | 450 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 440 | 739 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 15207665 | 15207665 | PRJNA690592_S_NODE_48952_length_443_cov_2.608108_g47938_i0 | PRJNA690592 | 48952 | 443 | 2.608108 | 11.55391844 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 93.5 | 2.52e-14 | NTclustered | gi|226473453|emb|FN315680.1| | 6182 | g47938 | i0 | 79.688 | 20.079006772009 | 128 | 26 | 29 | 0 | 49 | 176 | 384 | 511 | Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA3765.001|FSA001-P00033-I07, complete sequence | blastn | 8895 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 15973941 | 15973941 | PRJNA690592_S_NODE_175373_length_258_cov_1.248649_g174359_i0 | PRJNA690592 | 175373 | 258 | 1.248649 | 3.22151442 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 475 | 1.1799999999999999e-129 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g174359 | i0 | 100 | 4.50387596899225 | 257 | 0 | 99 | 0 | 1 | 257 | 482 | 738 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 1162 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 17248837 | 17248837 | PRJNA690592_S_NODE_140774_length_285_cov_0.900943_g139760_i0 | PRJNA690592 | 140774 | 285 | 0.900943 | 2.56768755 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 84.2 | 9.34e-12 | NTclustered | gi|690841701|emb|LN339654.1| | 99802 | g139760 | i0 | 92.982 | 0.578947368421053 | 57 | 4 | 20 | 0 | 229 | 285 | 526 | 582 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0226237 | blastn | 165 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 18523276 | 18523276 | PRJNA690592_S_NODE_183855_length_252_cov_1.480447_g182841_i0 | PRJNA690592 | 183855 | 252 | 1.480447 | 3.73072644 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 76.8 | 1.36e-9 | NTclustered | gi|1886141353|ref|XM_012936883.2| | 6185 | g182841 | i0 | 76.129 | 0.78968253968254 | 155 | 31 | 60 | 5 | 23 | 174 | 725 | 574 | Schistosoma haematobium 40S ribosomal protein S16 (RPS16), partial mRNA | blastn | 199 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 21074559 | 21074559 | PRJNA690592_S_NODE_89577_length_342_cov_2.208178_g88563_i0 | PRJNA690592 | 89577 | 342 | 2.208178 | 7.55196876 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.009 | NTclustered | gi|690613586|emb|LN169179.1| | 99802 | g88563 | i0 | 96.875 | 0.0935672514619883 | 32 | 1 | 9 | 0 | 220 | 251 | 1667 | 1636 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0150219 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 22349174 | 22349174 | PRJNA690592_S_NODE_54798_length_422_cov_2.865330_g53784_i0 | PRJNA690592 | 54798 | 422 | 2.86533 | 12.0916926 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 215 | 4.9e-51 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g53784 | i0 | 78.698 | 0.800947867298578 | 338 | 60 | 79 | 11 | 57 | 388 | 69 | 400 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 338 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 22856343 | 22856343 | PRJNA690592_S_NODE_164298_length_266_cov_1.196891_g163284_i0 | PRJNA690592 | 164298 | 266 | 1.196891 | 3.18373006 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|687669718|emb|LK621642.1| | 57078 | g163284 | i0 | 100 | 0.466165413533835 | 29 | 0 | 11 | 0 | 83 | 111 | 502 | 530 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0020436 | blastn | 124 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 22856416 | 22856416 | PRJNA690592_S_NODE_28818_length_562_cov_3.077710_g27820_i0 | PRJNA690592 | 28818 | 562 | 3.07771 | 17.2967302 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 65.8 | 7.11e-6 | NTclustered | gi|28273264|gb|AY157152.1| | 104925 | g27820 | i0 | 76.154 | 0.706405693950178 | 130 | 28 | 23 | 2 | 433 | 561 | 2440 | 2567 | Catenula sp. Lake Madgwick 28S large subunit ribosomal RNA gene, partial sequence | blastn | 397 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Catenulidae | Catenula | Catenula sp. Lake Madgwick | |||
| 23623882 | 23623882 | PRJNA690592_S_NODE_159299_length_269_cov_5.198980_g158285_i0 | PRJNA690592 | 159299 | 269 | 5.19898 | 13.9852562 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 111 | 4.01e-20 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g158285 | i0 | 80.556 | 8.07806691449814 | 144 | 28 | 54 | 0 | 126 | 269 | 652 | 509 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 2173 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 24897796 | 24897796 | PRJNA690592_S_NODE_215960_length_241_cov_0.916667_g214946_i0 | PRJNA690592 | 215960 | 241 | 0.916667 | 2.20916747 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 62.1 | 3.6e-5 | NTclustered | gi|690588513|emb|LN141137.1| | 99802 | g214946 | i0 | 97.222 | 0.406639004149378 | 36 | 1 | 15 | 0 | 161 | 196 | 1144 | 1109 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0129251 | blastn | 98 | 62.1 | 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);;