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

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

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

ncRNADetailInformation
  • Detail Information
  • Functional analysis
miRNA namepre-miRNA familypre-miRNA Sequencemature-miRNAmature sequencepre-miRNA description
miR-197
MI0000239 MIPF0000123 GGCUGUGCCGGGUAGAGAGGGCAGUGGGAGGUAAGAGCUCUUCACCCUUCACCACCUUCUCCACCCAGCAUGGCC MIMAT0000227

hsa-miR-197-3p
UUCACCACCUUCUCCACCCAGC
MI0000239 MIPF0000123 GGCUGUGCCGGGUAGAGAGGGCAGUGGGAGGUAAGAGCUCUUCACCCUUCACCACCUUCUCCACCCAGCAUGGCC MIMAT0022691

hsa-miR-197-5p
CGGGUAGAGAGGGCAGUGGGAGG
MI0000239 MIPF0000123 GGCUGUGCCGGGUAGAGAGGGCAGUGGGAGGUAAGAGCUCUUCACCCUUCACCACCUUCUCCACCCAGCAUGGCC MIMAT0022691

hsa-miR-197-5p
CGGGUAGAGAGGGCAGUGGGAGG
MI0000239 MIPF0000123 GGCUGUGCCGGGUAGAGAGGGCAGUGGGAGGUAAGAGCUCUUCACCCUUCACCACCUUCUCCACCCAGCAUGGCC MIMAT0000227

hsa-miR-197-3p
UUCACCACCUUCUCCACCCAGC
MI0000239 MIPF0000123 GGCUGUGCCGGGUAGAGAGGGCAGUGGGAGGUAAGAGCUCUUCACCCUUCACCACCUUCUCCACCCAGCAUGGCC MIMAT0000227

hsa-miR-197-3p
UUCACCACCUUCUCCACCCAGC
MI0000239 MIPF0000123 GGCUGUGCCGGGUAGAGAGGGCAGUGGGAGGUAAGAGCUCUUCACCCUUCACCACCUUCUCCACCCAGCAUGGCC MIMAT0022691

hsa-miR-197-5p
CGGGUAGAGAGGGCAGUGGGAGG
link to database TargetScanS 6.2 | MicroCosm | microRNA.org | miRNAMap 2.0
Interacted genes from RAID,miRTarBase
DPH1,ACTG1,MYH10,WDR6,RAD23B,SNX1,NEK4,CEP152,MED24,FASN,EIF4H,NSUN5,TRAP1,CDK10,METTL4
more » DPH1,ACTG1,MYH10,WDR6,RAD23B,SNX1,NEK4,CEP152,MED24,FASN,EIF4H,NSUN5,TRAP1,CDK10,METTL4,ATP11A,RXRB,TMX4,IER3,ZNF302,VDAC1,RUVBL1,RBM15B,H2AFZ,KIAA1274,HNRNPA1,GORASP2,CCNA2,TRAPPC1,ACVR1B,ZNF175,MCM7,NME2,SCD,FBXW7,CHIC2,ND6,WNK1,TAF4B,CPT1A,PHPT1,ATP2A2,DNLZ,MORN2,AK3,LDHB,JTB,RSRC2,DPYSL3,ALMS1,PLEKHG2,RGS16,ATF6B,NUS1,MAML1,RAB28,PRKAR2A,CYLD,IGF2-AS,GSTO1,ATP1A1,RPL22,ACVR1,STEAP2,FKBP4,SETD1B,OVCH2,SPG20,RPL13A,UMPS,TCOF1,TSPYL1,DCBLD2,HSPA4,MKRN1,HNRNPD,IARS2,BCR,CES1,C1orf115,ZNF208,CHTOP,EIF2C1,CKS1B,CCNG1,RBM4,FOXJ3,CPSF1,PFAS,G3BP1,HNF4A,PDCD4,GALT,IL1R1,CBX5,PPP2CA,SRCAP,E2F4,KLC1,RNFT2,COL4A6,RFX1,AGR2,STMN3,GOLGB1,KLF10,PRIM1,C1orf38,ACTL9,PLCB3,STRN,PHF20,DGCR8,TSPAN3,PPIA,SH3BP2,INTS4,PRKD2,PIPOX,HNRNPH1,ZNF354A,EHD2,GDF7,HNRNPA2B1,PTBP3,HSPD1,MEGF9,PMAIP1,RAD51,CPNE6,FUS,MRPS16,TTC8,SUDS3,MMP23A,BMF,HPN,CHD4,ZNF318,USO1,ISYNA1,MORC3,NOA1,PBX2,PEX13,ADAR,MPP6,MED16,MSI1,FOXO3,EEF1A1,TSEN34,DYRK2,SOD1,PDZRN3,ADIPOR1,ABCC3,TUSC2,RPL7A,CLIC1,NCL,LRP4,HMGN1
KEGG pathways enriched for interacted genes
pathway namepathway descriptiontarget genes enrich in pathwayp-value
hsa04350 TGF-beta signaling pathway PPP2CA,ACVR1B,ACVR1,GDF7,E2F4, 2.10E-1
Gene ontology terms enriched for interacted genes
GO termsGO terms descriptiontarget genes enrich in GO termp-value
GO:0016071 mRNA metabolic process HSPA1B,PTBP3,EIF2C1,TSEN34,HNRNPH1,HNRNPA1,HNRNPD,RBM4,ADAR,RBM15B,HNRNPA2B1,FUS,CPSF1, 5.23E-4
GO:0010033 response to organic substance HSPA1B,STEAP2,SOD1,CLIC1,CCNA2,ADIPOR1,HSPA4,HSPD1,PMAIP1,KLF10,HNF4A,PPP2CA,DGCR8,ATF6B,NME2,PRKAR2A,MSI1,RBM4,IL1R1, 5.43E-4
GO:0009260 ribonucleotide biosynthetic process NME2,UMPS,PFAS,ATP1A1,AK3,ATP11A,ATP2A2, 1.94E-2
GO:0006397 mRNA processing HNRNPH1,PTBP3,HNRNPA1,HNRNPD,TSEN34,RBM4,HNRNPA2B1,RBM15B,ADAR,FUS,CPSF1, 2.06E-2
GO:0008380 RNA splicing HNRNPH1,HNRNPA1,PPP2CA,HNRNPD,TSEN34,RBM4,HNRNPA2B1,RBM15B,FUS,CPSF1, 3.06E-2
KEGG pathways and Gene Ontology terms enriched for the interacted genes of ncRNA from RAID and miRTarBase.
disease namerelated genesp-value