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
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