RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA376117" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA376117 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
5503387 5503387 PRJNA376117_P_NODE_2385_length_958_cov_20.601130_g2135_i0 PRJNA376117 2385 958 20.60113 197.3588254 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1480 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g2135 i0 94.931 22.6597077244259 947 44 99 4 7 951 8984 8040 Stenostomum sthenum mitochondrion, complete genome blastn 21708 1480 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
7451520 7451520 PRJNA376117_P_NODE_14866_length_355_cov_2.063830_g14564_i0 PRJNA376117 14866 355 2.06383 7.3265965 Metazoa 33208 Platyhelminthes Platyhelminthes 656 0   NTclustered gi|60687563|gb|AY914894.1| 6182 g14564 i0 100 100 355 0 100 0 1 355 40 394 Schistosoma japonicum unknown mRNA blastn 35500 656 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
11878811 11878811 PRJNA376117_P_NODE_4190_length_672_cov_4.420701_g3902_i0 PRJNA376117 4190 672 4.420701 29.70711072 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 459 3.3799999999999996e-124   NTclustered gi|226478901|emb|FN317215.1| 6182 g3902 i0 81.416 50.6964285714286 565 101 84 3 17 579 620 58 Schistosoma japonicum isolate Anhui full length mRNA clone SJFCE0797|FSE_080_96_H12, complete sequence blastn 34068 459 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
16376086 16376086 PRJNA376117_P_NODE_16653_length_337_cov_2.041667_g16351_i0 PRJNA376117 16653 337 2.041667 6.88041779 Metazoa 33208 Platyhelminthes Platyhelminthes 303 7.95e-78   NTclustered gi|58197522|dbj|AB200392.1| 6161 g16351 i0 85.517 45.9940652818991 290 42 86 0 2 291 332 43 Dugesia japonica CaM mRNA for calmodulin, complete cds blastn 15500 303 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
23351734 23351734 PRJNA376117_P_NODE_21759_length_296_cov_1.896861_g21457_i0 PRJNA376117 21759 296 1.896861 5.61470856 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 289 1.9199999999999996e-73   NTclustered gi|393794039|dbj|AK388636.1| 6161 g21457 i0 84.775 96.5675675675676 289 42 97 2 9 296 1023 736 Dugesia japonica cDNA, clone: Dj_aH_000_00546HH.full, full-insert sequence, expressed in adult head blastn 28584 289 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
23352048 23352048 PRJNA376117_P_NODE_4119_length_680_cov_2.848435_g3831_i0 PRJNA376117 4119 680 2.848435 19.369358 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 977 0   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g3831 i0 94.219 20.7470588235294 640 37 94 0 41 680 1 640 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 14108 977 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
23352139 23352139 PRJNA376117_P_NODE_7739_length_481_cov_2.840686_g7438_i0 PRJNA376117 7739 481 2.840686 13.66369966 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 375 2.4499999999999997e-99   NTclustered gi|21308066|gb|AY067433.1| 79327 g7438 i0 83.838 75.1829521829522 396 62 82 2 87 481 1 395 Schmidtea mediterranea unknown mRNA sequence blastn 36163 375 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
24626031 24626031 PRJNA376117_P_NODE_22220_length_293_cov_1.395455_g21918_i0 PRJNA376117 22220 293 1.395455 4.08868315 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 246 1.16e-60   NTclustered gi|1929250148|gb|MT664960.1| 79327 g21918 i0 83.212 6.86348122866894 274 40 92 5 22 292 76 346 Schmidtea mediterranea protein phosphatase 1 catalytic subunit alpha (PPP1CA) mRNA, complete cds blastn 2011 246 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea

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