OCP Dataset

Open Cannabis Project Data

@kaggle.ostaski_ocp_dataset

Table List

1 table(124.88 KB)

Ocpdb

@kaggle.ostaski_ocp_dataset.ocpdb

124.88 KB
1099 rows
58 columns

ocpid OCPID	strain Strain	sampleid SampleID	daterecorded DateRecorded	reporttype ReportType	chemicallab ChemicalLab	h2o H2O	totalthc TotalTHC	thc THC	thca THCA	totalcbd TotalCBD	cbda CBDA	n__pinene Α-Pinene	camphene Camphene	myrcene Myrcene	n__pinene_6d3fbc Β-Pinene	n_3_carene 3-Carene	n__terpinene Α-Terpinene	d_limonene D-Limonene	p_cymene P-Cymene	ocimene Ocimene	eucalyptol Eucalyptol	n__terpinene_373002 Γ-Terpinene	terpinolene Terpinolene	linalool Linalool	isopulegol Isopulegol	geraniol Geraniol	n__caryophyllene Β-Caryophyllene	n__humelene Α-Humelene	nerolidol_1 Nerolidol-1	nerolidol_2 Nerolidol-2	guaiol Guaiol	caryophylleneoxide CaryophylleneOxide	n__bisabolol Α-Bisabolol	geneticlab GeneticLab	sample Sample	sampleurl SampleURL	organism Organism	organismurl OrganismURL	project Project	projecturl ProjectURL	study Study	studyurl StudyURL	run Run	runurl RunURL	datepublished DatePublished	spots Spots	bases Bases	size Size
420	CHEM 4	17002739	12 May 2018	C	Cascadia Labs	8.60%	193	193	203			0.18	0.04	1.16	0.22		0.03	1.57		0.15	0.05	0.03	0.04	0.37			5.48	2.03					0.87	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan
421	Z7	17002740	12 May 2018	C	Cascadia Labs	8.50%				140	147	0.16	0.03	5.15	0.1		0.03	0.9	0.09		0.03	0.03	0.04	0.25			2.35	1.14			0.25		0.62	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan
422	ACDC/Harlequin	17002741	12 May 2018	C	Cascadia Labs	14.80%	141	141	138	56	55	0.22	0.04	3.66	0.15			1.72	0.05	0.08	0.06	0.04	0.04	0.39			3.11	1.2			0.2		0.32	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan
423	HarleyWreck	17002742	12 May 2018	C	Cascadia Labs	8.40%	75	75	79	38	40	0.14	0.02	3.41	0.16		0.04	1.06	0.07	0.15	0.09	0.04	0.1	0.42			2.95	0.99			0.25		0.25	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan
424	Sour Amnesia	17002833	12 May 2018	C	Cascadia Labs	13.20%	222	222	222			0.84	0.08	2.03	0.42	0.29	0.3	1.05	0.21	3.03	0.06	0.33	3.91	0.28			1.42	0.58					0.19	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan
425	Jack Herer	17002834	12 May 2018	C	Cascadia Labs	10.10%	245	245	253			0.79	0.04	2.91	0.64	0.35	0.28	1.67	0.19	4.27	0.05	0.37	4.65	0.44			1.7	0.76			0.31		0.35	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan
426	Critical Cheese	17002835	12 May 2018	C	Cascadia Labs	10.60%	138	138	142			4.64	0.22	4.24	1.47		0.04	1.57		0.15		0.03	0.11	0.89			0.83	0.44						nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan
427	Sour Tangie	17002836	12 May 2018	B	Cascadia Labs	10.10%	254	254	263			2.26	0.17	5.68	0.62	0.03	0.03	1.3		0.07		0.02	0.06	1.02	0.11	0.16	0.63	0.29	0.14	0.1	0.08	0.07	0.12	Phylos Bioscience	SRS3289200	<a href="https://www.ncbi.nlm.nih.gov/sra?term=SRS3289200" target="_blank">SRS3289200</a>	Cannabis sativa	<a href="https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?mode=Info&id=3483" target="_blank">Cannabis sativa</a>	PRJNA470994	<a href="https://www.ncbi.nlm.nih.gov/bioproject/PRJNA470994" target="_blank"><small>PRJNA470994</small></a>	SRP145424	<a href="https://trace.ncbi.nlm.nih.gov/Traces/sra?study=SRP145424" target="_blank"><small>SRP145424</small></a>	SRR7151893	<a href="https://trace.ncbi.nlm.nih.gov/Traces/sra/?run=SRR7151893" target="_blank"><small>SRR7151893</small></a>	Fri May 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	948527	143216564	39.7 MB
428	WildFire	17002837	12 May 2018	C	Cascadia Labs	8.20%	165	165	174			0.6	0.2	3.84	0.78		0.03	4.1		0.14		0.03	0.09	1.08			3.22	1.33					0.41	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan
429	Papaya	17002845	12 May 2018	C	Cascadia Labs	9.30%	119	119	124	62	65	0.96	0.13	3.75	0.39			3.03	0.05	0.89	0.06	0.04	0.06	0.52			0.86	0.32					0.2	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan				nan


CREATE TABLE ocpdb (
  "ocpid" BIGINT,
  "strain" VARCHAR,
  "sampleid" DOUBLE,
  "daterecorded" VARCHAR,
  "reporttype" VARCHAR,
  "chemicallab" VARCHAR,
  "h2o" VARCHAR,
  "totalthc" DOUBLE,
  "thc" DOUBLE,
  "n__8_thc" DOUBLE,
  "n__9_thc" DOUBLE,
  "thca" DOUBLE,
  "thcv" DOUBLE,
  "totalcbd" DOUBLE,
  "cbda" DOUBLE,
  "cbdv" DOUBLE,
  "cbdva" DOUBLE,
  "cbc" DOUBLE,
  "cbg" DOUBLE,
  "cbn" DOUBLE,
  "n__pinene" DOUBLE,
  "camphene" DOUBLE,
  "myrcene" DOUBLE,
  "n__pinene_6d3fbc" DOUBLE,
  "n_3_carene" DOUBLE,
  "n__terpinene" DOUBLE,
  "d_limonene" DOUBLE,
  "p_cymene" DOUBLE,
  "ocimene" DOUBLE,
  "eucalyptol" DOUBLE,
  "n__terpinene_373002" DOUBLE,
  "terpinolene" DOUBLE,
  "linalool" DOUBLE,
  "isopulegol" DOUBLE,
  "geraniol" DOUBLE,
  "n__caryophyllene" DOUBLE,
  "n__humelene" DOUBLE,
  "nerolidol_1" DOUBLE,
  "nerolidol_2" DOUBLE,
  "guaiol" DOUBLE,
  "caryophylleneoxide" DOUBLE,
  "n__bisabolol" DOUBLE,
  "geneticlab" VARCHAR,
  "sample" VARCHAR,
  "sampleurl" VARCHAR,
  "organism" VARCHAR,
  "organismurl" VARCHAR,
  "project" VARCHAR,
  "projecturl" VARCHAR,
  "study" VARCHAR,
  "studyurl" VARCHAR,
  "run" VARCHAR,
  "runurl" VARCHAR,
  "datepublished" TIMESTAMP,
  "spots" DOUBLE,
  "bases" DOUBLE,
  "size" VARCHAR,
  "notes" VARCHAR
);