Going to the web client to synapse table with the following query:
SELECT distinct sex FROM syn20449214 where isCellLine is NULL OR isCellLine='FALSE'
gets me 'Female' and 'Male'
However, when i use the python client (via reticulate in R, because of package dependencies):
> expData<-syn$tableQuery(paste("SELECT * FROM",syn_file,"where isCellLine is NULL OR isCellLine='FALSE'"))$asDataFrame()
"Male" "Female" "male" "female"
which is the true table?