34c07fa95c834c1377e4e185b1a9e19499a0d536 kate Tue Jan 30 15:48:56 2018 -0800 Update schema, based on input from Braney. Improve map boxes. refs #17512 diff --git src/hg/lib/interact.as src/hg/lib/interact.as index 7000bba..88b98fa 100644 --- src/hg/lib/interact.as +++ src/hg/lib/interact.as @@ -1,21 +1,23 @@ table interact "Interaction between two regions" ( string chrom; "Chromosome (or contig, scaffold, etc.). For interchromosomal, use 2 records" uint chromStart; "Start position in chromosome of lower region" uint chromEnd; "End position in chromosome of upper region. For interchromosomal, set to chromStart+1" string name; "Name of item, for display. Usually 'name1/name2' or empty" uint score; "Score from 0-1000" - char[1] strand; "Direction of interaction (+ or -)" - uint color; "Item color, as itemRgb in bed9" - string chrom1; "Chromosome of first region" - uint chromStart1; "Start position in chromosome of first region" - uint chromEnd1; "End position in chromosome of first region" - string name1; "Identifier of first region. Can be used as link to related table" + double value; "Strength of interaction or other data value. Typically basis for score" + string exp; "Experiment name (metadata for filtering) or empty. + uint color; "Item color, as itemRgb in bed9. Typically based on strenght or filter" - string chrom2; "Chromosome of second region" - uint chromStart2; "Start position in chromosome of second region" - uint chromEnd2; "End position in chromosome of second region" - string name2; "Identifier of second region. Can be used as link to related table" + string sourceChrom; "Chromosome of source region (directional) or lower region." + uint sourceStart; "Start position in chromosome of source/lower region" + uint sourceEnd; "End position in chromosome of source/lower region" + string sourceName; "Identifier of source/lower region. Can be used as link to related table" + + string targetChrom; "Chromosome of target region (directional) or upper region" + uint targetStart; "Start position in chromosome of target/upper region" + uint targetEnd; "End position in chromosome of target/upper region" + string targetName; "Identifier of target/upper region. Can be used as link to related table" )