Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in anatomy facet::UBERON:0000481]]
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:0000481') 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
505
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:0000481') 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
505
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 | 372 | 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)
- 10038-101F2 (medulla oblongata, adult, pool1)
- 10039-101F3 (insula, adult, pool1)
- 10040-101F4 (frontal lobe, adult, pool1)
- 10042-101F6 (corpus callosum, adult, pool1)
- 10047-101G2 (tonsil, adult, pool1)
- 10059-101H5 (tongue, fetal, donor1)
- 10062-101H8 (stomach, fetal, donor1)
- 10063-101H9 (temporal lobe, fetal, donor1)
- 10064-101I1 (small intestine, fetal, donor1)
- 10067-101I4 (rectum, fetal, donor1)
- 10070-101I7 (colon, fetal, donor1)
- 10071-101I8 (duodenum, fetal, donor1)
- 10072-101I9 (parietal lobe, fetal, donor1)
- 10073-102A1 (occipital lobe, fetal, donor1)
- 10076-102A4 (occipital lobe, adult, donor1)
- 10082-102B1 (colon, adult, donor1)
- 10083-102B2 (cerebellum, adult, pool1)
- 10093-102C3 (salivary gland, adult, pool1)
- 10114-102E6 (cerebellum)
- 10115-102E7 (cerebellum)
- 10116-102E8 (cerebellum)
- 10117-102E9 (cerebellum)
- 10118-102F1 (cerebellum)
- 10119-102F2 (cerebellum)
- 10120-102F3 (cerebellum)
- 10121-102F4 (cerebellum)
- 10122-102F5 (cerebellum)
- 10123-102F6 (cerebellum)
- 10124-102F7 (cerebellum)
- 10125-102F8 (cerebellum)
- 10126-102F9 (cerebellum)
- 10127-102G1 (cerebellum)
- 10128-102G2 (cerebellum)
- 10129-102G3 (cerebellum)
- 10130-102G4 (cerebellum)
- 10131-102G5 (cerebellum)
- 10132-102G6 (cerebellum)
- 10133-102G7 (cerebellum)
- 10134-102G8 (cerebellum)
- 10135-102G9 (cerebellum)
- 10136-102H1 (cerebellum)
- 10137-102H2 (cerebellum)
- 10138-102H3 (cerebellum)
- 10139-102H4 (cerebellum)
- 10140-102H5 (cerebellum)
- 10141-102H6 (cerebellum)
- 10142-102H7 (cerebellum)
- 10143-102H8 (cerebellum)
- 10144-102H9 (cerebellum)
- 10145-102I1 (cerebellum)
- 10146-102I2 (cerebellum)
- 10147-102I3 (cerebellum)
- 10148-102I4 (cerebellum)
- 10149-102I5 (cerebellum)
- 10150-102I6 (medial frontal gyrus, adult, donor10252)
- 10151-102I7 (amygdala, adult, donor10252)
- 10152-102I8 (putamen, adult, donor10252)
- 10153-102I9 (hippocampus, adult, donor10252)
- 10154-103A1 (thalamus, adult, donor10252)
- 10155-103A2 (medulla oblongata, adult, donor10252)
- 10156-103A3 (medial temporal gyrus, adult, donor10252)
- 10157-103A4 (parietal lobe, adult, donor10252)
- 10158-103A5 (substantia nigra, adult, donor10252)
- 10160-103A7 (pineal gland, adult, donor10252)
- 10161-103A8 (globus pallidus, adult, donor10252)
- 10162-103A9 (pituitary gland, adult, donor10252)
- 10163-103B1 (occipital cortex, adult, donor10252)
- 10164-103B2 (caudate nucleus, adult, donor10252)
- 10165-103B3 (locus coeruleus, adult, donor10252)
- 10166-103B4 (cerebellum, adult, donor10252)
- 10167-103B5 (amygdala - adult, donor10196)
- 10168-103B6 (thalamus - adult, donor10196)
- 10169-103B7 (hippocampus - adult, donor10196)
- 10170-103B8 (medial frontal gyrus - adult, donor10196)
- 10171-103B9 (parietal lobe - adult, donor10196)
- 10172-103C1 (occipital cortex - adult, donor10196)
- 10173-103C2 (cerebellum - adult, donor10196)
- 10174-103C3 (medulla oblongata - adult, donor10196)
- 10175-103C4 (globus pallidus - adult, donor10196)
- 10176-103C5 (putamen, adult, donor10196)
- 10177-103C6 (caudate nucleus - adult, donor10196)
- 10178-103C7 (substantia nigra - adult, donor10196)
- 10179-103C8 (pineal gland - adult, donor10196)
- 10180-103C9 (pituitary gland - adult, donor10196)
- 10182-103D2 (locus coeruleus - adult, donor10196)
- 10183-103D3 (medial temporal gyrus - adult, donor10196)
- 10189-103D9 (appendix, adult)
- 10193-103E4 (diencephalon, adult)
- 10194-103E5
- 10199-103F1 (parotid gland, adult)
- 10202-103F4 (submaxillary gland, adult)
- 10203-103F5 (tongue, adult)
- 10208-103G1
- 10235-104A1 (visual cortex - wildtype)
- 10236-104A2 (visual cortex - wildtype)
- 10237-104A3 (visual cortex - wildtype)
- 10238-104A4 (visual cortex - wildtype)
- 10239-104A5 (visual cortex - wildtype)
- 10240-104A6 (visual cortex - wildtype)
- 10241-104A7 (visual cortex - wildtype)
- 10242-104A8 (visual cortex - wildtype)
- 10243-104A9 (visual cortex - wildtype)
- 10244-104B1 (visual cortex - Mecp knockout)
- 10245-104B2 (visual cortex - Mecp knockout)
- 10246-104B3 (visual cortex - Mecp knockout)
- 10247-104B4 (visual cortex - Mecp knockout)
- 10248-104B5 (visual cortex - Mecp knockout)
- 10249-104B6 (visual cortex - Mecp knockout)
- 10250-104B7 (visual cortex - Mecp knockout)
- 10251-104B8 (visual cortex - Mecp knockout)
- 10252-104B9 (Ileum epithelium, pool1)
- 10253-104C1 (Ileum epithelium, pool2)
- 10254-104C2
- 10255-104C3
- 10256-104C4
- 10257-104C5
- 10258-104C6
- 10259-104C7
- 10260-104C8 (Ileum epithelium, treated with RANKL, day03, pool3)
- 10261-104C9
- 10262-104D1 (Follicle Associated Epithelium, pool2)
- 10263-104D2 (Follicle Associated Epithelium, pool3)
- 10288-104F9 (tongue epidermis (fungiform papillae), donor1)
- 10289-104G1
- 10316-105A1
- 10317-105A2
- 10344-105D2
- 10345-105D3
- 10349-105D7 (visual cortex - wildtype)
- 1035-18D5 (stomach, embryo E17)
- 10350-105D8 (visual cortex - Mecp knockout)
- 10352-105E1 (medial frontal gyrus, newborn, donor10223)
- 10353-105E2 (medial temporal gyrus, newborn, donor10223)
- 10354-105E3 (caudate nucleus, newborn, donor10223)
- 10355-105E4 (occipital cortex, newborn, donor10223)
- 10356-105E5 (parietal lobe, newborn, donor10223)
- 10357-105E6 (cerebellum, newborn, donor10223)
- 10358-105E7 (substantia nigra, newborn, donor10223)
- 10360-105E9 (amygdala, newborn, donor10223)
- 10361-105F1 (medulla oblongata, newborn, donor10223)
- 10362-105F2 (locus coeruleus, newborn, donor10223)
- 10363-105F3 (hippocampus, newborn, donor10223)
- 10364-105F4 (globus pallidus, newborn, donor10223)
- 10365-105F5 (putamen, newborn, donor10223)
- 10366-105F6 (thalamus, newborn, donor10223)
- 10367-105F7 (globus pallidus, adult, donor10258)
- 10368-105F8 (medial frontal gyrus, adult, donor10258)
- 10370-105G1 (thalamus, adult, donor10258)
- 10371-105G2 (substantia nigra, adult, donor10258)
- 10372-105G3 (putamen, adult, donor10258)
- 10373-105G4 (parietal cortex, adult, donor10258)
- 10374-105G5 (hippocampus, adult, donor10258)
- 10375-105G6 (locus coeruleus, adult, donor10258)
- 10376-105G7 (medial temporal gyrus, adult, donor10258)
- 10377-105G8 (pineal gland, adult, donor10258)
- 10378-105G9 (pituitary gland, adult, donor10258)
- 10417-106C3 (papillotubular adenocarcinoma cell line:TGBC18TKB)
- 10420-106C6 (colon carcinoma cell line:COLO-320)
- 10434-106E2 (oral squamous cell carcinoma cell line:Ca9-22)
- 10436-106E4 (signet ring carcinoma cell line:Kato III)
- 10459-106G9
- 10469-106I1 (rectal cancer cell line:TT1TKB)
- 10473-106I5
- 10511-107D7
- 10512-107D8
- 10513-107D9 (colon carcinoma cell line:CACO-2)
- 10516-107E3
- 10520-107E7
- 10523-107F1
- 10529-107F7
- 10532-107G1
- 10535-107G4
- 10537-107G6
- 10544-107H4 (oral squamous cell carcinoma cell line:SAS)
- 10545-107H5 (oral squamous cell carcinoma cell line:HSC-3)
- 10549-107H9 (gastric cancer cell line:AZ521)
- 10550-107I1 (oral squamous cell carcinoma cell line:HO-1-u-1)
- 10557-107I8
- 10560-108A2 (gastric cancer cell line:GSS)
- 10561-108A3
- 10588-108D3
- 10596-108E2
- 10611-108F8
- 10612-108F9 (gastric adenocarcinoma cell line:MKN45)
- 10613-108G1
- 10614-108G2 (gastric adenocarcinoma cell line:MKN1)
- 10617-108G5
- 10622-108H1
- 10635-108I5
- 10653-109B5
- 10654-109B6
- 10657-109B9
- 10658-109C1
- 10660-109C3
- 10661-109C4
- 10665-109C8
- 10680-109E5
- 10723-110A3 (pharyngeal carcinoma cell line:Detroit 562)
- 10724-110A4
- 10733-110B4
- 10812-111B2 (normal intestinal epithelial cell line:FHs 74 Int)
- 10813-111B3 (normal embryonic palatal mesenchymal cell line:HEPM)
- 11214-116A8 (Mesenchymal stem cells - umbilical, donor0)
- 11221-116B6 (Gingival epithelial cells, donor1 (GEA11))
- 11222-116B7 (Fibroblast - Gingival, donor4 (GFH2))
- 11223-116B8 (Fibroblast - Periodontal Ligament, donor4 (PL29))
- 11235-116D2 (Astrocyte - cerebral cortex, donor1)
- 11237-116D4 (Fibroblast - Gingival, donor1)
- 11238-116D5 (Fibroblast - Periodontal Ligament, donor1)
- 11239-116D6 (Smooth Muscle Cells - Colonic, donor1)
- 11246-116E4 (Intestinal epithelial cells (polarized), donor1)
- 11251-116E9 (Keratinocyte - oral, donor1)
- 11302-117B6 (Gingival epithelial cells, donor2 (GEA14))
- 11303-117B7 (Fibroblast - Gingival, donor5 (GFH3))
- 11304-117B8 (Fibroblast - Periodontal Ligament, donor5 (PL30))
- 11316-117D2 (Astrocyte - cerebral cortex, donor2)
- 11318-117D4 (Fibroblast - Gingival, donor2)
- 11319-117D5 (Fibroblast - Periodontal Ligament, donor2)
- 11320-117D6 (Smooth Muscle Cells - Colonic, donor2)
- 11379-118B2 (Gingival epithelial cells, donor3 (GEA15))
- 11380-118B3 (Fibroblast - Periodontal Ligament, donor6 (PLH3))
- 11392-118C6 (Astrocyte - cerebral cortex, donor3)
- 11394-118C8 (Fibroblast - Gingival, donor3)
- 11395-118C9 (Fibroblast - Periodontal Ligament, donor3)
- 11396-118D1 (Smooth Muscle Cells - Colonic, donor3)
- 11489-119E4 (Mouse Neurons - substantia nigra, donor4)
- 11490-119E5 (Mouse Neurons - substantia nigra, donor5)
- 11495-119F1
- 11500-119F6 (Astrocyte - cerebellum, donor1)
- 11507-119G4 (Esophageal Epithelial Cells, donor1)
- 11508-119G5 (Smooth Muscle Cells - Esophageal, donor1)
- 11509-119G6 (Smooth Muscle Cells - Intestinal, donor1)
- 11539-120A9 (Mesenchymal Stem Cells - umbilical, donor1)
- 11548-120B9 (Mesenchymal Stem Cells - Wharton's Jelly, donor1)
- 11549-120C1 (Multipotent Cord Blood Unrestricted Somatic Stem Cells, donor1)
- 11550-120C2 (Mouse Astrocytes - cerebellar, donor2)
- 11551-120C3 (Mouse Astrocytes - hippocampus, donor2)
- 11575-120E9
- 11580-120F5 (Astrocyte - cerebellum, donor2)
- 11587-120G3 (Esophageal Epithelial Cells, donor2)
- 11588-120G4 (Smooth Muscle Cells - Esophageal, donor2)
- 11589-120G5
- 11619-122A8 (Mesenchymal Stem Cells - umbilical, donor2)
- 11628-122B8
- 11629-122B9 (Multipotent Cord Blood Unrestricted Somatic Stem Cells, donor2)
- 11631-122C2
- 11632-122C3 (Mouse Astrocytes - hippocampus, donor3)
- 11642-122D4
- 11643-122D5 (Mouse Neurons - dorsal spinal cord, donor3)
- 11644-122D6 (Mouse Neurons - hippocampal, donor3)
- 11645-122D7 (Mouse Neurons - raphe, donor3)
- 11646-122D8 (Mouse Neurons - striatal, donor3)
- 11647-122D9 (Mouse Neurons - cortical, donor3)
- 11648-122E1 (Mouse Neurons - ventral spinal cord, donor3)
- 11649-122E2
- 11656-122E9
- 11661-122F5 (Astrocyte - cerebellum, donor3)
- 11668-122G3 (Esophageal Epithelial Cells, donor3)
- 11669-122G4
- 11670-122G5
- 11700-123A8 (Mesenchymal Stem Cells - umbilical, donor3)
- 11708-123B7 (Mouse Astrocytes - cerebellar, donor1)
- 11709-123B8 (Mouse Astrocytes - hippocampus, donor1)
- 11719-123C9
- 11720-123D1 (Mouse Neurons - dorsal spinal cord, donor1)
- 11721-123D2 (Mouse Neurons - hippocampal, donor1)
- 11722-123D3 (Mouse Neurons - raphe, donor1)
- 11723-123D4 (Mouse Neurons - striatal, donor1)
- 11724-123D5 (Mouse Neurons - cortical, donor1)
- 11725-123D6 (Mouse Neurons - ventral spinal cord, donor1)
- 11726-123D7
- 11737-123E9
- 11738-123F1 (Mouse Neurons - dorsal spinal cord, donor2)
- 11739-123F2 (Mouse Neurons - hippocampal, donor2)
- 11740-123F3 (Mouse Neurons - raphe, donor2)
- 11741-123F4 (Mouse Neurons - striatal, donor2)
- 11742-123F5 (Mouse Neurons - cortical, donor2)
- 11743-123F6 (Mouse Neurons - ventral spinal cord, donor2)
- 11744-123F7
- 11770-123I6 (Mouse Neurons - substantia nigra, donor6)
- 11771-123I7 (salivary acinar cells, donor1)
- 11772-123I8 (salivary acinar cells, donor2)
- 11773-123I9 (salivary acinar cells, donor3)
- 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)
- 11921-125H4 (Fibroblast - Gingival, donor6 (aggressive periodontitis))
- 11922-125H5 (Fibroblast - Gingival, donor6 (control))
- 11923-125H6 (Fibroblast - Gingival, donor7 (aggressive periodontitis))
- 11924-125H7 (Fibroblast - Gingival, donor7 (control))
- 11925-125H8 (Fibroblast - Gingival, donor8 (chronic periodontitis))
- 11926-125H9 (Fibroblast - Gingival, donor8 (control))
- 11927-125I1 (Fibroblast - Gingival, donor9 (control))
- 11928-125I2 (Fibroblast - Gingival, donor10 (periodontitis))
- 12-14D5 (cortex, adult)
- 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)
- 1265-44F5 (pituitary gland, embryo E17)
- 1286-20C6 (stomach, embryo E18)
- 1289-20F7 (intestine, embryo E18)
- 13-16E8 (hippocampus, adult)
- 1308-22E9 (pituitary gland, neonate N00)
- 1322-23E9 (intestine, neonate N01)
- 1340-24B8 (stomach, neonate N03)
- 1352-25E3 (intestine, neonate N25)
- 13532-145G4 (cerebellar granule cells, embryo E13, biol_rep1 (E13R1))
- 13533-145G5 (cerebellar granule cells, embryo E13, biol_rep2 (E13R2))
- 13534-145G6 (cerebellar granule cells, embryo E13, biol_rep3 (E13R3))
- 13535-145G7 (cerebellar granule cells, embryo E15, biol_rep1 (E15R1))
- 13536-145G8 (cerebellar granule cells, embryo E15, biol_rep2 (E15R2))
- 13537-145G9 (cerebellar granule cells, embryo E15, biol_rep3 (E15R3))
- 13538-145H1 (cerebellar granule cells, embryo E18, biol_rep1 (E18R1))
- 13539-145H2 (cerebellar granule cells, embryo E18, biol_rep2 (E18R2))
- 13540-145H3 (cerebellar granule cells, embryo E18, biol_rep3 (E13R3))
- 1355-25E4 (stomach, neonate N25)
- 1384-42G1 (intestine, neonate N30)
- 1386-42I1 (stomach, neonate N30)
- 1388-42B2 (diencephalon, neonate N30)
- 1395-42I2 (cerebellum, neonate N30)
- 1396-42A3 (medulla oblongata, neonate N30)
- 15-8B2 (cerebellum, adult)
- 16-22A4 (corpora quadrigemina, adult)
- 17-12C2 (medulla oblongata, adult)
- 178-9A3 (intestine, adult)
- 19-21D8 (corpus striatum, adult)
- 20-12F2 (diencephalon, adult)
- 21-1G8 (pituitary gland, adult)
- 32-1B4 (tongue, adult)
- 33-1H6 (stomach, adult)
- 346-16E6 (pituitary gland, embryo E12)
- 356-43E3 (stomach, embryo E12)
- 36-18H7 (colon, adult)
- 37-13H4 (cecum, adult)
- 370-44C7 (pituitary gland, embryo E13)
- 381-16D5 (intestine, embryo E13)
- 398-44A5 (pituitary gland, embryo E14)
- 427-16B9 (pituitary gland, embryo E15)
- 449-43F6 (pituitary gland, embryo E16)
- 459-17D4 (stomach, embryo E16)
- 463-22H4 (intestine, embryo E16)
- 482-18D3 (intestine, embryo E17)
- 59-29C1 (submandibular gland, adult)
- 627-43G1 (hippocampus, neonate N00)
- 630-43F1 (corpus striatum, neonate N00)
- 644-26D1 (intestine, neonate N00)
- 688-20B8 (intestine, neonate N06)
- 718-18A9 (stomach, neonate N07)
- 720-20F2 (intestine, neonate N07)
- 755-23A5 (intestine, neonate N10)
- 790-21I1 (small intestine, neonate N16)
- 827-18D1 (intestine, neonate N20)
- 860-29I3 (intestinal mucosa, adult)
- 976-16D8 (intestine, embryo E15)