Schema for term
  Database: go    Primary Table: term    Row Count: 46,048   Data last updated: 2018-04-27
On download server: MariaDB table dump directory
fieldexampleSQL type info
id 1int(11) range
name is_avarchar(255) values
term_type relationshipvarchar(55) values
acc is_avarchar(255) values
is_obsolete 0int(11) range
is_root 0int(11) range
is_relation 1int(11) range

Connected Tables and Joining Fields
        dm1.bdgpGeneInfo.go (via term.acc)
      dm1.bdgpNonCodingInfo.go (via term.acc)
      go.goaPart.goId (via term.acc)
      go.graph_path.term1_id (via term.id)
      go.graph_path.term2_id (via term.id)
      go.term2term.term1_id (via term.id)
      go.term2term.term2_id (via term.id)
      go.term_dbxref.term_id (via term.id)
      go.term_definition.term_id (via term.id)
      go.term_synonym.term_id (via term.id)

Sample Rows
 
idnameterm_typeaccis_obsoleteis_rootis_relation
1is_arelationshipis_a001
2considermetadataconsider001
3replaced_bymetadatareplaced_by001
4Grouping classes that can be excludedsubsetgoantislim_grouping000
5Term not to be used for direct annotationsubsetgocheck_do_not_annotate000
6Term not to be used for direct manual annotationsubsetgocheck_do_not_manually_annotate000
7Aspergillus GO slimsubsetgoslim_aspergillus000
8Candida GO slimsubsetgoslim_candida000
9ChEMBL protein targets summarysubsetgoslim_chembl000
10Generic GO slimsubsetgoslim_generic000

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