Issue 14

[aguang]

Key changes:

• Some SRA metadata columns as well as a JSON of the metadata for an SRS/SRX id combo has been added to the table samplemeta
• In samplemeta, sample_id has been renamed to db_id, and sample_name has been renamed to sample_id. This is to match the fact the SRA has a column named sample_id (for SRX/ERX/DRX accessions) as well so that our sample_id is equivalent to SRA's sample_id. All places referencing sample_id or sample_name should have been changed accordingly.
• tables_create.py has been merged into db_create.py, so that when the db is created the tables are as well

This PR closes #14.

Potential issues:

• If requests are sent too often to SRA we will get a too many requests error and no SRA metadata will be pulled to populate samplemeta. In theory this should not be an issue since the limit is ~4 requests/second. In practice we'll see.

[codecov[bot]]

Codecov Report

Merging #25 into devel will increase coverage by 18.45%. The diff coverage is 91.07%.

@@             Coverage Diff             @@
##            devel      #25       +/-   ##
===========================================
+ Coverage   70.34%   88.79%   +18.45%     
===========================================
  Files          10       11        +1     
  Lines         499      607      +108     
===========================================
+ Hits          351      539      +188     
+ Misses        148       68       -80

Impacted Files	Coverage Δ
tests/test_sra.py	100% <100%> (ø)
qcdb/parsers/fastqc_parse.py	95.55% <100%> (ø)	:arrow_up:
qcdb/sra_metadata.py	100% <100%> (ø)
qcdb/parsers/parse.py	96.51% <100%> (+13.98%)	:arrow_up:
qcdb/db_create.py	63.26% <45.83%> (+63.26%)	:arrow_up:
qcdb/parsers/picardtools_parse.py	85.71% <50%> (ø)	:arrow_up:
qcdb/parsers/qckitfastq_parse.py	87.5% <66.66%> (ø)	:arrow_up:
qcdb/db_load.py	69.51% <80%> (+39.27%)	:arrow_up:
tests/test_db.py	97.22% <97.82%> (+2.16%)	:arrow_up:
... and 4 more

---

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update 29adef5...7a46ccf. Read the comment docs.