gene_id_mapping
49,663 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | gene_id | GeneID | ZFIN | miRBase | Ensembl_gene_id_from_NCBI | Ensembl_gene_id_from_ZFIN | Ensembl_gene_id |
|---|---|---|---|---|---|---|---|---|
| 0 | 0 | LOC141383674 | 141383674 | NA | NA | |||
| 1 | 1 | rpl24 | 192301 | ZDB-GENE-020419-25 | NA | ENSDARG00000099104 | ENSDARG00000099104 | ENSDARG00000099104 |
| 2 | 2 | cep97 | 386640 | ZDB-GENE-031030-11 | NA | ENSDARG00000102407 | ENSDARG00000102407 | ENSDARG00000102407 |
| 3 | 3 | nfkbiz | 100001781 | ZDB-GENE-071024-1 | NA | ENSDARG00000102097 | ENSDARG00000102097 | ENSDARG00000102097 |
| 4 | 4 | eed | 550463 | ZDB-GENE-050417-287 | NA | ENSDARG00000099640 | ENSDARG00000099640 | ENSDARG00000099640 |
| 5 | 5 | hikeshi | 550239 | ZDB-GENE-050417-34 | NA | ENSDARG00000104071 | ENSDARG00000104071 | ENSDARG00000104071 |
| 6 | 6 | tmem39a | 323208 | ZDB-GENE-030131-1928 | NA | ENSDARG00000102746 | ENSDARG00000102746 | ENSDARG00000102746 |
| 7 | 7 | ildr1a | 393364 | ZDB-GENE-040426-1412 | NA | ENSDARG00000103929 | ENSDARG00000103929 | ENSDARG00000103929 |
| 8 | 8 | LOC100332762 | 100332762 | NA | NA | |||
| 9 | 9 | gpa33a | 407680 | ZDB-GENE-080229-4 | NA | ENSDARG00000100223 | ENSDARG00000100223 | ENSDARG00000100223 |
| 10 | 10 | crfa4 | 100144570 | ZDB-GENE-080401-1 | NA | |||
| 11 | 11 | dusp27 | 792623 | ZDB-GENE-140513-1 | NA | ENSDARG00000099889 | ENSDARG00000099889 | ENSDARG00000099889 |
| 12 | 12 | pou2f1a | 30715 | ZDB-GENE-990415-185 | NA | |||
| 13 | 13 | wu:fj30f06 | 792477 | ZDB-GENE-030131-7567 | NA | ENSDARG00000112681 | ENSDARG00000112681 | |
| 14 | 14 | cd247 | 100101654 | ZDB-GENE-061130-4 | NA | ENSDARG00000100284 | ENSDARG00000100284 | |
| 15 | 15 | creg1 | 791208 | ZDB-GENE-070112-2042 | NA | ENSDARG00000105154 | ENSDARG00000105154 | ENSDARG00000105154 |
| 16 | 16 | h2af1al | 100332229 | ZDB-GENE-160922-1 | NA | ENSDARG00000098739 | ENSDARG00000098739 | |
| 17 | 17 | setdb2 | 335153 | ZDB-GENE-030131-7093 | NA | |||
| 18 | 18 | LOC101885776 | 101885776 | NA | NA | |||
| 19 | 19 | f7l | 100038778 | ZDB-GENE-070424-102 | NA | ENSDARG00000100782 | ENSDARG00000100782 | ENSDARG00000100782 |
| 20 | 20 | f7 | 114423 | ZDB-GENE-010814-1 | NA | ENSDARG00000034862 | ENSDARG00000034862 | ENSDARG00000034862 |
| 21 | 21 | f7i | 282671 | ZDB-GENE-021206-10 | NA | ENSDARG00000075827 | ENSDARG00000075827 | ENSDARG00000075827 |
| 22 | 22 | f10 | 282670 | ZDB-GENE-021206-9 | NA | ENSDARG00000088581 | ENSDARG00000088581 | ENSDARG00000088581 |
| 23 | 23 | prozb | 558106 | ZDB-GENE-120816-1 | NA | ENSDARG00000076900 | ENSDARG00000076900 | ENSDARG00000076900 |
| 24 | 24 | pcid2 | 492509 | ZDB-GENE-041114-79 | NA | ENSDARG00000013802 | ENSDARG00000013802 | ENSDARG00000013802 |
| 25 | 25 | cul4a | 394002 | ZDB-GENE-040426-1357 | NA | ENSDARG00000096578 | ENSDARG00000096578 | ENSDARG00000096578 |
| 26 | 26 | lamp1a | 324985 | ZDB-GENE-030131-3708 | NA | ENSDARG00000100181 | ENSDARG00000100181 | |
| 27 | 27 | grtp1a | 406711 | ZDB-GENE-040426-2733 | NA | ENSDARG00000029936 | ENSDARG00000029936 | ENSDARG00000029936 |
| 28 | 28 | adprhl1 | 450012 | ZDB-GENE-041010-126 | NA | ENSDARG00000041589 | ENSDARG00000041589 | ENSDARG00000041589 |
| 29 | 29 | LOC141383747 | 141383747 | NA | NA | |||
| 30 | 30 | dcun1d2b | 415246 | ZDB-GENE-040625-171 | NA | ENSDARG00000041592 | ENSDARG00000041592 | ENSDARG00000041592 |
| 31 | 31 | tmco3 | 564309 | ZDB-GENE-071030-1 | NA | ENSDARG00000075108 | ENSDARG00000075108 | |
| 32 | 32 | tfdp1b | 393749 | ZDB-GENE-040426-1746 | NA | ENSDARG00000016304 | ENSDARG00000016304 | ENSDARG00000016304 |
| 33 | 33 | grk1a | 564152 | ZDB-GENE-050823-1 | NA | ENSDARG00000058803 | ENSDARG00000058803 | ENSDARG00000058803 |
| 34 | 34 | cenpe | 767754 | ZDB-GENE-060929-860 | NA | ENSDARG00000063385 | ENSDARG00000063385 | ENSDARG00000063385 |
| 35 | 35 | tmem255b | 103911743 | NA | NA | |||
| 36 | 36 | gas6 | 335830 | ZDB-GENE-030131-7773 | NA | ENSDARG00000007804 | ENSDARG00000007804 | ENSDARG00000007804 |
| 37 | 37 | LOC141383826 | 141383826 | NA | NA | |||
| 38 | 38 | pros1 | 768180 | ZDB-GENE-061013-657 | NA | ENSDARG00000068261 | ENSDARG00000068261 | ENSDARG00000068261 |
| 39 | 39 | rasa3 | 100318936 | ZDB-GENE-090313-21 | NA | ENSDARG00000063371 | ENSDARG00000063371 | ENSDARG00000063371 |
| 40 | 40 | tpp2 | 100331669 | ZDB-GENE-121214-290 | NA | ENSDARG00000078751 | ENSDARG00000078751 | ENSDARG00000078751 |
| 41 | 41 | mettl21ca | 100149425 | ZDB-GENE-121214-178 | NA | ENSDARG00000078878 | ENSDARG00000078878 | |
| 42 | 42 | mettl21e | 436634 | ZDB-GENE-040718-53 | NA | ENSDARG00000016343 | ENSDARG00000016343 | ENSDARG00000016343 |
| 43 | 43 | ercc5 | 541502 | ZDB-GENE-050327-28 | NA | ENSDARG00000023678 | ENSDARG00000023678 | ENSDARG00000023678 |
| 44 | 44 | blzf1 | 114452 | ZDB-GENE-010724-1 | NA | ENSDARG00000011299 | ENSDARG00000011299 | ENSDARG00000011299 |
| 45 | 45 | trmt10c | 492460 | ZDB-GENE-041114-12 | NA | ENSDARG00000041575 | ENSDARG00000041575 | ENSDARG00000041575 |
| 46 | 46 | txnl4b | 641329 | ZDB-GENE-051030-63 | NA | ENSDARG00000058962 | ENSDARG00000058962 | ENSDARG00000058962 |
| 47 | 47 | si:ch73-41e3.7 | 572312 | ZDB-GENE-090313-163 | NA | ENSDARG00000089799 | ENSDARG00000089799 | ENSDARG00000089799 |
| 48 | 48 | mrpl16 | 493604 | ZDB-GENE-041122-1 | NA | ENSDARG00000075325 | ENSDARG00000075325 | ENSDARG00000075325 |
| 49 | 49 | cenpq | 101885540 | ZDB-GENE-200617-1 | NA | ENSDARG00000041570 | ENSDARG00000041570 | |
| 50 | 50 | LOC101885604 | 101885604 | NA | NA | ENSDARG00000113329 | ENSDARG00000113329 | |
| 51 | 51 | mir155 | 100033679 | ZDB-MIRNAG-090929-166 | MI0002023 | ENSDARG00000081781 | ENSDARG00000081781 | ENSDARG00000081781 |
| 52 | 52 | mrpl39 | 334588 | ZDB-GENE-030131-6520 | NA | ENSDARG00000041570 | ENSDARG00000041570 | ENSDARG00000041570 |
| 53 | 53 | jam2a | 100005261 | ZDB-GENE-031204-3 | NA | ENSDARG00000058996 | ENSDARG00000058996 | ENSDARG00000058996 |
| 54 | 54 | atp5pf | 406599 | ZDB-GENE-040426-2534 | NA | ENSDARG00000014313 | ENSDARG00000014313 | ENSDARG00000014313 |
| 55 | 55 | appa | 58083 | ZDB-GENE-000616-13 | NA | ENSDARG00000104279 | ENSDARG00000104279 | ENSDARG00000104279 |
| 56 | 56 | LOC141383918 | 141383918 | NA | NA | |||
| 57 | 57 | cyyr1 | 405818 | ZDB-GENE-040426-2356 | NA | ENSDARG00000103783 | ENSDARG00000103783 | ENSDARG00000103783 |
| 58 | 58 | adamts1 | 565145 | ZDB-GENE-070814-1 | NA | ENSDARG00000103519 | ENSDARG00000103519 | ENSDARG00000103519 |
| 59 | 59 | adamts5 | 565053 | ZDB-GENE-070814-2 | NA | ENSDARG00000100307 | ENSDARG00000100307 | |
| 60 | 60 | LOC137495378 | 137495378 | NA | NA | |||
| 61 | 61 | hemk2 | 436775 | ZDB-GENE-040718-206 | NA | ENSDARG00000115421 | ENSDARG00000115421 | ENSDARG00000115421 |
| 62 | 62 | gart | 58141 | ZDB-GENE-000616-14 | NA | ENSDARG00000101089 | ENSDARG00000101089 | |
| 63 | 63 | LOC100332351 | 100332351 | NA | NA | |||
| 64 | 64 | LOC101882330 | 101882330 | NA | NA | |||
| 65 | 65 | zgc:152904 | 767777 | ZDB-GENE-060929-856 | NA | ENSDARG00000098523 | ENSDARG00000098523 | |
| 66 | 66 | LOC141384273 | 141384273 | NA | NA | |||
| 67 | 67 | LOC137495379 | 137495379 | NA | NA | |||
| 68 | 68 | LOC141384236 | 141384236 | NA | NA | |||
| 69 | 69 | wu:fa56d06 | 795664 | ZDB-GENE-030131-9298 | NA | ENSDARG00000103342 | ENSDARG00000103342 | ENSDARG00000103342 |
| 70 | 70 | sonb | 565999 | ZDB-GENE-161028-1 | NA | |||
| 71 | 71 | LOC795531 | 795531 | NA | NA | |||
| 72 | 72 | donson | 110439729 | NA | NA | |||
| 73 | 73 | runx1 | 58126 | ZDB-GENE-000605-1 | NA | ENSDARG00000087646 | ENSDARG00000087646 | ENSDARG00000087646 |
| 74 | 74 | mir459 | 100628775 | ZDB-MIRNAG-090929-286 | MI0002180 | ENSDARG00000080051 | ENSDARG00000080051 | ENSDARG00000080051 |
| 75 | 75 | urp2 | 100001008 | ZDB-GENE-110718-3 | NA | ENSDARG00000067781 | ENSDARG00000067781 | ENSDARG00000067781 |
| 76 | 76 | LOC100333907 | 100333907 | NA | NA | ENSDARG00000099108 | ENSDARG00000099108 | |
| 77 | 77 | LOC141384037 | 141384037 | NA | NA | |||
| 78 | 78 | rcan1b | 336348 | ZDB-GENE-030131-8292 | NA | |||
| 79 | 79 | wu:fk30a06 | 336928 | ZDB-GENE-030131-8872 | NA | |||
| 80 | 80 | LOC137495381 | 137495381 | NA | NA | |||
| 81 | 81 | atp1a1a.4 | 64615 | ZDB-GENE-001212-4 | NA | ENSDARG00000001870 | ENSDARG00000001870 | ENSDARG00000001870 |
| 82 | 82 | atp1a1a.1 | 64612 | ZDB-GENE-001212-1 | NA | ENSDARG00000002791 | ENSDARG00000002791 | ENSDARG00000002791 |
| 83 | 83 | LOC108187381 | 108187381 | NA | NA | |||
| 84 | 84 | atp1a1a.2 | 64613 | ZDB-GENE-001212-2 | NA | ENSDARG00000007739 | ENSDARG00000007739 | ENSDARG00000007739 |
| 85 | 85 | atp1a1a.3 | 64614 | ZDB-GENE-001212-3 | NA | ENSDARG00000039131 | ENSDARG00000039131 | ENSDARG00000039131 |
| 86 | 86 | atp1a1a.5 | 245703 | ZDB-GENE-020501-1 | NA | ENSDARG00000040252 | ENSDARG00000040252 | ENSDARG00000040252 |
| 87 | 87 | si:ch211-132g1.3 | 100004401 | ZDB-GENE-090312-148 | NA | ENSDARG00000089477 | ENSDARG00000089477 | ENSDARG00000089477 |
| 88 | 88 | LOC141384207 | 141384207 | NA | NA | |||
| 89 | 89 | si:ch211-132g1.4 | 101884500 | ZDB-GENE-090313-26 | NA | ENSDARG00000095102 | ENSDARG00000095102 | ENSDARG00000095102 |
| 90 | 90 | cd2 | 101884448 | ZDB-GENE-190523-1 | NA | |||
| 91 | 91 | ptgfrnb | 101884699 | ZDB-GENE-121214-287 | NA | ENSDARG00000075505 | ENSDARG00000075505 | ENSDARG00000075505 |
| 92 | 92 | slc5a3a | 100004287 | ZDB-GENE-090312-3 | NA | ENSDARG00000010376 | ENSDARG00000010376 | ENSDARG00000010376 |
| 93 | 93 | oxgr1a.1 | 678638 | ZDB-GENE-060421-6734 | NA | ENSDARG00000033684 | ENSDARG00000033684 | ENSDARG00000033684 |
| 94 | 94 | oxgr1a.3 | 100005578 | ZDB-GENE-090312-23 | NA | ENSDARG00000040247 | ENSDARG00000040247 | ENSDARG00000040247 |
| 95 | 95 | oxgr1a.2 | 100004138 | ZDB-GENE-090312-1 | NA | ENSDARG00000078743 | ENSDARG00000078743 | ENSDARG00000078743 |
| 96 | 96 | mbnl2 | 560384 | ZDB-GENE-030131-9582 | NA | ENSDARG00000018460 | ENSDARG00000018460 | ENSDARG00000018460 |
| 97 | 97 | rap2ab | 100003903 | ZDB-GENE-090312-116 | NA | ENSDARG00000040246 | ENSDARG00000040246 | ENSDARG00000040246 |
| 98 | 98 | LOC141384284 | 141384284 | NA | NA | |||
| 99 | 99 | LOC137495389 | 137495389 | NA | NA |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE gene_id_mapping(gene_id VARCHAR, GeneID BIGINT, ZFIN VARCHAR, miRBase VARCHAR, Ensembl_gene_id_from_NCBI VARCHAR, Ensembl_gene_id_from_ZFIN VARCHAR, Ensembl_gene_id VARCHAR);; CREATE INDEX idx_ensembl_gene_id ON gene_id_mapping(Ensembl_gene_id);; CREATE INDEX idx_geneid ON gene_id_mapping(GeneID);; CREATE INDEX idx_gene_id ON gene_id_mapping(gene_id);; CREATE INDEX idx_zfin ON gene_id_mapping(ZFIN);;