Schema for chainMm9Link

Schema for chainMm9Link

Database: bosTau4 Primary Table: chainMm9Link Row Count: 56,052,589
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`	1716	`int unsigned`	Alignment start position in target
`tEnd`	1840	`int unsigned`	Alignment end position in target
`qStart`	86551890	`int unsigned`	start in query
`chainId`	495396	`int unsigned`	chain id in chain table

Connected Tables and Joining Fields


	bosTau4.chainMm9.id (via chainMm9Link.chainId) bosTau4.netMm9.chainId (via chainMm9Link.chainId)

Sample Rows

bin	tName	tStart	tEnd	qStart	chainId
585	chr1	1716	1840	86551890	495396
585	chr1	1840	1850	86552016	495396
585	chr1	1855	1877	86552026	495396
585	chr1	1879	1931	86552048	495396
585	chr1	1949	2005	86552100	495396
585	chr1	2008	2018	86552156	495396
585	chr1	2018	2035	86552170	495396
585	chr1	2037	2055	86552187	495396
585	chr1	2055	2143	86552207	495396
585	chr1	2143	2250	86552296	495396

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