Skip to content

How To Query

Salvador Martínez de Bartolomé edited this page Apr 25, 2019 · 2 revisions

How to query data in PINT

Here is a document were you can find some descriptions on how the query the data.
Please take a look at it at: PINT_help_Query_Commands.pdf

The list of commands available are:

  • AM[Aggregation_level, Amount_type, COND, Numerical_condition] Proteins or peptides satisfying a condition in the amount value (spectral counts, intensity, NSAF, XIC…).
  • CAN[Uniprot_version, Uniprot_header_line, Annotation_type, Annotation_name, Annotation_value, Numerical_condition] Proteins with specified annotations described by parameters.
  • COND[Condition_name, Project_tag] Proteins detected in certain experimental condition in a specific project.
  • GN[gene_name] Proteins with a specified gene name
  • LB[Aggregation_level, Label_name, ONLY] Proteins and peptides that were labeled with a certain quantitation label.
  • MSRUN[CSV_MS_run_Ids] Proteins and peptides detected in a list of MS runs.
  • ACC[CSV_accessions] Proteins from a list of protein accessions.
  • PTM[PTM_name, PTM_mass_diff_Dalton, Dalton_tolerance, Numerical_condition] Peptides containing specified PTMs in the sequence.
  • RA[Aggregation_level, COND,COND, Ratio_name, Numerical_condition, SC] Proteins or peptides satisfying a condition over a quantitative relative ratio between two experimental conditions.
  • SC[Aggregation_level, Score_type, Score_name, Numerical_condition] Proteins or peptides satisfying a condition over the value of a score.
  • SEQ[Aggregation_level, regular_expression] Peptides with a sequence matching a regular expression.
  • AN[uniprot_version, Annotation_String, Numerical_condition] Same as CAN, but without the need of specifying annotations types or UniProt header lines.
  • TX[Aggregation_level, Organism_name, Ncbi_tax_id, ONLY] Proteins and peptides from a specified organism
  • THR[threshold_name, Boolean_value] Proteins satisfying certain condition over a threshold associated with them.
  • TIS[CVS_tissue_names] Proteins detected in certain tissues.