I'm not arguing against your premise because your conclusion - that you leave implied - doesn't follow from your premise. When your argument did follow from your premise, that "all the expensive parts" is solely in the clinical trial, I did argue against your premise.
What you actually wrote in your second comment doesn't effectively argue against my point. There's no point arguing your assertion that clinical trials are expensive, they are, what you needed to argue was that it means that pharma companies are more efficient at developing drugs.
It can even be true that clinical trials are more expensive and that most of the aggregate cost from failed drugs is due to those that fail late, as well as that public research is more efficient at developing drugs.
Why? Because the likelihood that a drug fails, late of early, is a function of the drug itself - we expect that any trial of the same drug would arrive at essentially the same result. Therefore, even if the total cost of failed drugs is concentrated in those that fail late, that cost mostly has to do with the initial drug design, and I've provided quantitative data on the success rate of academic drug design, which is comparable or better than private drug design.
Therefore, the evidence is that academia can actually design drugs that have a competitively low expected cost from late failure.
Market dynamics also support this : a major and growing portion of new drug approvals are exactly this : academia designs a drug that has a competitively low cost from late clinical trial failure, a biotech company buys the rights to it after academia makes a compelling case, the trials succeed, and the biotech company makes a large expected profit.
So, even if your hypothesis is that most of the cost is from drugs that fail do fail late, it doesn't challenge the idea that academia is good at discovering drugs, because the drugs academia discover aren't more likely to fail late, according to the data I found and provided.
Also, you have to show that the majority of cost is from drugs that fail late : that doesn't seem true at all. The total cost of all clinical trials in the US is around 7B$ a year (https://www.clinicalleader.com/doc/considerations-for-improv...). As you correctly imply, this is a cost that is borne in large majority by the private sector. However, the other costs that are borne almost exclusively by the public sector and that are a necessary additional cost to add to the cost of drug development, is fundamental research, which provides new targets and modalities that are a necessary precursor to drug research. That accounts for the majority of the NIH budget, which itself is only one of the institutions that funds such research, and amounts to 48B$.