"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from identical_seq t1,identical_seq t2,protein t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Prohibitin' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from identical_seq t1,identical_seq t2,organism t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id and t3.name='Drosophila azteca' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from identical_seq t1,identical_seq t2,taxonomy t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id and t3.species_name='Melampitta gigantea' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from identical_seq t1,identical_seq t2,taxonomy t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.species_name='Acacia silvestris' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from identical_seq t1,identical_seq t2,source t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Acidic Lectin' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from identical_seq t1,identical_seq t2,source t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Beta-Catenin' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from identical_seq t1,identical_seq t2,neighboring_seq t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id_1 and t3.length_2=1977 group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from identical_seq t1,identical_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from identical_seq t1,identical_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from identical_seq t1,identical_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Prohibitin' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from identical_seq t1,identical_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from identical_seq t1,identical_seq t2,organism t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.name='Antonia ovata' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from identical_seq t1,identical_seq t2,taxonomy t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from identical_seq t1,identical_seq t2,taxonomy t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.species_name='Melampitta gigantea' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from identical_seq t1,identical_seq t2,source t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Simian Virus 40' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.nref_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Prohibitin' group by t1.taxon_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.taxon_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.nref_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Prohibitin' group by t1.taxon_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,organism t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id and t3.name='Antonia ovata' group by t1.taxon_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,organism t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id and t3.name='Drosophila azteca' group by t1.taxon_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,organism t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.name='Antonia ovata' group by t1.taxon_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,taxonomy t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id and t3.species_name='Acacia silvestris' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,taxonomy t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.nref_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,taxonomy t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.taxon_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,source t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Beta-Catenin' group by t1.nref_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.taxon_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.taxon_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Prohibitin' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.nref_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.taxon_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,protein t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Prohibitin' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,organism t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.name='Banana streak virus' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,organism t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.name='Drosophila azteca' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,organism t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.name='Banana streak virus' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,taxonomy t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.nref_id_2"
"select t1.taxon_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,source t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Simian Virus 40' group by t1.taxon_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from neighboring_seq t1,neighboring_seq t2,source t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Acidic Lectin' group by t1.nref_id_2"
"select t1.nref_id_2,count(distinct t2.nref_id_2) as temp_count from neighboring_seq t1,neighboring_seq t2,source t3 where t1.taxon_id_2=t2.taxon_id_2 and t1.nref_id_2=t3.nref_id and t3.p_name='Acidic Lectin' group by t1.nref_id_2"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,protein t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.taxon_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,protein t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.p_name='Prohibitin' group by t1.taxon_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,source t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.p_name='Simian Virus 40' group by t1.nref_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,source t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.p_name='Acidic Lectin' group by t1.taxon_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,source t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.p_name='Beta-Catenin' group by t1.taxon_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,identical_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_1 and t3.taxon_id_2='13719' group by t1.taxon_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,identical_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_2 and t3.taxon_id_2='13719' group by t1.nref_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,protein t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.nref_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,taxonomy t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.nref_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,taxonomy t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.species_name='Acacia silvestris' group by t1.nref_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,identical_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_1 and t3.taxon_id_2='13719' group by t1.taxon_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,neighboring_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_1 and t3.length_2=1977 group by t1.taxon_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,protein t3 where t1.name=t2.name and t1.nref_id=t3.nref_id and t3.p_name='Prohibitin' group by t1.nref_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,taxonomy t3 where t1.name=t2.name and t1.nref_id=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.nref_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,taxonomy t3 where t1.name=t2.name and t1.nref_id=t3.nref_id and t3.species_name='Melampitta gigantea' group by t1.taxon_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,source t3 where t1.name=t2.name and t1.nref_id=t3.nref_id and t3.p_name='Acidic Lectin' group by t1.nref_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,neighboring_seq t3 where t1.name=t2.name and t1.nref_id=t3.nref_id_1 and t3.length_2=1977 group by t1.nref_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,neighboring_seq t3 where t1.name=t2.name and t1.nref_id=t3.nref_id_2 and t3.length_2=1977 group by t1.nref_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from organism t1,organism t2,neighboring_seq t3 where t1.name=t2.name and t1.nref_id=t3.nref_id_2 and t3.length_2=1977 group by t1.taxon_id"
"select t1.last_updated,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,taxonomy t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.last_updated"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,taxonomy t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.species_name='Acacia silvestris' group by t1.nref_id"
"select t1.last_updated,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,taxonomy t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.species_name='Acacia silvestris' group by t1.last_updated"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,source t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.p_name='Simian Virus 40' group by t1.nref_id"
"select t1.last_updated,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,source t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.p_name='Acidic Lectin' group by t1.last_updated"
"select t1.last_updated,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,source t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.p_name='Beta-Catenin' group by t1.last_updated"
"select t1.last_updated,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,identical_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_2 and t3.taxon_id_2='13719' group by t1.last_updated"
"select t1.last_updated,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,neighboring_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_1 and t3.length_2=1977 group by t1.last_updated"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,neighboring_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_2 and t3.length_2=1977 group by t1.nref_id"
"select t1.last_updated,count(distinct t2.nref_id) as temp_count from protein t1,protein t2,neighboring_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_2 and t3.length_2=1977 group by t1.last_updated"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,taxonomy t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.p_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,identical_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_1 and t3.taxon_id_2='13719' group by t1.nref_id"
"select t1.source,count(distinct t2.nref_id) as temp_count from source t1,source t2,identical_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_1 and t3.taxon_id_2='13719' group by t1.source"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,identical_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_2 and t3.taxon_id_2='13719' group by t1.p_id"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,neighboring_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_2 and t3.length_2=1977 group by t1.p_id"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,protein t3 where t1.p_id=t2.p_id and t1.nref_id=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.p_id"
"select t1.source,count(distinct t2.nref_id) as temp_count from source t1,source t2,protein t3 where t1.p_id=t2.p_id and t1.nref_id=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.source"
"select t1.source,count(distinct t2.nref_id) as temp_count from source t1,source t2,organism t3 where t1.p_id=t2.p_id and t1.nref_id=t3.nref_id and t3.name='Antonia ovata' group by t1.source"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,taxonomy t3 where t1.p_id=t2.p_id and t1.nref_id=t3.nref_id and t3.species_name='Melampitta gigantea' group by t1.p_id"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,identical_seq t3 where t1.p_id=t2.p_id and t1.nref_id=t3.nref_id_2 and t3.taxon_id_2='13719' group by t1.p_id"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,neighboring_seq t3 where t1.p_id=t2.p_id and t1.nref_id=t3.nref_id_1 and t3.length_2=1977 group by t1.p_id"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,protein t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.p_id"
"select t1.source,count(distinct t2.nref_id) as temp_count from source t1,source t2,protein t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.source"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,protein t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.p_name='Prohibitin' group by t1.p_id"
"select t1.source,count(distinct t2.nref_id) as temp_count from source t1,source t2,taxonomy t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.species_name='Phoronis hippocrepia' group by t1.source"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,taxonomy t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.species_name='Acacia silvestris' group by t1.p_id"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,identical_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_2 and t3.taxon_id_2='13719' group by t1.p_id"
"select t1.p_id,count(distinct t2.nref_id) as temp_count from source t1,source t2,neighboring_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_1 and t3.length_2=1977 group by t1.p_id"
"select t1.source,count(distinct t2.nref_id) as temp_count from source t1,source t2,neighboring_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_1 and t3.length_2=1977 group by t1.source"
"select t1.source,count(distinct t2.nref_id) as temp_count from source t1,source t2,neighboring_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_2 and t3.length_2=1977 group by t1.source"
"select t1.lineage,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,identical_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_2 and t3.taxon_id_2='13719' group by t1.lineage"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,neighboring_seq t3 where t1.nref_id=t2.nref_id and t1.nref_id=t3.nref_id_2 and t3.length_2=1977 group by t1.nref_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,protein t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.taxon_id"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,protein t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.nref_id"
"select t1.lineage,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,protein t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id and t3.p_name='Phosphotransferase' group by t1.lineage"
"select t1.nref_id,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,identical_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_1 and t3.taxon_id_2='13719' group by t1.nref_id"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,identical_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_2 and t3.taxon_id_2='13719' group by t1.taxon_id"
"select t1.lineage,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,identical_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_2 and t3.taxon_id_2='13719' group by t1.lineage"
"select t1.taxon_id,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,neighboring_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_1 and t3.length_2=1977 group by t1.taxon_id"
"select t1.lineage,count(distinct t2.nref_id) as temp_count from taxonomy t1,taxonomy t2,neighboring_seq t3 where t1.taxon_id=t2.taxon_id and t1.nref_id=t3.nref_id_1 and t3.length_2=1977 group by t1.lineage"
"select t1.nref_id_2,count(distinct t2.nref_id_1) as temp_count from identical_seq t1,identical_seq t2,protein t3 where t1.nref_id_2=t2.nref_id_2 and t1.nref_id_1=t3.nref_id and t3.p_name='Alkaline ceramidase' group by t1.nref_id_2"