/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Experiment` (
  `CELL_LINE` varchar(25) NOT NULL,
  `species` varchar(25) DEFAULT NULL,
  `ensembl_ve` varchar(5) DEFAULT NULL,
  `mapper` varchar(12) DEFAULT NULL,
  `unique` varchar(3) DEFAULT NULL,
  `adapter_seq` varchar(50) DEFAULT NULL,
  `read_type` varchar(15) DEFAULT NULL,
  `read_length` varchar(3) DEFAULT NULL,
  `normal_tot_rRNA` varchar(20) DEFAULT NULL,
  `normal_tot_genomic` varchar(20) DEFAULT NULL,
  `normal_tot_phix` varchar(20) DEFAULT NULL,
  `normal_map_rRNA` varchar(20) DEFAULT NULL,
  `normal_map_genomic` varchar(20) DEFAULT NULL,
  `normal_map_phix` varchar(20) DEFAULT NULL,
  `normal_map_sRNA` varchar(20) DEFAULT NULL,
  `normal_map_tRNA` varchar(20) DEFAULT NULL,
  `treated_tot_rRNA` varchar(20) DEFAULT NULL,
  `treated_tot_genomic` varchar(20) DEFAULT NULL,
  `treated_tot_phix` varchar(20) DEFAULT NULL,
  `treated_map_rRNA` varchar(20) DEFAULT NULL,
  `treated_map_genomic` varchar(20) DEFAULT NULL,
  `treated_map_phix` varchar(20) DEFAULT NULL,
  `treated_map_sRNA` varchar(20) DEFAULT NULL,
  `treated_map_tRNA` varchar(20) DEFAULT NULL,
  `RPF_length` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `Experiment` VALUES ('guo_2010_mmu','mouse','87','STAR','N','TCGTATGCCGTCTTCTGCTTG','ribo','36','40212373','25311926','','14827334','21778652','','59583','13530','','','','','','','','','29_30'),('hurt_2013','mouse','87','STAR','N','AAAAAAAAAA','ribo','36','571938788','164542959','','391025776','157406015','','15805243','564810','','','','','','','','','28_29_30'),('ingolia_2014_mmu','mouse','87','STAR','N','CTGTAGGCACCATCAAT','ribo','36','310854993','133785264','','167903711','112557639','','8287303','878715','','','','','','','','','29_30_31'),('thoreen_2012','mouse','87','STAR','N','AAAAAAAA','ribo','36','132266208','56823109','','74455462','43645645','','715839','271798','','','','','','','','','28_29_30'),('eichorn_3t3_2014','mouse','87','STAR','N','TCGTATGCCGTCTTCTG','ribo','36','744454467','592079927','','146522780','516146827','','600216','5251544','','','','','','','','','30_31_32'),('eichorn_liver_2014','mouse','87','STAR','N','TCGTATGCCGTCTTCTG','ribo','36','193882701','189556729','','2976172','177563434','','117469','1232331','','','','','','','','','31_32_33'),('gonzalez_2014_mmu','mouse','87','STAR','N','CTGTAGGCACCAT','ribo','36','409721959','73424558','','333510938','47376364','','2698931','87532','','','','','','','','','29_30'),('jovanovic_2015','mouse','87','STAR','N','CTGTAGGCACCAT','ribo','36','77492379','22568384','','54226082','20018184','','556021','141892','','','','','','','','','29_30_31'),('ingolia_2011','mouse','87','STAR','N','CTGTAGGCACCATCAAT','ribo','36','292768663','203709536','','84265010','101185224','','4460024','334093','208161053','102917335','','95869579','81368966','','8656878','717261','31_32_33'),('lee_2012_mmu','mouse','87','STAR','N','AAAAAAA','ribo','36','14444521','4826302','','9409583','3321949','','162256','46380','42809237','5210882','','36673926','2349955','','922993','1436','28_29'),('blanco_2016','mouse','87','STAR','N','TGGAATTCTCGGGTGCC','ribo_untr','36','51305240','38385873','','10516976','34134096','','302379','2100012','','','','','','','','','26_27_28'),('castaneda_2014','mouse','87','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','287116334','33601552','','251964743','24636361','','1419018','131021','','','','','','','','','28_29'),('cho_2015','mouse','87','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','2558679164','2073091623','','401705284','1988656045','','50375940','33506317','','','','','','','','','29_30'),('deklerck_2015','mouse','87','STAR','N','CGCCTTGGCCGTACAGCAGA','ribo','36','231538398','136132827','','84523785','85732116','','4994011','5887775','273312137','84493538','','184450581','43056565','','2671456','1696562','28_29'),('fields_2015','mouse','87','STAR','N','CTGTAGGCACCATCAAT','ribo','36','522541603','325027642','','167906098','299417788','','25562479','4045384','997801214','233578376','','737970323','175624224','','18579783','7672732','30_31'),('gao_mef_2014','mouse','87','STAR','N','CTGTAGGCACCATCAAT','ribo','36','72355694','53526002','','16362945','40213120','','2372004','94743','57007658','9702632','','46958497','6283638','','340985','5544','27_28'),('gao_liver_2014','mouse','87','STAR','N','CTGTAGGCACCATCAAT','ribo','36','55644719','7455053','','48146363','4323880','','40437','2866','46414543','4557383','','41822873','1962995','','31830','2457','27_28'),('gerashchenko_2016','mouse','87','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','82061329','26957617','','54405063','24009494','','675254','23395','','','','','','','','','28_29_30'),('janich_2015','mouse','87','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','381556445','270314766','','103774501','223859513','','7026784','440394','','','','','','','','','29_30'),('you_2015','mouse','87','STAR','N','TGGAATTCTCGGGTGCC','ribo_untr','36','867884151','353336111','','498626048','307223572','','11597791','4324201','','','','','','','','','28_29'),('katz_2014','mouse','87','STAR','N','AAAAAAAAAAAA','ribo','36','762650330','176931039','','562144231','145494308','','23000719','574341','','','','','','','','','29_30_31'),('laguesse_2015','mouse','87','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','240620657','74590290','','156600658','56052514','','9404827','24882','','','','','','','','','29_30_31'),('reid_cytosol_2016','mouse','87','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','225563785','108082322','','115264989','90052427','','2205610','10864','','','','','','','','','32_33_34'),('reid_er_2016','mouse','87','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','191834192','66268317','','122293339','51409326','','3216690','55846','','','','','','','','','31_32'),('reid_2014','mouse','87','STAR','N','AGATCGGAAGAGCACAC','ribo','36','488871876','241877406','','236479893','185157987','','10406302','108275','','','','','','','','','32_33_34'),('diaz_munoz_2015','mouse','87','STAR','N','AGATCGGAAGAGCACACGTCT','ribo','36','473252888','247378749','','152767193','172092844','','72902171','204775','','','','','','','','','30_31'),('eichorn_bcell_2014','mouse','87','STAR','N','TCGTATGCCGTCTTCTG','ribo','36','1674924207','1292539686','','369226548','1061299893','','9082630','4075343','','','','','','','','','29_30_31'),('dunn_2014','fruitfly','87','STAR','N','CTGTAGGCACCATCAAT','ribo','36','40309979','27390780','','12350282','24961071','','76525','492392','45154808','24104093','','20667068','21528121','','105142','278505','None'),('kronja_2014','fruitfly','87','STAR','N','TCGTATGCCGTCTTCTGCTTG','ribo_untr','36','209138084','33509668','','173442546','23902819','','45936','2139934','','','','','','','','','None'),('aspden_2014','fruitfly','87','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','347408013','37989732','','290940835','21327857','','552786','17924660','','','','','','','','','None'),('bazinni_2014','zebrafish','88','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','1896261467','1295109089','','575460417','1151615859','','3102375','22589586','','','','','','','','','27_28'),('lee_2013','zebrafish','88','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','96198583','67257554','','28157802','60282703','','106244','676983','','','','','','','','','28_29'),('chew_2013','zebrafish','88','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','930053282','602056482','','313541525','584779611','','198657','14256618','','','','','','','','','28_29'),('arnold_c14_2014','c.elegans','89','STAR','N','TGGAATTCTCGGGTGCCAAGG','ribo_untr','36','131497977','47447147','','68721618','35163795','','1719726','13609486','','','','','','','','','30_31'),('arnold_n2_2014','c.elegans','89','STAR','N','TGGAATTCTCGGGTGCCAAGG','ribo_untr','36','245003433','100518244','','115893073','78465109','','3534717','25057399','','','','','','','','','30_31'),('hendriks_2014','c.elegans','89','STAR','N','TGGAATTCTCGGGTGCC','ribo_untr','36','454164004','310743280','','139551597','290052048','','2587077','1282050','','','','','','','','','29_30'),('nedialkova_2015','c.elegans','89','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','226774346','68927823','','151916803','41268679','','529617','5400103','','','','','','','','','29_30_31'),('stadler_2012','c.elegans','89','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','456497360','167319253','','282871230','97542267','','947359','5359518','','','','','','','','','29_30_31'),('stadler_fire_2011','c.elegans','89','STAR','N','AAAAAAAAAAA','ribo_untr','36','120902859','37623500','','78924502','33084564','','396633','3958224','','','','','','','','','29_30_31'),('andreev_2015_rat','rat','89','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','922673938','131932359','','789429520','120007726','','1308676','3383','','','','','','','','','30_31'),('ori_brain_2015','rat','89','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','203807604','143993331','','27648174','128908017','','30664397','1501702','','','','','','','','','28_29'),('ori_liver_2015','rat','89','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','294363997','192921039','','78731341','173304375','','22069633','641984','','','','','','','','','31_32'),('schafer_heart_2015','rat','89','STAR','N','AGATCGGAAGAGCACACGTCT','ribo_untr','36','576627895','460277983','','89594181','447309777','','21462772','5292959','','','','','','','','','28_29_30'),('schafer_liver_2015','rat','89','STAR','N','AGATCGGAAGAGCACACGTCT','ribo_untr','36','719532272','505483440','','204217342','496650302','','9010809','820681','','','','','','','','','28_29_30'),('jakobsson_2017','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','77988591','30046110','','43500461','26371187','','2308686','2133334','','','77988885','','','294','','','30_31'),('malecki_2017','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','27300264','11133388','','14263399','10798625','','1370206','533271','','','27300678','','','414','','','29_30_31'),('mills_2016','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','1181094582','224430649','','832444400','201517772','','48927571','75291962','','','1181965961','','','871379','','','30_31_32'),('park_2017','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','105198600','16443656','','82323601','12519956','','2003587','4427756','','','105198778','','','178','','','31_32_33'),('shi_2017','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','122190772','3365218','','117913505','2079007','','386460','525589','','','122331898','','','141126','','','26_27'),('zhang_2017','human','91','STAR','N','CTGTAGGCACCATCAAT','ribo','36','56312467','39445366','','9653224','36366958','','6217359','996518','28387893','11972270','56354218','10711011','10528327','41751','5540268','164344','29_30'),('loayza_puch_2016','human','92','STAR','N','TGGAATTCTCGGGTGCC','ribo_untr','36','29296847','10012084','','9397346','5273610','','9101308','786109','','','','','','','','','30_31_32'),('calviello_2016','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','31966016','27519114','','3123022','25726661','','845738','478142','','','31967082','','','1066','','','28_29_30'),('park_2016','human','92','STAR','N','TGGAATTCTCGGGTGCC','ribo_untr','36','1222911194','453359209','','522355050','377321368','','92664798','154532137','','','1222912983','','','1789','','','28_29_30'),('rutkowski_2015','human','92','STAR','N','AGATCGGAAGAGCGGTTCAG','ribo_untr','36','547719419','74569838','','467261446','56986395','','4374602','1513533','','','','','','','','','28_29'),('andreev_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','249223465','19994876','','228216873','17535316','','545809','465907','','','251104707','','','1881242','','','29_30_31'),('wang_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','147607454','38257254','','104947271','27924167','','2681261','1721668','','','147867656','','','260202','','','28_29_30'),('werner_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','600591560','151184246','','445082145','118228464','','3274690','1050479','','','','','','','','','28_29_30'),('ji_BJ_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo','36','92968738','18116818','','73589542','16278402','','744818','517560','101088318','5043425','93367964','95642530','3185630','399226','291255','111108','28_29'),('ji_breast_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo','36','245363147','37165598','','206822590','31709138','','654436','720523','56961251','1971938','246667469','54866679','1500664','1304322','80512','42122','28_29'),('gawron_2016','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo','36','317495673','170197628','','121624927','156444645','','22372391','3300727','240001595','124278639','320196759','92153128','116827338','2701086','18925882','4643946','29_30_31'),('tirosh_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','532398265','114454427','','406104702','93318782','','7392569','4446567','','','','','','','','','29_30'),('iwasaki_2016','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','449900789','38776897','','409367678','34556802','','1467123','289091','','','449904218','','','3429','','','28_29'),('grow_2015','human','92','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','286005482','97541278','','112668960','71463607','','61707907','14087337','','','286005483','','','1','','','33_34'),('su_2015','human','92','STAR','N','AAAAAAAAAAAAA','ribo_untr','36','175879180','66625093','','103090297','64312305','','2801591','3362199','','','177472911','','','1593731','','','33_34'),('zur_2016','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','353869147','97800387','','200269977','90478642','','37201263','18597520','','','353870825','','','1678','','','29_30_31'),('elkon_2015','human','92','STAR','N','TGGAATTCTCGGGTGCCAAGG','ribo_untr','36','252426269','129803198','','111507229','54721802','','7695914','3419928','','','','','','','','','29_30'),('niu_2014','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','319303525','225070887','','78107376','184458708','','6740681','9384581','','','','','','','','','0'),('crappe_2014','human','92','STAR','N','AGATCGGAAGAGCACAC','ribo','36','128049354','27151249','','96179452','22206635','','1025453','3693200','135585502','40293248','','90119179','32109503','','1791609','3381466','28_29'),('eichorn_2014','human','92','STAR','N','GCTCGTATGC','ribo_untr','36','32668927','7369195','','1837163','6997536','','168492','23294077','','','32669006','','','79','','','29_30'),('gonzalez_2014','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','228996104','86864708','','136554264','70661307','','746658','4830474','','','229642241','','','646137','','','28_29'),('guo_2014','human','92','STAR','N','TCGTATGCCGTCTTCTG','ribo_untr','36','116224785','81232216','','30119723','70742902','','2052902','2819944','','','116224986','','','201','','','29_30'),('ingolia_2014','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','132473181','129560738','','1495727','37685864','','659483','757233','','','132474479','','','1298','','','28_29'),('jan_2014','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','65343582','10516089','','53667729','8761441','','298012','861752','','','65453066','','','109484','','','30_31'),('rubio_2014','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','535845416','417946503','','10563179','385184371','','25964657','81371077','','','','','','','','','30_31_32'),('tanenbaum_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','874599182','104038477','','723205879','85808078','','43664383','3690443','','','','','','','','','29_30_31'),('wein_2014','human','92','STAR','N','TGGAATTCTCGGGTGCC','ribo_untr','36','918223','916765','','31','915111','','1384','43','','','','','','','','','28_29'),('yoon_2014','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','33167461','2934249','','29559703','1986531','','632354','41155','','','33167548','','','87','','','29_30'),('xu_2016','human','92','STAR','N','AGATCGGAAGAGCACAC','ribo_untr','36','358466272','108636435','','211530090','97335633','','33489757','4809990','','','359341359','','','875087','','','28_29'),('cenik_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','2287427059','572179234','','1247420035','307152969','','171155883','296671907','','','','','','','','','29_30_31'),('fritsch_2012','human','92','STAR','N','AAAAAAAAAAAAAAAAAAAA','ribo_untr','36','219741529','55100961','','161300920','53371041','','236108','3103540','','','','','','','','','29_30'),('stern_ginossar_2012','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo','36','38918671','19199294','','18822718','15257599','','277059','619600','95023060','13403862','','79494896','7501664','','1191328','932974','29_30_31'),('ingolia_2012','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','190371072','15876659','','173593272','13900767','','753565','147576','','','190371422','','','350','','','28_29'),('liu_HEK_2013','human','92','STAR','N','AAAAAAAAAAAA','ribo_untr','36','201405789','68800454','','121919958','37547300','','8092711','2592666','','','','','','','','','28_29'),('liu_Hela_2013','human','92','STAR','N','AAAAAAAAAAA','ribo_untr','36','70165272','12897999','','55981523','11675205','','1167837','117913','','','73333641','','','3168369','','','28_29'),('loayza_puch_2013','human','92','STAR','N','TCGTATGCCGTCTTCT','ribo_untr','36','1852547613','222743281','','1596792835','125532206','','12222181','20789316','','','','','','','','','29_30'),('rooijers_2013','human','92','STAR','N','TCGTATGCCGTCTTCTGCTTG','ribo_untr','36','277710699','26569697','','202049506','15951526','','5247585','43843911','','','','','','','','','28_29_30'),('wiita_2013','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','109822674','65255675','','22931','56819583','','35936228','8607840','','','','','','','','','30_31_32'),('lee_2012','human','92','STAR','N','AAAAAAAAAAA','ribo','36','45163281','13263801','','30522939','11191370','','1231167','145374','34292298','5818778','45163537','26791447','5297780','256','1465094','216979','28_29'),('stumpf_2013','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo','36','38918671','19199294','','18822718','15257599','','277059','619600','95023060','13403862','','79494896','7501664','','1191328','932974','29_30_31'),('sidrauski_2015','human','92','STAR','N','CTGTAGGCACCATCAAT','ribo_untr','36','646839322','88122992','','546986699','82188875','','2032929','9696702','','','','','','','','','30_31_32');
