-- MySQL dump 10.13  Distrib 8.0.36, for Win64 (x86_64)
--
-- Host: localhost    Database: pesticides
-- ------------------------------------------------------
-- Server version	8.0.36

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `reaction_types`
--

DROP TABLE IF EXISTS `reaction_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reaction_types` (
  `reaction_id` int NOT NULL,
  `enzymes` varchar(100) NOT NULL,
  `biosystem` varchar(100) NOT NULL,
  `biotransformerrule` varchar(100) NOT NULL,
  PRIMARY KEY (`reaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reaction_types`
--

LOCK TABLES `reaction_types` WRITE;
/*!40000 ALTER TABLE `reaction_types` DISABLE KEYS */;
INSERT INTO `reaction_types` VALUES (1,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0027'),(2,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0029'),(3,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0030'),(4,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0031'),(5,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0063_PATTERN2'),(6,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0022_PATTERN1'),(7,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0080'),(8,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0330_PATTERN3'),(9,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0071'),(10,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0379'),(11,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0050'),(12,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0241'),(13,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0295_PATTERN2'),(14,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0023_PATTERN2'),(15,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0193'),(16,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0005_PATTERN3'),(17,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0327'),(18,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0022_PATTERN2'),(19,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0337_PATTERN1'),(20,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0065_PATTERN2'),(21,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0067_PATTERN1'),(22,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0275'),(23,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0162'),(24,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0051_PATTERN2'),(25,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0291_PATTERN1'),(26,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0353'),(27,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0374_PATTERN2'),(28,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0073'),(29,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0242_PATTERN1'),(30,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0243'),(31,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0420_PATTERN1'),(32,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0028'),(33,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0259'),(34,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0049'),(35,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0414'),(36,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0318_PATTERN2'),(37,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0440'),(38,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0020'),(39,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0068'),(40,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0070'),(41,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0332'),(42,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0002'),(43,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0330_PATTERN4'),(44,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0024_PATTERN1'),(45,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0333'),(46,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0286'),(47,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0430'),(48,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0402'),(49,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0144'),(50,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0330_PATTERN6'),(51,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0330_PATTERN5'),(52,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0389'),(53,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0011'),(54,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0036'),(55,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0044'),(56,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0023_PATTERN1'),(57,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0375'),(58,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0102'),(59,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0103_PATTERN1'),(60,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0013'),(61,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0042'),(62,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0108'),(63,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0383'),(64,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0065_PATTERN1'),(65,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0334'),(66,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0242_PATTERN3'),(67,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0001'),(68,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0014'),(69,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0064'),(70,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0021_PATTERN2'),(71,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0361'),(72,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0432_PATTERN2'),(73,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0158_PATTERN2'),(74,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0104_PATTERN1'),(75,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0260'),(76,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0158_PATTERN1'),(77,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0055_PATTERN2'),(78,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0051_PATTERN3'),(79,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0429'),(80,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0391_PATTERN2'),(81,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0003'),(82,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0295_PATTERN1'),(83,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0368'),(84,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0008'),(85,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0254_PATTERN2'),(86,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0393'),(87,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0374_PATTERN1'),(88,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0351_PATTERN6'),(89,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0231'),(90,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0342'),(91,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0061'),(92,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0373'),(93,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0306'),(94,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0388_PATTERN4'),(95,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0219'),(96,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0376'),(97,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0210'),(98,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0174'),(99,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0154'),(100,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0351_PATTERN7'),(101,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0359'),(102,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0388_PATTERN2'),(103,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0143'),(104,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0423_PATTERN2'),(105,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0357_PATTERN1'),(106,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0318_PATTERN1'),(107,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0208'),(108,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0209'),(109,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0325'),(110,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0060'),(111,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0388_PATTERN3'),(112,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0021_PATTERN1'),(113,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0026'),(114,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0156_PATTERN1'),(115,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0427'),(116,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0357_PATTERN2'),(117,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0255_PATTERN2'),(118,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0351_PATTERN3'),(119,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0206'),(120,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0313'),(121,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0391_PATTERN1'),(122,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0195'),(123,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0394'),(124,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0040'),(125,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0352_PATTERN2'),(126,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0348_PATTERN4'),(127,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0352_PATTERN1'),(128,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0051_PATTERN4'),(129,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0352_PATTERN3'),(130,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0105'),(131,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0377'),(132,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0388_PATTERN1'),(133,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0218'),(134,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0041'),(135,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0192'),(136,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0442'),(137,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0443'),(138,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0370'),(139,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0104_PATTERN2'),(140,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0351_PATTERN8'),(141,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0352_PATTERN5'),(142,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0392'),(143,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0149_PATTERN1'),(144,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0180'),(145,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0351_PATTERN2'),(146,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0351_PATTERN1'),(147,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0202'),(148,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0337_PATTERN2'),(149,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0340_PATTERN2'),(150,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0352_PATTERN4'),(151,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0365'),(152,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0190'),(153,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0082'),(154,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0423_PATTERN1'),(155,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0337_PATTERN3'),(156,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0337_PATTERN4'),(157,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0051_PATTERN1'),(158,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0297'),(159,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0337_PATTERN5'),(160,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0348_PATTERN2'),(161,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0362_PATTERN4'),(162,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0337_PATTERN6'),(163,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0255_PATTERN1'),(164,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0362_PATTERN1'),(165,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0153_PATTERN1'),(166,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0358'),(167,'Unspecified environmental bacterial enzyme','ENVMICRO','EAWAG_RULE_BT0363');
/*!40000 ALTER TABLE `reaction_types` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-04-03 11:43:09
