4898794edd81be5285ea6e544acbedeaeb31bf78 max Tue Nov 23 08:10:57 2021 -0800 Fixing pointers to README file for license in all source code files. refs #27614 diff --git src/hg/protein/kgAliasKgXref/kgAliasKgXref.c src/hg/protein/kgAliasKgXref/kgAliasKgXref.c index 032c562..b16979a 100644 --- src/hg/protein/kgAliasKgXref/kgAliasKgXref.c +++ src/hg/protein/kgAliasKgXref/kgAliasKgXref.c @@ -1,74 +1,74 @@ /* kgAliasKgXref - generate Known Genes alias list table for RefSeq accession numbers */ /* Copyright (C) 2013 The Regents of the University of California - * See README in this or parent directory for licensing information. */ + * See kent/LICENSE or http://genome.ucsc.edu/license/ for licensing information. */ #include "common.h" #include "hCommon.h" #include "hdb.h" void usage() /* Explain usage and exit. */ { errAbort( "kgAliasKgXref - create gene alias .tab file " "usage:\n" " kgAliasKgXref xxxx\n" " xxxx is genome database name\n" "example: kgAliasKgXref hg16\n"); } int main(int argc, char *argv[]) { struct sqlConnection *conn, *conn2; char query[256], query2[256]; struct sqlResult *sr, *sr2; char **row, **row2; char *kgID; FILE *o2; char *database; char *geneSymbol; char *proteinID; if (argc != 2) usage(); database = cloneString(argv[1]); conn = hAllocConn(database); conn2= hAllocConn(database); o2 = mustOpen("jj.dat", "w"); sqlSafef(query2, sizeof query2, "select name, proteinID from %s.knownGene;", database); sr2 = sqlMustGetResult(conn2, query2); row2 = sqlNextRow(sr2); while (row2 != NULL) { kgID = row2[0]; proteinID = row2[1]; sqlSafef(query, sizeof query,"select geneSymbol from %s.kgXref where kgID = '%s';", database, kgID); sr = sqlMustGetResult(conn, query); row = sqlNextRow(sr); while (row != NULL) { geneSymbol = row[0]; if (strlen(geneSymbol) >0) { fprintf(o2, "%s\t%s\n", kgID, geneSymbol); } row = sqlNextRow(sr); } sqlFreeResult(&sr); row2 = sqlNextRow(sr2); } sqlFreeResult(&sr2); carefulClose(&o2); hFreeConn(&conn); hFreeConn(&conn2); mustSystem("cat jj.dat|sort|uniq >kgAliasKgXref.tab"); mustSystem("rm jj.dat"); return(0); }