Schema for chainHg18Link

Schema for chainHg18Link

Database: bosTau4 Primary Table: chainHg18Link Row Count: 89,969,603
Format description: alignment block in chain

field	example	SQL type	description
`bin`	585	`smallint unsigned`	Indexing field to speed chromosome range queries.
`tName`	chr1	`varchar(255)`	Target sequence name
`tStart`	1744	`int unsigned`	Alignment start position in target
`tEnd`	1784	`int unsigned`	Alignment end position in target
`qStart`	58653115	`int unsigned`	start in query
`chainId`	71673	`int unsigned`	chain id in chain table

Connected Tables and Joining Fields


	bosTau4.chainHg18.id (via chainHg18Link.chainId) bosTau4.netHg18.chainId (via chainHg18Link.chainId)

Sample Rows

bin	tName	tStart	tEnd	qStart	chainId
585	chr1	1744	1784	58653115	71673
585	chr1	1784	1838	58653156	71673
585	chr1	1838	1850	58653212	71673
585	chr1	1856	1950	58653224	71673
585	chr1	1950	1960	58653322	71673
585	chr1	1962	2000	58653332	71673
585	chr1	2018	2061	58653370	71673
585	chr1	2061	2112	58653417	71673
585	chr1	2112	2146	58653469	71673
585	chr1	2149	2173	58653503	71673

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.