PPLRE SprotProteinLocation Table

• The PPLRE SprotProteinLocation Table is a table that contains the extracted information from the Swiss-Prot data w.r.t. a protein's location.
  • See: PPLRE LocationSynonym Table.

---

Global Statistics

• Records: 80,226 records

---

Usage

• Hopefully to extract many many more curated OPL relations.

---

Source

• ftp://ftp.uniprot.org/pub/databases/uniprot/current_release/knowledgebase/taxonomic_divisions/

---

Attribute Statistics

• Localization: Contains the text that follows the Swiss-Prot Accession Format comment SUBCELLULAR LOCATION

SELECT LocationText, LocationId, Method, COUNT(*) AS Proteins WHERE OrganismType=Bacteria GROUP BY 1, 2, 3

1. LocationText LocationId Method Proteins

cytoplasm GO0005737 By similarity 19,556 cell inner membrane UNDEF By experiment 8,488 cytoplasm GO0005737 By experiment 8,007 cell membrane GO0005886 By experiment 7,731 cytoplasm GO0005737 Probable 5,315 multi-pass membrane protein GO0005886 By similarity 4,629 cytoplasm GO0005737 Potential 4,038 peripheral membrane protein UNDEF By similarity 3,735 multi-pass membrane protein GO0005886 Potential 3,389 multi-pass membrane protein GO0005886 By experiment 1,673 cell outer membrane UNDEF By experiment 917 multi-pass membrane protein GO0005886 Probable 751 periplasm GO0030288 By similarity 700 ...

                                                                           76,476 

SELECT LocationText, LocationId, Method, COUNT(*) AS Proteins WHERE OrganismType=Archaea GROUP BY 1, 2, 3

1. ProteinPA OrganismID LocationText Method

cytoplasm GO0005737 By similarity 1,035 cell membrane GO0005886 By experiment 768 cytoplasm GO0005737 By experiment 583 multi-pass membrane protein GO0005886 Potential 422 cytoplasm GO0005737 Potential 281 ...

                                                                                 3,749 

---

Sample

% head SprotProteinLocation.tab

1. ProteinPA LocationText LocationId Method

Q60317 cytoplasm GO0005737 By similarity Q58097 cytoplasm GO0005737 By similarity Q9V0L2 cytoplasm GO0005737 By similarity O58489 cytoplasm GO0005737 By similarity O93744 cytoplasm GO0005737 By similarity Q4J8X2 cytoplasm GO0005737 By similarity P14909 cytoplasm GO0005737 By similarity Q972A2 cytoplasm GO0005737 By similarity Q8TK19 cytoplasm GO0005737 By similarity

% wc -l SprotProteinLocation.tab 80226 SprotProteinLocation.tab

---

Example

1. ProteinPA LocationText LocationId Method

Q60317 cytoplasm GO0005737 By similarity Q58097 cytoplasm GO0005737 By similarity O58760 cell membrane GO0005886 By experiment O58760 multi-pass membrane protein GO0005886 Potential Q9V0L2 cytoplasm GO0005737 By similarity P58502 secreted protein UNDEF By experiment Q9YDX4 cell membrane GO0005886 By experiment Q6M0X3 cytoplasm GO0005737 By experiment O58489 cytoplasm GO0005737 By similarity Q9V2E4 peripheral membrane protein UNDEF By similarity Q8TK19 cytoplasm GO0005737 By similarity P81327 cell membrane GO0005886 By experiment Q53765 single-pass type ii membrane protein UNDEF Potential Q57550 lipid-anchor UNDEF Potential Q972A2 cytoplasm GO0005737 By similarity Q8PY27 peripheral membrane protein UNDEF By similarity P81327 multi-pass membrane protein GO0005886 Potential P29086 cell membrane GO0005886 By experiment P29086 multi-pass membrane protein GO0005886 Probable ...