Skip to content

Instantly share code, notes, and snippets.

@dbolser

dbolser/gist:9130915

Created February 21, 2014 08:55
Show Gist options
  • Save dbolser/9130915 to your computer and use it in GitHub Desktop.
Save dbolser/9130915 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
> SELECT COUNT(*), COUNT(DISTINCT exon_id), COUNT(DISTINCT transcript_id) FROM exon_transcript;
+----------+-------------------------+-------------------------------+
| COUNT(*) | COUNT(DISTINCT exon_id) | COUNT(DISTINCT transcript_id) |
+----------+-------------------------+-------------------------------+
| 248445 | 248445 | 248445 |
+----------+-------------------------+-------------------------------+
1 row in set (0.00 sec)
> SELECT COUNT(*), SUM(exon_id is null), COUNT(DISTINCT exon_id), COUNT(DISTINCT transcript_id) FROM exon_transcript;
+----------+----------------------+-------------------------+-------------------------------+
| COUNT(*) | SUM(exon_id is null) | COUNT(DISTINCT exon_id) | COUNT(DISTINCT transcript_id) |
+----------+----------------------+-------------------------+-------------------------------+
| 248445 | 0 | 233414 | 97851 |
+----------+----------------------+-------------------------+-------------------------------+
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment