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

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

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

ncRNADetailInformation
  • Detail Information
  • Functional analysis
miRNA namepre-miRNA familypre-miRNA Sequencemature-miRNAmature sequencepre-miRNA description
miR-30a-5p
MI0000088 MIPF0000005 GCGACUGUAAACAUCCUCGACUGGAAGCUGUGAAGCCACAGAUGGGCUUUCAGUCGGAUGUUUGCAGCUGC MIMAT0000087

hsa-miR-30a-5p
UGUAAACAUCCUCGACUGGAAG The mature sequences miR-30 and miR-97 appear to originate fromthe same precursor. Subsequent data confirm that both arms of theprecursor appear to give rise to mature miRNA sequences (Pfeffer S, pers.comm.). Landgraf et al. later showed that the 5' product is thepredominant one . Related miRNAs are processed from the 5' arms ofother precursor loci (mir-30b, MIR:MI0000441; mir-30c-1, MIR:MI0000736;mir-30c-2, MIR:MI0000254; mir-30d, MIR:MI0000255; mir-30e, MI0000749).
link to database TargetScanS 6.2 | MicroCosm | microRNA.org | miRNAMap 2.0
Interacted genes from RAID,miRTarBase
PTP4A1,CDCP1,RAB14,TMED7,WDR74,DNAJC3,KRT77,DHX8,NT5C3,NAPG,CPSF1,RAD23B,MRE11A,PIK3CD,AVEN
more » PTP4A1,CDCP1,RAB14,TMED7,WDR74,DNAJC3,KRT77,DHX8,NT5C3,NAPG,CPSF1,RAD23B,MRE11A,PIK3CD,AVEN,CDK6,IFRD2,ZNF638,MLLT11,HINT3,GABARAPL2,INTS6,WDR12,TUBA1B,POLR2C,HDAC1,ARF6,SMAD1,G3BP1,LRRFIP1,CARS,ITGA6,TRIO,PRMT1,YRDC,TMED3,GRPEL2,JUN,HIST1H1A,SLC38A5,RBM34,TNFAIP2,TNPO3,SDCBP,CPSF4,PABPC1,PPA1,GATAD2B,IFRD1,MYO10,TGFBI,FRG1,RHOB,STUB1,RBM5,KPNA1,TIMM8A,AP2A1,NDE1,CDH2,GTF2H2C,TUBB4B,EFTUD1,MGST2,LCLAT1,GLRX3,RAB21,TMED1,ATP2A2,KRT6B,ACSL4,RAB27B,CNP,RPRD1B,C1D,SMARCA1,CIRBP,DNAJA1,RPP40,MAT2A,GNG2,PES1,XPO1,RPP14,CORO1C,RBMS1,GNA13,TPI1,THUMPD1,MAN1A2,ME3,MBNL1,RRP36,CAPN2,UTP6,TMED5,PDCD10,GATC,LRRN1,PAICS,THEM4,BAX,LTN1,CLEC4D,GTF2H2,HNRNPM,PRPF40A,PDLIM7,PPP3CA,MSL2,LSM12,SNAI1,NEUROD1,NDUFAF1,OGFOD1,PICALM,SF3B3,ANXA1,GLRX,HK1,TPBG,SLC33A1,STX7,NUFIP2,SLC9A3R2,MAP2K3,PCNA,CTNNB1,DHX33,CCPG1,ITGB3,TGM2,PTPRK,RBMS3,ATOX1,GMFB,ERP44,PBRM1,STX16,IDH1,KIAA1609,LSS,P4HA2,PRKCDBP,PAFAH1B2,CTNND1,TMEM192,SARS,RUNX2,HNRNPA1L2,ITPRIP,PHB2,FNDC3B,NCKAP1,DNAJB1,GALNT1,IGF1R,GTF2H1,NT5E,SUCLA2,MAP1LC3B2,TICAM2,UTP15,SMN1,DDX10,DPY19L1,RBFOX2,REXO4,PPP2R2A,ATP6V1B2,FDX1,TIMM9,RPS17,SEC11A,GPD2,BCL6,TOM1,ZFPL1,PRPF19,SEC24A,NDEL1,CPOX,CDC20,MARCH5,VIM,DAG1,TAPBP,TIMM17A,ITGA2,UHRF2,FAHD1,AP2S1,MKI67IP,RRP15,HECTD1,EIF2C2,AP3S1,TBCB,PPP1CC,SLC7A6,SLC4A10,CPNE8,EIF1,SNX3,URM1,CD44,TUBB3,RPRD1A,ACP2,MOSPD2,DYNC1LI1,TNFRSF10B,FXR2,PPOX,DOCK7,LMNB2,KPNA4,FBN1,NOP14,ATL2,SPCS3,ITGB4,NDFIP1,TBC1D4,DNAJB4,TMEM41B,LDLR,IKBIP,YWHAE,UBE2I,ELMOD2,ANKRD26,CNPY4,PAK1IP1,EXOC2,GPRC5A,NOL8,GALNT7,SON,CBFB,MAK16,ATP8A2,SH3GL1,PRIM1,TRRAP,GGCT,TMED10,PPP2R4,CEP72,PPP2R5C,HNRNPA1,WDR75,ANAPC5,DROSHA,JUP,PRKAA1,HEATR2,APEH,MAN2B1,THBS1,SLC7A11,SCAF1,GLIPR1,ARPC5,CYR61,GNAI2,TMED2,USE1,TM9SF1,SEC11C,VEZT,FXR1,PKM2,DERL1,CAT,ASCC3,KIDINS220,CSNK1G1,GTF3C4,PPP3R1,MPP2,NT5C1B,CNDP2,PLIN3,ESRRA,PLA2G4A,CAST,ADPGK,BCL2L1,RHOF,TWF1,STRN,PPID,ATXN10,SEC23A,CDC123,PTBP1,XPOT,TRIM28,MRPL28,EIF2B1,SLC4A7,KIAA0564,PRPF4B,MLH1,REEP5,PHLDA2,EEF1A1,ABL1,PPP1R10,COPS7B,LARP4B,CSDA,SMCHD1,PNPO,NOTCH1,LIN28A,VAMP3,BMS1,KIF11,EXOSC10,SEC24B,RETSAT,NUCB1,DDX50,MPDU1,REXO1,SERPINB5,DHX36,USP16,UBL3,PTMS,FAF2,MTX3,HDGF,ATRX,RARS2,MTDH,UGDH,ABCB10,LRRC8C,MAP1LC3B,BECN1,NDUFV3,NFU1,LSM1,ITPRIPL2,SLC38A1,TMEM2,PTRH1,RRM2,WDR82,TMEM59,PTGFRN,UTP11L,TMCO1,SMN2,NIP7,FAM96A,LARP4,BAZ1B,TNRC6A,AK2,SERPINE2,PPP1R12A,RBFOX1,KRT85,SCD,SAMD9,XPO7,SLC12A4,LIG3,TIMM10,DTL,C16orf62,EEF2,KCNN4,LIMCH1,PYCR2,NCEH1,ZNF324,SLC12A2,CPSF3L,POLR2B,CSNK1G3,EPT1,ERLIN1,PRDM1,UFM1,FOXD1,SEPT7,EGFR,PEX11B,NAP1L1,UAP1,FSCN1,YWHAZ,PCNT,SOD2,ARG1,CHD1,PAIP1,USP5,WNT5A,SLC38A2,PSME4,RAB34,RPN2,CPSF3,MET,TMEM87A,GNG5,NXT1,NCL,OGDH,RFT1,TOMM5,ANPEP,TIAL1,DARS2,MAPK1,KDELC2,CAMKV,DNAJC2,DNAJA4,TRIP12,SCYL1,SEC62,KIF5B,NOL9,NPR3,DSG2,SAMHD1,FMR1,PNMA2,ELOVL5,TELO2,SYPL1,PGM1,CSNK1G2,UBE2H,EIF2B4,RQCD1,CTSL1,RND3,OSBPL8,C5orf15,MRPS5,NR2F6
KEGG pathways enriched for interacted genes
pathway namepathway descriptiontarget genes enrich in pathwayp-value
hsa05412 Arrhythmogenic right ventricular cardiomyopathy (ARVC) ITGA2,ITGB3,ITGB4,DSG2,DAG1,ITGA6,JUP,CDH2,ATP2A2,CTNNB1, 5.64E-4
hsa05130 Pathogenic Escherichia coli infection TUBB4B,ARPC5,TUBB3,YWHAZ,ABL1,NCL,TUBA1B,CTNNB1, 1.88E-2
hsa04510 Focal adhesion CAPN2,JUN,ITGA2,EGFR,ITGB3,ITGB4,CTNNB1,IGF1R,PIK3CD,PPP1CC,PPP1R12A,MET,ITGA6,THBS1,MAPK1, 4.06E-2
hsa05210 Colorectal cancer JUN,IGF1R,PIK3CD,MLH1,EGFR,BAX,MET,CTNNB1,MAPK1, 4.61E-2
hsa05014 Amyotrophic lateral sclerosis (ALS) DERL1,BCL2L1,MAP2K3,BAX,CAT,PPP3CA,PPP3R1, 5.96E-2
Gene ontology terms enriched for interacted genes
GO termsGO terms descriptiontarget genes enrich in GO termp-value
GO:0006396 RNA processing EIF2C2,INTS6,SARS,DROSHA,LSM1,HNRNPA1L2,ZNF638,RBFOX1,RPP40,CPSF4,PES1,LIN28A,CPSF3,RPP14,PRPF19,FRG1,HNRNPA1,CPSF3L,UTP6,PRPF40A,URM1,MBNL1,CPSF1,UTP15,RBM5,HNRNPM,PRPF4B,WDR12,MLH1,RBFOX2,RPS17,SF3B3,UTP11L,PTBP1,NOP14,EXOSC10,C1D,RBMS1,SCAF1,POLR2B,DHX8,POLR2C,SMN2,SMN1,PABPC1,SMAD1, 1.53E-10
GO:0046907 intracellular transport JUN,STX7,STX16,TIMM10,ATP2A2,SEC23A,RHOB,NAPG,XPO7,TIMM17A,BCL6,USE1,BAX,ATL2,AP2A1,NDE1,TIMM9,MTX3,MAPK1,TMED10,TOM1,XPO1,TAPBP,RAB14,KPNA4,SEC24B,NDEL1,PPP1R10,NXT1,SCYL1,HNRNPA1,GABARAPL2,PCNA,AP2S1,AP3S1,SEC24A,KIF5B,TOMM5,KPNA1,BCL2L1,PPP3CA,TIMM8A,DERL1,GRPEL2,SDCBP,YWHAZ,SEC62,YWHAE,XPOT, 5.63E-10
GO:0034613 cellular protein localization JUN,XPO1,TOM1,EGFR,STX7,STX16,TIMM10,KPNA4,SEC24B,CTNNB1,PPP1R10,SEC23A,NXT1,NAPG,TIMM17A,XPO7,PCNA,AP2S1,BCL6,AP3S1,SEC24A,TOMM5,PTPRK,KPNA1,BAX,PPP3CA,TIMM8A,DERL1,GRPEL2,SDCBP,AP2A1,YWHAZ,SEC62,TIMM9,YWHAE,MTX3,MAPK1, 8.27E-10
GO:0070727 cellular macromolecule localization JUN,XPO1,TOM1,EGFR,STX7,STX16,TIMM10,KPNA4,SEC24B,CTNNB1,PPP1R10,SEC23A,NXT1,NAPG,TIMM17A,XPO7,PCNA,AP2S1,BCL6,AP3S1,SEC24A,TOMM5,PTPRK,KPNA1,BAX,PPP3CA,TIMM8A,DERL1,GRPEL2,SDCBP,AP2A1,YWHAZ,SEC62,TIMM9,YWHAE,MTX3,MAPK1, 1.00E-9
GO:0006886 intracellular protein transport JUN,XPO1,TOM1,STX7,STX16,TIMM10,KPNA4,SEC24B,PPP1R10,SEC23A,NXT1,NAPG,TIMM17A,XPO7,PCNA,AP2S1,AP3S1,BCL6,SEC24A,TOMM5,KPNA1,PPP3CA,TIMM8A,DERL1,GRPEL2,SDCBP,AP2A1,YWHAZ,SEC62,TIMM9,YWHAE,MTX3,MAPK1, 1.32E-8
KEGG pathways and Gene Ontology terms enriched for the interacted genes of ncRNA from RAID and miRTarBase.
disease namerelated genesp-value