mysql> SELECT DISTINCT sg FROM data; +----------------------------------+ | sg | +----------------------------------+ | | | P -1 | | C 2/c | | C 2/m | | C2/c | | I 41/a | | P -1 | | P 21 | | P 21 21 21 | | P 21 c n | | P 21/a | | P 21/c | | P 21/n | | P 63 2 2 | | P b c a | | P b c n | | P c a 21 | | P n a 21 | | P n m a | | P-1 | | P21/a | | P21/c | | R -3c | | ¨P | | _cell_angle_beta | | -C 2yc | | -F 4 2 3 | | -P 1 | | -P 2ybc | | -P 2yn | | -P1 | | ? ? ? ? | | ??? | | ???? | | ?P? | | (000 ??? | | (P | | A -1 | | A 1 1 2/a | | A 1 1 2/a {non-std setting; b ax | | A 1 1 2/m | | A 1 2 1 | | A 1 2/a 1 | | A 1 2/m 1 | | A 1 2/n 1 | | A 1 a 1 | | A 2 | | A 2 m m | | A 2/a | | A 2/m | | A 2/n | | A 21 2 2 | | A 21 a m | | A 21 m a | | A b a 2 | | A b m 2 | | A b m a | | A b m m | | A c 2 a | | A c a m | | A m a 2 | | A m a a | | A m a m | | A m m 2 | | A m m a | | A m m m | | A n | | A2/m | | Aba2 | | Abma | | Ama2 | | Amm2 | | Ammm | | B -1 | | B 1 | | B 1 1 2 | | B 1 1 2/b | | B 1 1 2/n | | B 1 1 m | | B 1 2 1 | | B 1 21 1 | | B 1 21/d 1 | | B 1 21/m 1 | | B 2 m b | | B 21/c | | B 21/d | | B b 21 m | | B b a 2 | | B b a m | | B b c m | | B b m 2 | | B b m m | | B m 2 m | | B m a b | | B m a m | | B m m b | | B2/m | | Bbm2 | | Bmab | | C 2/m | | C -1 | | C -4 2 b | | C ? | | C 1 | | C 1 1 1 | | C 1 1 21 | | C 1 1 21/d | | C 1 2 1 | | C 1 2/c 1 | | C 1 2/c 1 S | | C 1 2/m 1 | | C 1 21 1 | | C 1 c 1 | | C 1 m 1 | | C 2 | | C 2 / c | | C 2 /c | | C 2 2 2 | | C 2 2 2(1) | | C 2 2 21 | | C 2 c a | | C 2 c b | | C 2/a | | C 2/c | | C 2/m | | C 2/n | | C 2y | | C 4 2 21 | | C c | | C c 2 a | | C c c 2 | | C c c a | | C c c a (C c c e) | | C c c a Z | | C c c m | | C c m 21 | | C c m b | | C c m m | | C cc2 | | C cmb | | C m | | C m 2 a | | C m 2 m | | C m c 21 | | C m c a | | C m c m | | C m m 2 | | C m m a | | C m m b | | C m m m | | C mca | | C_1_2/c_1 | | C_2/c | | C-1 | | C12/c1 | | C2 | | C2:b1 | | C2/c | | C2/c , No.15 | | C2/c No.15 | | C2/c(0\b0)s0 | | C2/m | | C2/m(\a0\g)0s | | C2/m(0\b0)s0 | | C222 | | C222(1) | | C2221 | | Cc | | Ccca | | Cm | | Cm2m | | Cmc2(1) | | Cmc21 | | Cmca | | Cmcm | | Cmcm (no. 63) | | Cmmm | | Cubic | | F | | F -1 | | F -4 3 c | | F -4 3 m | | F -4 d 2 | | F ? | | F 1 | | F 1 1 2 | | F 1 2/d 1 | | F 1 2/m 1 | | F 1 d 1 | | F 2 | | F 2 2 2 | | F 2 3 | | F 2 d d | | F 2 m m | | F 4 3 2 | | F 4/m m m | | F 41 3 2 | | F 41/a d c | | F d -3 | | F d -3 (origin at 3) | | F d -3 c | | F d -3 c Z | | F d -3 m | | F d -3 m {origin @ -3 m} | | F d -3 m {origin @ centre (-3m)} | | F d -3 m S | | F d -3 m S1 | | F d -3 m Z | | F d -3 Z | | F d -3m | | F d 2 d | | F d 3 | | F d 3 c | | F d 3 m | | F d 3- m | | F d d | | F d d 2 | | F d d 2 S | | F d d d | | F d d d {origin @ -1 @ d d d} | | F d d d {origin @ 2 2 2} | | F d d d S | | F d d d Z | | F dd2 | | F m -3 | | F m -3 c | | F m -3 m | | F m 2 m | | F m 3 c | | F m 3 m | | F m m 2 | | F m m m | | F-4 3c | | F-43m | | F43m | | Fd-3 | | Fd-3m | | Fd-3m:1 | | Fd3 | | Fdd2 | | Fddd | | Fm-3m | | Fm3m | | Fmm2 | | hexag | | I | | I -1 | | I -4 | | I -4 2 d | | I -4 2 d S | | I -4 2 m | | I -4 3 d | | I -4 3 m | | I -4 c 2 | | I -4 m 2 | | I -42d | | I ? | | I ? ? ? | | I ??? | | I 1 1 2/a | | I 1 1 2/b | | I 1 1 2/m | | I 1 1 b | | I 1 2 1 | | I 1 2/a 1 | | I 1 2/a 1 S | | I 1 2/c 1 | | I 1 2/m 1 | | I 1 a 1 | | I 1 m 1 | | I 2 | | I 2 1 1 2 | | I 2 2 2 | | I 2 3 | | I 2 c b | | I 2 c m | | I 2 m b | | I 2 m m | | I 2/a | | I 2/c | | I 2/m | | I 21 21 21 | | I 21 3 | | I 21/a -3 | | I 4 | | I 4 -c 2 | | I 4 /m m m | | I 4 1/a (origin at -1) | | I 4 2 2 | | I 4 3 2 | | I 4 c m | | I 4 m m | | I 4/m | | I 4/m c m | | I 4/m c m S | | I 4/m m m | | I 4/mmm | | I 41 | | I 41 2 2 | | I 41 3 2 | | I 41 c d | | I 41 m d | | I 41/a | | I 41/a (origin @ -1 on glide pla | | I 41/a (origin at -1) | | I 41/a {origin @ -1 on glide pla | | I 41/a {origin @ -4} | | I 41/a {origin of higher symmetr | | I 41/a c d | | I 41/a c d S | | I 41/a c d Z | | I 41/a m d | | I 41/a m d 1 | | I 41/a m d S | | I 41/a m d Z | | I 41/a S | | I 41/a Z | | I 41/a Z1 | | I 41/acd | | I 43 | | I a | | I a -3 | | I a -3 d | | I a 3 | | I a 3 d | | I b a 2 | | I b a m | | I b a m S | | I b a2 | | I b c a | | I b m 2 | | I b m m | | I c | | I c m a S | | I m | | I m -3 | | I m -3 m | | I m 2 m | | I m 3 | | I m 3 m | | I m a 2 | | I m a b | | I m a m | | I m c b | | I m c m | | I m m 2 | | I m m a | | I m m m | | I ma2 | | I-4 | | I-42d | | I-42m | | I-43d | | I-43m | | I2 | | I2/a | | I2/b(\a\b0)00 | | I2/c | | I2/m | | I222 | | I23 | | I4 | | I4(1)/a | | I4(1)/acd | | I4(1)cd | | I4/m | | I4/m c m | | I4/m m m | | I4/mcm | | I4/mmm | | I4/mmm ? | | I41/a | | I41/a c d | | I41/a m d | | I41/acd | | I41/amd | | I41cd | | I4cm | | I4mm | | Ia | | Ia-3 | | Ia3d | | Iba2 | | Ibam | | Ibm2 | | Im | | Im-3m | | Im2m | | Ima2 | | Imma | | Imma(00\g)s00 | | Immm | | Monoclinic | | Orthorhombic | | P | | P 21/c | | P 21/n | | P b c a | | P - 1 | | P -1 | | P -1- | | P -3 | | P -3 1 c | | P -3 1 c S | | P -3 1 m | | P -3 c 1 | | P -3 m 1 | | P -3? | | P -4 | | P -4 2 c | | P -4 2 m | | P -4 21 c | | P -4 21 m | | P -4 21/c | | P -4 3 m | | P -4 3 n | | P -4 b 2 | | P -4 m 2 | | P -4 n 2 | | P -6 | | P -6 2 c | | P -6 2 m | | P -6 c 2 | | P -6 m 2 | | P ? | | P ? ? | | P ? ? ? | | P ??? | | P 1 | | P 1 1 2/b | | P 1 1 2/m | | P 1 1 2/n | | P 1 1 21 | | P 1 1 21/a | | P 1 1 21/b | | P 1 1 21/m | | P 1 1 21/n | | P 1 1 m | | P 1 2 1 | | P 1 2/a 1 | | P 1 2/c 1 | | P 1 2/m 1 | | P 1 2/n 1 | | P 1 21 1 | | P 1 21/a 1 | | P 1 21/c 1 | | P 1 21/m 1 | | P 1 21/m 1 S | | P 1 21/n 1 | | P 1 a 1 | | P 1 c 1 | | P 1 m 1 | | P 1 n 1 | | P 1 n a m 1 | | P 2 | | P 2 1 /n | | P 2 1 2 1 2 1 | | P 2 1/ c | | P 2 1/c | | P 2 1/n | | P 2 21 2 | | P 2 21 21 | | P 2 3 | | P 2 a n | | P 2 c m | | P 2 m m | | P 2 n n | | P 2(1) | | P 2(1) / n | | P 2(1)/c | | P 2(1)/n | | P 2/a | | P 2/c | | P 2/m | | P 2/n | | P 2~1~/c | | P 2~1~/n | | P 21 | | P 21 / n | | P 21 /a | | P 21 /c | | P 21 /n | | P 21 1 1 | | P 21 2 21 | | P 21 21 2 | | P 21 21 21 | | P 21 3 | | P 21 a b | | P 21 a m | | P 21 c a | | P 21 c n | | P 21 m n | | P 21 n | | P 21 n b | | P 21 n m | | P 21/ a | | P 21/ c | | P 21/a | | P 21/b 1 1 | | P 21/b 21/c 21/a | | P 21/c | | P 21/c 2/c 2/a | | P 21/m | | P 21/m 1 1 | | P 21/N | | P 21/n 1 1 | | P 21/n 21/m 21/a | | P 21/n' | | P 212121 | | P 21ab | | P 21c | | P 21cn | | P 21nb | | P 2c -2ac | | P 3 | | P 3 1 2 | | P 3 1 21 | | P 3 1 c | | P 3 1 m | | P 3 2 1 | | P 3 2 21 | | P 3 c 1 | | P 3 m 1 | | P 31 | | P 31 1 2 | | P 31 2 1 | | P 31 2 1 (or P 32 2 1) | | P 31 2 1 S | | P 31 21 | | P 32 | | P 32 1 2 | | P 32 2 1 | | P 32 2 1 S | | P 32 21 | | P 4 | | P 4 2/n c m | | P 4 21 2 | | P 4 b m | | P 4 c c | | P 4 m m | | P 4 n c | | P 4/m | | P 4/m b m | | P 4/m c c | | P 4/m m m | | P 4/m n c | | P 4/mbm | | P 4/n | | P 4/n -3 2/n P n -3 n | | P 4/n (origin @ -1 on n) | | P 4/n b m | | P 4/n b m S | | P 4/n b m Z | | P 4/n c c | | P 4/n c c {origin @ -1 @ n 1(c, | | P 4/n c c {origin @ -4/n c n} | | P 4/n c c S | | P 4/n c c Z | | P 4/n m m | | P 4/n m m S | | P 4/n m m Z | | P 4/n n c | | P 4/n n c {origin @ -1 @ n n (n, | | P 4/n n c S | | P 4/n n c Z1 | | P 4/n S | | P 41 | | P 41 2 2 | | P 41 21 2 | | P 41 3 2 | | P 42 | | P 42 21 2 | | P 42 3 2 | | P 42 b c | | P 42 m c | | P 42 n m | | P 42/m | | P 42/m b c | | P 42/m m c | | P 42/m m c S | | P 42/m n m | | P 42/mnm | | P 42/n | | P 42/n {origin @ -4} | | P 42/n {origin choice 2} | | P 42/n b c | | P 42/n c m | | P 42/n c m S | | P 42/n c m Z | | P 42/n m c | | P 42/n m c S | | P 42/n m c Z | | P 42/n n m | | P 42/n S | | P 42/n Z | | P 42/nmc | | P 43 | | P 43 2 2 | | P 43 21 2 | | P 43 3 2 | | P 4mm | | P 6 | | P 6 m m | | P 6? | | P 6/m | | P 6/m c c | | P 6/m c c S | | P 6/m m m | | P 61 | | P 61 2 2 | | P 62 | | P 62 2 1 | | P 62 2 2 | | P 63 | | P 63 ? | | P 63 2 2 | | P 63 22 | | P 63 c m | | P 63 m c | | P 63 m c S | | P 63/m | | P 63/m c m | | P 63/m m c | | P 64 | | P 64 2 2 | | P 65 | | P 65 2 2 | | P a | | P a -3 | | P a 3 | | P a-3 | | P b -3 | | P b 2 n | | P b 21 a | | P b 21 m | | P b a 2 | | P b a a | | P b a m | | P b a n | | P b c 21 | | P b c a | | P b c m | | P b c n | | P b m 2 | | P b m a | | P b m m | | P b m n | | P b n 21 | | P b n a | | P b n b | | P b n m | | P b n m S | | P b n n | | P bca | | P bcn | | P c | | P c 21 b | | P c 21 n | | P c a 21 | | P c a a | | P c a b | | P c a m | | P c a n | | P c c a | | P c c n | | P c m 21 | | P c m a | | P c m b | | P c m n | | P c n b | | P c n n | | P d 3 m | | P m -3 | | P m -3 m | | P m -3 n | | P m 1 1 | | P m 2 a | | P m 2 m | | P m 3 m | | P m 3 n | | P m a 2 | | P m a b | | P m a m | | P m a n | | P m c 21 | | P m c b | | P m c n | | P m c n S1 | | P m c n S2 | | P m m 2 | | P m m a | | P m m m | | P m m n | | P m m n {origin @ m m 2/n} | | P m m n S | | P m m n Z | | P m n 21 | | P m n 21 S | | P m n a | | P m n b | | P m n b S | | P m n m | | P m n m S | | P m n m Z | | P m n n | | P n | | P n -3 | | P n -3 m | | P n -3 m S | | P n -3 m Z | | P n -3 n | | P n -3 n Z | | P n -3 S | | P n -3 Z | | P n 1 1 | | P n 21 a | | P n 21 m | | P n 3 | | P n 3 m | | P n a 21 | | P n a a | | P n a b | | P n a m | | P n a n | | P n c 2 | | P n c a | | P n c b S | | P n c m | | P n c n | | P n m 21 | | P n m a | | P n m m | | P n m m S | | P n m m Z | | P n m n | | P n n 2 | | P n n a | | P n n m | | P n n n | | P na21 | | P nma | | P_1_21/a_1 | | P_1_21/c_1 | | P_1_21/n_1 | | P_21/n | | P_61_2_2 | | P-1 | | P-1 , No. 2 | | P-1(\a\b\g)0 | | P-3 | | P-31c | | P-31m | | P-3c1 | | P-3m1 | | P-4 | | P-4 21 c | | P-4-h(10)g(2)dcba | | P-421c | | P-421m | | P-43m | | P-6 | | P-62c | | P-62m | | P? | | P~cab~ | | P1 | | P1 2/n 1 | | P1- | | P112/n | | P1121/a | | P12(1)/c1 | | P12(1)/n1 | | P121/c1 | | P121/n1 | | P2 | | P2 (1) /m | | P2 1/n | | P2_1/n | | P2(1) | | P2(1)/a | | P2(1)/c | | P2(1)/m | | P2(1)/n | | P2(1)2(1)2(1) | | P2/c | | P2/m(\a1/2\g)00 | | P2/n | | P2~1~ | | P2~1~/a | | P2~1~/c | | P2~1~/n | | P2~1~2~1~2~1~ | | P21 | | p21 21 2 | | P21 21 21 | | P21 or P21/m | | P21.a | | P21/a | | P21/c | | P21/c? | | P21/c(\a0\g)00 | | P21/m | | P21/n | | P21212 | | P212121 | | P213 | | P21cn | | P21nb | | P3 | | P3(1)21 | | P3(2)21 | | P321 | | P3221 | | P3c& | | P3c1 | | P3m1 | | P4(1) | | P4(1)2(1)2 | | P4(2)/n | | P4(3)2(1)2 | | P4/m b m | | P4/m c c | | P4/m m m | | P4/m n c | | P4/mbm | | P4/mcc | | P4/mmm | | P4/n | | P4/n b m | | P4/n c c | | P4/n m m | | P4/n n c | | P4/nbm | | P4/ncc | | P4/nmm | | P41 | | P41212 | | P4132 | | P42 mnm | | P42/m b c | | P42/m n m | | P42/mnm | | P42/n | | P42/n c m | | P42/n m c | | P42/nmc | | P422 | | P42bc | | p43 | | P43-n | | P43212 | | P4332 | | P4bm | | P4mm | | P4mmc | | P6 | | P6(3) | | P6(3)/mmc | | P6(3)mc | | P6(5)22 | | P6/mmm | | P6122 | | P63/m | | P63/mcm | | P63/mmc | | P63mc | | P6522 | | Pa-3 | | Pa3 | | Pbc2 | | Pbc2(1) | | Pbc2~1~ | | Pbc21 | | Pbca | | Pbcm | | Pbcn | | Pbma | | Pbmm | | Pbnm | | Pc | | Pc21n | | Pca2 | | Pca2(1) | | Pca21 | | Pcab | | Pcam | | Pcc2 | | Pcca | | Pccn | | Pcmn | | Pm n a | | Pm-3 | | Pm-3m | | Pm-3n | | Pm3m | | Pmc2(1) | | Pmc21 | | Pmcn | | Pmmm | | Pmmn | | Pmn2 | | Pmn2(1) | | Pmn21 | | Pmna | | Pmnb | | Pn | | Pn (No.7) | | Pn m a | | Pn-3 | | Pn3- | | Pna2(1) | | Pna21 | | Pnam | | Pnma | | Pnmm | | Pnna | | Pnnm | | R -3 | | R -3 {hexagonal axes} | | R -3 {rhombohedral axes} | | R -3 2/c | | R -3 2/m | | R -3 c | | R -3 c {hexagonal axes} | | R -3 c {rhombohedral axes} | | R -3 c H | | R -3 c R | | R -3 c RS | | R -3 cr {rhombohedral axes} | | R -3 H | | R -3 HR | | R -3 m | | R -3 m {hexagonal axes} | | R -3 m {rhombohedral axes} | | R -3 m H | | R -3 m HR | | R -3 m R | | R -3 m:h | | R -3 R | | R -3:H | | r -3:r | | R -3c | | R -3m | | R ? | | R ? ? | | R ?? | | R 1 2/c 1 | | R 3 | | R 3 {hexagonal axes} | | R 3 {rhombohedral axes} | | R 3 2 | | R 3 2 {hexagonal axes} | | R 3 2 H | | R 3 2 R | | R 3 c | | R 3 c {hexagonal axes} | | R 3 c {hexagonalal axes} | | R 3 c {rhombohedral axes} | | R 3 c H | | R 3 c R | | R 3 H | | R 3 m | | R 3 m {hexagonal axes} | | R 3 m H | | R 3 m R | | R 3 R | | R 32 | | R 32r | | R 3c | | R_-3_c | | R-3 | | R-3c | | R-3m | | R-3m(00\g)0s | | R??? | | R3 | | R32 | | R3c | | R3m | | rhombohedral | | tetragonal | | triclinic | | unknown | | X-3c1(00\g)000 | | x, y, z | | X2/m | | X2/m(\a0\g)0s | | X4bm | | Xmcm(0\b0)s0s | | Xmcm(00g)000 | +----------------------------------+ 990 rows in set (0.00 sec)