Schema for term2term

JavaScript is disabled in your web browser

You must have JavaScript enabled in your web browser to use the Genome Browser

Schema for term2term

Database: go Primary Table: term2term Row Count: 93,713 Data last updated: 2018-04-27
On download server: MariaDB table dump directory

field	example	SQL type	info
`id`	1	`int(11)`	range
`relationship_type_id`	1	`int(11)`	range
`term1_id`	35	`int(11)`	range
`term2_id`	34	`int(11)`	range
`complete`	0	`int(11)`	range

Connected Tables and Joining Fields


	go.graph_path.term1_id (via term2term.term1_id) go.graph_path.term2_id (via term2term.term1_id) go.term.id (via term2term.term1_id) go.term_dbxref.term_id (via term2term.term1_id) go.term_definition.term_id (via term2term.term1_id) go.term_synonym.term_id (via term2term.term1_id)

Sample Rows

id	relationship_type_id	term1_id	term2_id	complete
1	1	35	34	0
2	1	35	41	0
3	1	58	57	0
4	1	35	75	0
5	1	58	81	0
6	1	35	83	0
7	1	58	88	0
8	1	58	100	0
9	1	58	105	0
10	1	58	111	0

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