timeout while trying to fetch data

[emmats]

I would like to download my file "all ambiguous peptides" from SQLshare but the download directly from the site didn't seem to be progressing. I tried fetchdata in the sql python tools, but it timed out (see below). Now I can't even access my datasets. Is there something wrong?

Thanks
Emma

Emmas-MacBook-Pro-2:tools Emma$ python fetchdata.py --dataset 'all ambiguous peptides' --format csv --output all_ambiguous_peptides.csv
Traceback (most recent call last):
File "fetchdata.py", line 77, in
main()
File "fetchdata.py", line 71, in main
data = fetchdata(args.sql, args.format, args.output)
File "fetchdata.py", line 29, in fetchdata
conn = sqlshare.SQLShare()
File "build/bdist.macosx-10.5-x86_64/egg/sqlshare/init.py", line 80, in init
File "build/bdist.macosx-10.5-x86_64/egg/sqlshare/init.py", line 280, in get_userinfo
File "build/bdist.macosx-10.5-x86_64/egg/sqlshare/init.py", line 267, in poll_selector
sqlshare.SQLShareError: code: 400 : {"Detail":"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This failure occurred while attempting to connect to the routing destination."}

[shrjain]

Hi Emma,
From what I can see, one of the 2 datasets ([bact detection peptide
replicates]**) you are trying to join is really really big. My guess is
that the results are just too big for the query to finish on time.
One option would be to break the joins in this dataset into multiple
datasets and snapshot the intermediate results so that they don't have to
be computed again. Let me know if this helps.

**[bact detection peptide replicates] is defined as follows:

SELECT * FROM [emmats@washington.edu].[bact detection distinct peptides]
LEFT JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection9
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection9.pep.xls].
[A1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection69.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection69.pep.xls].
[A1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Dectection10.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection10.pep.xls].
[A2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection70.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection70.pep.xls].
[A2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Dectection11.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection11.pep.xls].
[A3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection71.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection71.pep.xls].
[A3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection58
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection58.pep.xls].[A3
.3 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection23.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection23.pep.xls].
[B1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection51.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection51.pep.xls].
[B1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection24.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection24.pep.xls].
[B2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection52.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection52.pep.xls].
[B2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection25.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection25.pep.xls].
[B3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection53.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection53.pep.xls].
[B3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection27.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection27.pep.xls].
[C1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection87_15051208724.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection87_15051208724.pep.xls].[C1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection28.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection28.pep.xls].
[C2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection88_150512103018.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection88_150512103018.pep.xls].[C2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection29.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection29.pep.xls].
[C3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection89_150512121311.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection89_150512121311.pep.xls].[C3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection17.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection17.pep.xls].
[D1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection59.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection59.pep.xls].
[D1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection18.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection18.pep.xls].
[D2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection60.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection60.pep.xls].
[D2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection19.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection19.pep.xls].
[D3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection61.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection61.pep.xls].
[D3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection45.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection45.pep.xls].
[E1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection55.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection55.pep.xls].
[E1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection46.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection46.pep.xls].
[E2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection56.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection56.pep.xls].
[E2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection47.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection47.pep.xls].
[E3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection57.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection57.pep.xls].
[E3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Dectection13.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection13.pep.xls].
[F1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection79.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection79.pep.xls].
[F1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection87.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection87.pep.xls].
[F1.3 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Dectection14.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection14.pep.xls].
[F2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection80.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection80.pep.xls].
[F2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection88.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection88.pep.xls].
[F2.3 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Dectection15.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection15.pep.xls].
[F3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection81.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection81.pep.xls].
[F3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection89.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection89.pep.xls].
[F3.3 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection37.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection37.pep.xls].
[G1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection73.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection73.pep.xls].
[G1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection38.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection38.pep.xls].
[G2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection74.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection74.pep.xls].
[G2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection39.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection39.pep.xls].
[G3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection75.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection75.pep.xls].
[G3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection31.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection31.pep.xls].
[H1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection83.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection83.pep.xls].
[H1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection32.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection32.pep.xls].
[H2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection84.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection84.pep.xls].
[H2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection84_15051204842.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection84_15051204842.pep.xls].[H2.3 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection33.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection33.pep.xls].
[H3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection85.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection85.pep.xls].
[H3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection85_150512055136.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection85_150512055136.pep.xls].[H3.3 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection41.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection41.pep.xls].
[I1.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection65.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection65.pep.xls].
[I1.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection42.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection42.pep.xls].
[I2.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection66.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection66.pep.xls].
[I2.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection43.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection43.pep.xls].
[I3.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015
_May_6_Bacteria_Detection67.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection67.pep.xls].
[I3.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection30
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection30.pep.xls].[N1
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection22
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection22.pep.xls].[N2
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection56
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection56.pep.xls].[N2
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection25
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection25.pep.xls].[N3
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection57
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection57.pep.xls].[N3
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection26
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection26.pep.xls].[M1
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection42
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection42.pep.xls].[M1
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection27
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection27.pep.xls].[M2
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection43
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection43.pep.xls].[M2
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection28
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection28.pep.xls].[M3
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection44
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection44.pep.xls].[M3
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection32
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection32.pep.xls].[L1
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection46
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection46.pep.xls].[L1
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection33
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection33.pep.xls].[L2
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection34
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection34.pep.xls].[L3
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection48
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection48.pep.xls].[L3
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection38
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection38.pep.xls].[J1
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection52
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection52.pep.xls].[J1
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection39
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection39.pep.xls].[J2
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection53
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection53.pep.xls].[J2
.2 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection40
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection40.pep.xls].[J3
.1 peptide]
LEFT JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection54
.pep.xls]
ON [emmats@washington.edu].[bact detection distinct peptides].peptide=
[emmats@washington.edu].[interact-2015_June_9_BactDetection54.pep.xls].[J3
.2 peptide] ​

On Tue, Oct 27, 2015 at 2:44 PM, emmats notifications@github.com wrote:

I would like to download my file "all ambiguous peptides" from SQLshare
but the download directly from the site didn't seem to be progressing. I
tried fetchdata in the sql python tools, but it timed out (see below). Now
I can't even access my datasets. Is there something wrong?

Thanks
Emma

Emmas-MacBook-Pro-2:tools Emma$ python fetchdata.py --dataset 'all
ambiguous peptides' --format csv --output all_ambiguous_peptides.csv
Traceback (most recent call last):
File "fetchdata.py", line 77, in
main()
File "fetchdata.py", line 71, in main
data = fetchdata(args.sql, args.format, args.output)
File "fetchdata.py", line 29, in fetchdata
conn = sqlshare.SQLShare()
File "build/bdist.macosx-10.5-x86_64/egg/sqlshare/init.py", line 80, in
init
File "build/bdist.macosx-10.5-x86_64/egg/sqlshare/init.py", line 280,
in get_userinfo
File "build/bdist.macosx-10.5-x86_64/egg/sqlshare/init.py", line 267,
in poll_selector
sqlshare.SQLShareError: code: 400 : {"Detail":"Timeout expired. The
timeout period elapsed prior to completion of the operation or the server
is not responding. This failure occurred while attempting to connect to the
routing destination."}

—
Reply to this email directly or view it on GitHub
#72.

[emmats]

Ok. I can definitely break the joins up, but how do I create snapshots?

[shrjain]

I am sorry I forgot to mention that.
When you select any dataset by clicking on it you get the following options:

​

On Tue, Oct 27, 2015 at 8:51 PM, emmats notifications@github.com wrote:

Ok. I can definitely break the joins up, but how do I create snapshots?

—
Reply to this email directly or view it on GitHub
#72 (comment).

[emmats]

I was able to run several of the subsetted queries and then I started getting this error:

Problem running query: Error parsing response: JSON.parse

[shrjain]

As discussed in the email thread, we can use this query instead:

SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection9.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection9.pep.xls].[A1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection69.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection69.pep.xls].[A1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection10.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection10.pep.xls].[A2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection70.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection70.pep.xls].[A2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection11.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection11.pep.xls].[A3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection71.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection71.pep.xls].[A3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection58.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection58.pep.xls].[A3.3 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection23.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection23.pep.xls].[B1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection51.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection51.pep.xls].[B1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection24.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection24.pep.xls].[B2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection52.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection52.pep.xls].[B2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection25.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection25.pep.xls].[B3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection53.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection53.pep.xls].[B3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection27.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection27.pep.xls].[C1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection87_15051208724.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection87_15051208724.pep.xls].[C1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection28.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection28.pep.xls].[C2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection88_150512103018.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection88_150512103018.pep.xls].[C2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection29.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection29.pep.xls].[C3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection89_150512121311.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection89_150512121311.pep.xls].[C3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection17.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection17.pep.xls].[D1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection59.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection59.pep.xls].[D1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection18.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection18.pep.xls].[D2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection60.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection60.pep.xls].[D2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection19.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection19.pep.xls].[D3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection61.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection61.pep.xls].[D3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection45.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection45.pep.xls].[E1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection55.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection55.pep.xls].[E1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection46.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection46.pep.xls].[E2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection56.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection56.pep.xls].[E2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection47.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection47.pep.xls].[E3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection57.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection57.pep.xls].[E3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection13.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection13.pep.xls].[F1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection79.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection79.pep.xls].[F1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection87.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection87.pep.xls].[F1.3 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection14.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection14.pep.xls].[F2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection80.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection80.pep.xls].[F2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection88.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection88.pep.xls].[F2.3 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection15.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Dectection15.pep.xls].[F3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection81.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection81.pep.xls].[F3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection89.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection89.pep.xls].[F3.3 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection37.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection37.pep.xls].[G1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection73.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection73.pep.xls].[G1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection38.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection38.pep.xls].[G2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection74.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection74.pep.xls].[G2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection39.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection39.pep.xls].[G3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection75.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection75.pep.xls].[G3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection31.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection31.pep.xls].[H1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection83.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection83.pep.xls].[H1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection32.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection32.pep.xls].[H2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection84.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection84.pep.xls].[H2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection84_15051204842.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection84_15051204842.pep.xls].[H2.3 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection33.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection33.pep.xls].[H3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection85.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection85.pep.xls].[H3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection85_150512055136.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection85_150512055136.pep.xls].[H3.3 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection41.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection41.pep.xls].[I1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection65.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection65.pep.xls].[I1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection42.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection42.pep.xls].[I2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection66.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection66.pep.xls].[I2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection43.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection43.pep.xls].[I3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection67.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_May_6_Bacteria_Detection67.pep.xls].[I3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection30.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection30.pep.xls].[N1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection22.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection22.pep.xls].[N2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection56.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection56.pep.xls].[N2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection25.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection25.pep.xls].[N3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection57.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection57.pep.xls].[N3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection26.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection26.pep.xls].[M1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection42.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection42.pep.xls].[M1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection27.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection27.pep.xls].[M2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection43.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection43.pep.xls].[M2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection28.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection28.pep.xls].[M3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection44.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection44.pep.xls].[M3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection32.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection32.pep.xls].[L1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection46.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection46.pep.xls].[L1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection33.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection33.pep.xls].[L2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection34.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection34.pep.xls].[L3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection48.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection48.pep.xls].[L3.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection38.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection38.pep.xls].[J1.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection52.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection52.pep.xls].[J1.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection39.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection39.pep.xls].[J2.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection53.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection53.pep.xls].[J2.2 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection40.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection40.pep.xls].[J3.1 peptide]
UNION ALL
SELECT *
FROM [emmats@washington.edu].[bact detection distinct peptides]
JOIN [emmats@washington.edu].[interact-2015_June_9_BactDetection54.pep.xls] ON [emmats@washington.edu].[bact detection distinct peptides].peptide=[emmats@washington.edu].[interact-2015_June_9_BactDetection54.pep.xls].[J3.2 peptide] ​