错误信息提示:
错误号:12142

错误原因:Table 'hscellor_ncrdeathdb.ncrnadeathmiRNA2targetDB' doesn't exist

错误sql语句:
select * from ncrnadeathmiRNA2targetDB where mirnaSymbol like '%miR-19b' and taxid like '9606'
——错误记录被保存!

ncRNADetailInformation
  • Detail Information
  • Functional analysis
miRNA namepre-miRNA familypre-miRNA Sequencemature-miRNAmature sequencepre-miRNA description
miR-19b
MI0000075 MIPF0000011 ACAUUGCUACUUACAAUUAGUUUUGCAGGUUUGCAUUUCAGCGUAUAUAUGUAUAUGUGGCUGUGCAAAUCCAUGCAAAACUGAUUGUGAUAAUGU MIMAT0000074

hsa-miR-19b-3p
UGUGCAAAUCCAUGCAAAACUGA
MI0000075 MIPF0000011 ACAUUGCUACUUACAAUUAGUUUUGCAGGUUUGCAUUUCAGCGUAUAUAUGUAUAUGUGGCUGUGCAAAUCCAUGCAAAACUGAUUGUGAUAAUGU MIMAT0000074

hsa-miR-19b-3p
UGUGCAAAUCCAUGCAAAACUGA
MI0000075 MIPF0000011 ACAUUGCUACUUACAAUUAGUUUUGCAGGUUUGCAUUUCAGCGUAUAUAUGUAUAUGUGGCUGUGCAAAUCCAUGCAAAACUGAUUGUGAUAAUGU MIMAT0000074

hsa-miR-19b-3p
UGUGCAAAUCCAUGCAAAACUGA
MI0000075 MIPF0000011 ACAUUGCUACUUACAAUUAGUUUUGCAGGUUUGCAUUUCAGCGUAUAUAUGUAUAUGUGGCUGUGCAAAUCCAUGCAAAACUGAUUGUGAUAAUGU MIMAT0000074

hsa-miR-19b-3p
UGUGCAAAUCCAUGCAAAACUGA
MI0000075 MIPF0000011 ACAUUGCUACUUACAAUUAGUUUUGCAGGUUUGCAUUUCAGCGUAUAUAUGUAUAUGUGGCUGUGCAAAUCCAUGCAAAACUGAUUGUGAUAAUGU MIMAT0000074

hsa-miR-19b-3p
UGUGCAAAUCCAUGCAAAACUGA
MI0000075 MIPF0000011 ACAUUGCUACUUACAAUUAGUUUUGCAGGUUUGCAUUUCAGCGUAUAUAUGUAUAUGUGGCUGUGCAAAUCCAUGCAAAACUGAUUGUGAUAAUGU MIMAT0000074

hsa-miR-19b-3p
UGUGCAAAUCCAUGCAAAACUGA
MI0000075 MIPF0000011 ACAUUGCUACUUACAAUUAGUUUUGCAGGUUUGCAUUUCAGCGUAUAUAUGUAUAUGUGGCUGUGCAAAUCCAUGCAAAACUGAUUGUGAUAAUGU MIMAT0000074

hsa-miR-19b-3p
UGUGCAAAUCCAUGCAAAACUGA
link to database TargetScanS 6.2 | MicroCosm | microRNA.org | miRNAMap 2.0
Interacted genes from RAID,miRTarBase
PTP4A1,MAPRE3,NUTF2,MID1IP1,PDRG1,KAT2B,PSMD9,MYLIP,EIF3L,IER3IP1,ARID4B,RDH11,HOXC8,TBC1D13,XYLT2
more » PTP4A1,MAPRE3,NUTF2,MID1IP1,PDRG1,KAT2B,PSMD9,MYLIP,EIF3L,IER3IP1,ARID4B,RDH11,HOXC8,TBC1D13,XYLT2,ENPP5,VPS4B,MEF2D,SLC35D1,RAB1A,CDK19,BACE1,DCAF7,HABP4,RPA2,HMGCS1,LTN1,GMEB2,ZER1,MTRR,GCM1,SLC44A1,ZMYM2,FBXO28,LPHN2,LONRF1,DDX6,ARL6IP1,CTR9,MYCN,MPHOSPH9,DCAF8,CAMSAP1,TRIM59,BTBD10,ESR1,PAPD4,BAHD1,NDEL1,STK38,HIF1AN,SMAD4,ZNF507,BMPR2,KLHL21,POGZ,LBR,ZNF417,CUL5,C10orf26,YTHDC1,MOSPD2,PALLD,TAF4,IMPDH1,HIPK3,TSC22D3,LDLR,SAMD1,CD2AP,RNF41,AP2B1,KLF10,KIAA1967,C16orf70,SON,MBOAT7,ANKRD10,HHEX,CEP350,HNRNPA1,SEMA6B,PRKAA1,SEC23B,EPC1,BCL2L11,CCND2,CNOT4,ANKRD52,LPGAT1,NFIB,DERL1,SAMD8,ZBTB4,BLCAP,PTPRG,CD46,PDE4D,SMCR8,SMYD2,ZNF711,SLC4A7,ATXN7L1,HBP1,CLIP1,ZNF644,DEGS1,ATM,MRPL19,FYCO1,ZNF567,BTBD3,ARRDC3,FAT3,NDUFB2,SRSF7,TPGS2,PDZD11,C11orf96,DMXL2,NCKAP5,SOCS1,PIK3R3,ATXN1,ZFHX4,ALAD,RASSF1,WDR26,KIAA0889,SEL1L3,SPTY2D1,ELOVL5,SYBU,TRIM33,RAP2C,NFATC4,SLMAP,CYP19A1,MREG,WEE1,SMARCA2,RNF11,CA13,SERINC3,E2F8,TMEM45A,NCOA3,ZNF721,SLAIN1,CNOT6,ALG2,WDR33,MB21D2,TRPC3,ARHGAP11A,CREBL2,RAB21,ATF2,RNF145,TBC1D25,WBP2,ACPL2,LRIG3,LRP8,TNRC6B,SESTD1,DAAM2,MBNL1,TMBIM6,ARHGAP1,RASSF2,HEG1,DYNLL2,PTPN4,PSAP,THOP1,SNAPIN,TRIM2,PPP1R15B,COX10,KCTD10,MRPL32,HARS,KATNAL1,ESYT1,RAB5B,TOM1L2,SOCS4,TCF4,SECISBP2L,ARHGAP12,CCNL1,EGLN3,CPD,GPATCH8,NR3C1,GFOD1,HIPK1,SGTB,OTUD4,TBC1D4,CGN,ACVR1,CENPN,STEAP2,RNF111,ZFAND5,ZNF217,SPG20,TGFBR2,TMEM9B,KCTD20,PATL1,TLR2,CSNK1G1,PPP6R2,ELOVL4,FAM46A,ZCCHC14,SHCBP1,NR3C2,ATMIN,RHEBL1,SIX4,PTEN,VAMP3,JARID2,C12orf66,AP3S2,PRKACB,ROR1,ABHD5,SPATA2,CPPED1,OTUD1,NFATC3,PRUNE2,FBXO8,DNAJA2,CREB3L2,SUV420H1,ZNF521,RAB34,MAP7,TES,ADRM1,CYP2U1,SEMA4C,EIF2C1,USP37,RRAS2,NACC2,HOXA5,NCBP2
KEGG pathways enriched for interacted genes
pathway namepathway descriptiontarget genes enrich in pathwayp-value
hsa03018 RNA degradation CNOT6,DDX6,CNOT4,PATL1, 4.00E-1
hsa04310 Wnt signaling pathway NFATC4,DAAM2,NFATC3,CCND2,SMAD4,PRKACB, 5.04E-1
hsa04144 Endocytosis LDLR,AP2B1,VPS4B,RAB5B,RNF41,TGFBR2, 9.85E-1
Gene ontology terms enriched for interacted genes
GO termsGO terms descriptiontarget genes enrich in GO termp-value
GO:0045449 regulation of transcription ZMYM2,SMARCA2,MEF2D,ZNF644,ZNF417,HHEX,NR3C2,JARID2,TAF4,ZNF521,ESR1,MYCN,EPC1,CREBL2,ATF2,TCF4,HOXA5,HIPK1,ZNF507,NR3C1,EIF2C1,ATXN1,KLF10,ZNF711,ZNF721,SMAD4,CNOT4,POGZ,TRIM33,NFATC4,GMEB2,NACC2,NFATC3,NCOA3,ZBTB4,PSMD9,MAPRE3,HABP4,SIX4,NFIB,CCNL1,GCM1,RHEBL1,HIPK3,HIF1AN,CREB3L2,CNOT6,RAB1A,E2F8,ZNF567,SUV420H1,HOXC8,KAT2B,ACVR1,ARID4B,HBP1,ZNF217,TSC22D3,ZFHX4,TLR2, 8.23E-5
GO:0006350 transcription ZMYM2,SMARCA2,MEF2D,ZNF644,ZNF417,HHEX,NR3C2,JARID2,TAF4,ZNF521,ESR1,EPC1,CREBL2,ATF2,TCF4,HOXA5,HIPK1,ZNF507,NR3C1,EIF2C1,KLF10,ZNF711,ZNF721,SMAD4,CNOT4,ADRM1,TRIM33,NFATC4,GMEB2,NFATC3,NCOA3,ZBTB4,HABP4,NFIB,CCNL1,GCM1,HIPK3,HIF1AN,BMPR2,CREB3L2,CNOT6,ZNF567,E2F8,HOXC8,KAT2B,SUV420H1,ARID4B,HBP1,ZNF217,ZFHX4, 2.14E-4
GO:0044265 cellular macromolecule catabolic process TRIM33,EIF2C1,CUL5,MYLIP,RNF41,SOCS1,FBXO28,USP37,SOCS4,PSMD9,BACE1,KLHL21,LDLR,DERL1,FBXO8,RNF111,NCBP2,ATM,CD2AP,CNOT4,RPA2,RNF11,ZER1, 6.24E-4
GO:0009057 macromolecule catabolic process TRIM33,EIF2C1,CUL5,MYLIP,RNF41,SOCS1,FBXO28,USP37,SOCS4,PSMD9,BACE1,KLHL21,LDLR,DERL1,FBXO8,RNF111,NCBP2,ATM,CD2AP,CNOT4,RPA2,RNF11,ZER1, 1.63E-2
GO:0035295 tube development BMPR2,HOXA5,HHEX,MYCN,ACVR1,SMAD4,TGFBR2,NFIB,BCL2L11,TMBIM6, 4.20E-2
KEGG pathways and Gene Ontology terms enriched for the interacted genes of ncRNA from RAID and miRTarBase.
disease namerelated genesp-value