[BioSQL-l] Co-ordinates

[Peter Cock]

On Wed, Jan 15, 2014 at 7:05 AM, Trevor Bell <trevorgrahambell at gmail.com> wrote:
> I worked through the BioSQL tutorial
> (http://biopython.org/wiki/BioSQL) and then imported a sequence I am
> interested in. Consider the following section of the full GenBank
> record of that sequence:
>
> ----------
>      CDS             155..835
>                      /gene="S"
>                      /codon_start=1
>                      /product="S protein"
>                      /protein_id="AAP79717.1"
>                      /db_xref="GI:32330472"
> ----------
>
> Where in the database schema can I find the co-ordinates of the
> gene/protein or the genomic region sequenced? I'm interested in the
> "155..835" in the example above. I can find the other data in the
> database (S, AAP79717, etc.).

The feature location coordinates are in the location table,
http://www.biosql.org/wiki/Schema_Overview#LOCATION

The protein ID etc should be in the feature annotation bundle.

Peter