# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-03T09:21:53+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 'Journal of natural products') 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
"1506439","9.5032","0.0002","11.2533","0.0003","19.2625","0.0006","90","","90","","90","","2059.98","0.09","293","","293","","","","","","","","see text","3","P 21 21 21","P 2ac 2ab","19","","methyl (1E,4E)-6α,8β-diacetoxy-7βH-germacra-1(10),4-dien-14-oate","","- C20 H30 O6 -","- C20 H30 O6 -","- C80 H120 O24 -","4","1","","Triana, Jorge; López, Mariana; Pérez, Francisco J; González-Platas, Javier; Quintana, José; Estévez, Francisco; León, Francisco; Bermejo, Jaime","Sesquiterpenoids from Pulicaria canariensis and their cytotoxic activities.","Journal of natural products","2005","68","4","523","531","10.1021/np0496183","","x-ray","0.71073","MoKα","","0.0765","0.063","","","0.1638","0.1762","","","","","","1.217","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1506440","9.039","0.001","14.621","0.001","14.866","0.001","90","","90","","90","","1964.7","0.3","293","","293","","","","","","","","see text","3","P 21 21 21","P 2ac 2ab","19","","(1E)-1β,10α-epoxy-6α,8β-diacetoxy-7βH-germacra-4-ene-14-al","","- C19 H28 O6 -","- C19 H28 O6 -","- C76 H112 O24 -","4","1","","Triana, Jorge; López, Mariana; Pérez, Francisco J; González-Platas, Javier; Quintana, José; Estévez, Francisco; León, Francisco; Bermejo, Jaime","Sesquiterpenoids from Pulicaria canariensis and their cytotoxic activities.","Journal of natural products","2005","68","4","523","531","10.1021/np0496183","","x-ray","0.71073","MoKα","","0.0882","0.0711","","","0.1782","0.1932","","","","","","1.121","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1506441","9.698","0.001","13.617","0.001","14.946","0.001","90","","90","","90","","1973.7","0.3","293","","293","","","","","","","","see text","3","P 21 21 21","P 2ac 2ab","19","","1β,10α,4α,Diepoxy-6α,8β-diacetoxy-7βH-germacra-14-al","","- C19 H28 O7 -","- C19 H28 O7 -","- C76 H112 O28 -","4","1","","Triana, Jorge; López, Mariana; Pérez, Francisco J; González-Platas, Javier; Quintana, José; Estévez, Francisco; León, Francisco; Bermejo, Jaime","Sesquiterpenoids from Pulicaria canariensis and their cytotoxic activities.","Journal of natural products","2005","68","4","523","531","10.1021/np0496183","","x-ray","0.71073","MoKα","","0.0745","0.0637","","","0.1682","0.1801","","","","","","1.178","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1506442","5.441","0.001","14.886","0.003","17.243","0.003","90","","90","","90","","1396.6","0.5","293","","293","","","","","","","","see text","3","P 21 21 21","P 2ac 2ab","19","","15-hydroxy-10(14)-oplopen-4-one","","- C15 H24 O2 -","- C15 H24 O2 -","- C60 H96 O8 -","4","1","","Triana, Jorge; López, Mariana; Pérez, Francisco J; González-Platas, Javier; Quintana, José; Estévez, Francisco; León, Francisco; Bermejo, Jaime","Sesquiterpenoids from Pulicaria canariensis and their cytotoxic activities.","Journal of natural products","2005","68","4","523","531","10.1021/np0496183","","x-ray","0.71073","MoKα","","0.0411","0.0352","","","0.1115","0.1171","","","","","","0.984","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1506443","16.525","0.007","7.74","0.002","12.559","0.006","90","","110.18","0.03","90","","1507.7","1.1","215","2","215","2","","","","","","","","3","P 1 21/n 1","-P 2yn","14","malettinin D","","","- C16 H16 O7 -","- C16 H16 O7 -","- C64 H64 O28 -","4","1","","Angawi, Rihab F.; Swenson, Dale C.; Gloer, James B.; Wicklow, Donald T.","Malettinins B-D: new polyketide metabolites from an unidentified fungal colonist of Hypoxylon Stromata (NRRL 29110).","Journal of natural products","2005","68","2","212","216","10.1021/np049625r","","","0.71073","MoKα","","0.0641","0.0477","","","0.1289","0.1442","","","","","","1.072","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1506444","11.213","0.002","14.543","0.003","16.498","0.003","90","","90","","90","","2690.3","0.9","293","2","293","2","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","puqienine A","","","- C28 H49 N O4 -","- C28 H49 N O4 -","- C112 H196 N4 O16 -","4","1","","Jiang, Yan; Li, Huijun; Li, Ping; Cai, Zhaohui; Ye, Wencai","Steroidal alkaloids from the bulbs of Fritillaria puqiensis.","Journal of natural products","2005","68","2","264","267","10.1021/np0497649","","","0.71073","MoKα","","0.2021","0.0666","","","0.1594","0.2176","","","","","","0.995","","","","has coordinates","201954","2020-10-21","18:00:00",""