void txGeneColor(char *uniProtDb, char *infoFile, char *pickFile, char *outFile)
/* txGeneColor - Figure out color to draw gene in.. */
{
/* Load picks into hash. We don't use cdsPicksLoadAll because empty fields
* cause that autoSql-generated routine problems. */
struct hash *pickHash = newHash(18);
struct cdsPick *pick;
struct lineFile *lf = lineFileOpen(pickFile, TRUE);
char *row[CDSPICK_NUM_COLS];
while (lineFileRowTab(lf, row))
{
pick = cdsPickLoad(row);
hashAdd(pickHash, pick->name, pick);
}
/* Open uniprot database connection. */
struct sqlConnection *uConn = sqlConnect(uniProtDb);
#ifdef OLD
/* Figure out our light and medium colors. */
mediumBlue.r = (6*trueBlue.r + 4*255)/10;
mediumBlue.g = (6*trueBlue.g + 4*255)/10;
mediumBlue.b = (6*trueBlue.b + 4*255)/10;
lightBlue.r = (1*trueBlue.r + 2*255)/3;
lightBlue.g = (1*trueBlue.g + 2*255)/3;
lightBlue.b = (1*trueBlue.b + 2*255)/3;
#endif /* OLD */
/* Read in info file, and loop through it to make out file. */
struct txInfo *info, *infoList = txInfoLoadAll(infoFile);
FILE *f = mustOpen(outFile, "w");
for (info = infoList; info != NULL; info = info->next)
{
struct rgbColor *col;
pick = hashFindVal(pickHash, info->name);
if (pick != NULL)
{
char *source = pick->source;
if (sameString(source, "RefPepValidated"))
col = &trueBlue;
else if (sameString(source, "ccds"))
col = &trueBlue;
else if (sameString(source, "RefPepReviewed"))
col = &trueBlue;
else if (sameString(source, "RefSeqValidated"))
col = &trueBlue;
else if (sameString(source, "RefSeqReviewed"))
col = &trueBlue;
else if (sameString(source, "swissProt"))
col = &trueBlue;
else if (startsWith("Ref", source))
col = &mediumBlue;
else
col = &lightBlue;
if (pick->swissProt[0] != 0)
{
char *acc = spLookupPrimaryAcc(uConn, pick->swissProt);
struct slName *pdbList = spPdbAccs(uConn, acc);
if (pdbList != NULL)
col = &black;
slFreeList(&pdbList);
}
}
else
col = &lightBlue;
fprintf(f, "%s\t%d\t%d\t%d\n", info->name, col->r, col->g, col->b);
}
carefulClose(&f);
}
void spTest(char *database, char *someAcc)
/* spTest - Test out sp library.. */
{
struct sqlConnection *conn = sqlConnect(database);
char *acc, *id, *binomial, *common;
struct slName *geneList, *gene, *accList, *n, *list;
struct slName *nameList, *name, *keyList, *key, *typeList, *type;
struct spFeature *featList, *feat;
struct spCitation *citeList, *cite;
char *ret = NULL;
int taxon;
int classId = 0, typeId = 0, refId = 0;
printf("input: %s\n", someAcc);
acc = spLookupPrimaryAcc(conn, someAcc);
printf("primary accession: %s\n", acc);
id = spAccToId(conn, acc);
printf("SwissProt id: %s\n", id);
printf("acc from id: %s\n", spIdToAcc(conn, id));
ret = spOrganelle(conn, acc);
printf("organelle: %s\n", (ret == NULL) ? "(null)" : ret);
printf("isCurated: %d\n", spIsCurated(conn, acc));
printf("aaSize: %d\n", spAaSize(conn,acc));
printf("molWeight: %d\n", spMolWeight(conn,acc));
printf("createDate: %s\n", spCreateDate(conn,acc));
printf("seqDate: %s\n", spSeqDate(conn,acc));
printf("annDate: %s\n", spAnnDate(conn,acc));
printf("description: %s\n", spDescription(conn, acc));
taxon = spTaxon(conn, acc);
printf("taxon: %d\n", taxon);
binomial = spTaxonToBinomial(conn, taxon);
printf("first scientific name: %s\n", binomial);
common = spTaxonToCommon(conn, taxon);
printf("first common name: %s\n", common);
printf("taxon from sci: %d\n", spBinomialToTaxon(conn, binomial));
printf("taxon from common: %d\n", spCommonToTaxon(conn, common));
printf("all scientific names:");
nameList = spBinomialNames(conn, acc);
for (name = nameList; name != NULL; name = name->next)
printf(" %s,", name->name);
printf("\n");
printf("gene(s):");
geneList = spGenes(conn,acc);
for (gene=geneList; gene != NULL; gene = gene->next)
printf(" %s,", gene->name);
printf("\n");
for (gene=geneList; gene != NULL; gene = gene->next)
{
accList = spGeneToAccs(conn, gene->name, 0);
printf(" any %s:", gene->name);
for (n = accList; n != NULL; n = n->next)
printf(" %s,", n->name);
printf("\n");
slFreeList(&accList);
printf(" %s %s:", common, gene->name);
accList = spGeneToAccs(conn, gene->name, taxon);
for (n = accList; n != NULL; n = n->next)
printf(" %s,", n->name);
printf("\n");
slFreeList(&accList);
}
slFreeList(&geneList);
printf("keyword(s):");
keyList = spKeywords(conn, acc);
for (key = keyList; key != NULL; key = key->next)
printf(" %s,", key->name);
printf("\n");
for (key = keyList; key != NULL; key = key->next)
{
accList = spKeywordSearch(conn, key->name, taxon);
printPartialList(common, key->name, accList, 4);
slFreeList(&accList);
break; /* This is a little slow, once is enough. */
}
for (key = keyList; key != NULL; key = key->next)
{
accList = spKeywordSearch(conn, key->name, 0);
printPartialList("all", key->name, accList, 4);
slFreeList(&accList);
break; /* This is a little slow, once is enough. */
}
slFreeList(&keyList);
printf("All comments:\n");
list = slComments(conn, acc, NULL);
for (n = list; n != NULL; n = n->next)
printf(" %s\n", n->name);
slFreeList(&list);
typeList = slCommentTypes(conn);
for (type = typeList; type != NULL; type = type->next)
{
list = slComments(conn, acc, type->name);
if (list != NULL)
{
printf("%s comments:\n", type->name);
for (n = list; n != NULL; n = n->next)
printf(" %s\n", n->name);
slFreeList(&list);
}
}
slFreeList(&typeList);
list = spEmblAccs(conn, acc);
printf("GenBank/EMBL:");
for (n = list; n != NULL; n = n->next)
printf(" %s,", n->name);
printf("\n");
if (list != NULL)
printf("acc from %s: %s\n",
list->name, spAccFromEmbl(conn, list->name));
slFreeList(&list);
list = spPdbAccs(conn, acc);
printf("PDB:");
for (n = list; n != NULL; n = n->next)
printf(" %s,", n->name);
printf("\n");
featList = spFeatures(conn, acc, 0, 0);
printf("All features:\n");
for (feat = featList; feat != NULL; feat = feat->next)
{
printFeat(conn, feat);
classId = feat->featureClass;
typeId = feat->featureType;
}
slFreeList(&featList);
if (classId != 0 && typeId != 0)
{
printf("%s class features:\n", spFeatureClassName(conn, classId));
featList = spFeatures(conn, acc, classId, 0);
for (feat = featList; feat != NULL; feat = feat->next)
printFeat(conn, feat);
slFreeList(&featList);
printf("%s type features:\n", spFeatureTypeName(conn, typeId));
featList = spFeatures(conn, acc, 0, typeId);
for (feat = featList; feat != NULL; feat = feat->next)
printFeat(conn, feat);
slFreeList(&featList);
printf("same class & type features:\n");
featList = spFeatures(conn, acc, classId, typeId);
for (feat = featList; feat != NULL; feat = feat->next)
printFeat(conn, feat);
slFreeList(&featList);
printf("class loop: %d->%s->%d\n", classId,
spFeatureClassName(conn, classId),
spFeatureClassId(conn, spFeatureClassName(conn, classId)));
printf("type loop: %d->%s->%d\n", typeId,
spFeatureTypeName(conn, typeId),
spFeatureTypeId(conn, spFeatureTypeName(conn, typeId)));
}
citeList = spCitations(conn, acc);
for (cite = citeList; cite != NULL; cite = cite->next)
{
refId = cite->reference;
printf("title: %s\n", spRefTitle(conn, refId));
printf("authors:");
list = spRefAuthors(conn, refId);
for (n = list; n != NULL; n = n->next)
printf(" %s, ", n->name);
printf("\n");
slFreeList(&list);
printf("location: %s\n", spRefCite(conn, refId));
printf("pubMed: %s\n", spRefPubMed(conn, refId));
}
if (refId != 0)
{
printf("other accs associated with last reference:\n\t");
list = spRefToAccs(conn, refId);
printPartialList("", "", list, 6);
slFreeList(&list);
}
sqlDisconnect(&conn);
}
