ZFIN Data Load Sheets Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions for Using ZFIN Data Submission Templates
2
This workbook is a Google Spreadsheet. Please make a copy for your own personal use and leave the original template version in place for others to use. Each tab includes one or more rows of example data in a light gray font color. Those rows provide some examples of what the data may look like.

The tabs in this workbook are designed to capture the critical details for specific data types that can be submitted to ZFIN. In many cases data must be added to more than one tab in order to submit the complete data set to ZFIN. For example, to submit new transgenic lines to ZFIN, it may be necessary to add data to the constructs tab to describe new constructs and to also add data to the Mutants/Transgenics tab to specify the new transgenic insertion data. Most data submissions also require information in the Citations tab to allow creation of the required data-submission-specific publication at ZFIN to represent the data load.
3
4
Required and Optional Data:
Column headers for required data are highlighted and have an asterisk, other fields are optional.

Data Sources:
Data entered are either free text, restricted to a constrained set of terms, or from an ontology. Data that come from a constrained set have a pick list to allow only selection of valid entries. Columns that require terms from an ontology are highlighted yellow. The ontology terms can be typed or pasted in, but the OntoMaton plug-in for Google Spreadsheets has been incorporated to assist in locating ontology terms from the correct and current ontology at BioPortal. Anatomy terms come from the Zebrafish Anatomy Ontology (ZFA), Gene Ontology terms come from the Gene Ontology (GO), PATO terms come from the Phenotypic Quality Ontology (PATO), and disease terms come from the Human Disease Ontology (DO).

Using OntoMaton:
To use OntoMaton, click Add-ons->OntoMaton->Perform Ontology Search. If that option is not available, you must add the plug-in by clicking Add-ons->Get Add-ons and finding the plug-in. The "Perform Ontology Search" option adds the OntoMaton plug-in to the right margin of the spreadsheet. Search for a term of interest using the OntoMaton plug-in. It will search BioPortal for the search term and offer ontology terms from the correct ontology. Click "Insert Term" to add a specific term to the spreadsheet in the cell where the cursor is located. OntoMaton can be a little slow to use, so once you have located the correct and valid term once, it is acceptable to just copy and past it when you want to re-use it in the spread sheet.
5
6
Direct Questions to: zfinadmn@zfin.org
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...