ftp://ftp.ncbi.nih.gov/pub/HomoloGene/current/

##</code><code>##

 homologene_group_id | tax_id | geneid  |     symbol      | protein_gi | protein_accession 
---------------------+--------+---------+-----------------+------------+-------------------
                   3 |   9606 |      34 | ACADM           |  187960098 | NP_001120800.1
                   3 |   9598 |  469356 | ACADM           |  114557331 | XP_524741.2
                   3 |   9615 |  490207 | ACADM           |   73960161 | XP_547328.2
                   3 |   9913 |  505968 | ACADM           |  115497690 | NP_001068703.1
                   3 |  10090 |   11364 | Acadm           |    6680618 | NP_031408.1
                   3 |  10116 |   24158 | Acadm           |    8392833 | NP_058682.1
                   3 |   7955 |  406283 | acadm           |   47085823 | NP_998254.1
                   3 |   7227 |   38864 | CG12262         |   24660351 | NP_648149.1
                   3 |   7165 | 1276346 | AgaP_AGAP005662 |   58387602 | XP_315683.2
                   3 |   6239 |  181757 | acdh-10         |   17569725 | NP_510788.1
(

##</code><code>##



#!/bin/sh

wget ftp://ftp.ncbi.nih.gov/pub/HomoloGene/current/homologene.data;

< homologene.data psql -c "
  drop table if exists my_homologene_data;
  create table         my_homologene_data (
    homologene_group_id  integer , 
    tax_id               integer , 
    geneid               integer , 
    symbol               text    , 
    protein_gi           integer , 
    protein_accession    text     
 );
 copy my_homologene_data from stdin csv delimiter E'\t';
";

echo "select count(*) from my_homologene_data" | psql;

##</code><code>##

select * from my_homologene_data where homologene_group_id = 31015

##</code><code>##

http://www.ncbi.nlm.nih.gov/homologene/?term=31015