• Home
  • Stocks
  • Downloadable stock lists and associated information

Downloadable stock lists and associated information

Here we provide links to downloadable comma separated value (.csv) files carrying stock data for use locally. 

Important - please note that, as of 10/5/2018, the bloomington.csv has changed.  Some of the information formerly carried in the bloomington.csv is now carried in stockcomps_map_comments.csv. 

1) bloomington.csv - This is the basic downloadable version of the BDSC stock list. It carries all currently available stocks.

  • Stk # - BDSC stock number
  • Genotype
  • Ch # all - all affected chromosomes
  • A.K.A. - 'Also Known As' (stock synonyms)
  • Date added - the date the stock was added to the collection
  • Donor info - names and affiliations of the person(s) who donated the stock
  • Stock comments - comments that pertain to the stock as a whole (comments pertaining to individual components within a stock can be found in stockcomps_map_comments.csv below)

2) stockcomps_map_comments.csv - Note, we define a component as an individual unit within a genotype such as an allele, insertion, deficiency, etc. For example, y[1] sc[*] v[1]; P{y[+t7.7] v[+t1.8]=TRiP.HMC03795}attP40 has four components; y[1], sc[*], v[1], and P{y[+t7.7] v[+t1.8]=TRiP.HMC03795}attP40.

This file carries mapping information and/or comment(s) for individual components as well as the stock number(s) and genotypes for stocks that carry those components. Be aware that in an effort to keep this file from being too unwieldy, ONLY components that have map data and/or comment data are included.

  • Stk # - BDSC stock number
  • Genotype
  • component_symbol - the FlyBase symbol for a component (only components with map data and/or comments are included)
  • fbid - the FlyBase identifier for the component
  • mapstatement - map information for the component
  • comment1 - component comment (usually a descriptive comment)
  • comment2 - additional comment (often a map comment)
  • comment3 - additional comment

3) stockgenes.csv - This file carries stock numbers and their genotypes with ALL associated components and their associated genes (this is big file with >328,000 records).

  • stknum: BDSC stock number
  • genotype
  • component_symbol: the FlyBase symbol for a component
  • gene_symbol: the FlyBase genes associated with the component
  • fbgn: the FBgn identifier for the gene
  • bdsc_symbol_id: BDSC ID number for the component (not a stock number!)
  • bdsc_gene_id: BDSC ID number for the gene

4) stockgenes_compgenes.csv - This file carries data describing the relationship between a component and a gene (the component carries sequences for RNAi of the gene, the component is inserted into the gene, the component carries regulatory sequences from the gene, etc).

  • bdsc_symbol_id: BDSC ID number for the component (not a stock number!)
  • bdsc_gene_id: BDSC ID number for a gene
  • compgeneprop_id: BDSC ID number describing the relationship between a component and a gene
  • prop_syn: description of the relationship between a component and a gene

5) stockgenes_compprops.csv - This file carries data pertaining to symbols and their attributes (viability, uses, tags etc). These attributes are mostly used to pull components and stocks onto specific stock browsing pages so this list is by no means meant to be exhaustive.

  • bdsc_symbol_id: BDSC ID number for the component (not a stock number!)
  • property_id: BDSC ID number for property descriptions
  • property_descrip: descriptions of specific component attributes
  • prop_syn: an abbreviated description or synonym

Don't see what you need? Please contact us!