Compartment A/B

A/B区室是在早期Hi-C研究中发现的,整个基因组可以分为倾向于优先与自身区室相互作用的A区室和B区室。A区室与活跃表达的开放染色质相关联,而B区室则与不活跃表达的封闭染色质相关。这些区室自我交互,可能有助于蛋白质和其他因素如长非编码RNA在核内的局部化。

A/B compartments were first discovered in early Hi-C studies.Researchers noticed that the whole genome could be split into two spatial compartments, labelled "A" and "B", where regions in compartment A tend to interact preferentially with A compartment-associated regions than B compartment-associated ones. (其中区室A倾向于优先与A区室相互作用)Similarly, regions in compartment B tend to associate with other B compartment-associated regions.

A/B compartment-associated regions are on the multi-Mb scale and correlate with either open and expression-active chromatin ("A" compartments) or closed and expression-inactive chromatin ("B" compartments).A compartments tend to be gene-rich, have high GC-content, contain histone markers(组蛋白标记) for active transcription(转录), and usually displace the interior of the nucleus. As well, they are typically made up of self-interacting domains and contain early replication origins. B compartments, on the other hand, tend to be gene-poor, compact, contain histone markers for gene silencing, and lie on the nuclear periphery. They are consisted mostly of LADs and contain late replication origins.

The fact that compartments self-interact is consistent with the idea that the nucleus localizes proteins and other factors such as long non-coding RNA (lncRNA) in regions suited for their individual roles.[citation needed] An example of this is the presence of multiple transcription factories throughout the nuclear interior.These factories are associated with elevated levels of transcription due to the high concentration of transcription factors (such as transcription protein machinery, active genes, regulatory elements, and nascent RNA). Around 95% of active genes are transcribed within transcription factories. Each factory can transcribe multiple genes - these genes need not have similar product functions, nor do they need to lie on the same chromosome. Finally, the co-localization of genes within transcription factories is known to depend on cell type.

A/B often compartments vary between cell types.

form:https://en.wikipedia.org/wiki/Nuclear_organization#A/B_compartments

select * from ( SELECT proj.PROJ_ID project_name ,a.PROJECT_ID,'Hull' hull_Or_Topside ,'NA' object_Code,a.SYSTEM_NO,a.SUB_SYSTEM_NO,a.cable_No,'CABLE' item_type,to_char(a.LENGTH) quantity,'METER' quantity_unit,a.CP_ORDER_NO pullin_cable_report ,a.MR_SICODE conection_report,a.MR_SICODE assembly_report,'NA' hydrostec_test,'NA' calibration_report,a.MR_SICODE continuity_test,a.MR_SICODE megger_test ,a.MR_SICODE HIPOT_test, nvl(CASE WHEN CONNECTION_END_ENDTIME IS NOT NULL THEN '05 - Assembled Item' WHEN CONNECTION_END_ENDTIME IS NULL THEN '00 - Not received' WHEN a.cp_Finish_Date IS NOT NULL THEN '02 - Waiting Inspection' ELSE '01 - Assembly not started' end,'00 - Not received') status_eit, 'NA' megablock ,'NA' Elevation_or_compartment,a.certification certification,'NA' nr10,'NA' ex,'NA' blank_test_report,a.MR_SICODE loop_Test_Report FROM CE_CABLE a LEFT JOIN proj ON a.PROJECT_ID = proj.PROJ_NO where a.PROJECT_ID in (select to_number(regexp_replace(i.name, '[^0-9]', '')) from BASE_DICTIONARY d join base_dictionary_info i on d.id=i.dicid where d.code='P80H614projectweld' AND i.STATE = 1) and a.is_delete = 0 AND a.is_top = 1 <if test="model.projectId != null"> AND a.PROJECT_ID = #{model.projectId} </if> UNION all SELECT proj.PROJ_ID project_name ,a.PROJECT_ID,'Hull' hull_Or_Topside ,CASE WHEN a.REMARKS = 'Instrument' THEN a.object_Code ELSE a.big_Reg end object_Code , a.system_no SYSTEM_NO , a.SUB_SYSTEM_NO SUB_SYSTEM_NO ,a.TAG_NO cable_No ,CASE WHEN a.REMARKS = 'Instrument' THEN 'INSTRUMENT' ELSE 'EQUIPMENT' end item_type, '1' quantity, 'SET' quantity_unit, 'NA' pullin_cable_report, a.MR_SICODE conection_report, a.MR_SICODE assembly_report, 'NA' hydrostec_test, CASE WHEN a.REMARKS = 'Instrument' THEN a.Calibration_Report ELSE 'NA' END calibration_report, a.MR_SICODE continuity_test,a.MR_SICODE megger_test ,a.MR_SICODE HIPOT_test, nvl(CASE WHEN a.instal_endtime is NULL THEN '00 - Not received' ELSE '05 - Assembled Item' end,'00 - Not received') status_eit, CASE WHEN a.REMARKS = 'Instrument' THEN a.object_Code end megablock, CASE WHEN a.REMARKS = 'Instrument' THEN a.room_No end Elevation_or_compartment ,a.certification certification ,a.nr10 nr10 ,ex_Yn en ,CASE WHEN a.REMARKS = 'Instrument' THEN a.tct_Discipline end blank_test_report,a.MR_SICODE loop_Test_Report FROM T_EQUIPMENT a LEFT JOIN proj ON a.PROJECT_ID = proj.PROJ_NO where a.IS_DELETE = 0 AND (a.REMARKS = 'Instrument' OR TCT_DISCIPLINE = 'EIT Equipment' ) and a.PROJECT_ID in (select to_number(regexp_replace(i.name, '[^0-9]', '')) from BASE_DICTIONARY d join base_dictionary_info i on d.id=i.dicid where d.code='P80H614projectweld' AND i.STATE = 1) <if test="model.projectId != null"> AND a.PROJECT_ID = #{model.projectId} </if> UNION all SELECT a.PROJ_NO project_name ,a.PROJ_ID PROJECT_ID,a.hull_Or_Topside ,a.AREA as object_Code, a.PI_SYCODE SYSTEM_NO,a.PI_SSCODE SUB_SYSTEM_NO, a.LINE_NUMBER cable_No, a.ITEM_TYPE, to_char ( a.QUANTITY ) QUANTITY, a.QUANTITY_UNIT, 'NA' pullin_cable_report, 'NA' conection_report, 'NA' assembly_report, a.PI_TICODE hydrostec_test, 'NA' calibration_report, 'NA' continuity_test, 'NA' megger_test , 'NA' HIPOT_test, nvl(d.status_Eit,'00 - Not received') status_Eit, 'NA' megablock , 'NA' Elevation_or_compartment, 'NA' certification, 'NA' nr10, 'NA' ex, 'NA' blank_test_report, 'NA' loop_Test_Report FROM (( SELECT ct.LINE_NUMBER, ct.PROJ_ID, ct.PROJ_NO, ct.AREA, 'Hull' AS hull_Or_Topside, ct.SHOP_DRAWING, ct.ITEM_TYPE, ct.QUANTITY, ct.QUANTITY_UNIT, pm.PI_TICODE, pm.PI_SYCODE , pm.PI_SSCODE, pm.PROJECT_NUMBER, ct.DELETE_FLAG FROM CP_TUBING ct LEFT JOIN PDCS_MCPIPEINFO pm ON ct.LINE_NUMBER = pm.PI_LINENO AND ct.PROJ_NO = pm.PROJECT_NUMBER AND pm.IS_DELETE = 0)a JOIN ( SELECT ct.LINE_NUMBER, pm.PI_TICODE, COALESCE( ( SELECT mr.MR_COMPDATE FROM ( SELECT pm2.MR_COMPDATE FROM PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_SICODE = 'MP01' AND pm2.IS_DELETE = 0 ORDER BY pm2.ID ) mr WHERE ROWNUM = 1 ),'') assembly_Date FROM CP_TUBING ct LEFT JOIN PDCS_MCPIPEINFO pm ON ct.LINE_NUMBER = pm.PI_LINENO AND ct.PROJ_NO = pm.PROJECT_NUMBER AND pm.IS_DELETE = 0)b ON a.LINE_NUMBER = b.LINE_NUMBER LEFT JOIN ( SELECT ct.LINE_NUMBER, pm.PI_TICODE, COALESCE( ( SELECT mr.MR_COMPDATE FROM ( SELECT pm2.MR_COMPDATE FROM PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_SICODE = 'MP02' AND pm2.IS_DELETE = 0 ORDER BY pm2.ID ) mr WHERE ROWNUM = 1 ),'') hydrostatic_Test_Date FROM CP_TUBING ct LEFT JOIN PDCS_MCPIPEINFO pm ON ct.LINE_NUMBER = pm.PI_LINENO AND ct.PROJ_NO = pm.PROJECT_NUMBER AND pm.IS_DELETE = 0)c ON a.LINE_NUMBER = c.LINE_NUMBER LEFT JOIN (SELECT ct.LINE_NUMBER, pm.PI_TICODE, CASE WHEN EXISTS ( SELECT 1 FROM PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_SICODE = 'MP05' AND pm2.MR_COMPDATE IS NOT NULL AND pm2.IS_DELETE = 0 ) THEN '05 - Assembled Item' WHEN EXISTS ( SELECT 1 FROM PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_SICODE IN ('MP01', 'MP02', 'MP03', 'MP04') AND pm2.MR_COMPDATE IS NOT NULL AND pm2.IS_DELETE = 0 ) THEN '02 - Waiting Inspection' WHEN NOT EXISTS ( SELECT 1 FROM PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_COMPDATE IS NOT NULL AND pm2.IS_DELETE = 0 ) THEN '01 - Assembly not started' ELSE '01 - Assembly not started' END AS status_Eit FROM CP_TUBING ct LEFT JOIN PDCS_MCPIPEINFO pm ON ct.LINE_NUMBER = pm.PI_LINENO AND ct.PROJ_NO = pm.PROJECT_NUMBER AND pm.IS_DELETE = 0)d ON a.LINE_NUMBER = d.LINE_NUMBER) WHERE a.DELETE_FLAG = 0 AND a.PROJ_ID in (select to_number(regexp_replace(i.name, '[^0-9]', '')) from BASE_DICTIONARY d join base_dictionary_info i on d.id=i.dicid where d.code='P80H614projectweld' AND i.STATE = 1) <if test="model.projectId != null"> AND a.PROJ_ID = #{model.projectId} </if> UNION ALL SELECT t.proj_id project_name, t.project_id PROJECT_ID, 'Topdide' hull_Or_Topside, t.job_object object_Code, 'NA' SYSTEM_NO, 'NA' SUB_SYSTEM_NO, t.component_no cable_No, 'EIT' item_type, to_char ( t.QUANTITY ) QUANTITY, 'SET' quantity_unit, 'NA' pullin_cable_report, 'NA' conection_report, 'NA' assembly_report, 'NA' hydrostec_test, 'NA' calibration_report, 'NA' continuity_test, 'NA' megger_test, 'NA' HIPOT_test, t.status_type status_eit, 'NA' megablock, 'NA' Elevation_or_compartment, 'NA' certification, 'NA' nr10, 'NA' ex, 'NA' blank_test_report, 'NA' loop_Test_Report FROM ( SELECT proj.proj_id, t.project_id, t.object_code AS job_object, t.part_number AS component_no, t.print_no AS draw_no, t.quantity, CASE WHEN t.pre_pro_state = 0 THEN '00 - Not received' WHEN t.instal_pro_state = 0 OR t.instal_pro_state = 1 THEN '01 - Assembly not started' WHEN (t.is_pb = 1 AND t.pb_insp_finish_date IS NULL) THEN '02 - Waiting Inspection' WHEN t.instal_pro_state = 2 THEN '05 - Assembled Item' END AS status_type, ROW_NUMBER() OVER (PARTITION BY t.project_id, t.print_no, t.part_number ORDER BY t.rev DESC) AS rev_max FROM project_item_electric t LEFT JOIN proj ON proj.proj_no = t.project_id WHERE t.state = 1 <if test="model.projectId != null"> AND t.project_id = #{model.projectId} </if> ) t WHERE t.rev_max = 1 )把每个表名前面都加上ECIMS_AIO.
最新发布
09-26
SELECT * FROM ( -- 第一部分:电缆数据(CE_CABLE) SELECT proj.PROJ_ID project_name, a.PROJECT_ID, 'Hull' hull_Or_Topside, 'NA' object_Code, a.SYSTEM_NO, a.SUB_SYSTEM_NO, a.cable_No, 'CABLE' item_type, TO_CHAR(a.LENGTH) quantity, 'METER' quantity_unit, a.CP_ORDER_NO pullin_cable_report, a.MR_SICODE conection_report, a.MR_SICODE assembly_report, 'NA' hydrostec_test, 'NA' calibration_report, a.MR_SICODE continuity_test, a.MR_SICODE megger_test, a.MR_SICODE HIPOT_test, NVL( CASE WHEN CONNECTION_END_ENDTIME IS NOT NULL THEN '05 - Assembled Item' WHEN CONNECTION_END_ENDTIME IS NULL THEN '00 - Not received' WHEN a.cp_Finish_Date IS NOT NULL THEN '02 - Waiting Inspection' ELSE '01 - Assembly not started' END, '00 - Not received' ) status_eit, 'NA' megablock, 'NA' Elevation_or_compartment, a.certification certification, 'NA' nr10, 'NA' ex, 'NA' blank_test_report, a.MR_SICODE loop_Test_Report FROM ECIMS_AIO.CE_CABLE a LEFT JOIN ECIMS_AIO.proj ON a.PROJECT_ID = proj.PROJ_NO WHERE a.PROJECT_ID IN ( SELECT TO_NUMBER(REGEXP_REPLACE(i.name, '[^0-9]', '')) FROM ECIMS_AIO.BASE_DICTIONARY d JOIN ECIMS_AIO.base_dictionary_info i ON d.id = i.dicid WHERE d.code = 'P80H614projectweld' AND i.STATE = 1 ) AND a.is_delete = 0 AND a.is_top = 1 AND a.PROJECT_ID = 2542 UNION ALL -- 第二部分:仪表/设备数据(T_EQUIPMENT) SELECT proj.PROJ_ID project_name, a.PROJECT_ID, 'Hull' hull_Or_Topside, CASE WHEN a.REMARKS = 'Instrument' THEN a.object_Code ELSE a.big_Reg END object_Code, a.system_no SYSTEM_NO, a.SUB_SYSTEM_NO SUB_SYSTEM_NO, a.TAG_NO cable_No, CASE WHEN a.REMARKS = 'Instrument' THEN 'INSTRUMENT' ELSE 'EQUIPMENT' END item_type, '1' quantity, 'SET' quantity_unit, 'NA' pullin_cable_report, a.MR_SICODE conection_report, a.MR_SICODE assembly_report, 'NA' hydrostec_test, CASE WHEN a.REMARKS = 'Instrument' THEN a.Calibration_Report ELSE 'NA' END calibration_report, a.MR_SICODE continuity_test, a.MR_SICODE megger_test, a.MR_SICODE HIPOT_test, NVL(CASE WHEN a.instal_endtime IS NULL THEN '00 - Not received' ELSE '05 - Assembled Item' END, '00 - Not received') status_eit, CASE WHEN a.REMARKS = 'Instrument' THEN a.object_Code END megablock, CASE WHEN a.REMARKS = 'Instrument' THEN a.room_No END Elevation_or_compartment, a.certification certification, a.nr10 nr10, ex_Yn en, CASE WHEN a.REMARKS = 'Instrument' THEN a.tct_Discipline END blank_test_report, a.MR_SICODE loop_Test_Report FROM ECIMS_AIO.T_EQUIPMENT a LEFT JOIN ECIMS_AIO.proj ON a.PROJECT_ID = proj.PROJ_NO WHERE a.IS_DELETE = 0 AND (a.REMARKS = 'Instrument' OR TCT_DISCIPLINE = 'EIT Equipment') AND a.PROJECT_ID IN ( SELECT TO_NUMBER(REGEXP_REPLACE(i.name, '[^0-9]', '')) FROM ECIMS_AIO.BASE_DICTIONARY d JOIN ECIMS_AIO.base_dictionary_info i ON d.id = i.dicid WHERE d.code = 'P80H614projectweld' AND i.STATE = 1 ) AND a.PROJECT_ID = 2542 UNION ALL -- 第三部分:管路数据(CP_TUBING + PDCS_MCPIPEINFO 等) SELECT a.PROJ_NO project_name, a.PROJ_ID PROJECT_ID, a.hull_Or_Topside, a.AREA as object_Code, a.PI_SYCODE SYSTEM_NO, a.PI_SSCODE SUB_SYSTEM_NO, a.LINE_NUMBER cable_No, a.ITEM_TYPE, TO_CHAR(a.QUANTITY) QUANTITY, a.QUANTITY_UNIT, 'NA' pullin_cable_report, 'NA' conection_report, 'NA' assembly_report, a.PI_TICODE hydrostec_test, 'NA' calibration_report, 'NA' continuity_test, 'NA' megger_test, 'NA' HIPOT_test, NVL(d.status_Eit, '00 - Not received') status_eit, 'NA' megablock, 'NA' Elevation_or_compartment, 'NA' certification, 'NA' nr10, 'NA' ex, 'NA' blank_test_report, 'NA' loop_Test_Report FROM ( ( SELECT ct.LINE_NUMBER, ct.PROJ_ID, ct.PROJ_NO, ct.AREA, 'Hull' AS hull_Or_Topside, ct.SHOP_DRAWING, ct.ITEM_TYPE, ct.QUANTITY, ct.QUANTITY_UNIT, pm.PI_TICODE, pm.PI_SYCODE, pm.PI_SSCODE, pm.PROJECT_NUMBER, ct.DELETE_FLAG FROM ECIMS_AIO.CP_TUBING ct LEFT JOIN ECIMS_AIO.PDCS_MCPIPEINFO pm ON ct.LINE_NUMBER = pm.PI_LINENO AND ct.PROJ_NO = pm.PROJECT_NUMBER AND pm.IS_DELETE = 0 ) a JOIN ( SELECT ct.LINE_NUMBER, pm.PI_TICODE, COALESCE( (SELECT mr.MR_COMPDATE FROM (SELECT pm2.MR_COMPDATE FROM ECIMS_AIO.PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_SICODE = 'MP01' AND pm2.IS_DELETE = 0 ORDER BY pm2.ID) mr WHERE ROWNUM = 1), '' ) assembly_Date FROM ECIMS_AIO.CP_TUBING ct LEFT JOIN ECIMS_AIO.PDCS_MCPIPEINFO pm ON ct.LINE_NUMBER = pm.PI_LINENO AND ct.PROJ_NO = pm.PROJECT_NUMBER AND pm.IS_DELETE = 0 ) b ON a.LINE_NUMBER = b.LINE_NUMBER ) LEFT JOIN ( SELECT ct.LINE_NUMBER, pm.PI_TICODE, COALESCE( (SELECT mr.MR_COMPDATE FROM (SELECT pm2.MR_COMPDATE FROM ECIMS_AIO.PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_SICODE = 'MP02' AND pm2.IS_DELETE = 0 ORDER BY pm2.ID) mr WHERE ROWNUM = 1), '' ) hydrostatic_Test_Date FROM ECIMS_AIO.CP_TUBING ct LEFT JOIN ECIMS_AIO.PDCS_MCPIPEINFO pm ON ct.LINE_NUMBER = pm.PI_LINENO AND ct.PROJ_NO = pm.PROJECT_NUMBER AND pm.IS_DELETE = 0 ) c ON a.LINE_NUMBER = c.LINE_NUMBER LEFT JOIN ( SELECT ct.LINE_NUMBER, pm.PI_TICODE, CASE WHEN EXISTS ( SELECT 1 FROM ECIMS_AIO.PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_SICODE = 'MP05' AND pm2.MR_COMPDATE IS NOT NULL AND pm2.IS_DELETE = 0 ) THEN '05 - Assembled Item' WHEN EXISTS ( SELECT 1 FROM ECIMS_AIO.PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_SICODE IN ('MP01', 'MP02', 'MP03', 'MP04') AND pm2.MR_COMPDATE IS NOT NULL AND pm2.IS_DELETE = 0 ) THEN '02 - Waiting Inspection' WHEN NOT EXISTS ( SELECT 1 FROM ECIMS_AIO.PDCS_MCRESULT pm2 WHERE pm2.MR_TICODE = pm.PI_TICODE AND pm2.MR_COMPDATE IS NOT NULL AND pm2.IS_DELETE = 0 ) THEN '01 - Assembly not started' ELSE '01 - Assembly not started' END AS status_Eit FROM ECIMS_AIO.CP_TUBING ct LEFT JOIN ECIMS_AIO.PDCS_MCPIPEINFO pm ON ct.LINE_NUMBER = pm.PI_LINENO AND ct.PROJ_NO = pm.PROJECT_NUMBER AND pm.IS_DELETE = 0 ) d ON a.LINE_NUMBER = d.LINE_NUMBER WHERE a.DELETE_FLAG = 0 AND a.PROJ_ID IN ( SELECT TO_NUMBER(REGEXP_REPLACE(i.name, '[^0-9]', '')) FROM ECIMS_AIO.BASE_DICTIONARY d JOIN ECIMS_AIO.base_dictionary_info i ON d.id = i.dicid WHERE d.code = 'P80H614projectweld' AND i.STATE = 1 ) AND a.PROJ_ID = 2542 UNION ALL -- 第四部分:电气预制件数据(project_item_electric) SELECT t.proj_id project_name, t.project_id PROJECT_ID, 'Topdide' hull_Or_Topside, t.job_object object_Code, 'NA' SYSTEM_NO, 'NA' SUB_SYSTEM_NO, t.component_no cable_No, 'EIT' item_type, TO_CHAR(t.QUANTITY) QUANTITY, 'SET' quantity_unit, 'NA' pullin_cable_report, 'NA' conection_report, 'NA' assembly_report, 'NA' hydrostec_test, 'NA' calibration_report, 'NA' continuity_test, 'NA' megger_test, 'NA' HIPOT_test, t.status_type status_eit, 'NA' megablock, 'NA' Elevation_or_compartment, 'NA' certification, 'NA' nr10, 'NA' ex, 'NA' blank_test_report, 'NA' loop_Test_Report FROM ( SELECT proj.proj_id, t.project_id, t.object_code AS job_object, t.part_number AS component_no, t.print_no AS draw_no, t.quantity, CASE WHEN t.pre_pro_state = 0 THEN '00 - Not received' WHEN t.instal_pro_state = 0 OR t.instal_pro_state = 1 THEN '01 - Assembly not started' WHEN (t.is_pb = 1 AND t.pb_insp_finish_date IS NULL) THEN '02 - Waiting Inspection' WHEN t.instal_pro_state = 2 THEN '05 - Assembled Item' END AS status_type, ROW_NUMBER() OVER (PARTITION BY t.project_id, t.print_no, t.part_number ORDER BY t.rev DESC) AS rev_max FROM ECIMS_AIO.project_item_electric t LEFT JOIN ECIMS_AIO.proj ON proj.proj_no = t.project_id WHERE t.state = 1 AND t.project_id = 2542 ) t WHERE t.rev_max = 1 ) 第四部分拼接不上怎么回事
09-26
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值