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 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_100q10\_reads | Integer | extrapolated 100q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_100q17\_reads | Integer | extrapolated 100q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_100q20\_reads | Integer | extrapolated 100q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_100q47\_reads | Integer | extrapolated 100q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_100q7\_reads | Integer | extrapolated 100q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_200q10\_reads | Integer | extrapolated 200q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_200q17\_reads | Integer | extrapolated 200q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_200q20\_reads | Integer | extrapolated 200q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_200q47\_reads | Integer | extrapolated 200q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_200q7\_reads | Integer | extrapolated 200q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_300q10\_reads | Integer | extrapolated 300q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_300q17\_reads | Integer | extrapolated 300q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_300q20\_reads | Integer | extrapolated 300q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_300q47\_reads | Integer | extrapolated 300q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_300q7\_reads | Integer | extrapolated 300q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_400q10\_reads | Integer | extrapolated 400q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_400q17\_reads | Integer | extrapolated 400q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_400q20\_reads | Integer | extrapolated 400q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_400q47\_reads | Integer | extrapolated 400q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_400q7\_reads | Integer | extrapolated 400q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_50q10\_reads | Integer | extrapolated 50q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_50q17\_reads | Integer | extrapolated 50q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_50q20\_reads | Integer | extrapolated 50q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_50q47\_reads | Integer | extrapolated 50q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_50q7\_reads | Integer | extrapolated 50q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_from\_number\_of\_sampled\_reads | Integer | extrapolated from number of sampled reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_mapped\_bases\_in\_q10\_alignments | Big (8 byte) integer | extrapolated mapped bases in q10 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_mapped\_bases\_in\_q17\_alignments | Big (8 byte) integer | extrapolated mapped bases in q17 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_mapped\_bases\_in\_q20\_alignments | Big (8 byte) integer | extrapolated mapped bases in q20 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_mapped\_bases\_in\_q47\_alignments | Big (8 byte) integer | extrapolated mapped bases in q47 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_mapped\_bases\_in\_q7\_alignments | Big (8 byte) integer | extrapolated mapped bases in q7 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q10\_alignments | Integer | extrapolated q10 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q10\_coverage\_percentage | Floating point number | extrapolated q10 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q10\_longest\_alignment | Integer | extrapolated q10 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q10\_mean\_alignment\_length | Integer | extrapolated q10 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q10\_mean\_coverage\_depth | Floating point number | extrapolated q10 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q17\_alignments | Integer | extrapolated q17 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q17\_coverage\_percentage | Floating point number | extrapolated q17 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q17\_longest\_alignment | Integer | extrapolated q17 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q17\_mean\_alignment\_length | Integer | extrapolated q17 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q17\_mean\_coverage\_depth | Floating point number | extrapolated q17 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q20\_alignments | Integer | extrapolated q20 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q20\_coverage\_percentage | Floating point number | extrapolated q20 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q20\_longest\_alignment | Integer | extrapolated q20 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q20\_mean\_alignment\_length | Integer | extrapolated q20 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q20\_mean\_coverage\_depth | Floating point number | extrapolated q20 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q47\_alignments | Integer | extrapolated q47 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q47\_coverage\_percentage | Floating point number | extrapolated q47 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q47\_longest\_alignment | Integer | extrapolated q47 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q47\_mean\_alignment\_length | Integer | extrapolated q47 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q47\_mean\_coverage\_depth | Floating point number | extrapolated q47 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q7\_alignments | Integer | extrapolated q7 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q7\_coverage\_percentage | Floating point number | extrapolated q7 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q7\_longest\_alignment | Integer | extrapolated q7 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q7\_mean\_alignment\_length | Integer | extrapolated q7 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | extrapolated\_q7\_mean\_coverage\_depth | Floating point number | extrapolated q7 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | genome | String (up to 512) | genome | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | genomelength | Integer | genomelength | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | 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\_coverage\_percentage | Floating point number | q10 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | 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 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q10\_qscore\_bases | Big (8 byte) integer | q10 qscore bases | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q17\_alignments | Integer | q17 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q17\_coverage\_percentage | Floating point number | q17 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | 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 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q17\_qscore\_bases | Big (8 byte) integer | q17 qscore bases | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q20\_alignments | Integer | q20 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q20\_coverage\_percentage | Floating point number | q20 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | 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 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q20\_qscore\_bases | Big (8 byte) integer | q20 qscore bases | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q47\_alignments | Integer | q47 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q47\_coverage\_percentage | Floating point number | q47 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | 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 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q47\_qscore\_bases | Big (8 byte) integer | q47 qscore bases | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q7\_alignments | Integer | q7 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q7\_coverage\_percentage | Floating point number | q7 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | 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 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | q7\_qscore\_bases | Big (8 byte) integer | q7 qscore bases | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r100Q10 | Integer | r100Q10 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r100Q17 | Integer | r100Q17 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r100Q20 | Integer | r100Q20 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r200Q10 | Integer | r200Q10 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r200Q17 | Integer | r200Q17 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r200Q20 | Integer | r200Q20 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r50Q10 | Integer | r50Q10 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r50Q17 | Integer | r50Q17 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | r50Q20 | Integer | r50Q20 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | rCoverage | Floating point number | rCoverage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | rLongestAlign | Integer | rLongestAlign | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | rMeanAlignLen | Integer | rMeanAlignLen | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | rNumAlignments | Integer | rNumAlignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | raw\_accuracy | Floating point number | raw accuracy | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | report | Results (ForeignKey) | the related rundb.Results row | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s100Q10 | Integer | s100Q10 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s100Q17 | Integer | s100Q17 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s100Q20 | Integer | s100Q20 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s200Q10 | Integer | s200Q10 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s200Q17 | Integer | s200Q17 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s200Q20 | Integer | s200Q20 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s50Q10 | Integer | s50Q10 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s50Q17 | Integer | s50Q17 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | s50Q20 | Integer | s50Q20 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sCoverage | Floating point number | sCoverage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sLongestAlign | Integer | sLongestAlign | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sMeanAlignLen | Integer | sMeanAlignLen | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sNumAlignments | Integer | sNumAlignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_100q10\_reads | Integer | sampled 100q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_100q17\_reads | Integer | sampled 100q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_100q20\_reads | Integer | sampled 100q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_100q47\_reads | Integer | sampled 100q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_100q7\_reads | Integer | sampled 100q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_200q10\_reads | Integer | sampled 200q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_200q17\_reads | Integer | sampled 200q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_200q20\_reads | Integer | sampled 200q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_200q47\_reads | Integer | sampled 200q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_200q7\_reads | Integer | sampled 200q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_300q10\_reads | Integer | sampled 300q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_300q17\_reads | Integer | sampled 300q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_300q20\_reads | Integer | sampled 300q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_300q47\_reads | Integer | sampled 300q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_300q7\_reads | Integer | sampled 300q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_400q10\_reads | Integer | sampled 400q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_400q17\_reads | Integer | sampled 400q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_400q20\_reads | Integer | sampled 400q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_400q47\_reads | Integer | sampled 400q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_400q7\_reads | Integer | sampled 400q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_50q10\_reads | Integer | sampled 50q10 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_50q17\_reads | Integer | sampled 50q17 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_50q20\_reads | Integer | sampled 50q20 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_50q47\_reads | Integer | sampled 50q47 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_50q7\_reads | Integer | sampled 50q7 reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_mapped\_bases\_in\_q10\_alignments | Big (8 byte) integer | sampled mapped bases in q10 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_mapped\_bases\_in\_q17\_alignments | Big (8 byte) integer | sampled mapped bases in q17 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_mapped\_bases\_in\_q20\_alignments | Big (8 byte) integer | sampled mapped bases in q20 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_mapped\_bases\_in\_q47\_alignments | Big (8 byte) integer | sampled mapped bases in q47 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_mapped\_bases\_in\_q7\_alignments | Big (8 byte) integer | sampled mapped bases in q7 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q10\_alignments | Integer | sampled q10 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q10\_coverage\_percentage | Floating point number | sampled q10 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q10\_longest\_alignment | Integer | sampled q10 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q10\_mean\_alignment\_length | Integer | sampled q10 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q10\_mean\_coverage\_depth | Floating point number | sampled q10 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q17\_alignments | Integer | sampled q17 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q17\_coverage\_percentage | Floating point number | sampled q17 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q17\_longest\_alignment | Integer | sampled q17 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q17\_mean\_alignment\_length | Integer | sampled q17 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q17\_mean\_coverage\_depth | Floating point number | sampled q17 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q20\_alignments | Integer | sampled q20 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q20\_coverage\_percentage | Floating point number | sampled q20 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q20\_longest\_alignment | Integer | sampled q20 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q20\_mean\_alignment\_length | Integer | sampled q20 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q20\_mean\_coverage\_depth | Floating point number | sampled q20 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q47\_alignments | Integer | sampled q47 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q47\_coverage\_percentage | Floating point number | sampled q47 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q47\_longest\_alignment | Integer | sampled q47 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q47\_mean\_alignment\_length | Integer | sampled q47 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q47\_mean\_coverage\_depth | Floating point number | sampled q47 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q7\_alignments | Integer | sampled q7 alignments | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q7\_coverage\_percentage | Floating point number | sampled q7 coverage percentage | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q7\_longest\_alignment | Integer | sampled q7 longest alignment | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q7\_mean\_alignment\_length | Integer | sampled q7 mean alignment length | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | sampled\_q7\_mean\_coverage\_depth | Floating point number | sampled q7 mean coverage depth | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | 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 | +----------------------------------------------------+-------------------------+-----------------------------------------------+ | total\_number\_of\_sampled\_reads | Integer | total number of sampled reads | +----------------------------------------------------+-------------------------+-----------------------------------------------+