# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T09:12:06+01:00
# Query:
# SELECT data.*
# FROM
#  data JOIN jaltnames
#  ON altname = journal
# WHERE
#  (status is null or status != 'retracted') and
#  (journal_id IN (SELECT DISTINCT(journal_id) FROM jaltnames WHERE altname LIKE 'Journal of agricultural and food chemistry') AND volume = 63 AND duplicateof IS NULL AND (status is NULL OR status != 'errors') AND (method is NULL OR method != 'theoretical'))
# ORDER BY file asc
file,a,siga,b,sigb,c,sigc,alpha,sigalpha,beta,sigbeta,gamma,siggamma,vol,sigvol,celltemp,sigcelltemp,diffrtemp,sigdiffrtemp,cellpressure,sigcellpressure,diffrpressure,sigdiffrpressure,thermalhist,pressurehist,compoundsource,nel,sg,sgHall,sgNumber,commonname,chemname,mineral,formula,calcformula,cellformula,Z,Zprime,acce_code,authors,title,journal,year,volume,issue,firstpage,lastpage,doi,method,radiation,wavelength,radType,radSymbol,Rall,Robs,Rref,wRall,wRobs,wRref,RFsqd,RI,gofall,gofobs,gofgt,gofref,duplicateof,optimal,status,flags,svnrevision,date,time,onhold
"1531043","14.7352","0.0017","8.7127","0.0009","14.2158","0.0012","90","","114.431","0.012","90","","1661.7","0.3","293.18","0.1","293.18","0.1","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","","","- C19 H16 O7 -","- C19 H16 O7 -","- C76 H64 O28 -","4","1","","Ma, Yan-Yan; Zhao, Deng-Gao; Zhou, Ai-Yu; Zhang, Yu; Du, Zhiyun; Zhang, Kun","α-Glucosidase Inhibition and Antihyperglycemic Activity of Phenolics from the Flowers of Edgeworthia gardneri.","Journal of agricultural and food chemistry","2015","63","37","8162","8169","10.1021/acs.jafc.5b03081","","x-ray","0.71073","MoKα","","0.1415","0.0713","","","0.1532","0.2056","","","","","","1.062","","","","has coordinates","160540","2020-10-21","18:00:00",""
"1540696","9.0359","0.0003","10.9281","0.0004","15.2645","0.0005","90","","90","","90","","1507.3","0.09","93","0.1","93","0.1","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","","","- C12 H21 N O5 S -","- C12 H21 N O5 S -","- C48 H84 N4 O20 S4 -","4","1","","Hakamata, Wataru; Koyama, Ryosuke; Tanida, Mizuki; Haga, Tomomi; Hirano, Takako; Akao, Makoto; Kumagai, Hitomi; Nishio, Toshiyuki","A Simple Synthesis of Alliin and allo-Alliin: X-ray Diffraction Analysis and Determination of Their Absolute Configurations.","Journal of agricultural and food chemistry","2015","63","50","10778","10784","10.1021/acs.jafc.5b05501","","","1.54178","","","0.027","0.025","","","0.0611","0.0621","","","","","","1.063","","","","has coordinates,has disorder","173582","2020-10-21","18:00:00",""