Drosophila Melanogaster Genome

name Name	product Product	mrnaacc MrnaAcc	protacc ProtAcc	genename GeneName	prodname ProdName	locuslinkid LocusLinkId
C1orf137	putative uncharacterized protein C1orf137	NM_001013643	NP_001013665	242612	388327	388667
HMOX1	heme oxygenase 1	NM_001285567	NP_001272496	69217	23001	100860951
Adi1	1,2-dihydroxy-3-keto-5-methylthiopentene dioxygenase	NM_001285856	NP_001272785	163375	297261	101715211
XDH	xanthine dehydrogenase/oxidase	NM_001285974	NP_001272903	46674	112746	100515259
LOC101740470	chromobox protein homolog 5-like	NM_001285966	NP_001272895	242613	388328	101740470
BMI1	polycomb complex protein BMI-1	NM_001285971	NP_001272900	66522	406122	100520800
LOC102197686	bombesin receptor subtype-3-like	NM_001285977	NP_001272906	242614	388329	102197686
RPS7	40S ribosomal protein S7	NM_001285957	NP_001272886	50681	13390	101798974
IL33	interleukin-33	NM_001285978	NP_001272907	73400	96466	100518643
COPZ1	coatomer subunit zeta-1	NM_001285734	NP_001272663	33154	158162	100861396


CREATE TABLE refseq_link (
  "name" VARCHAR,
  "product" VARCHAR,
  "mrnaacc" VARCHAR,
  "protacc" VARCHAR,
  "genename" BIGINT,
  "prodname" BIGINT,
  "locuslinkid" BIGINT,
  "omimid" BIGINT
);