A missed penalty kick has cost French rugby side Bordeaux millions of dollars after the team missed out on qualifying for the lucrative European Rugby Championships Cup.

The Begles needed to win the match to finish sixth in France's Top 14 rugby competition and qualify for the tournament where the prize pool is EU $112 million (AU $157 million).

And after clawing their way back into the game with a late try, they looked to be set for victory when they were awarded a close range penalty kick in the final seconds.

But to the dismay of the Bordeaux players, coaching staff and fans, French flyhalf Lionel Beauxis missed what should have been a simple shot and allowed Toulouse to triumph 23-22.

Beauxis and several teammates dropped to the turf in despair while coach Raphael Ibanez was left to lament the miss at fulltime.

"I've known some great moments and some cruel ones and this is certainly one of the latter," said Ibanez.

Bordeaux' misery saw Oyonnax take their place in the play-offs by a point despite a 46-17 thrashing by defending champions Toulon which saw them take their try tally at home this season to over 50.

Racing-Metro too sealed their place in the top six putting an end to a run of four successive defeats with a 53-10 humbling of a sorry Castres side that only ensured it didn't suffer the humiliation of relegation, just two years after being crowned champions, last week.

Racing will play Paris rivals Stade Francais in the play-offs next Friday while Oyonnax are away at Toulouse on Saturday - Toulon will play the winner of the former while Clermont whill host the winners of the latter.

Bordeaux' upset, though, was nothing compared to the tears that flowed at Bayonne as the Basque club did everything in its power to extend its elite status to 12 years but not even a bonus point 45-12 win over La Rochelle was sufficient.

"This is very diifficult for the region," said coach Nicolas Morlaes referring to the Basque region which saw Biarritz relegated last season and who failed to regain their Top 14 place this term.

"Scoring 45 points against a good side like La Rochelle is a superb performance but in the end it counts for nothing.

"I am very disappointed, very dejected."

Bayonne slipped out because Brive came up with an unexpectedly strong performance at home to an abject Stade Francais outfit, who came unlike La Rochelle with something to play for in trying to secure a top two spot and direct entry into the play-off semi-finals.

However, Stade played more like the relegation-threatened side as Brive turned them inside out sending their fans into ecstasy in the second-half as they ensured they got the bonus point win they required to stay up.

First Fijian Malakai Bakaniceva, who had only just come onto the pitch, burst clear of a despairing Stade defence and over the line, though, in a nerve jangling moment he all but lost control of the ball before recovering it to touch down.

Stade were all over the place and Brive fans unconfined joy knew no bounds as fly-half Riaan Swanepoel intercepted a Stade pass on the halfway line and ran it back to score their fourth try which Gaetan Germain converted for 27-0.

"We've had a complicated season," admitted Brive player Jean-Baptiste Pejoine.

"Always looking at the others results to see how we were placed is very tiring and stressful.

"We had a lot of pressure on us in this match but we used it to our advantage."

Grenoble also toyed with the drop till the dying minutes but just maintained their status with a defensive bonus point in a 29-24 defeat by already relegated Lyon for whom former France captain Lionel Nallet received a special welcome as he bowed out after 18 years at the top level.

"It's bad for the heart and bad for the constitution," said Grenoble kicker Jonathan Wisniewski, who ended up as the leading points scorer in the Top 14.