×
Menu
Index

Input data structure

 
QuBAS accepts files that have variables separated by a ","  tab  ";"  or space.
 
The comma separated file is described here but the description applies equally well to other separators.
 
The separator is specified when creating the Data File Template.
 

Comma separated variable files: csv

 
csv is a standard form of text file in which each field is separated from the next by a comma (,) and in which each new record is on a new row. The standard form also expects the same number of fields in each row.  There are many variations, but so long as the basic principle is present in the file, QuBAS will read it.
 
  It should be noted that use of a "," within a field, such as in an address, will cause problems with data read of that field and should be avoided.
  Note that some non-English operating systems use a comma instead of a point in number notation:  11,23 rather than 11.23  Clearly this will case problems for QuBAS when reading a csv file. It is recommended that the operating system number notation settings are changed to the point convention.
 

Example csv bioassay data

A simple 8x12 csv file with some other Metadata might look like this when viewed as a text file:
 
Import Note,Standard 1x96 no issues Meta data V1,,,,,,,,,,,,
Company,Biologic systems Inc a streetAny town,,,,,,,,,,,,
Assay ID,TSOP294 Av,,,,,,,,,,,,
Assay Run ,2,,,,,,,,,,,,
Reference ID,RS-1,,,,,,,,,,,,
Sample date ,06/21/2016,,,,,,,,,,,,
Method ID,Ian001,,,,,,,,,,,,
operator ID,John,,,,,,,,,,,,
,dose ug/ml,0,61.44,30.72,15.36,7.68,3.84,1.92,0.96,0.48,0.24,0.12,0
,,,,,,,,,,,,,
,Ref,0.0186,2.5698,2.5085,2.2702,1.9483,1.0362,0.2283,0.0437,0.0275,0.0258,0.0239,0.0226
,Sample A,0.019,2.4922,2.4854,2.2958,1.9187,0.8898,0.1908,0.0397,0.0257,0.0279,0.0219,0.0218
,Sample B,0.0196,2.4005,2.5115,2.1414,1.7725,0.8577,0.1543,0.0343,0.024,0.0251,0.0218,0.0238
,Control,0.0187,2.178,2.3407,2.1569,1.9753,1.2817,0.3287,0.0551,0.0289,0.0227,0.0226,0.0242
,Ref,0.0187,2.4682,2.3996,2.1321,1.8018,0.767,0.1366,0.0344,0.0245,0.0253,0.0226,0.0255
,Sample A,0.0176,2.5428,2.5336,2.2646,1.8088,0.7854,0.1591,0.0358,0.0256,0.0228,0.0223,0.0245
,Sample B,0.0188,2.4641,2.4824,2.1443,1.7811,0.8482,0.1954,0.0359,0.0239,0.0249,0.0249,0.0246
,control,0.0234,2.0681,2.3242,2.2488,2.0291,1.2908,0.3532,0.0589,0.0313,0.0262,0.0276,0.0254
~End,,,,,,,,,,,,,
Instrument type: Instrument serial number:,,,,,,,,,,,,,
 
When viewed in a spreadsheet package such as Excel it takes a familiar shape:
This example has been shaded to indicate which parts are assay data values (grey) and which are Metadata (pink).