Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in cell lineage facet::CL:0000738]]
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='CL:0000738') AND t1.p_id=686)
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
0
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='CL:0000738') AND t1.p_id=686)
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
0
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 | 647 | 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)
- 10399-106A3 (acute myeloid leukemia (FAB M5) cell line:THP-1 (fresh))
- 10400-106A4 (acute myeloid leukemia (FAB M5) cell line:THP-1 (revived))
- 10405-106A9 (acute myeloid leukemia (FAB M5) cell line:THP-1 (thawed))
- 10416-106C2 (chronic lymphocytic leukemia (T-CLL) cell line:SKW-3)
- 10421-106C7 (adult T-cell leukemia cell line:ATN-1)
- 10422-106C8 (Burkitt's lymphoma cell line:DAUDI)
- 10427-106D4 (b cell line:RPMI1788)
- 10429-106D6 (acute lymphoblastic leukemia (T-ALL) cell line:HPB-ALL)
- 10435-106E3 (Hodgkin's lymphoma cell line:HD-Mar2)
- 10455-106G5 (acute lymphoblastic leukemia (B-ALL) cell line:BALL-1)
- 10457-106G7 (squamous cell lung carcinoma cell line:LC-1F)
- 10464-106H5 (acute lymphoblastic leukemia (T-ALL) cell line:Jurkat)
- 10467-106H8
- 10474-106I6 (myeloma cell line:PCM6)
- 10476-106I8 (Burkitt's lymphoma cell line:RAJI)
- 10478-107A1
- 10498-107C3
- 10501-107C6 (squamous cell lung carcinoma cell line:RERF-LC-AI)
- 10528-107F6
- 10534-107G3 (acute lymphoblastic leukemia (B-ALL) cell line:NALM-6)
- 10546-107H6
- 10547-107H7
- 10548-107H8
- 10563-108A5 (xeroderma pigentosum b cell line:XPL 17)
- 10564-108A6
- 10566-108A8
- 10574-108B7
- 10594-108D9
- 10625-108H4
- 10631-108I1 (diffuse large B-cell lymphoma cell line:CTB-1)
- 10704-109H2 (osteoclastoma cell line:Hs 706.T)
- 10711-109H9 (fibrous histiocytoma cell line:GCT TIB-223)
- 10712-109I1 (hairy cell leukemia cell line:Mo)
- 10725-110A5
- 10731-110B2
- 10744-110C6 (mycosis fungoides, T cell lymphoma cell line:HuT 102 TIB-162)
- 10745-110C7
- 10768-110F3
- 10773-110F8
- 10775-110G1 (lymphoma, malignant, hairy B-cell cell line:MLMA)
- 10777-110G3 (NK T cell leukemia cell line:KHYG-1)
- 10795-110I3 (anaplastic large cell lymphoma cell line:Ki-JK)
- 10808-111A7 (hereditary spherocytic anemia cell line:WIL2-NS)
- 10821-111C2 (B lymphoblastoid cell line: GM12878 ENCODE, biol_rep1)
- 10822-111C3 (B lymphoblastoid cell line: GM12878 ENCODE, biol_rep2)
- 10823-111C4 (B lymphoblastoid cell line: GM12878 ENCODE, biol_rep3)
- 10840-111E3 (plasma cell leukemia cell line:ARH-77)
- 11224-116B9 (CD14+ Monocytes, donor1)
- 11225-116C1 (CD4+ T Cells, donor1)
- 11226-116C2 (CD8+ T Cells, donor1)