Schema for sfAssign
  Database: hg16    Primary Table: sfAssign    Row Count: 764,386   Data last updated: 2004-05-21
Format description: Superfamily Assignment table
On download server: MariaDB table dump directory
fieldexampleSQL type description
genomeID aavarchar(255) genome ID
seqID gi|15605769|ref|NP_213146.1|varchar(255) sequence ID
modelID 0011675varchar(255) model ID
region 1-138varchar(255) region
eValue 5e-34varchar(255) E value
sfID 46458varchar(255) Superfamily entry ID
sfDesc Aquifex aeolicus VF5varchar(255) Superfamily entry description

Connected Tables and Joining Fields
        hg16.ensGtp.protein (via sfAssign.seqID)
      hg16.ensemblXref3.protein (via sfAssign.seqID)
      hg16.sfDes.id (via sfAssign.sfID)
      hgFixed.scopDes.sunid (via sfAssign.sfID)

Sample Rows
 
genomeIDseqIDmodelIDregioneValuesfIDsfDesc
aagi|15605769|ref|NP_213146.1|00116751-1385e-3446458Aquifex aeolicus VF5
aagi|15607032|ref|NP_214414.1|00106143-1571.6e-2446548Aquifex aeolicus VF5
aagi|15606011|ref|NP_213388.1|0010680122-2224.5e-2246548Aquifex aeolicus VF5
aagi|15606075|ref|NP_213452.1|001068093-2178.5e-2146548Aquifex aeolicus VF5
aagi|15605900|ref|NP_213277.1|001068025-1422.5e-1846548Aquifex aeolicus VF5
aagi|15605895|ref|NP_213272.1|00106808-1247.7e-1646548Aquifex aeolicus VF5
aagi|15606570|ref|NP_213950.1|001374419-53,82-1508e-1646548Aquifex aeolicus VF5
aagi|15606743|ref|NP_214123.1|001068013-974.3e-1546548Aquifex aeolicus VF5
aagi|15606277|ref|NP_213656.1|001061434-1273e-1146548Aquifex aeolicus VF5
aagi|15607133|ref|NP_212997.1|00096159-693e-1446561Aquifex aeolicus VF5

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