Skip to content

Instantly share code, notes, and snippets.

@dbolser

dbolser/gist:9118844

Created February 20, 2014 17:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dbolser/9118844 to your computer and use it in GitHub Desktop.
Save dbolser/9118844 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
ensrw@mysql-eg-staging-2.ebi.ac.uk:4275 (oryza_sativa_core_22_75_7)
> SELECT COUNT(*) FROM exon_transcript;
+----------+
| COUNT(*) |
+----------+
| 248445 |
+----------+
1 row in set (0.00 sec)
ensrw@mysql-eg-staging-2.ebi.ac.uk:4275 (oryza_sativa_core_22_75_7)
> SELECT COUNT(DISTINCT exon_id) FROM exon_transcript;
+-------------------------+
| COUNT(DISTINCT exon_id) |
+-------------------------+
| 233414 |
+-------------------------+
1 row in set (0.11 sec)
ensrw@mysql-eg-staging-2.ebi.ac.uk:4275 (oryza_sativa_core_22_75_7)
> SELECT COUNT(DISTINCT transcript_id) FROM exon_transcript;
+-------------------------------+
| COUNT(DISTINCT transcript_id) |
+-------------------------------+
| 97851 |
+-------------------------------+
1 row in set (0.12 sec)
ensrw@mysql-eg-staging-2.ebi.ac.uk:4275 (oryza_sativa_core_22_75_7)
> SELECT COUNT(*), COUNT(DISTINCT exon_id) FROM exon_transcript;
+----------+-------------------------+
| COUNT(*) | COUNT(DISTINCT exon_id) |
+----------+-------------------------+
| 248445 | 233414 |
+----------+-------------------------+
1 row in set (0.05 sec)
ensrw@mysql-eg-staging-2.ebi.ac.uk:4275 (oryza_sativa_core_22_75_7)
> SELECT COUNT(*), COUNT(DISTINCT transcript_id) FROM exon_transcript;
+----------+-------------------------------+
| COUNT(*) | COUNT(DISTINCT transcript_id) |
+----------+-------------------------------+
| 248445 | 97851 |
+----------+-------------------------------+
1 row in set (0.11 sec)
ensrw@mysql-eg-staging-2.ebi.ac.uk:4275 (oryza_sativa_core_22_75_7)
> 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.06 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment