=== feature.CAGE_L1_promoter.tbl.txt.bz2 ##ColumnVariables[feature_id] = (internal) feature_id of the transcription starting site (or level1 promoter) ##ColumnVariables[primary_name] = name of the transcription starting site # # select # feature.feature_id # , primary_name # # from # feature # , feature_source # # where feature_source.name = "CAGE_L1_promoter" # and feature_source.feature_source_id = feature.feature_source_id # ; # # # === feature.CAGE_L2_promoter.tbl.txt.bz2 ##ColumnVariables[feature_id] = (internal) feature_id of the prmoter (or level2 promoter) ##ColumnVariables[primary_name] = name of the promoter # # select # feature.feature_id # , primary_name # # from # feature # , feature_source # # where feature_source.name = "CAGE_L2_promoter_april2008" # and feature_source.feature_source_id = feature.feature_source_id # ; # # # === feature.CAGE_L3_promoter.tbl.txt.bz2 ##ColumnVariables[feature_id] = (internal) feature_id of the prmoter region (or level3 promoter) ##ColumnVariables[primary_name] = name of the promoter region # # select # feature.feature_id # , primary_name # # from # feature # , feature_source # # where feature_source.name = "CAGE_L3_promoter_april2008" # and feature_source.feature_source_id = feature.feature_source_id # ; # # # === feature.entrez_gene.tbl.txt.bz2 ##ColumnVariables[feature_id] = (internal) feature_id of the entrez gene ##ColumnVariables[primary_name] = gene symbol ##ColumnVariables[sym_value] = entrez gene id # # select # feature.feature_id # , primary_name # , sym_value # # from # feature # , feature_2_symbol # , symbol # , feature_source # # where feature.feature_id = feature_2_symbol.feature_id # and feature_2_symbol.symbol_id = symbol.symbol_id # and symbol.sym_type = "EntrezID" # and feature_source.name = "Entrez_gene" # and feature_source.feature_source_id = feature.feature_source_id # ; # # # === feature.miRBase_mature.tbl.txt.bz2 ##ColumnVariables[feature_id] = (internal) feature_id of the mature miRNA ##ColumnVariables[primary_name] = name of the mature miRNA (in miRbase) ##ColumnVariables[sym_value] = accession of the mature miRNA (in miRbase) # # select # feature.feature_id # , primary_name # , sym_value # # from # feature # , feature_2_symbol # , symbol # , feature_source # # where feature_source.name = "miRBase_mature" # and feature_source.feature_source_id = feature.feature_source_id # and feature.feature_id = feature_2_symbol.feature_id # and feature_2_symbol.symbol_id = symbol.symbol_id # and symbol.sym_type = "miRBaseACC" # ; # # # === feature.miRBase_pre.tbl.txt.bz2 ##ColumnVariables[feature_id] = (internal) feature_id of the mature miRNA ##ColumnVariables[primary_name] = name of the miRNA precursor (in miRbase) ##ColumnVariables[sym_value] = accession of the miRNA precursor (in miRbase) # # select # feature.feature_id # , primary_name # , sym_value # # from # feature # , feature_2_symbol # , symbol # , feature_source # # where feature_source.name = "miRBase_pre" # and feature_source.feature_source_id = feature.feature_source_id # and feature.feature_id = feature_2_symbol.feature_id # and feature_2_symbol.symbol_id = symbol.symbol_id # and symbol.sym_type = "miRBaseACC" # ; # #