@transform( exportCapseqlncRNATSSGeneList, suffix( ".lncrna.tss.distance.export"), ".lncrna.tss.distance.export.load" )
def loadCapseqlncRNATSSGeneList( infile, outfile ):
    track = P.snip( os.path.basename( infile ), ".lncrna.tss.distance.export" ).replace("-","_").replace(".","_")
    geneset_name = PARAMS["geneset_name"]
    statement = """cat %(infile)s | python %(scriptsdir)s/csv2db.py 
                         --database=%(database)s
                         --table=%(track)s_interval_lncrna_mapping
                         --index=gene_id
                         --index=interval_id
                   > %(outfile)s; """
    P.run()
    
############################################################
############################################################
## External RNAseq transcripts
function returning a transaction id and creating the associated pipeline
dataset/ETHPy150Open CGATOxford/cgat/obsolete/pipeline_proj007.py/loadCapseqlncRNATSSGeneList--crossover with--dataset/ETHPy150Open kakwa/pygraph_redis/pygraph_redis/directed_graph.py/Directed_graph._gen_transaction