# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-07-05T22:19:19+02: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 'ACS chemical biology') AND volume = 14 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 "4514610","6.072","","13.299","","16.147","","73.2","","82.66","","78.95","","1221.46","","293","2","293","2","","","","","","","","4","P -1","-P 1","2","","","","- C25 H29 N O8 -","- C25 H29 N O8 -","- C50 H58 N2 O16 -","2","1","","Gerlach, Erica M.; Korkmaz, Melissa A.; Pavlinov, Ivan; Gao, Qiwen; Aldrich, Leslie N.","Systematic Diversity-Oriented Synthesis of Reduced Flavones from γ-Pyrones to Probe Biological Performance Diversity.","ACS chemical biology","2019","14","7","1536","1545","10.1021/acschembio.9b00294","","","0.71073","MoKα","","0.1885","0.1087","","","0.2489","0.2746","","","","","","1.558","","","","has coordinates,has disorder","219795","2020-10-21","18:00:00","" "4515456","12.4957","0.0018","12.624","0.0017","14.069","0.002","77.346","0.007","86.013","0.008","76.532","0.007","2105.5","0.5","150","1","150","1","","","","","","","","6","P -1","-P 1","2","rl021","","","- C50 H42 F2 N6 O4 Zn -","- C50 H42 F2 N6 O4 Zn -","- C100 H84 F4 N12 O8 Zn2 -","2","1","","Vaden, Rachel M.; Guillen, Katrin P.; Salvant, Justin M.; Santiago, Celine B.; Gibbons, Joseph B.; Pathi, Satya S.; Arunachalam, Sasi; Sigman, Matthew S.; Looper, Ryan E.; Welm, Bryan E.","A Cancer-Selective Zinc Ionophore Inspired by the Natural Product Naamidine A.","ACS chemical biology","2019","14","1","106","117","10.1021/acschembio.8b00977","","","0.71073","MoKα","","0.0546","0.0375","","","0.0941","0.0992","","","","","","1.084","","","","has coordinates,has disorder","225610","2020-10-21","18:00:00",""