Manual Phenotyping Database
The manual phenotyping database contains phenotypic field data that was collected by hand.
The main tables in the manual phenotyping database are shown in the figure below.
The query below is an example of how to generate a monthly report of the PCTHEAD (percent heading) trait.
SET SESSION group_concat_max_len = 10000;
SET @SQL = NULL;
'MAX(IF(phenotype_date = ''', `phenotype_date`, ''',phenotype_value,NULL)) AS ''', `phenotype_date`,'''')
) INTO @SQL FROM phenotype WHERE YEAR(phenotype_date) = 2016;
SET @SQL = CONCAT('SELECT entity_id, ', @SQL, '
FROM phenotype WHERE phenotype.entity_id LIKE ''%16ASH0%'' AND phenotype.trait_id LIKE ''%PCTHEAD%''
GROUP BY entity_id');
PREPARE stmt FROM @SQL;
DEALLOCATE PREPARE stmt;