Publications for New York Structural Genomics Research Consortium
| Total Publications | 184 |
|---|---|
| Publications with >5 Citations | 138 |
| Structural Publications | 87 |
| Methodological and Other Publications | 97 |
| Total Citations | 7665 |
| Avg. Citations (Structural) | 21.0 |
| Avg. Citations (Methodological and Other) | 60.2 |
| Total Impact | 1,165.5 |
More New York Structural Genomics Research Consortium statistics here.
Structural Publications
- Target: NYSGXRC-11023l
(2011)
Structural basis for a ribofuranosyl binding protein: Insights into the furanose specific transport.
Proteins, 79, 1352-7 (Details) (Pub Med ID: 21387413) (PDB: 3KSM)
Times cited: 0
(2011)
VISTA, a novel mouse Ig superfamily ligand that negatively regulates T cell responses.
Journal of Experimental Medicine, 208, 577-92 (Details) (Pub Med ID: 21383057)
Times cited: no data- Target: NYSGXRC-9208a
(2011)
Enzymatic deamination of the epigenetic base N-6-methyladenine.
Journal of the American Chemical Society, 133, 2080-3 (Details) (Pub Med ID: 21275375)
Times cited: no data - Target: NYSGXRC-9206a
(2011)
Catalytic mechanism and three-dimensional structure of adenine deaminase.
Biochemistry, 50, 1917-27 (Details) (Pub Med ID: 21247091)
Times cited: 3 - Target: NYSGXRC-11191g
(2011)
Structural and functional studies of fatty acyl adenylate ligases from E. coli and L. pneumophila.
Journal of Molecular Biology, 406, 313-24 (Details) (Pub Med ID: 21185305)
Times cited: 0
2011 (click to unfold)
2010 (click to unfold)
2009 (click to unfold)
2008 (click to unfold)
2007 (click to unfold)
2006 (click to unfold)
2005 (click to unfold)
2004 (click to unfold)
2003 (click to unfold)
2002 (click to unfold)
2001 (click to unfold)
2000 (click to unfold)
Average number of citations per publication (structural): 21.0
Methodological and Other Publications
(2011)
Structural and Immunologic Characterization of Ara h 1, a Major Peanut Allergen.
Journal of Biological Chemistry, 286, 39318-27 (Details) (Pub Med ID: 21917921)
Times cited: 1
(2011)
X-ray crystallography: Assessment and validation of protein-small molecule complexes for drug discovery.
Expert Opin Drug Discov, 6, 771-782 (Details) (Pub Med ID: 21779303)
Times cited: 0
(2011)
Metalloproteomics: forward and reverse approaches in metalloprotein structural and functional characterization.
Current Opinion in Chemical Biology, 15, 144-8 (Details) (Pub Med ID: 21130021)
Times cited: 1
2011 (click to unfold)
2010 (click to unfold)
2009 (click to unfold)
2008 (click to unfold)
2007 (click to unfold)
2006 (click to unfold)
2005 (click to unfold)
2004 (click to unfold)
2003 (click to unfold)
2002 (click to unfold)
2001 (click to unfold)
2000 (click to unfold)
Average number of citations per publication (methodological): 60.2
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public'; | 0 | 21 | 8 | |
| 2 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'publication' AND (table_schema = 'public') ORDER BY position | 0 | 29 | 13 | |
| 3 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'journal_alias' AND (table_schema = 'public') ORDER BY position | 0 | 2 | 6 | |
| 4 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'journal' AND (table_schema = 'public') ORDER BY position | 0 | 6 | 7 | |
| 5 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'initiative' AND (table_schema = 'public') ORDER BY position | 0 | 3 | 7 | |
| 6 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'abstract' AND (table_schema = 'public') ORDER BY position | 0 | 3 | 6 | |
| 7 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'publication_pdb' AND (table_schema = 'public') ORDER BY position | 0 | 3 | 7 | |
| 8 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'technology' AND (table_schema = 'public') ORDER BY position | 0 | 4 | 7 | |
| 9 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'publication_technology' AND (table_schema = 'public') ORDER BY position | 0 | 3 | 6 | |
| 10 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'centers' AND (table_schema = 'public') ORDER BY position | 0 | 12 | 8 | |
| 11 | SELECT DISTINCT "Center"."category" AS "Center__category" FROM "centers" AS "Center" WHERE "Center"."psi3" = TRUE | 0 | 5 | 1 | |
| 12 | SELECT "Center"."id" AS "Center__id", "Center"."full_name" AS "Center__full_name" FROM "centers" AS "Center" WHERE "Center"."psi3" = TRUE AND "Center"."category" IS NULL ORDER BY "id" ASC | 0 | 1 | 1 | |
| 13 | SELECT "Center"."id" AS "Center__id", "Center"."full_name" AS "Center__full_name" FROM "centers" AS "Center" WHERE "Center"."psi3" = TRUE AND "Center"."category" = 'resource' ORDER BY "id" ASC | 0 | 2 | 1 | |
| 14 | SELECT "Center"."id" AS "Center__id", "Center"."full_name" AS "Center__full_name" FROM "centers" AS "Center" WHERE "Center"."psi3" = TRUE AND "Center"."category" = 'membrane' ORDER BY "id" ASC | 0 | 9 | 0 | |
| 15 | SELECT "Center"."id" AS "Center__id", "Center"."full_name" AS "Center__full_name" FROM "centers" AS "Center" WHERE "Center"."psi3" = TRUE AND "Center"."category" = 'biology' ORDER BY "id" ASC | 0 | 12 | 0 | |
| 16 | SELECT "Center"."id" AS "Center__id", "Center"."full_name" AS "Center__full_name" FROM "centers" AS "Center" WHERE "Center"."psi3" = TRUE AND "Center"."category" = 'ht' ORDER BY "id" ASC | 0 | 4 | 0 | |
| 17 | SELECT "Center"."id" AS "Center__id", "Center"."full_name" AS "Center__full_name" FROM "centers" AS "Center" WHERE (("Center"."psi1" = TRUE) OR ("Center"."psi2" = TRUE)) ORDER BY "id" ASC | 0 | 18 | 1 | |
| 18 | SELECT "Center"."id" AS "Center__id" FROM "centers" AS "Center" WHERE "nih" = TRUE AND (("Center"."psi1" = TRUE) OR ("Center"."psi2" = TRUE) OR ("Center"."psi3" = TRUE)) ORDER BY "id" ASC | 0 | 38 | 1 | |
| 19 | SELECT COUNT(*), SUM(times_cited) FROM publication WHERE true AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%ATCG3D%' OR center like '%BSGC%' OR center like '%CEBS%' OR center like '%CELLMAT%' OR center like '%CESG%' OR center like '%CHSAM%' OR center like '%CHTSB%' OR center like '%CSMP%' OR center like '%GPCR%' OR center like '%IFN%' OR center like '%ISFI%' OR center like '%JCMM%' OR center like '%JCSG%' OR center like '%MCSG%' OR center like '%MPID%' OR center like '%MPP%' OR center like '%MPSBC%' OR center like '%MPSbyNMR%' OR center like '%MTBI%' OR center like '%NatPro%' OR center like '%NESG%' OR center like '%NMHRCM%' OR center like '%NPCXstals%' OR center like '%NYCOMPS%' OR center like '%NYSGRC%' OR center like '%NYSGXRC%' OR center like '%PCSEP%' OR center like '%PSIMR%' OR center like '%PSISBKB%' OR center like '%SECSG%' OR center like '%SGPP%' OR center like '%STEMCELL%' OR center like '%TB%' OR center like '%TCELL%' OR center like '%TEMIMPS%' OR center like '%TJMP%' OR center like '%TMPC%' OR center like '%TransportPDB%') | 0 | 1 | 9 | |
| 20 | SELECT COUNT(*), SUM(times_cited) FROM publication WHERE (type='method' OR type='other') AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%ATCG3D%' OR center like '%BSGC%' OR center like '%CEBS%' OR center like '%CELLMAT%' OR center like '%CESG%' OR center like '%CHSAM%' OR center like '%CHTSB%' OR center like '%CSMP%' OR center like '%GPCR%' OR center like '%IFN%' OR center like '%ISFI%' OR center like '%JCMM%' OR center like '%JCSG%' OR center like '%MCSG%' OR center like '%MPID%' OR center like '%MPP%' OR center like '%MPSBC%' OR center like '%MPSbyNMR%' OR center like '%MTBI%' OR center like '%NatPro%' OR center like '%NESG%' OR center like '%NMHRCM%' OR center like '%NPCXstals%' OR center like '%NYCOMPS%' OR center like '%NYSGRC%' OR center like '%NYSGXRC%' OR center like '%PCSEP%' OR center like '%PSIMR%' OR center like '%PSISBKB%' OR center like '%SECSG%' OR center like '%SGPP%' OR center like '%STEMCELL%' OR center like '%TB%' OR center like '%TCELL%' OR center like '%TEMIMPS%' OR center like '%TJMP%' OR center like '%TMPC%' OR center like '%TransportPDB%') | 0 | 1 | 5 | |
| 21 | SELECT COUNT(*), SUM(times_cited) FROM publication WHERE (type='structure' OR type='note' OR type='function') AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%ATCG3D%' OR center like '%BSGC%' OR center like '%CEBS%' OR center like '%CELLMAT%' OR center like '%CESG%' OR center like '%CHSAM%' OR center like '%CHTSB%' OR center like '%CSMP%' OR center like '%GPCR%' OR center like '%IFN%' OR center like '%ISFI%' OR center like '%JCMM%' OR center like '%JCSG%' OR center like '%MCSG%' OR center like '%MPID%' OR center like '%MPP%' OR center like '%MPSBC%' OR center like '%MPSbyNMR%' OR center like '%MTBI%' OR center like '%NatPro%' OR center like '%NESG%' OR center like '%NMHRCM%' OR center like '%NPCXstals%' OR center like '%NYCOMPS%' OR center like '%NYSGRC%' OR center like '%NYSGXRC%' OR center like '%PCSEP%' OR center like '%PSIMR%' OR center like '%PSISBKB%' OR center like '%SECSG%' OR center like '%SGPP%' OR center like '%STEMCELL%' OR center like '%TB%' OR center like '%TCELL%' OR center like '%TEMIMPS%' OR center like '%TJMP%' OR center like '%TMPC%' OR center like '%TransportPDB%') | 0 | 1 | 3 | |
| 22 | SELECT SUM(impact_factor) as impact FROM publication, journal, journal_alias WHERE journal_short = name AND journal.id = journal_id AND true AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%ATCG3D%' OR center like '%BSGC%' OR center like '%CEBS%' OR center like '%CELLMAT%' OR center like '%CESG%' OR center like '%CHSAM%' OR center like '%CHTSB%' OR center like '%CSMP%' OR center like '%GPCR%' OR center like '%IFN%' OR center like '%ISFI%' OR center like '%JCMM%' OR center like '%JCSG%' OR center like '%MCSG%' OR center like '%MPID%' OR center like '%MPP%' OR center like '%MPSBC%' OR center like '%MPSbyNMR%' OR center like '%MTBI%' OR center like '%NatPro%' OR center like '%NESG%' OR center like '%NMHRCM%' OR center like '%NPCXstals%' OR center like '%NYCOMPS%' OR center like '%NYSGRC%' OR center like '%NYSGXRC%' OR center like '%PCSEP%' OR center like '%PSIMR%' OR center like '%PSISBKB%' OR center like '%SECSG%' OR center like '%SGPP%' OR center like '%STEMCELL%' OR center like '%TB%' OR center like '%TCELL%' OR center like '%TEMIMPS%' OR center like '%TJMP%' OR center like '%TMPC%' OR center like '%TransportPDB%') | 0 | 1 | 7 | |
| 23 | SELECT count(*) FROM publication WHERE times_cited>=5 AND true AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%ATCG3D%' OR center like '%BSGC%' OR center like '%CEBS%' OR center like '%CELLMAT%' OR center like '%CESG%' OR center like '%CHSAM%' OR center like '%CHTSB%' OR center like '%CSMP%' OR center like '%GPCR%' OR center like '%IFN%' OR center like '%ISFI%' OR center like '%JCMM%' OR center like '%JCSG%' OR center like '%MCSG%' OR center like '%MPID%' OR center like '%MPP%' OR center like '%MPSBC%' OR center like '%MPSbyNMR%' OR center like '%MTBI%' OR center like '%NatPro%' OR center like '%NESG%' OR center like '%NMHRCM%' OR center like '%NPCXstals%' OR center like '%NYCOMPS%' OR center like '%NYSGRC%' OR center like '%NYSGXRC%' OR center like '%PCSEP%' OR center like '%PSIMR%' OR center like '%PSISBKB%' OR center like '%SECSG%' OR center like '%SGPP%' OR center like '%STEMCELL%' OR center like '%TB%' OR center like '%TCELL%' OR center like '%TEMIMPS%' OR center like '%TJMP%' OR center like '%TMPC%' OR center like '%TransportPDB%') | 0 | 1 | 4 | |
| 24 | SELECT "Center"."id" AS "Center__id", "Center"."full_name" AS "Center__full_name" FROM "centers" AS "Center" WHERE "nih" = TRUE AND (("psi1" = TRUE) OR ("psi2" = TRUE) OR ("psi3" = TRUE)) ORDER BY "id" ASC | 0 | 38 | 1 | |
| 25 | SELECT "Center"."id" AS "Center__id", "Center"."full_name" AS "Center__full_name" FROM "centers" AS "Center" WHERE "nih" = TRUE AND (("psi1" = TRUE) OR ("psi2" = TRUE) OR ("psi3" = TRUE)) ORDER BY "id" ASC | 0 | 38 | 1 | |
| 26 | SELECT COUNT(*), SUM(times_cited) FROM publication WHERE true AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%') | 0 | 1 | 2 | |
| 27 | SELECT COUNT(*), SUM(times_cited) FROM publication WHERE (type='method' OR type='other') AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%') | 0 | 1 | 1 | |
| 28 | SELECT COUNT(*), SUM(times_cited) FROM publication WHERE (type='structure' OR type='note' OR type='function') AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%') | 0 | 1 | 2 | |
| 29 | SELECT SUM(impact_factor) as impact FROM publication, journal, journal_alias WHERE journal_short = name AND journal.id = journal_id AND true AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%') | 0 | 1 | 2 | |
| 30 | SELECT count(*) FROM publication WHERE times_cited>=5 AND true AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%') | 0 | 1 | 1 | |
| 31 | SELECT year, type, count(*) FROM publication WHERE (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%') GROUP BY year, type ORDER BY year DESC | 0 | 36 | 3 | |
| 32 | SELECT year, count(*) FROM publication WHERE (type='structure' OR type='note' OR type='function') AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%') GROUP BY year ORDER BY year DESC | 0 | 12 | 3 | |
| 33 | SELECT year, count(*) FROM publication WHERE (type='method' OR type='other') AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%') GROUP BY year ORDER BY year DESC | 0 | 12 | 2 | |
| 34 | SELECT "Publication"."id" AS "Publication__id","Publication"."pmid" AS "Publication__pmid","Publication"."authors" AS "Publication__authors","Publication"."title" AS "Publication__title","Publication"."journal_short" AS "Publication__journal_short","Publication"."issn" AS "Publication__issn","Publication"."year" AS "Publication__year","Publication"."vol" AS "Publication__vol","Publication"."pages" AS "Publication__pages","Publication"."center" AS "Publication__center","Publication"."target_id" AS "Publication__target_id","Publication"."pdb_id" AS "Publication__pdb_id","Publication"."type" AS "Publication__type","Publication"."status" AS "Publication__status","Publication"."source" AS "Publication__source","Publication"."remark" AS "Publication__remark","Publication"."verified" AS "Publication__verified","Publication"."frozen" AS "Publication__frozen","Publication"."times_cited" AS "Publication__times_cited","Publication"."times_cited_update" AS "Publication__times_cited_update","Publication"."inserted" AS "Publication__inserted","Publication"."updated" AS "Publication__updated","Publication"."times_cited_status" AS "Publication__times_cited_status","Publication"."pubmed_times_cited" AS "Publication__pubmed_times_cited","Publication"."pubmed_times_cited_update" AS "Publication__pubmed_times_cited_update","Publication"."pubmed_times_cited_status" AS "Publication__pubmed_times_cited_status","Publication"."cover_image" AS "Publication__cover_image","Publication"."initiative_id" AS "Publication__initiative_id","Publication"."pmcid" AS "Publication__pmcid","Journal"."id" as "Journal__id","Journal"."display_name" as "Journal__display_name","PubAbstract"."abstract" as "PubAbstract__abstract","Initiative"."name" as "Initiative__name","Initiative"."short_name" as "Initiative__short_name" FROM publication as "Publication" LEFT JOIN journal_alias as "JournalAlias" on "Publication".journal_short = "JournalAlias".name LEFT JOIN journal as "Journal" on "JournalAlias".journal_id = "Journal".id LEFT JOIN initiative as "Initiative" on "Publication".initiative_id = "Initiative".id LEFT JOIN abstract as "PubAbstract" on "PubAbstract".publication_id = "Publication".id WHERE (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (((type='structure' OR type='note' OR type='function')) AND ((center like '%NYSGRC%' or center like '%NYSGXRC%'))) ORDER BY "year" DESC, "pmid" DESC, "status" ASC | 0 | 87 | 10 | |
| 35 | SELECT "PublicationPdb"."id" AS "PublicationPdb__id", "PublicationPdb"."publication_id" AS "PublicationPdb__publication_id", "PublicationPdb"."pdb_id" AS "PublicationPdb__pdb_id" FROM "publication_pdb" AS "PublicationPdb" WHERE 1 = 1 | 0 | 1175 | 2 | |
| 36 | SELECT "Publication"."id" AS "Publication__id","Publication"."pmid" AS "Publication__pmid","Publication"."authors" AS "Publication__authors","Publication"."title" AS "Publication__title","Publication"."journal_short" AS "Publication__journal_short","Publication"."issn" AS "Publication__issn","Publication"."year" AS "Publication__year","Publication"."vol" AS "Publication__vol","Publication"."pages" AS "Publication__pages","Publication"."center" AS "Publication__center","Publication"."target_id" AS "Publication__target_id","Publication"."pdb_id" AS "Publication__pdb_id","Publication"."type" AS "Publication__type","Publication"."status" AS "Publication__status","Publication"."source" AS "Publication__source","Publication"."remark" AS "Publication__remark","Publication"."verified" AS "Publication__verified","Publication"."frozen" AS "Publication__frozen","Publication"."times_cited" AS "Publication__times_cited","Publication"."times_cited_update" AS "Publication__times_cited_update","Publication"."inserted" AS "Publication__inserted","Publication"."updated" AS "Publication__updated","Publication"."times_cited_status" AS "Publication__times_cited_status","Publication"."pubmed_times_cited" AS "Publication__pubmed_times_cited","Publication"."pubmed_times_cited_update" AS "Publication__pubmed_times_cited_update","Publication"."pubmed_times_cited_status" AS "Publication__pubmed_times_cited_status","Publication"."cover_image" AS "Publication__cover_image","Publication"."initiative_id" AS "Publication__initiative_id","Publication"."pmcid" AS "Publication__pmcid","Journal"."id" as "Journal__id","Journal"."display_name" as "Journal__display_name","PubAbstract"."abstract" as "PubAbstract__abstract","Initiative"."name" as "Initiative__name","Initiative"."short_name" as "Initiative__short_name" FROM publication as "Publication" LEFT JOIN journal_alias as "JournalAlias" on "Publication".journal_short = "JournalAlias".name LEFT JOIN journal as "Journal" on "JournalAlias".journal_id = "Journal".id LEFT JOIN initiative as "Initiative" on "Publication".initiative_id = "Initiative".id LEFT JOIN abstract as "PubAbstract" on "PubAbstract".publication_id = "Publication".id WHERE (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (((type='method' OR type='other')) AND ((center like '%NYSGRC%' or center like '%NYSGXRC%'))) ORDER BY "year" DESC, "pmid" DESC, "status" ASC | 0 | 97 | 8 | |
| 37 | SELECT "PublicationPdb"."id" AS "PublicationPdb__id", "PublicationPdb"."publication_id" AS "PublicationPdb__publication_id", "PublicationPdb"."pdb_id" AS "PublicationPdb__pdb_id" FROM "publication_pdb" AS "PublicationPdb" WHERE 1 = 1 | 0 | 1175 | 2 |