The remains of a dinosaur have been unveiled after being discovered by archaeologists in a clay pit.