RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA980585" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA980585 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
4782927 4782927 PRJNA980585_P_NODE_31104_length_277_cov_1.014706_g30850_i0 PRJNA980585 31104 277 1.014706 2.81073562 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 198 3.09e-46   NTclustered gi|1929250148|gb|MT664960.1| 79327 g30850 i0 84.466 4.57761732851986 206 26 73 5 12 214 278 76 Schmidtea mediterranea protein phosphatase 1 catalytic subunit alpha (PPP1CA) mRNA, complete cds blastn 1268 198 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
12433596 12433596 PRJNA980585_P_NODE_13510_length_375_cov_1.264901_g13256_i0 PRJNA980585 13510 375 1.264901 4.74337875 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 571 2.2199999999999993e-158   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g13256 i0 94.133 11.3066666666667 375 22 100 0 1 375 384 10 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 4240 571 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
14982292 14982292 PRJNA980585_P_NODE_13112_length_379_cov_1.509804_g12858_i0 PRJNA980585 13112 379 1.509804 5.72215716 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 54.7 0.01   NTclustered gi|1373855834|ref|XM_024494294.1| 6210 g12858 i0 96.875 0.0844327176781003 32 1 8 0 143 174 3581 3612 Echinococcus granulosus Calcineurin-binding protein cabin-1 (EGR_05045), partial mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
19120774 19120774 PRJNA980585_P_NODE_52815_length_245_cov_0.895349_g52561_i0 PRJNA980585 52815 245 0.895349 2.19360505 Macrostomum 39217 Platyhelminthes Platyhelminthes 91.6 4.69e-14   NTclustered gi|261873767|gb|FJ715332.1| 683731 g52561 i0 82.692 42.2163265306122 104 16 42 2 139 241 246 348 Macrostomum sp. LS 302 voucher MTP LS 302 28S large subunit ribosomal RNA gene, partial sequence blastn 10343 91.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum sp. LS 302
23907758 23907758 PRJNA980585_P_NODE_8799_length_445_cov_62.715054_g8545_i0 PRJNA980585 8799 445 62.715054 279.0819903 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 732 0   NTclustered gi|68479954|gb|DQ076149.1| 6182 g8545 i0 96.811 0.986516853932584 439 13 99 1 2 440 449 12 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 439 732 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum

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