", $row["count(*)"]); $results = mysql_query("select count(*) from viper,EXPTL where viper.entry_key = EXPTL.entry_key AND EXPTL.method LIKE '%X-RAY%' and (supercede is null or supercede != 1)"); $row = mysql_fetch_array($results); printf("X-ray Models: %s
", $row["count(*)"]); $results = mysql_query("select count(*) from viper,EXPTL where viper.entry_key = EXPTL.entry_key AND EXPTL.method LIKE '%ELEC%' AND (supercede is NULL or supercede != 1)"); $row = mysql_fetch_array($results); printf("Cryo-EM Models: %s
", $row["count(*)"]); $results = mysql_query("select count(*) from viper,EXPTL where viper.entry_key = EXPTL.entry_key AND EXPTL.method LIKE '%MODEL%' AND (supercede is NULL or supercede != 1)"); $row = mysql_fetch_array($results); printf("Theoretical Models: %s
", $row["count(*)"]); // $results = mysql_query("select count(*) from viper where resolution is not null and supercede is null"); // $row = mysql_fetch_array($results); // printf("X-ray Crystal Structures: %s
", $row["count(*)"]); // $results = mysql_query("select count(*) from viper where resolution is null and supercede is null"); // $row = mysql_fetch_array($results); // printf("Cryo-EM Model Coordinate Sets: %s
", $row["count(*)"]); ?>
", $row["count(*)"]); $results = mysql_query("select count(distinct family) from viper where (supercede is null or supercede != 1)"); $row = mysql_fetch_array($results); printf("Virus Families: %s
", $row["count(distinct family)"]); $results = mysql_query("select count(distinct genus) from viper where (supercede is null or supercede != 1)"); $row = mysql_fetch_array($results); printf("Virus Genera: %s
", $row["count(distinct genus)"]); ?> Method-Based Stats
Recently Deposited Capsids
  • {pdb_id}: {name} {deposition_date}
  • Please be patient while we load the data...
  • Failed to load data!
Recently Updated Capsids (VIPERdb)
  • {pdb_id}: {name} {db_load_date}
  • Please be patient while we load the data...
  • Failed to load data!
Most Viewed Capsids
  • {@li}: {name} ({times_viewed})
  • Please be patient while we load the data...
  • Failed to load data!