User:DB

From MetaBase
Jump to: navigation, search
email dan.bolser@gmail.com
sal
fname
mname
lname
inst
dept
country
state
city
BiOFreedom!

Hello! If you like you can leave a message!

I maintain a profile on Nature Networks and OpenWetWare, which is actually a vain effort to beat my brothers Google rank.


Contents

My favourite databases

Funny-pictures-cat-sleeps-boring-meeting.jpg

Some databases that I have used

Interesting databases

Here is a loose collection of databases that I have found using and developing MetaBase that look very interesting:

My MetaBase convenience links

MediaWiki bookmarks

Cool stuff

Administrative queryies

<source lang="sql"> -- Top contributors: select

*

from (

select
  rev_user_text, count(*) as hits
from
  mb_revision
group by
  rev_user_text

) as x order by

hits desc

limit

20;

-- Top email domains: select

 right(user_email, length(user_email) - LOCATE("@", user_email)) as domain, 
 count(*) as domain_count 

from

 mb_user 

group by

 domain 

having

 domain_count>1;

-- Select likely spammers (sorry!): select

 user_name, user_real_name, user_password, user_email 

from

 mb_user 

where

 user_email rlike "mail.ru"

</source>

To Add

This is a MetaBase also http://www.up.univ-mrs.fr/~wabim/english/logligne.html albeit a static one. I would like to make an entry in MetaBase for all such web pages, each categorized as a Category:Database of databases. See also Category:Database pages to write

And;

Pages to add and/or categorize as NCBI 
NCBI resources include Entrez, the Entrez Programming Utilities, My NCBI, PubMed, PubMed Central, Entrez Gene, the NCBI Taxonomy Browser, BLAST, BLAST Link (BLink), Electronic PCR, OrfFinder, Spidey, Splign, RefSeq, UniGene, HomoloGene, ProtEST, dbMHC, dbSNP, Cancer Chromosomes, Entrez Genome, Genome Project, the Trace, Assembly, and Short Read Archives, Map Viewer, Model Maker, Evidence Viewer, Clusters of Orthologous Groups, Viral Genotyping Tools, Influenza Viral Resources, HIV-1/Human Protein Interaction Database, Gene Expression Omnibus, Entrez Probe, GENSAT, Database of Genotype and Phenotype, Online Mendelian Inheritance in Man, Online Mendelian Inheritance in Animals, the Molecular Modeling Database, the Conserved Domain Database, the Conserved Domain Architecture Retrieval Tool, and the PubChem suite of small molecule databases.
ExPASy
Swiss-Flash reports news of databases, software and service developments from the groups at the Swiss Institute of Bioinformatics that are responsible for the ENZYME, PROSITE, SWISS-2DPAGE, Swiss-Prot and TrEMBL databases; the Melanie software package; the ExPASy WWW server the SWISS-MODEL, Swiss-Shop and other network-based computational tools; the Core Facilities services.

Databases to add

See Category...

http://semantic-mediawiki.org/wiki/Image:Feed_icon.png

Important repositories

  • Ensembl
  • Entrez Gene
  • FlyBase
  • InterPro
  • Mouse Genome Database (MGD)
  • Online Mendelian Inheritance in Man (OMIM)

Edit me!

Search for "Dan Bolser" in;

Funny-pictures-ceiling-cat-tells-kitten-to-kill.jpg

Personal tools
Namespaces

Variants
Actions
Navigation
See also:
Toolbox