Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in anatomy facet::UBERON:0005409]]
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:0005409') 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
55
OFFSET
30
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:0005409') 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
55
OFFSET
30
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 | 96 | 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
NoneHuman (Homo sapiens)
- 10523-107F1
- 10529-107F7
- 10535-107G4
- 10549-107H9 (gastric cancer cell line:AZ521)
- 10557-107I8
- 10560-108A2 (gastric cancer cell line:GSS)
- 10561-108A3
- 10596-108E2
- 10611-108F8
- 10612-108F9 (gastric adenocarcinoma cell line:MKN45)
- 10613-108G1
- 10614-108G2 (gastric adenocarcinoma cell line:MKN1)
- 10622-108H1
- 10635-108I5
- 10653-109B5
- 10654-109B6
- 10657-109B9
- 10680-109E5
- 10812-111B2 (normal intestinal epithelial cell line:FHs 74 Int)
- 11239-116D6 (Smooth Muscle Cells - Colonic, donor1)
- 11246-116E4 (Intestinal epithelial cells (polarized), donor1)
- 11320-117D6 (Smooth Muscle Cells - Colonic, donor2)
- 11396-118D1 (Smooth Muscle Cells - Colonic, donor3)
- 11509-119G6 (Smooth Muscle Cells - Intestinal, donor1)
- 11589-120G5
- 11670-122G5
- 11848-124I3 (CD326+ enterocyte, pool1)
- 11849-124I4 (CD326+ enterocyte, pool2)
- 11850-124I5 (CD326+ enterocyte isolated from mice, treated with RANKL, day03, pool1)
- 11851-124I6 (CD326+ enterocyte isolated from mice, treated with RANKL, day03, pool2)
- 11852-124I7 (CD326++ enterocyte isolated from mice, treated with RANKL, day03, pool1)
- 11853-124I8 (CD326++ enterocyte isolated from mice, treated with RANKL, day03, pool2)
- 12228-129F5 (Lgr5 positive intestinal stem cells, pool1)
- 12229-129F6 (Lgr5 positive intestinal stem cells, pool2)
- 12230-129F7 (Lgr5 positive intestinal stem cells, pool3)
- 12247-129H6 (natural helper cells, IL2 treated, day15, biol_rep1)
- 12248-129H7 (natural helper cells, IL2 treated, day15, biol_rep2)
- 12249-129H8 (natural helper cells, IL2 treated, day15, biol_rep3)
- 1251-16I5 (intestine, embryo E12)
- 1252-16G8 (stomach, embryo E15)
- 1286-20C6 (stomach, embryo E18)
- 1289-20F7 (intestine, embryo E18)
- 1322-23E9 (intestine, neonate N01)
- 1340-24B8 (stomach, neonate N03)
- 1352-25E3 (intestine, neonate N25)
- 1355-25E4 (stomach, neonate N25)
- 1384-42G1 (intestine, neonate N30)
- 1386-42I1 (stomach, neonate N30)
- 178-9A3 (intestine, adult)
- 33-1H6 (stomach, adult)