Key Description File (.ky)
Comments:
Line 1: specify the delimiter you would like to use to format the file such as --###--
Line 2: start symbol of a table ###
Line 3: the actual table name in the database where the properties are stored.
Line 4 - Line x: names of the columns as keys for properties/annotations. A
property or an annotation is a pair of a key and a value associated with this
key.
Line x+1: Connection specifies how this table are connected to other tables
in the same database by their columns. In the example below TAXON.TAXON_OID
is connected with TAXON_INFO.TAXON_OID and TAXON.TAXON_OID is also connected
with TAXON_PHENOTYPE.TAXON_OID. The first element after the delimiter specifies
the column in this table (here is TAXON table) and followed by all the columns
in other tables which this column is connected to.
Line y: the ending symbol of a table ---
Example:
delimiter--###--
###
Table--###--TAXON
Name--###--TAXON_NAME--###--VARCHAR(255)
Name--###--GENUS--###--VARCHAR(100)
Name--###--SPECIES--###--VARCHAR(100)
Name--###--COMMON_NAME--###--VARCHAR(255)
Name--###--TAXON_ID--###--NUMERIC(16)
Name--###--ABBR_NAME--###--VARCHAR(255)
Name--###--DOMAIN--###--VARCHAR(255)
Name--###--PHYLUM--###--VARCHAR(255)
Name--###--IR_CLASS--###--VARCHAR(255)
Name--###--IR_ORDER--###--VARCHAR(255)
Name--###--FAMILY--###--VARCHAR(255)
Name--###--GENOME_SIZE--###--NUMERIC(16,3)
Name--###--NCBI_SPECIES_CODE--###--VARCHAR(20)
Name--###--COG_CAT_CNT--###--NUMERIC(16)
Name--###--KEGG_CNT--###--NUMERIC(16)
Name--###--GOLD_ID--###--VARCHAR(50)
Name--###--TAXON_OID--###--NUMERIC(16,0)
Name--###--SEQ_STATUS--###--VARCHAR(255)
Connection--###--TAXON.TAXON_OID--###--TAXON_INFO.TAXON_OID--###--TAXON_PHENOTYPE.TAXON_OID
---
Also available:
