Tools for Comparative Genomics

 
 

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:

SampleKeyFileDerby.ky