ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '701236' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '701236' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '701236' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '701236' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '701236']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '701236'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 701236 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 701236]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 701236 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 701236

Título del libro: Tuberculosis And The Tubercle Bacillus
Título del capítulo: The PE and PPE Multigene Families of Mycobacteria

Autores UNAM:
CLARA INES ESPITIA PINZON;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2022

---

Palabras clave:

Antigenic variation; Genomic era; Immunological response; M. tuberculosis; Molecular tools; Multigene families; Mycobacteria; Mycobacterium tuberculosis; Pathogenic mycobacteria; Polymorphic GC -rich repetitive sequence

---

Resumen:

© 2005 ASM Press, Washington, D.C.Epidemiologists searching for new molecular tools to compare strains and to differentiate between species of mycobacteria first recognized an abundance of genes containing the repetitive sequences -CGGCGGCAA- and -GCCGGTGTTG- within the genomes of pathogenic mycobacteria. In this genomic era, we now recognize that the redundant polymorphic GC-rich repetitive sequence (PGRS) present in Mycobacterium tuberculosis and other mycobacteria belongs to the subfamily of PE_PGRS genes present in the PE multigene family. This chapter reviews what is known about the expression, function, and immunological response to the PE, PE_PGRS, and PPE genes. Importantly, several studies using microarray analysis have also suggested that expression of PPE genes within mycobacteria may be regulated by specific changes in environmental conditions. Due to their highly polymorphic C-terminal domains, PPE genes may serve as a source of antigenic variation for mycobacteria. The PPE-MPTR protein Rv1917c has been the focus of an extensive investigation and has been found to be expressed in liquid cultures of Mycobacterium tuberculosis H37Rv, to be localized in the cell wall, and to be at least partly exposed on the cell surface of mycobacteria. Although there has been some progress, the function(s) of the PPE proteins remains vague. In addition to a possible role in antigenic variation, it has been postulated that PPE proteins could function as storage proteins for the rare amino acid asparagine, since asparagines are preferred nitrogen sources of M. tuberculosis.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781683674184
Editorial:
wiley

Tipo de producto:
Book chapter

DOI:
10.1128/9781555817657.ch33