Trajectory data: database structure

on Thursday, December 20th, 2012 5:16 | by

CeTrAn is our software to analyse trajectory data, written in R it is free and open source . It was designed to analyse data obtained in the Buridan’s experiment setup. I am now trying to have a larger scope and incorporate different type of data:, for instance:

– Buridan’s experiment done with a different tracker

– Walking honeybee tracking in a rectangular arena, with a rewarded target

– Animal (flies/bees) walking on a ball, using open- or closed-loop experiment setup

– trajectory data obtained from the pysolo software (flies)

– larval crawling data

I want to include an automatic depository of the data in a database. Automatic entries in Figshare is for instance possible. (see older posts). My problem is to find a way to treat the data such that:

1. the raw data is uploaded

2. all data is uploaded also if we use only the centroid displacement (in some data file the head position is also given)

3. the data can be reused and data obtained in different lab, animal, setup can be compared. (data should be organized such that it can be searched and queried).

4. probably other elements that I do not think of….

 

My main problem: I have nearly no experience in data management/design, ontology or semantic web. Here is a first draft of a database structure that I have thought of. Every feedback would be welcome:

Print Friendly, PDF & Email

C105-Gal4 S-Map results

on Wednesday, December 5th, 2012 5:49 | by

Here I post the S-Map results of the C105 gal4 lines crossed with TNT. Its part of the double line c105-c232 Gal4 that showed phenotype. Seems tetanus has some effect. C105-C232 Gal4 slope range was around 0.005.

N –  34, 37, 29 respectively

Rest of the analysis on the way !

 

Print Friendly, PDF & Email

c105 Gal4 test

on Wednesday, November 21st, 2012 8:34 | by

Currently I am testing C105-Gal4 line and two groups seem to fly so weak(8/24 so far). I will be testing them until I have reasonable number.

Alongside,  writing results and nearing completion on this chapter (thesis).But yet to prepare quality figures.

By the way, tag cloud is awesome !

 

Print Friendly, PDF & Email

log sathish

on Wednesday, October 31st, 2012 7:14 | by

1. Very relevant nature news on two layers of behavioural variability

https://www.nature.com/neuro/journal/v15/n11/full/nn.3247.html

This article argues about the presence of variability during the onset of stimuli.

2. detailed the formulae behind the fft function and relevant mathematical equations.

3. Started writing introduction part of my thesis; finished writing material and methods section except  some cartoons.

May be I should start writing the results section alongside.

3. Third round of cross for self learning experiment with c105-c232 gal4 lines under way.

 

Print Friendly, PDF & Email

c232,105yx UAS-TNT self learning

on Saturday, October 27th, 2012 4:44 | by

none of the group learn. Flies are quite weak. The two groups with UAS show a clear problem in operant behavior (low score during learning phases)…

Print Friendly, PDF & Email

Torque distribution

on Wednesday, October 24th, 2012 2:17 | by

I had seen beautiful bell shaped distribution of torque (around 0) from the Heisenberg’s lab. We thus checked the data we have (the 6 minutes data we produced with the same flies for the torque meter and compensator. Data produced on the same day, or later (when sathish was mastering the preparation a bit better).
Here is the distributions:

Our distribution are close enough to the bell shape obtain by the Heisenberg’s group. The wing beat analyser seem to lead to different torque calculation, though.
PS: no difference seen in the frequency of spikes on the other hand.

Print Friendly, PDF & Email

SMap before and after self-learning: no difference

on Friday, October 19th, 2012 6:33 | by

small but significantly different from 0 slope in the S-Map procedure, both before and after self-learning.



No difference in the slope while comparing before and after learning for each fly.

n>130 for each group.

Print Friendly, PDF & Email

grip analysis on Buridan activity data

on Wednesday, October 17th, 2012 7:49 | by

Grip analysis on:

1. Interval between activities (temporal)

2.Difference between the subsequent activity (temporal) like  [X2-X1,X3-X2]

3.Difference between the subsequent distance travelled during the activity period (spatial)

4.Pysolo midline crossing data. Data sampling at 1 min interval. number of time fly crosses the virtual midline over the period of 60 s.

Bar: 1.c105;c232-wtb

2.c105232-TNT

3. Wtb-TNT

 

Inter-activity interval of buridan activity

 

2.Difference between the subsequent activity

Difference between the subsequent distance travelled during the activity period

pysolo midlines crossing

 

 

Print Friendly, PDF & Email

oct 16 log

on Tuesday, October 16th, 2012 9:29 | by

Matlab:

1.New data acquired from Julien for pretest and memory test differentiation, seems 2 min is not sufficient enough. Scripts are running and soon will post all the figures.

2. Buridan data analysis codes compiled and running grip analysis on the inter activity interval (temporal ) data.

3.Prepared scripts to run the difference between individual activity like Xt2-Xt1,Xt3-Xt2.,,.. To see  the randomness on  generated matrix. Yet to get the plots.

4.working on the midline crossing data in order to cross insert into the gripburidan analysis.

Log end

 

 

Print Friendly, PDF & Email

15 Oct Sathish’ log

on Monday, October 15th, 2012 6:43 | by

Well,

Since its lab notebook, I write in such a way that I could easily understand the tasks and rest could follow up. I will post figures with explanation and results whenever available.

Matlab:

1. working on the scripts to differentiate initial 2 min and last 2 min of self learning exp. to see the learning effect.

dataset suffix numbered in random fashion, unable to create handle to embed in struct field. Cell array conversion was possible but cant identify the fly specificities. Waiting to get updated version of data from Julien.

21 Hz corrected to 20 hz using interp1 method written and saved in home/character/Julien/

rest of code compiled and saved in same loc.

2. Buridan data – after analysis .csv file data is arranged on basis of activity and non activity.

wrote codes to extract each fly data out of .csv and place in .mat file to enable easy loop over. error due to presence of 2 activity log subsequently due to bursts inside activity matrix. troubled files isolated.

interval between each activity is considered as IAI .  Even number logic is used in script. data(m,n)*ones(M)

sprintf(‘sol%d’,’iteration’) leaves only string ,convert using str2num and call the metafile.Yet to compile.

3.Altered the Grip code such that grip does not try to convert the location of activity(spikes) to time domains.saved as griburidan.m only used with buridan and pysolo data.yet to compile to function

Flies:

1.crosses under way for self learning with crowd control

2.c819 Gal4 arrived from Bloomington n quarantined.

Log end

Print Friendly, PDF & Email