Publications

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.
Filter: Options:
Enter value:
Display EndNote format

Structural Publications

    Fold 2011 (click to unfold)

  1. Target: NYSGXRC-11023l
    Bagaria A, Kumaran D, Burley SK, Swaminathan S 
    (2011)
    PSI:Phase 2
    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

  2. Wang L, Rubinstein R, Lines JL, Wasiuk A, Ahonen C, Guo Y, Lu LF, Gondek D, Wang Y, Fava RA, Fiser A, Almo S, Noelle RJ 
    (2011)
    PSI:Biology
    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

  3. Target: NYSGXRC-9208a
    Kamat SS, Fan H, Sauder JM, Burley SK, Shoichet BK, Sali A, Raushel FM 
    (2011)
    PSI:Phase 2
    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

  4. Target: NYSGXRC-9206a
    Kamat SS, Bagaria A, Kumaran D, Holmes-Hampton GP, Fan H, Sali A, Sauder JM, Burley SK, Lindahl PA, Swaminathan S, Raushel FM 
    (2011)
    PSI:Phase 2
    Catalytic mechanism and three-dimensional structure of adenine deaminase.
    Biochemistry, 50, 1917-27  (Details) (Pub Med ID: 21247091)
    Times cited: 3

  5. Target: NYSGXRC-11191g
    Zhang Z, Zhou R, Sauder JM, Tonge PJ, Burley SK, Swaminathan S 
    (2011)
    PSI:Phase 2
    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

  6. Unfold 2010 (click to unfold)

    Unfold 2009 (click to unfold)

    Unfold 2008 (click to unfold)

    Unfold 2007 (click to unfold)

    Unfold 2006 (click to unfold)

    Unfold 2005 (click to unfold)

    Unfold 2004 (click to unfold)

    Unfold 2003 (click to unfold)

    Unfold 2002 (click to unfold)

    Unfold 2001 (click to unfold)

    Unfold 2000 (click to unfold)

Total number of citations for structural publications: 1825
Average number of citations per publication (structural): 21.0

Methodological and Other Publications

    Fold 2011 (click to unfold)

  1. Chruszcz M, Maleki SJ, Majorek KA, Demas M, Bublin M, Solberg R, Hurlburt BK, Ruan S, Mattisohn CP, Breiteneder H, Minor W 
    (2011)
    PSI:Biology
    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

  2. Cooper DR, Porebski PJ, Chruszcz M, Minor W 
    (2011)
    PSI:Biology
    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

  3. Shi W, Chance MR 
    (2011)
    PSI:Phase 2
    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

  4. Unfold 2010 (click to unfold)

    Unfold 2009 (click to unfold)

    Unfold 2008 (click to unfold)

    Unfold 2007 (click to unfold)

    Unfold 2006 (click to unfold)

    Unfold 2005 (click to unfold)

    Unfold 2004 (click to unfold)

    Unfold 2003 (click to unfold)

    Unfold 2002 (click to unfold)

    Unfold 2001 (click to unfold)

    Unfold 2000 (click to unfold)

Total number of citations for methodological publications: 5840
Average number of citations per publication (methodological): 60.2
(default) 37 queries took 148 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';0218
2SELECT 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 position02913
3SELECT 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 position026
4SELECT 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 position067
5SELECT 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 position037
6SELECT 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 position036
7SELECT 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 position037
8SELECT 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 position047
9SELECT 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 position036
10SELECT 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 position0128
11SELECT DISTINCT "Center"."category" AS "Center__category" FROM "centers" AS "Center" WHERE "Center"."psi3" = TRUE 051
12SELECT "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 011
13SELECT "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 021
14SELECT "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 090
15SELECT "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 0120
16SELECT "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 040
17SELECT "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 0181
18SELECT "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 0381
19SELECT 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%')019
20SELECT 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%')015
21SELECT 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%')013
22SELECT 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%')017
23SELECT 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%')014
24SELECT "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 0381
25SELECT "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 0381
26SELECT 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%')012
27SELECT 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%')011
28SELECT 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%')012
29SELECT 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%')012
30SELECT 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%')011
31SELECT 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 DESC0363
32SELECT 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 DESC0123
33SELECT 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 DESC0122
34SELECT "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 08710
35SELECT "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 011752
36SELECT "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 0978
37SELECT "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 011752