Change `seq_id` to string
The seq_id
in the reads
and sequences
tables is currently an integer that acts as primary key and is auto-incremented.
To support third-party data in the schema (notably 10X), the type needs to be switched to a string.
- This will affect all tables which have
seq_id
as a foreign key. - Auto-increment does not work for strings, so
seq_id
must be generated by the script performing the INSERT - The pipeline scripts need to be adopted accordingly