Repetitive elements in human genome v 18

• from genome browser
• = ver 36 at NCBI

select repFamily,count(*) from repeatmasker group by repFamily;
+----------------+----------+
| repFamily      | count(*) |
+----------------+----------+
| AcHobo         |    18890 | 
| acro           |       39 | 
| Alu            |  1180972 | 
| centr          |     2201 | 
| CR1            |    53677 | 
| DNA            |    13570 | 
| ERV            |      577 | 
| ERV1           |   176391 | 
| ERVK           |    10573 | 
| ERVL           |   131565 | 
| L1             |   919426 | 
| L2             |   406974 | 
| Low_complexity |   367544 | 
| MaLR           |   331641 | 
| Mariner        |    16189 | 
| MER1_type      |   214721 | 
| MER1_type?     |     5248 | 
| MER2_type      |    82765 | 
| Merlin         |       54 | 
| MIR            |   587443 | 
| MuDR           |     1861 | 
| Other          |     3366 | 
| PiggyBac       |     2088 | 
| RNA            |      713 | 
| rRNA           |     1739 | 
| RTE            |    16285 | 
| Satellite      |     6006 | 
| scRNA          |     1376 | 
| Simple_repeat  |   419392 | 
| snRNA          |     4287 | 
| srpRNA         |      943 | 
| Tc2            |     7620 | 
| telo           |      372 | 
| Tip100         |    26801 | 
| tRNA           |     1873 | 
| Unknown        |      924 | 
+----------------+----------+
36 rows in set (1 min 6.82 sec)

mysql> select repName,count(*) from repeatmasker where repFamily='L1' group by repName;
+-------------+----------+
| repName     | count(*) |
+-------------+----------+
| HAL1        |    28098 | 
| HAL1b       |     7350 | 
| L1HS        |     1723 | 
| L1M         |    12098 | 
| L1M1        |    10599 | 
| L1M2        |     9983 | 
| L1M2a       |      534 | 
| L1M2a1      |      162 | 
| L1M2b       |      339 | 
| L1M2c       |      590 | 
| L1M3        |     7946 | 
| L1M3a       |      684 | 
| L1M3b       |      876 | 
| L1M3c       |     1142 | 
| L1M3d       |      829 | 
| L1M3de      |      539 | 
| L1M3e       |     1034 | 
| L1M3f       |     1317 | 
| L1M4        |    20379 | 
| L1M4b       |     7682 | 
| L1M4c       |     8050 | 
| L1M5        |    66091 | 
| L1MA1       |     4095 | 
| L1MA10      |     5433 | 
| L1MA2       |     7162 | 
| L1MA3       |     8390 | 
| L1MA4       |     9203 | 
| L1MA4A      |     5945 | 
| L1MA5       |     4158 | 
| L1MA5A      |     3227 | 
| L1MA6       |     4840 | 
| L1MA7       |     7787 | 
| L1MA8       |    10222 | 
| L1MA9       |    15686 | 
| L1MB1       |     5991 | 
| L1MB2       |     7895 | 
| L1MB3       |    15405 | 
| L1MB4       |     9130 | 
| L1MB5       |     8983 | 
| L1MB7       |    20612 | 
| L1MB8       |    15315 | 
| L1MC        |    16654 | 
| L1MC1       |    12152 | 
| L1MC2       |     6028 | 
| L1MC3       |    13252 | 
| L1MC4       |    30360 | 
| L1MC4a      |    29004 | 
| L1MC4_3endX |      984 | 
| L1MC5       |    20705 | 
| L1MCa       |     7724 | 
| L1MCb       |     2952 | 
| L1MCc       |     7021 | 
| L1MD        |    11060 | 
| L1MD1       |     6323 | 
| L1MD2       |    12944 | 
| L1MD3       |     7517 | 
| L1MDa       |    10139 | 
| L1MDb       |     1872 | 
| L1ME1       |    27165 | 
| L1ME2       |    15885 | 
| L1ME3       |     7707 | 
| L1ME3A      |    16444 | 
| L1ME3B      |    27824 | 
| L1ME4a      |    38172 | 
| L1MEa       |     1713 | 
| L1MEb       |     5847 | 
| L1MEc       |    21962 | 
| L1MEd       |    16283 | 
| L1MEe       |    12819 | 
| L1P         |     1707 | 
| L1P1        |     2928 | 
| L1P2        |     2082 | 
| L1P3        |     3307 | 
| L1P3b       |      188 | 
| L1P4        |     4515 | 
| L1P4a       |      577 | 
| L1P4b       |      267 | 
| L1P4c       |       91 | 
| L1P4d       |      213 | 
| L1P4e       |      321 | 
| L1P5        |     1499 | 
| L1PA10      |     6724 | 
| L1PA11      |     3948 | 
| L1PA12      |     1883 | 
| L1PA13      |     8518 | 
| L1PA14      |     2765 | 
| L1PA15      |     7315 | 
| L1PA15-16   |     1302 | 
| L1PA16      |    13431 | 
| L1PA17      |     4857 | 
| L1PA2       |     4789 | 
| L1PA3       |    10358 | 
| L1PA4       |    11596 | 
| L1PA5       |    11014 | 
| L1PA6       |     5694 | 
| L1PA7       |    12567 | 
| L1PA8       |     7845 | 
| L1PA8A      |     2342 | 
| L1PB        |     1619 | 
| L1PB1       |    12875 | 
| L1PB2       |     2778 | 
| L1PB3       |     3466 | 
| L1PB4       |     6626 | 
| L1PBa       |     2000 | 
| L1PBa1      |      727 | 
| L1PBb       |      302 | 
| L1PREC2     |     8354 | 
+-------------+----------+
107 rows in set (20.03 sec)