/usr/share/doc/libbiojava-java/resources/org/biojava/bio/program/unigene/createUnigene.sql is in libbiojava-java 1:1.7.1-5.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 | # unigene schema
#
# The unigene entry
CREATE TABLE cluster (
id varchar(10) unique NOT NULL,
title varchar(255),
gene varchar(255),
cytoband varchar(7),
locuslink int,
gnm_terminus char(1),
chromosome char(2),
unique key cluster_id (id)
);
# Expression list for a unigene entry
CREATE TABLE express (
cluster_id varchar(10) not null,
tissue varchar(255),
unique key express_key (cluster_id, tissue)
);
# sts for a unigene entry
CREATE TABLE sts (
cluster_id varchar(10) not null,
acc varchar(10),
name varchar(10),
unist varchar(10),
key sts_key (cluster_id)
);
# TXMAP for a unigene entry
CREATE TABLE txmap (
cluster_id varchar(10) not null,
id varchar(16),
key txmap_key (cluster_id)
);
# protsim for a unigene entry
CREATE TABLE protsim (
cluster_id varchar(10) not null,
org varchar(255),
protgi varchar(10),
protid varchar(15),
pct int(4),
aln int(4),
key protsim_key (cluster_id)
);
# sequences in a unigene cluster
CREATE TABLE sequence (
cluster_id varchar(10) not null,
acc varchar(15),
nid varchar(15),
clone varchar(15),
clone_end char(2),
lid int(5),
pid varchar(15),
key sequence_key (cluster_id)
);
|