Schema for sfAssign
  Database: rn3    Primary Table: sfAssign    Row Count: 809,190   Data last updated: 2004-04-28
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
        rn3.ensGtp.protein (via sfAssign.seqID)
      rn3.ensTranscript.translation_name (via sfAssign.seqID)
      hgFixed.scopDes.sunid (via sfAssign.sfID)
      rn3.sfDes.id (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.