Database Table rundb_libmetrics

Postgres database: iondb

Postgres table: rundb_libmetrics

Library metrics data model.

Lifecycle

Library metrics are computed as part of the analysis pipeline.

Referenced by

• rundb_results

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