[Cod-bugs] Query about experimental condition information for entries

[Andrius Merkys]

Dear Jiuyang,

On 2019-09-17 15:55, J. Zhao wrote:
>
> I notice that only very few entires have '_diffrn_ambient_pressure'
> and '_diffrn_ambient_temperature', only around 1.9k out of ~400,000.
>
> Is it normal or my problem of searching?
>
I have checked the counts of entries with defined 'diffrtemp'
('_diffrn_ambient_temperature') and 'diffrpressure'
('_diffrn_ambient_pressure') values:

andrius at suopis ~ $ mysql -u cod_reader -h www.crystallography.net cod -e
'select count(*) from data where diffrtemp is not null' -N
+--------+
| 344017 |
+--------+
andrius at suopis ~ $ mysql -u cod_reader -h www.crystallography.net cod -e
'select count(*) from data where diffrpressure is not null' -N
+------+
| 3353 |
+------+

So while the number of records with pressure is really low, 3/4 of all
the records contain information about temperature.

Hope this helps,
Andrius

-- 
Andrius Merkys
Vilnius University Institute of Biotechnology, Saulėtekio al. 7, room V325
LT-10257 Vilnius, Lithuania