# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T12:42:01+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 = 68 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
"1559808","6.6263","0.0001","12.3911","0.0002","16.6583","0.0003","90","","90","","90","","1367.77","0.04","100","2","100","2","","","","","","","","3","P 21 21 21","P 2ac 2ab","19","","","","- C15 H22 O5 -","- C15 H22 O5 -","- C60 H88 O20 -","4","1","","Shi, Zhen-Zhen; Liu, Xiang-Hong; Li, Xiao-Nian; Ji, Nai-Yun","Antifungal and Antimicroalgal Trichothecene Sesquiterpenes from the Marine Algicolous Fungus <i>Trichoderma brevicompactum</i> A-DL-9-2.","Journal of agricultural and food chemistry","2020","68","52","15440","15448","10.1021/acs.jafc.0c05586","","","1.54178","CuKα","","0.028","0.0279","","","0.0718","0.0718","","","","","","1.1","","","","has coordinates","260431","2021-01-04","03:17:01",""
"1559809","22.252","0.002","6.8553","0.0006","8.7551","0.0008","90","","90","","90","","1335.5","0.2","293","2","293","2","","","","","","","","3","P 21 21 21","P 2ac 2ab","19","","","","- C15 H22 O4 -","- C15 H22 O4 -","- C60 H88 O16 -","4","1","","Shi, Zhen-Zhen; Liu, Xiang-Hong; Li, Xiao-Nian; Ji, Nai-Yun","Antifungal and Antimicroalgal Trichothecene Sesquiterpenes from the Marine Algicolous Fungus <i>Trichoderma brevicompactum</i> A-DL-9-2.","Journal of agricultural and food chemistry","2020","68","52","15440","15448","10.1021/acs.jafc.0c05586","","","1.54178","CuKα","","0.1309","0.0815","","","0.1901","0.2334","","","","","","1.066","","","","has coordinates","260431","2021-01-04","03:17:01",""
"1559810","6.3065","0.0003","7.0893","0.0003","32.1064","0.0014","90","","90","","90","","1435.43","0.11","100","2","100","2","","","","","","","","3","P 21 21 21","P 2ac 2ab","19","","","","- C15 H24 O3 -","- C15 H24 O3 -","- C60 H96 O12 -","4","1","","Shi, Zhen-Zhen; Liu, Xiang-Hong; Li, Xiao-Nian; Ji, Nai-Yun","Antifungal and Antimicroalgal Trichothecene Sesquiterpenes from the Marine Algicolous Fungus <i>Trichoderma brevicompactum</i> A-DL-9-2.","Journal of agricultural and food chemistry","2020","68","52","15440","15448","10.1021/acs.jafc.0c05586","","","1.54178","CuKα","","0.028","0.0278","","","0.0763","0.0764","","","","","","1.064","","","","has coordinates","260431","2021-01-04","03:17:01",""