[ensembl-dev] mysql homo_sapiens_otherfeatures_97_38 content
Jerome Roy
jerome at wuxinextcode.com
Tue Aug 13 15:35:00 BST 2019
Hi,
Apologies if there's a simple explanation I missed; I was accessing the mysql db and noticed missing data that I was expecting in the homo_sapiens_otherfeatures_97_38.gene table:
(none)> select source,count(*) from homo_sapiens_otherfeatures_97_38.gene group by source;
+-----------------+----------+
| source | count(*) |
+-----------------+----------+
| BestRefSeq | 31502 |
| ccds | 33367 |
| Curated Genomic | 16356 |
| ensembl | 261624 |
| Gnomon | 11787 |
| tRNAscan-SE | 575 |
+-----------------+----------+
6 rows in set
Time: 0.499s
(none)> select source,count(*) from homo_sapiens_otherfeatures_95_38.gene group by source;
+-----------------+----------+
| source | count(*) |
+-----------------+----------+
| BestRefSeq | 31637 |
| ccds | 32471 |
| Curated Genomic | 16472 |
| ensembl | 261624 |
| Gnomon | 11999 |
| refseq | 28125 |
| tRNAscan-SE | 575 |
+-----------------+----------+
7 rows in set
Time: 0.497s
i.e. the rows with source='refseq' have disappeared from the ensembl97 (and ensembl96) database.
Is this change documented somewhere?
Best regards,
--
Jerome Roy
WuXiNextCODE
https://www.wuxinextcode.com/
More information about the Dev
mailing list