I would phrase this differently. Statistical significance does not link directly to the effect size. Therefore, you could have a p-value of .049 with a very large effect (due to small sample size or large variation within groups), and another p-value of 0.001 with a very small effect (due to large sample sizes and small variation within groups).