|
|
EXCHANGE WITH RCSB.
MmCIF Categories Exported and Database Stored Procedures Generated
select ordinal,category_id,procedure_cif,procedure_xml
from categories_ok
| ORDINAL |
CATEGORY_ID
|
PROCEDURE_CIF
|
PROCEDURE_XML
|
| 1 | ATOM_SITE | SATOMSITE55 | XATOMSITE55 |
| 2 | ATOM_SITES | SATOMSITES53 | XATOMSITES53 |
| 3 | ATOM_TYPE | SATOMTYPE54 | XATOMTYPE54 |
| 4 | AUDIT_AUTHOR | SAUDITAUTHO7 | XAUDITAUTHO7 |
| 5 | CELL | SCELL11 | XCELL11 |
| 6 | CHEM_COMP | SCHEMCOMP21 | XCHEMCOMP21 |
| 7 | CITATION | SCITAT9 | XCITAT9 |
| 8 | CITATION_AUTHOR | SCITATAUTHO10 | XCITATAUTHO10 |
| 9 | CITATION_EDITOR | SCITATEDITO8 | XCITATEDITO8 |
| 10 | DATABASE_2 | SDATAB22 | XDATAB22 |
| 11 | DATABASE_PDB_CAVEAT | SDATABPDBCAVEA56 | XDATABPDBCAVEA56 |
| 12 | DATABASE_PDB_MATRIX | SDATABPDBMATRI52 | XDATABPDBMATRI52 |
| 13 | DATABASE_PDB_REV | SDATABPDBREV4 | XDATABPDBREV4 |
| 14 | DATABASE_PDB_REV_RECORD | SDATABPDBREVRECOR5 | XDATABPDBREVRECOR5 |
| 15 | DIFFRN | SDIFFR24 | XDIFFR24 |
| 16 | DIFFRN_DETECTOR | SDIFFRDETEC25 | XDIFFRDETEC25 |
| 17 | DIFFRN_MEASUREMENT | SDIFFRMEASU59 | XDIFFRMEASU59 |
| 18 | DIFFRN_RADIATION | SDIFFRRADIA26 | XDIFFRRADIA26 |
| 19 | DIFFRN_RADIATION_WAVELENGTH | SDIFFRRADIAWAVEL27 | XDIFFRRADIAWAVEL27 |
| 20 | DIFFRN_SOURCE | SDIFFRSOURC28 | XDIFFRSOURC28 |
| 21 | ENTITY | ENTIT13 | XENTIT13 |
| 22 | ENTITY_KEYWORDS | SENTITKEYWO14 | XENTITKEYWO14 |
| 23 | ENTITY_POLY_SEQ | SENTITPOLYSEQ15 | XENTITPOLYSEQ15 |
| 24 | ENTITY_SRC_GEN | SENTITSRCGEN16 | XENTITSRCGEN16 |
| 25 | ENTITY_SRC_NAT | SENTITSRCNAT17 | XENTITSRCNAT17 |
| 26 | ENTRY | SENTRY1 | XENTRY1 |
| 27 | EXPTL | SEXPTL22 | XEXPTL22 |
| 28 | EXPTL_CRYSTAL | SEXPTLCRYST23 | XEXPTLCRYST23 |
| 29 | PDBX_DATABASE_PDB_OBS_SPR | SPDBXDATABPDBOBSSPR6 | XPDBXDATABPDBOBSSPR6 |
| 30 | PDBX_DATABASE_STATUS | SPDBXDATABSTATU3 | XPDBXDATABSTATU3 |
| 31 | PDBX_NONPOLY_SCHEME | SPDBXNONPOSCHEM58 | XPDBXNONPOSCHEM58 |
| 32 | PDBX_POLY_SEQ_SCHEME | SPDBXPOLYSEQSCHEM57 | XPDBXPOLYSEQSCHEM57 |
| 33 | PDBX_REFINE | SPDBXREFIN34 | XPDBXREFIN34 |
| 34 | PDBX_STRUCT_SHEET_HBOND | SPDBXSTRUCSHEETHBOND49 | XPDBXSTRUCSHEETHBOND49 |
| 35 | PDBX_XPLOR_FILE | SPDBXXPLORFILE36 | XPDBXXPLORFILE36 |
| 36 | REFINE | SREFIN31 | XREFIN31 |
| 37 | REFINE_ANALYZE | SREFINANALY32 | XREFINANALY32 |
| 38 | REFINE_LS_RESTR | SREFINLSRESTR33 | XREFINLSRESTR33 |
| 39 | REFINE_LS_SHELL | SREFINLSSHELL35 | XREFINLSSHELL35 |
| 40 | REFLNS | SREFLN29 | XREFLN29 |
| 41 | REFLNS_SHELL | SREFLNSHELL30 | XREFLNSHELL30 |
| 42 | STRUCT | SSTRUC37 | XSTRUC37 |
| 43 | STRUCT_ASYM | SSTRUCASYM39 | XSTRUCASYM39 |
| 44 | STRUCT_BIOL | SSTRUCBIOL40 | XSTRUCBIOL40 |
| 45 | STRUCT_BIOL_GEN | SSTRUCBIOLGEN41 | XSTRUCBIOLGEN41 |
| 46 | STRUCT_CONF | SSTRUCCONF42 | XSTRUCCONF42 |
| 47 | STRUCT_CONF_TYPE | SSTRUCCONFTYPE43 | XSTRUCCONFTYPE43 |
| 48 | STRUCT_CONN | SSTRUCCONN44 | XSTRUCCONN44 |
| 49 | STRUCT_CONN_TYPE | SSTRUCCONNTYPE45 | XSTRUCCONNTYPE45 |
| 50 | STRUCT_KEYWORDS | SSTRUCKEYWO38 | XSTRUCKEYWO38 |
| 51 | STRUCT_REF | SSTRUCREF18 | XSTRUCREF18 |
| 52 | STRUCT_REF_SEQ | SSTRUCREFSEQ19 | XSTRUCREFSEQ19 |
| 53 | STRUCT_REF_SEQ_DIF | SSTRUCREFSEQDIF20 | XSTRUCREFSEQDIF20 |
| 54 | STRUCT_SHEET | SSTRUCSHEET46 | XSTRUCSHEET46 |
| 55 | STRUCT_SHEET_ORDER | SSTRUCSHEETORDER47 | XSTRUCSHEETORDER47 |
| 56 | STRUCT_SHEET_RANGE | SSTRUCSHEETRANGE48 | XSTRUCSHEETRANGE48 |
| 57 | STRUCT_SITE | SSTRUCSITE50 | XSTRUCSITE50 |
| 58 | STRUCT_SITE_GEN | SSTRUCSITEGEN51 | XSTRUCSITEGEN51 |
| 59 | SYMMETRY | SSYMME12 | XSYMME12 |
|