Experimental observation of the transition from weak link to tunnel junction