RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA520845" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA520845 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
1764568 1764568 PRJNA520845_P_NODE_18022_length_915_cov_3.694774_g16797_i0 PRJNA520845 18022 915 3.694774 33.8071821 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 154 2.4599999999999995e-32   NTclustered gi|1084312253|ref|XM_018795509.1| 6183 g16797 i0 74.795 3.1912568306010902 365 80 39 9 165 523 3170 2812 Schistosoma mansoni myosin heavy chain, putative partial mRNA blastn 2920 154 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
1764769 1764769 PRJNA520845_P_NODE_188162_length_271_cov_1.555556_g186663_i0 PRJNA520845 188162 271 1.555556 4.21555676 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 193 1.3999999999999998e-44   NTclustered gi|263405579|gb|GU130533.1| 6182 g186663 i0 80.309 5.8450184501845 259 47 95 4 3 259 695 951 Schistosoma japonicum cAMP-dependent protein kinase catalytic subunit mRNA, complete cds blastn 1584 193 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
8145815 8145815 PRJNA520845_P_NODE_71467_length_439_cov_4.803279_g69968_i0 PRJNA520845 71467 439 4.803279 21.08639481 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 732 0   NTclustered gi|68479954|gb|DQ076149.1| 6182 g69968 i0 96.811 1 439 13 100 1 1 439 449 12 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 439 732 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
9416320 9416320 PRJNA520845_P_NODE_13848_length_1049_cov_5.297131_g12773_i0 PRJNA520845 13848 1049 5.297131 55.56690419 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 678 0   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g12773 i0 85.429 17.7397521448999 652 95 62 0 232 883 652 1 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 18609 678 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
9421569 9421569 PRJNA520845_P_NODE_93508_length_384_cov_1.482315_g92009_i0 PRJNA520845 93508 384 1.482315 5.6920896 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 268 3.3399999999999995e-67   NTclustered gi|393793983|dbj|AK388580.1| 6161 g92009 i0 80.501 86.1328125 359 62 92 8 7 361 646 1000 Dugesia japonica cDNA, clone: Dj_aH_000_00053HN.full, full-insert sequence, expressed in adult head blastn 33075 268 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
10695747 10695747 PRJNA520845_P_NODE_34369_length_647_cov_3.101045_g32915_i0 PRJNA520845 34369 647 3.101045 20.06376115 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 357 1.22e-93   NTclustered gi|1929250148|gb|MT664960.1| 79327 g32915 i0 83.163 55.9010819165379 392 64 60 2 1 391 504 894 Schmidtea mediterranea protein phosphatase 1 catalytic subunit alpha (PPP1CA) mRNA, complete cds blastn 36168 357 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
11967701 11967701 PRJNA520845_P_NODE_167030_length_288_cov_1.265116_g165531_i0 PRJNA520845 167030 288 1.265116 3.64353408 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|687158087|emb|LN016860.1| 99802 g165531 i0 96.97 0.25 33 1 11 0 22 54 1705 1737 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0016622 blastn 72 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
13246343 13246343 PRJNA520845_P_NODE_58011_length_490_cov_1.107914_g56516_i0 PRJNA520845 58011 490 1.107914 5.4287786 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 346 1.96e-90   NTclustered gi|62199102|gb|AY967472.1| 79327 g56516 i0 84.84 67.5081632653061 343 48 70 4 1 341 437 97 Schmidtea mediterranea clone HE.1.01H mRNA sequence blastn 33079 346 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
15793728 15793728 PRJNA520845_P_NODE_245833_length_245_cov_0.895349_g244334_i0 PRJNA520845 245833 245 0.895349 2.19360505 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|39939245|gb|AY395038.1| 6183 g244334 i0 100 0.938775510204082 30 0 12 0 13 42 339 368 Schistosoma mansoni thyroid hormone receptor alpha mRNA, complete cds blastn 230 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
20891587 20891587 PRJNA520845_P_NODE_187337_length_272_cov_1.160804_g185838_i0 PRJNA520845 187337 272 1.160804 3.15738688 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 285 2.26e-72   NTclustered gi|1842149|dbj|AB001051.1| 6161 g185838 i0 85.609 90.4742647058823 271 39 99 0 1 271 362 92 Dugesia japonica mRNA for ADP-ribosylation factor, complete cds blastn 24609 285 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
23439688 23439688 PRJNA520845_P_NODE_10479_length_1209_cov_16.937500_g9548_i0 PRJNA520845 10479 1209 16.9375 204.774375 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 1857 0   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g9548 i0 99.607 17.583953680727902 1018 2 84 1 192 1209 1 1016 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 21259 1857 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
23442386 23442386 PRJNA520845_P_NODE_203619_length_259_cov_0.989247_g202120_i0 PRJNA520845 203619 259 0.989247 2.56214973 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 104 6.42e-18   NTclustered gi|1084299418|ref|XM_018797796.1| 6183 g202120 i0 79.355 0.598455598455598 155 26 59 6 6 157 174 325 Schistosoma mansoni putative cortactin partial mRNA blastn 155 104 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;