Database Schema

Schema documentation covering the tellic data structure across neo4j and SOLR indices

This documentation represent the most current tellic data schema. 

Last updated on: July 1st, 2020


neo4j schema

Schema for entities

Nodes_Drug
entity_type
ontology
concept_id
entity_name
label
class
synonyms
molecule_type

 

Nodes_Gene
entity_type
ontology
concept_id
entity_name
label
class
gene_type
synonyms
uniprot_id
ensembl_id
entrez_id
mgd_ids
opentargets_link

 

Nodes_Disease
entity_type
ontology
concept_id
entity_name
label
class
therapeutic_areas
synonyms

 

Nodes_Phenotype
entity_type
ontology
concept_id
entity_name
label
class
definition
synonyms

 

Nodes_Variant
entity_type
ontology
concept_id
entity_name
label
class
chromosome
position
synonyms

 

Schema for relationships

processed_relationships_with_strength
relUid
num_of_merged
avg_strength
min_epoch_time
max_epoch_time
concept_1_id
concept_2_id

 

processed_relationships_without_strength

relUid
num_of_merged
min_epoch_time
max_epoch_time
concept_1_id
concept_2_id 

 

 

 

 

 

 


SOLR schema

Publication metadata

solr_relationships_pubs 

relUid
tellic_evidence_id
start_node
end_node
source_type
source_id
source_name
strength
sentence_text
concept_1_mention
concept_1_start
concept_1_end
concept_2_mention
concept_2_start
concept_2_end
sentence_no
title
author
date
epoch_time
journal
impact_factor
link

 

Clinical Trial metadata

solr_relationships_ct
relUid
tellic_evidence_id
start_node
end_node
source_type
source_id
source_name
title
sponsor
conditions
interventions
phase
start_date
end_date
epoch_time
link

 

GWAS metadata

solr_relationships_gwas
relUid
tellic_evidence_id
start_node
end_node
concept_1_mention
concept_2_mention
source_type
source_id
source_name
p_log_value
date
epoch_time
journal
impact_factor
study_accession
study_title
author
link

 

Patent metadata

solr_relationships_patents 

relUid
tellic_evidence_id
start_node
end_node
source_type
source_id
source_name
strength
sentence_text
concept_1_mention
concept_1_start
concept_1_end
concept_2_mention
concept_2_start
concept_2_end
sentence_no
title
inventor
assignee
filing_type
date
epoch_time
link

 

Timeline functionality

solr_relationships_with_strength

relUid
source_type
strength
epoch_time

 

solr_relationships_without_strength

relUid
source_type
epoch_time

 

SOLR datatypes

relUid: string
tellic_evidence_id: string
start_node: string
end_node: string
source_type: string
source_id: string
source_name: string
strength: pfloat
sentence_text: text_general
concept_1_mention: string
concept_2_mention: string
sentence_no: pint
title: text_general
author: text_general
date: pdate
epoch_time: plong
journal: text_general
impact factor: pfloat
link: string

sponsor: text_general
conditions: text_general
interventions: text_general
phase: text_general
start_date: pdate
end_date: pdate

variant_name: string
p_log_value: pfloat
study_accession: string
study_title: text_general

inventor: text_general
assignee: text_general
filing_type: string