Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in anatomy facet::UBERON:0000489]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='UBERON:0000489') AND t1.p_id=687)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
255
OFFSET
10
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='UBERON:0000489') AND t1.p_id=687)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
255
OFFSET
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 71 | 100.00 | Using index condition; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | resource_browser.t1.s_id | 1 | 50.00 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneMouse (Mus musculus)
- 10418-106C4 (transitional-cell carcinoma cell line:5637)
- 10450-106F9 (embryonic kidney cell line: HEK293/SLAM untreated)
- 10451-106G1 (embryonic kidney cell line: HEK293/SLAM infection, 24hr)
- 10466-106H7
- 10471-106I3 (renal cell carcinoma cell line:TUHR10TKB)
- 10517-107E4
- 10518-107E5
- 10519-107E6
- 10540-107G9
- 10565-108A7
- 10587-108D2
- 10597-108E3 (Wilms' tumor cell line:HFWT)
- 10721-110A1 (leiomyoblastoma cell line:G-402)
- 10739-110C1
- 10747-110C9
- 10751-110D4
- 10809-111A8 (Wilms' tumor cell line:G-401)
- 10811-111B1
- 11514-119H2 (Renal Glomerular Endothelial Cells, donor1)
- 11515-119H3 (Renal Proximal Tubular Epithelial Cell, donor1)
- 11516-119H4 (Renal Cortical Epithelial Cells, donor1)
- 11517-119H5 (Renal Epithelial Cells, donor1)
- 11518-119H6 (Renal Mesangial Cells, donor1)
- 11519-119H7 (Smooth Muscle Cells - Bladder, donor1)
- 11590-120G6 (Alveolar Epithelial Cells, donor2)
- 11594-120H1 (Renal Glomerular Endothelial Cells, donor2)
- 11595-120H2 (Renal Proximal Tubular Epithelial Cell, donor2)
- 11596-120H3 (Renal Cortical Epithelial Cells, donor2)
- 11597-120H4 (Renal Epithelial Cells, donor2)
- 11598-120H5 (Renal Mesangial Cells, donor2)
- 11599-120H6
- 11643-122D5 (Mouse Neurons - dorsal spinal cord, donor3)
- 11648-122E1 (Mouse Neurons - ventral spinal cord, donor3)
- 11650-122E3
- 11675-122H1 (Renal Glomerular Endothelial Cells, donor3)
- 11676-122H2 (Renal Proximal Tubular Epithelial Cell, donor3)
- 11677-122H3
- 11678-122H4 (Renal Epithelial Cells, donor3)
- 11679-122H5 (Renal Mesangial Cells, donor3)
- 11680-122H6
- 11720-123D1 (Mouse Neurons - dorsal spinal cord, donor1)
- 11725-123D6 (Mouse Neurons - ventral spinal cord, donor1)
- 11727-123D8 (Mouse Renal epithelial cells, donor1)
- 11738-123F1 (Mouse Neurons - dorsal spinal cord, donor2)
- 11743-123F6 (Mouse Neurons - ventral spinal cord, donor2)
- 11745-123F8
- 11783-124B1 (Renal Glomerular Endothelial Cells, donor4)
- 11948-126B4 (Pre-hematopoietic stem cell, aorta-gonad-mesonephros (AGM) region derived, embryo E9.5)
- 11951-126B7 (hematopoietic stem cell,aorta-gonad-mesonephros (AGM) region derived, embryo E11.5)
- 1288-20C7 (kidney, embryo E18)
- 1353-25F3 (kidney, neonate N25)
- 1385-42H1 (kidney, neonate N30)
- 24-13C9 (spinal cord, adult)
- 411-4I9 (kidney, embryo E14)
- 434-16F8 (kidney, embryo E15)
- 464-22A5 (kidney, embryo E16)
- 483-18I2 (kidney, embryo E17)
- 646-21G7 (kidney, neonate N00)
- 758-6D5 (kidney, neonate N10)
- 832-19I1 (kidney, neonate N20)
- 879-12E4 (urinary bladder, adult)