UniLectin exploration platform and database for curated and predicted lectin carbohydrate binding proteins

This endpoint enables you to perform queries on the lectin table.
It retrieves the content of the specified column (getcolumns) where another column (wherecolumn) has a specific value (isvalue).

The available columns for this table are:

• lectin_id
• pdb
• fold: lectin fold
• class: lectin class
• family: lectin family
• origin: lectin origin
• species: lectin species
• species_id: id of species
• resolution: experimental resolution
• comments
• cfg
• uniprot: id
• protein_name
• ligand
• monosac
• iupac
• ligand_link
• dt

• getcolumn: string of which column needs to be fetched (one or multiple columns, separated by comma)
• wherecolumn: string of the focused column
• isvalue: string of what value need to be matched in wherecolumn (here, wildcards are also accepted such as "Rattus%" to match everything starting with "Rattus")
• limit: (optional) integer of the number of results to be returned (default: 1000, -1 for all)

• Get all the Binding domains ids (pdb) and their UniProt ids:
  Try this query { "getcolumns": "pdb,uniprot", "wherecolumn": "pdb", "isvalue": "%%" , "limit": "1000"}
• Get lectome of a species:
  Try this query { "getcolumns": "iupac,species", "wherecolumn": "species", "isvalue": "Rattus norvegicus", "limit": "1000"}
• Get all lectins that do have a ligand :
  Try this query { "getcolumns": "pdb,uniprot", "wherecolumn": "iupac", "isvalue": "VALUE_NOT_EMPTY", "limit": "1000"}

This endpoint enables you to perform queries on the predicted lectins table.
It retrieves the content of the specified column (getcolumns) where another column (wherecolumn) has a specific value (isvalue).

The available columns for this table are:

• protein_ac: UniProt i.e:A0A2P8WI18
• uniprot: i.e:A0A2P8WI18
• protein.protein_id: i.e:1182210
• protein.name: i.e:C-type lectin domain-containing protein (Fragment)
• fold: i.e:ab mixed C-type lectin-like
• domains.domains_id: i.e:128145
• length: i.e:1669
• alt_ac: NCBI protein i.e:PSN19462
• genus:
• gene: the gene (Chz/contig) i.e:PYEQ01000096.1
• gene_begin: i.e:6118
• gene_end: i.e:11124
• cluster: i.e:A0A2P8WI18
• strain: i.e:CCP5:
• species: i.e:filamentous cyanobacterium CCP5
• sgroup: i.e:filamentous cyanobacterium
• superkingdom: i.e:Bacteria
• kingdom: i.e:None
• phylum: i.e:Cyanobacteria
• domain: lectin class i.e:C-type lectin
• score: i.e:0.281
• pfam_name: i.e:HemolysinCabind |
• cazy: i.e:CBM57
• ref_seq: i.e:KKEVEKLKS--CPKKWKAFQGKCYFFSNEKKTWEEAEKACSERGAHLVVIKSAEEQEFLQ-QLSKSNSYWIGLTDEKTEGTWQWVDGSPLNYKNWAPGEPNNA...
• match_seq: i.e:TQQTN---TITIPNGVT-YNGSLYVLTDSVMTWLNAQAYAESLGGNLVTINDSTEENWIRSVFGTSEQFWIGLNDQAANTQFKWVSGEALTYTNFEPGRID...

• getcolumn: string of which column needs to be fetched (one or multiple columns, separated by comma)
• wherecolumn: string of the focused column
• isvalue: string of what value need to be matched in wherecolumn (here, wildcards are also accepted such as "Rattus%" to match everything starting with "Rattus")
• limit: (optional) integer of the number of results to be returned (default: 1000, -1 for all)

• Get the lectome of all proteins from the bacteria kingdom:
  Try this query { "getcolumns": "fold,domain,uniprot,superkingdom", "wherecolumn": "superkingdom", "isvalue": "Bacteria%" , "limit": "2000"}
• Get all predicted proteins:
  Try this query { "getcolumns": "uniprot,domain", "wherecolumn": "uniprot", "isvalue": "%%" , "limit": "2000"}