[BioSQL-l] The bioentry and biosequence tables

[Peter]

Hello all,

Looking at the BioSQL schema, it initially appears that each bioentry
can have multiple biosequence entries (each with their own alphabet,
version and length).  On reading
http://biosql.org/wiki/Schema_Overview#BIOSEQUENCE I see that in fact
the schema should make sure each bioentry can have at most one
biosequence - which is good news.  If this was not the case, then the
location of any seqfeature locations would be ambiguous.

Was there a reason for not just putting optional sequence, length and
alphabet fields into the bioentry table directly (instead of having a
separate biosequence table)?  Does doing it as a separate table speed
up accessing the core (non-sequence) bioentry information?

Thanks,

Peter