Bad synonyms in CSV

[need47]

Dear COCONUT team,

First of all, thanks for the awesome database. I found some issues with the synonyms while exploring the CSV file downloaded at:
https://coconut.s3.uni-jena.de/prod/downloads/2026-01/coconut_csv-01-2026.zip

For example, the first entry is:
https://coconut.naturalproducts.net/compounds/CNP0074864.1

It contains many synonyms like below:
• [(3S,5R,6R,8S,9S,10R,13R,14S,17R)-5,6-dibromo-10,13-dimethyl-17-[(2R)-6-methylheptan-2-yl]-1,2,3,4,6,7,8,9,11,12,14,15,16,17-tetradecahydrocyclopenta[a]phenanthren-3-yl] acetate

However, the comma ‘,’ in the downloaded file is mistranslated to pipe ‘|’, which I believe is the delimiter.
• …|Acebrocholum|Acebrocol|(3S|5R|6R|8S|9S|10R|13R|14S|17R)-5|6-dibromo-10|13-dimethyl-17-(2R)-6-methylheptan-2-yl-1|2|3|4|6|7|8|9|11|12|14|15|16|17-tetradecahydrocyclopentaaphenanthren-3-yl acetate|…

Would you like to take a look?

Best regards

[need47]

I think there is a similar issue for the iupac_name column (mind the ~{} below):
[(3~{S},5~{R},6~{R},8~{S},9~{S},10~{R},13~{R},14~{S},17~{R})-5,6-dibromo-17-[(1~{R})-1,5-dimethylhexyl]-10,13-dimethyl

I noticed this in the PostgreSQL db as well.

[Kohulan]

@need47 Could you share the ID as well?

[need47]

Same entry: https://coconut.naturalproducts.net/compounds/CNP0074864.1

This seems systematic:

[Kohulan]

Hi @need47 ,

In this case, it is used to mark the R, S and other groups in italics. That is not an encoding issue.

The "[(3~{S},5~{R},6~{R},8~{S},9~{S},10~{R},13~{R},14~{S},17~{R})-5,6-dibromo-17-[(1~{R})-1,5-dimethylhexyl]-10,13-dimethyl"

will be converted to the following:

[need47]

Yeah, didn't expect that.

[need47]

I should have added that the same issue applies to the name column.

[need47]

I can confirm that the synonyms issue has been fixed in the Feb. release. But, the italics format in the name and iupac_name remains.

[sriramkanakam87]

Will deploy a fix soon.