OrDB

SQL programs - List


 
Name
1 access log
2 all NeuronDB neurons
3 all open requests for models
4 all open requests for models by Tom Morse
5 alternate models a la showmodel
6 Check if a UserID has rights to access the ModelDB pipeline.
7 count of Non-NEURON models added last year
8 count papers that are between two dates
9 day made public, serialno, accession, modelname, provenance **** This is the one that words ****
10 debug hierarchy display
11 debug link counts
12 debug: select 200 most prolific authors
13 Details of attributes of models
14 develop cell list hierarchy
15 display hierarcy class like 20, canonical compartments
16 Display paper name and start page
17 display papers that have "doi" in the doi field
18 find all models who's papers have pubmed id(s)
19 find alternate models for particular model
20 Find alternate models versions
21 find how many reference links
22 find implementers
23 find models whose papers have a particular pubmed id
24 find models whose papers have doi's
25 find models whose papers have doi`s for specific doi
26 find number of alternative models
27 find number of references in papers with references
28 find obj id and name for children from vertebrate parent in extended cell tree
29 find relationships to children for parent vertebrate in tree
30 find roots of extended cell tree
31 Find the 100 Most Cited Papers
32 Find the 200 most prolific ModelDB paper authors
33 FindPapers prototype
34 implementers number of public models
35 J Neurophysiol public models
36 list model accession numbers and create date
37 list neurondb names by create date
38 list neurons alphabetically
39 list nn models
40 list of NEURON models sorted by date for a particular year
41 made public date,non-NEURON simulator models entered in modeldb 20070431-20080501
42 made public date,non-NEURON simulator models entered in modeldb over 20060431-20070501
43 model object id and topic pairs
44 model publicdate, obj id, name, becausewas
45 model serial no, obj id, name, and made public date
46 models add because unsolicited (only)
47 models added because solicited
48 models between 20050431 and 20060501
49 models by simulator
50 models list for a cell type 52420
51 models sorted by publication date, paper name
52 modified NeuronDB neuron object finder
53 network models before 20040801
54 network models before 20040801 with cells
55 network models before 20080501
56 network models before 20080501 with cell counts
57 network models before 20080501 with cells
58 network models with object id and name
59 network models with object id only displayed
60 neuron and neuron(web-link to model) models
61 NeuronDB report: neurons with notes
62 NeuronDB report: num of notes for neurons alphabetically sorted
63 NeuronDB report: number of notes for neurons numerically sorted
64 num mdb grp implemented models between 20060431 and 20070501
65 num models between 20050431 and 20060501
66 num models between 20060431 and 20070501
67 num models made public in 2006
68 num solicited models between 20060431 and 20070501
69 num unsolicited models between 20060431 and 20070501
70 number of journal names
71 number of modeldbs model articles in each journal
72 number of neuron types in NN models before 20040801
73 Number of public models that cite a paper
74 Number of public models that cite a paper w title
75 Number of refs in NeuronDB with object_id
76 object id and date made public for models documented with Provenance
77 objects fields
78 papers created by Liz
79 papers entered from a date onward
80 papers without pubmed id
81 papers, year, month, with text or citation references to ModelDB
82 Provenance model object id and date made public
83 public model creation time
84 public models and simulator sorted by create date
85 public models not classified in provenance
86 public models ordered by creation date
87 replicate NeuronDB query
88 requests for models that need follow ups
89 Same Name and Date Papers
90 Search for papers by auth, first page, year
91 SearchForModelsByAuthor
92 Select papers that have text or citation references to ModelDB
93 Show all alternate models descriptions
94 show all receptors
95 Show article authors year journal and other details for public models
96 Show Attributes-Datatypes for MDB
97 show children only for attribute neurotransmitters
98 show children only for attribute receptors
99 show concept eav_objects
100 show concept objects
101 show journals attached to public models
102 show just authors and journal for models
103 Show model type (Network, neuron, dendr.) of models sorted by date
104 show papers that cite modeldb in order of creation
105 show roots (these have no parents) for neurotransmitters
106 show roots (these have no parents) for receptors
107 simulator fields by create date
108 simulator homepages
109 simulators
110 sorted concept (Topic) usage by all the models
111 test
112 The 1000 most recently entered papers
113 unique made public date, accession # for models
114 unique made public date, accession # for non NEURON models added over last year