# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-26T18:31:43+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 'Bioorganic & Medicinal Chemistry Letters') AND volume = 24 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
"8000258","4.8686","0.0004","15.1351","0.0013","19.0283","0.0018","94.372","0.005","93.841","0.006","93.639","0.005","1391.6","0.2","","","100","","","","","","","","","4","P -1","-P 1","2","N-Benzyl-2,7-dimethylimidazo[1,2-a]pyridine-3-carboxamide (1)","","","- C17 H17 N3 O -","- C17 H17 N3 O -","- C68 H68 N12 O4 -","4","2","","Garrett C. Moraski; Allen G. Oliver; Lowell D. Markley; Sanghyun Cho; Scott G. Franzblau; Marvin J. Miller","Scaffold-switching: An exploration of 5,6-fused bicyclic heteroaromatics systems to afford antituberculosis activity akin to the imidazo[1,2-a]pyridine-3-carboxylates","Bioorganic & Medicinal Chemistry Letters","2014","24","","3493","3498","10.1016/j.bmcl.2014.05.062","","x-ray","1.54178","CuKα","","0.0731","0.0483","","","0.1414","0.1818","","","","","","1.188","","","","has coordinates","204918","2020-10-21","18:00:00",""
"8000259","9.3005","0.0008","6.6121","0.0005","11.8267","0.001","90","","106.276","0.001","90","","698.14","0.1","","","120","","","","","","","","","4","P 1 21/m 1","-P 2yb","11","N-Benzyl-2,6-dimethylimidazo[1,2-b]pyridazine-3-carboxamide","","","- C16 H16 N4 O -","- C16 H16 N4 O -","- C32 H32 N8 O2 -","2","0.5","","Garrett C. Moraski; Allen G. Oliver; Lowell D. Markley; Sanghyun Cho; Scott G. Franzblau; Marvin J. Miller","Scaffold-switching: An exploration of 5,6-fused bicyclic heteroaromatics systems to afford antituberculosis activity akin to the imidazo[1,2-a]pyridine-3-carboxylates","Bioorganic & Medicinal Chemistry Letters","2014","24","","3493","3498","10.1016/j.bmcl.2014.05.062","","x-ray","0.71073","MoKα","","0.0474","0.0453","","","0.1275","0.1306","","","","","","1.054","","","","has coordinates","204919","2020-10-21","18:00:00",""
"8000260","4.783","0.0003","25.5753","0.0015","11.9469","0.0007","90","","98.639","0.003","90","","1444.84","0.15","","","100","","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","N-Benzyl-2,6-dimethyl-1H-indole-3-carboxamide","","","- C18 H18 N2 O -","- C18 H18 N2 O -","- C72 H72 N8 O4 -","4","1","","Garrett C. Moraski; Allen G. Oliver; Lowell D. Markley; Sanghyun Cho; Scott G. Franzblau; Marvin J. Miller","Scaffold-switching: An exploration of 5,6-fused bicyclic heteroaromatics systems to afford antituberculosis activity akin to the imidazo[1,2-a]pyridine-3-carboxylates","Bioorganic & Medicinal Chemistry Letters","2014","24","","3493","3498","10.1016/j.bmcl.2014.05.062","","x-ray","1.54178","CuKα","","0.0531","0.0415","","","0.1013","0.1083","","","","","","1.028","","","","has coordinates","204921","2020-10-21","18:00:00",""
"8000261","5.9164","0.0002","13.074","0.0003","18.5711","0.0005","109.499","0.001","93.229","0.002","94.402","0.002","1344.97","0.07","","","100","","","","","","","","","4","P -1","-P 1","2","N-Benzyl-6-methyl-2H-indazole-3-carboxamide","","","- C16 H15 N3 O -","- C16 H15 N3 O -","- C64 H60 N12 O4 -","4","2","","Garrett C. Moraski; Allen G. Oliver; Lowell D. Markley; Sanghyun Cho; Scott G. Franzblau; Marvin J. Miller","Scaffold-switching: An exploration of 5,6-fused bicyclic heteroaromatics systems to afford antituberculosis activity akin to the imidazo[1,2-a]pyridine-3-carboxylates","Bioorganic & Medicinal Chemistry Letters","2014","24","","3493","3498","10.1016/j.bmcl.2014.05.062","","x-ray","1.54178","CuKα","","0.0546","0.0402","","","0.0999","0.1084","","","","","","1.042","","","","has coordinates","204922","2020-10-21","18:00:00",""
"8000262","9.772","0.003","5.8461","0.0019","22.078","0.007","90","","91.411","0.006","90","","1260.9","0.7","","","120","","","","","","","","","4","P 1 21/n 1","-P 2yn","14","N-Benzyl-7-methyl-[1,2,4]triazolo[4,3-a]pyridine-3-carboxamide","","","- C15 H14 N4 O -","- C15 H14 N4 O -","- C60 H56 N16 O4 -","4","1","","Garrett C. Moraski; Allen G. Oliver; Lowell D. Markley; Sanghyun Cho; Scott G. Franzblau; Marvin J. Miller","Scaffold-switching: An exploration of 5,6-fused bicyclic heteroaromatics systems to afford antituberculosis activity akin to the imidazo[1,2-a]pyridine-3-carboxylates","Bioorganic & Medicinal Chemistry Letters","2014","24","","3493","3498","10.1016/j.bmcl.2014.05.062","","x-ray","0.71073","MoKα","","0.08","0.0603","","","0.1465","0.1588","","","","","","1.057","","","","has coordinates","204924","2020-10-21","18:00:00",""
"8000263","20.3189","0.0011","10.8268","0.0005","15.6023","0.0009","90","","129.107","0.003","90","","2663.4","0.3","","","100","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","N-Benzyl-5,7-dimethyl-[1,2,4]triazolo[1,5-a]pyrimidine-2-carboxamide","","","- C15 H15 N5 O -","- C15 H15 N5 O -","- C120 H120 N40 O8 -","8","1","","Garrett C. Moraski; Allen G. Oliver; Lowell D. Markley; Sanghyun Cho; Scott G. Franzblau; Marvin J. Miller","Scaffold-switching: An exploration of 5,6-fused bicyclic heteroaromatics systems to afford antituberculosis activity akin to the imidazo[1,2-a]pyridine-3-carboxylates","Bioorganic & Medicinal Chemistry Letters","2014","24","","3493","3498","10.1016/j.bmcl.2014.05.062","","x-ray","1.54178","CuKα","","0.0362","0.0356","","","0.0899","0.0904","","","","","","1.043","","","","has coordinates","204926","2020-10-21","18:00:00",""
"8000264","7.9379","0.0003","19.6844","0.0009","9.5568","0.0004","90","","100.934","0.002","90","","1466.17","0.11","","","100","","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","N-Benzyl-3,7-dimethylimidazo[1,2-a]pyridine-2-carboxamide","","","- C17 H17 N3 O -","- C17 H17 N3 O -","- C68 H68 N12 O4 -","4","1","","Garrett C. Moraski; Allen G. Oliver; Lowell D. Markley; Sanghyun Cho; Scott G. Franzblau; Marvin J. Miller","Scaffold-switching: An exploration of 5,6-fused bicyclic heteroaromatics systems to afford antituberculosis activity akin to the imidazo[1,2-a]pyridine-3-carboxylates","Bioorganic & Medicinal Chemistry Letters","2014","24","","3493","3498","10.1016/j.bmcl.2014.05.062","","x-ray","1.54178","CuKα","","0.0461","0.0372","","","0.0922","0.0978","","","","","","1.033","","","","has coordinates","204927","2020-10-21","18:00:00",""