Skip to content

Grouping SQL rows for assay data

Bruno Costa edited this page Jan 9, 2020 · 2 revisions

Group element is used to glue sql rows together

Reserved elements: group, attributes, header, metadata

"group":{
	_table:"Annotation",
	Sequence:{
		_table:["Mature_miRNA","Mature_miRNA_sequence"],
		_attribute:"sequence"
	}
	
},
"attributes":{
	_table:"Annotation",
	Sequence:{
		_table:["Mature_miRNA","Mature_miRNA_sequence"],
		_attribute:"sequence"
	},
	Name:{
		_table:"Mature_miRNA",
		_attribute:"name"
	},
	Accession:{
		_table:"Mature_miRNA",
		_attribute:"accession"
	}
},
"header":{
	_table:"Assay",
	"assayName":"name",
},
"raw":"",
"cpm":"",
metadata:{
	_table:"./",
	row:{
		_table:"Assay",
		assayId:"id"		
	},
	cell:{
		_table:"./",
		id:"",
		assayId:{_table:"Assay",_attribute:"id"}
	}
}
Clone this wiki locally