<?xml version="1.0"?>
<edsp version="3.1" about_me="http://ycmi.med.yale.edu/EAVCR/EDSP" source="Olfactory Receptors Database">
  <source>
    <type>eav/cr</type>
    <name>Data Store:SenseLab</name>
    <location>ordb.biotech.ttu.edu</location>
    <date>4/29/2026 4:08:50 PM</date>
    <query_method>GET</query_method>
    <query_parameter>o=112065</query_parameter>
  </source>
  <metadata type="partial" time="0">
    <datatypes>
      <datatype id="B" name="Boolean" xml_datatype="xs:boolean" />
      <datatype id="C" name="Object/Ref" xml_datatype="xs:long" />
      <datatype id="D" name="Datetime" xml_datatype="xs:dateTime" />
      <datatype id="F" name="Formula(only)" xml_datatype="xs:anyType" />
      <datatype id="H" name="Hierarchy(p)" xml_datatype="xs:long" />
      <datatype id="I" name="Integer" xml_datatype="xs:long" />
      <datatype id="M" name="Memo" xml_datatype="xs:string" />
      <datatype id="R" name="Real" xml_datatype="xs:double" />
      <datatype id="S" name="String" xml_datatype="xs:string" />
      <datatype id="V" name="Object/Value" xml_datatype="xs:long" />
      <datatype id="W" name="Object/Ref(MC)" xml_datatype="xs:long" />
      <datatype id="Y" name="Binary" xml_datatype="xs:base64Binary" />
    </datatypes>
    <metadata_ontology>
      <sem_type_atts />
      <sem_rel_types />
      <sem_rel_att />
    </metadata_ontology>
    <database id="d2" name="modeldb" caption="ModelDB" caption_long="Model Database" description="ModelDB provides an accessible location for storing and efficiently retrieving compartmental neuron models. ModelDB is tightly coupled with NeuronDB. Models can be coded in any language for any environment, though ModelDB has been initially constructed for use with NEURON and GENESIS. Model code can be viewed before downloading and browsers can be set to auto-launch the models" main_class="19" version="3" version_date="4/12/2002 11:28:19 AM">
      <class id="c73" name="sql_programs" caption="SQL programs" description="These SQL programs are intended to display tables that are useful for administration and development of scripts." object_description_hide="false" type="E" is_concept="false" host_concepts="false" uid="" version="3" version_date="4/27/2003 9:43:11 AM">
        <att id="a229" dt_id="M" sn="1" name="sql_program" caption="SQL Program" description="This stores an SQL program" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="1" version_date="4/27/2003 9:45:32 AM" />
        <att id="a230" dt_id="I" sn="2" name="max_rows" caption="Maximum Rows" description="This variable determines the maximum number of rows that are desired to be displayed. If set to &quot;-1&quot; then all rows are displayed." width="20" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="2" version_date="4/27/2003 9:52:03 AM" />
        <att id="a231" dt_id="I" sn="3" name="max_cols" caption="Maximum Columns" description="This variable determines the maximum number of columns that are desired to be displayed. If set to &quot;-1&quot; then all columns are displayed." width="20" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="2" version_date="4/27/2003 10:36:43 AM" />
      </class>
    </database>
  </metadata>
  <data time="0">
    <data_database db_id="d2">
      <data_class class_id="c73" version="3">
        <object id="o112065" name="Select papers that have text or citation references to ModelDB" description="" uid="" version="7" version_date="1/12/2018 1:41:28 PM">
          <att_value att_id="a229" value="select row_number() over (ORDER BY year.VALUE_ DESC, papers.object_name) as row ,  papers.object_id as OBJECTID,papers.object_name as PAPERNAME, paperusage.object_name as USAGE, year.value_&#xD;&#xA;from objects papers inner join eav_objects statedusage on papers.object_id=statedusage.object_id and papers.object_class=42 inner join objects paperusage on paperusage.object_id=statedusage.value_    and statedusage.attribute_id=452  left join eav_string year on year.OBJECT_ID = papers.OBJECT_ID and year.ATTRIBUTE_ID = 154&#xD;&#xA;ORDER BY year.VALUE_ DESC, papers.object_name" />
        </object>
      </data_class>
    </data_database>
  </data>
</edsp>

