gistfile1.txt

[email protected]:4275 (oryza_sativa_core_22_75_7)
> SELECT COUNT(*) FROM exon_transcript;
+----------+
| COUNT(*) |
+----------+
|   248445 |
+----------+
1 row in set (0.00 sec)


[email protected]: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)


[email protected]: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)


[email protected]: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)


[email protected]: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)

[email protected]: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)