Database Table rundb_libmetrics
============================================================================

Postgres database: ``iondb``


Postgres table: ``rundb_libmetrics``


.. include:: ../manual_database_ref_docs/rundb_libmetrics.rst

Schema
-------

+--------------------------------+-------------------------+---------------------------------+
| Field                          | Type                    | Description                     |
+================================+=========================+=================================+
| Genome\_Version                | String (up to 512)      | Genome Version                  |
+--------------------------------+-------------------------+---------------------------------+
| Index\_Version                 | String (up to 512)      | Index Version                   |
+--------------------------------+-------------------------+---------------------------------+
| align\_sample                  | Integer                 | align sample                    |
+--------------------------------+-------------------------+---------------------------------+
| aveKeyCounts                   | Floating point number   | aveKeyCounts                    |
+--------------------------------+-------------------------+---------------------------------+
| cf                             | Floating point number   | cf                              |
+--------------------------------+-------------------------+---------------------------------+
| dr                             | Floating point number   | dr                              |
+--------------------------------+-------------------------+---------------------------------+
| duplicate\_reads               | Integer                 | duplicate reads                 |
+--------------------------------+-------------------------+---------------------------------+
| genome                         | String (up to 512)      | genome                          |
+--------------------------------+-------------------------+---------------------------------+
| genomesize                     | Big (8 byte) integer    | genomesize                      |
+--------------------------------+-------------------------+---------------------------------+
| i100Q10\_reads                 | Integer                 | i100Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i100Q17\_reads                 | Integer                 | i100Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i100Q20\_reads                 | Integer                 | i100Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i100Q47\_reads                 | Integer                 | i100Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i100Q7\_reads                  | Integer                 | i100Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i150Q10\_reads                 | Integer                 | i150Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i150Q17\_reads                 | Integer                 | i150Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i150Q20\_reads                 | Integer                 | i150Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i150Q47\_reads                 | Integer                 | i150Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i150Q7\_reads                  | Integer                 | i150Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i200Q10\_reads                 | Integer                 | i200Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i200Q17\_reads                 | Integer                 | i200Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i200Q20\_reads                 | Integer                 | i200Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i200Q47\_reads                 | Integer                 | i200Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i200Q7\_reads                  | Integer                 | i200Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i250Q10\_reads                 | Integer                 | i250Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i250Q17\_reads                 | Integer                 | i250Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i250Q20\_reads                 | Integer                 | i250Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i250Q47\_reads                 | Integer                 | i250Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i250Q7\_reads                  | Integer                 | i250Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i300Q10\_reads                 | Integer                 | i300Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i300Q17\_reads                 | Integer                 | i300Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i300Q20\_reads                 | Integer                 | i300Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i300Q47\_reads                 | Integer                 | i300Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i300Q7\_reads                  | Integer                 | i300Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i350Q10\_reads                 | Integer                 | i350Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i350Q17\_reads                 | Integer                 | i350Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i350Q20\_reads                 | Integer                 | i350Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i350Q47\_reads                 | Integer                 | i350Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i350Q7\_reads                  | Integer                 | i350Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i400Q10\_reads                 | Integer                 | i400Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i400Q17\_reads                 | Integer                 | i400Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i400Q20\_reads                 | Integer                 | i400Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i400Q47\_reads                 | Integer                 | i400Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i400Q7\_reads                  | Integer                 | i400Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i450Q10\_reads                 | Integer                 | i450Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i450Q17\_reads                 | Integer                 | i450Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i450Q20\_reads                 | Integer                 | i450Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i450Q47\_reads                 | Integer                 | i450Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i450Q7\_reads                  | Integer                 | i450Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i500Q10\_reads                 | Integer                 | i500Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i500Q17\_reads                 | Integer                 | i500Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i500Q20\_reads                 | Integer                 | i500Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i500Q47\_reads                 | Integer                 | i500Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i500Q7\_reads                  | Integer                 | i500Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i50Q10\_reads                  | Integer                 | i50Q10 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i50Q17\_reads                  | Integer                 | i50Q17 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i50Q20\_reads                  | Integer                 | i50Q20 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i50Q47\_reads                  | Integer                 | i50Q47 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i50Q7\_reads                   | Integer                 | i50Q7 reads                     |
+--------------------------------+-------------------------+---------------------------------+
| i550Q10\_reads                 | Integer                 | i550Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i550Q17\_reads                 | Integer                 | i550Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i550Q20\_reads                 | Integer                 | i550Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i550Q47\_reads                 | Integer                 | i550Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i550Q7\_reads                  | Integer                 | i550Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| i600Q10\_reads                 | Integer                 | i600Q10 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i600Q17\_reads                 | Integer                 | i600Q17 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i600Q20\_reads                 | Integer                 | i600Q20 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i600Q47\_reads                 | Integer                 | i600Q47 reads                   |
+--------------------------------+-------------------------+---------------------------------+
| i600Q7\_reads                  | Integer                 | i600Q7 reads                    |
+--------------------------------+-------------------------+---------------------------------+
| id                             | Integer                 | ID                              |
+--------------------------------+-------------------------+---------------------------------+
| ie                             | Floating point number   | ie                              |
+--------------------------------+-------------------------+---------------------------------+
| q10\_alignments                | Integer                 | q10 alignments                  |
+--------------------------------+-------------------------+---------------------------------+
| q10\_longest\_alignment        | Integer                 | q10 longest alignment           |
+--------------------------------+-------------------------+---------------------------------+
| q10\_mapped\_bases             | Big (8 byte) integer    | q10 mapped bases                |
+--------------------------------+-------------------------+---------------------------------+
| q10\_mean\_alignment\_length   | Integer                 | q10 mean alignment length       |
+--------------------------------+-------------------------+---------------------------------+
| q17\_alignments                | Integer                 | q17 alignments                  |
+--------------------------------+-------------------------+---------------------------------+
| q17\_longest\_alignment        | Integer                 | q17 longest alignment           |
+--------------------------------+-------------------------+---------------------------------+
| q17\_mapped\_bases             | Big (8 byte) integer    | q17 mapped bases                |
+--------------------------------+-------------------------+---------------------------------+
| q17\_mean\_alignment\_length   | Integer                 | q17 mean alignment length       |
+--------------------------------+-------------------------+---------------------------------+
| q20\_alignments                | Integer                 | q20 alignments                  |
+--------------------------------+-------------------------+---------------------------------+
| q20\_longest\_alignment        | Integer                 | q20 longest alignment           |
+--------------------------------+-------------------------+---------------------------------+
| q20\_mapped\_bases             | Big (8 byte) integer    | q20 mapped bases                |
+--------------------------------+-------------------------+---------------------------------+
| q20\_mean\_alignment\_length   | Integer                 | q20 mean alignment length       |
+--------------------------------+-------------------------+---------------------------------+
| q47\_alignments                | Integer                 | q47 alignments                  |
+--------------------------------+-------------------------+---------------------------------+
| q47\_longest\_alignment        | Integer                 | q47 longest alignment           |
+--------------------------------+-------------------------+---------------------------------+
| q47\_mapped\_bases             | Big (8 byte) integer    | q47 mapped bases                |
+--------------------------------+-------------------------+---------------------------------+
| q47\_mean\_alignment\_length   | Integer                 | q47 mean alignment length       |
+--------------------------------+-------------------------+---------------------------------+
| q7\_alignments                 | Integer                 | q7 alignments                   |
+--------------------------------+-------------------------+---------------------------------+
| q7\_longest\_alignment         | Integer                 | q7 longest alignment            |
+--------------------------------+-------------------------+---------------------------------+
| q7\_mapped\_bases              | Big (8 byte) integer    | q7 mapped bases                 |
+--------------------------------+-------------------------+---------------------------------+
| q7\_mean\_alignment\_length    | Integer                 | q7 mean alignment length        |
+--------------------------------+-------------------------+---------------------------------+
| raw\_accuracy                  | Floating point number   | raw accuracy                    |
+--------------------------------+-------------------------+---------------------------------+
| report                         | Results (ForeignKey)    | the related rundb.Results row   |
+--------------------------------+-------------------------+---------------------------------+
| sysSNR                         | Floating point number   | sysSNR                          |
+--------------------------------+-------------------------+---------------------------------+
| totalNumReads                  | Integer                 | totalNumReads                   |
+--------------------------------+-------------------------+---------------------------------+
| total\_mapped\_reads           | Big (8 byte) integer    | total mapped reads              |
+--------------------------------+-------------------------+---------------------------------+
| total\_mapped\_target\_bases   | Big (8 byte) integer    | total mapped target bases       |
+--------------------------------+-------------------------+---------------------------------+