SQLShare Intro

sr320 edited this page Jan 6, 2014 · 2 revisions

This is the website https://sqlshare.escience.washington.edu


SQLShare_187B106E.png

All you need to log on is a UW Id or Google Account.

Once you log in the main UIs include


SQLShare_and_README.md_and_SQLShare_187B110A.png
Upload_File_187B115D.png
Upload_File_187B1184.png

In short, SQLShare is a easy way to manipulate tabular data, including (but not limited to)

  • selecting data subsets
  • joining tables
  • performing arithmatic
  • reorganizing tabular data

### Here is a straight-forward example of joining two tables. A BLAST output table will be joined with gene descriptions.

Table 1 is a BLAST output tablular file uploaded using wizard shown above. https://sqlshare.escience.washington.edu/sqlshare/#s=query/wearh%40washington.edu/Oly_Blast_uniprot_swissprot.txt


SQLShare_-_View_Query_187B13C2.png
SQLShare_-_View_Query_and_SQLShare_187B14E1.png
SQLShare_-_View_Query_187B18DE.png
This can also be done in New Query UI Run_Query_187B1988.png And from here you can Save or simply download the joined table.

Explanation of code

SELECT *    
FROM     
[wearh@washington.edu].[Oly_Blast_uniprot_swissprot.txt]blast   
Left Join 
[samwhite@washington.edu].[UniprotProtNamesReviewed_yes20130610]unp 
on
blast.Column3 = unp.SPID​
Run_Query_187B1B37.png
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.